-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|