DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: rman restore rollback datafile

  1. #1
    Join Date
    Apr 2001
    Location
    Berlin
    Posts
    65

    Post rman restore rollback datafile

    In RMAN, to restore a datafile that
    belongs to the rollback tablespace,
    does the backup has to be taken explicitly
    using a datafile backup instead of full database
    backup?

    In a test that I'm doing, I used this full
    backup script below to take a full backup.

    run {
    allocate channel ch1 type disk format
    '/disk1/ora_disk/test_back_%s';
    set limit channel ch1 kbytes=1000;
    sql 'alter system switch logfile';
    sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
    backup database;
    backup
    format='/disk1/ora_disk/test_arch_%s'
    archivelog like '/disk2/testdisk/arch/%'
    channel ch1 delete input;
    }

    After that, I removed one datafile that makes
    up the rollback tablespace

    e.g. rm /disk1/rollback/testdb_rollbacks.dbf

    When restoring it, I tried using this script but
    it did not work.

    run{
    allocate channel ch1 type disk;
    restore datafile 3
    recover tablespace RBS;
    sql 'alter tablespace RBS online';
    }

    Can any one please help me with some speccific
    syntax,etc.

    I have researched a lot of docs. but can't seem
    to come out with the correct syntax.
    All the docs that I have read refrences to the
    recovery method above.

    Any help with the specific syntax examples
    to restore the RBS datafiles would be
    appreciated.

    Thanks.

  2. #2
    Join Date
    Aug 2000
    Posts
    87
    run
    {
    allocate channel d1 type disk;
    setlimit channel d1 kbytes 2097150 maxopenfiles 32 readrate 200;
    sql 'alter tablespace rbs offline immediate';
    restore tablespace rbs;
    recover tablespace rbs;
    sql 'alter tablespace rbs online';
    release channel d1;
    }

    Try the above script.

    Regards,
    Vinod

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