Tablespace restore / recovery with RMAN
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 14

Thread: Tablespace restore / recovery with RMAN

Threaded View

  1. #1
    Join Date
    Oct 2002
    Posts
    807

    Tablespace restore / recovery with RMAN

    Hi,
    I've got a question on tablespace restore / recovery with RMAN. Background : I am currently backing up a database (in archivelog mode) using rman scripts. I use incremental backups to backup the database every night (level 0 on sun, level 1 on other days). Archive logs are backed up every hour.
    I'd like to get your opinion on ways to restore the tablespace in the below scenario.

    1) I create a NEW tablespace (tablespace 'TEST_TS') at 1pm today and add a bunch of tables to it.
    2) I then rename the underlying datafile '/u12/oradata/TESTRMAN/test_ts01.dbf' to test_ts01.dbf.old or something.

    Now how do I recover this tablespace (TEST_TS)? I tried offlining it, and restoring it from rman..but that doesn't seem to work since it doesn't have a baseline.

    Any ideas? Do I have to do a point in time recovery or something?

    Thanks for your time.

    PS : Yes, I realize that it is a good practise to backup the database immediately after creating a new tablespace..but lets keep that aside for now.
    Last edited by Axr2; 04-13-2004 at 03:43 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width