Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Recovery Manager and Media Management software
I am confused about how Recovery Manager works with Media Management
software.
I am using Recovery Manager with Recovery Catalog and Veritos. Suppose I am running hot backups and then shut down the database and do a cold backup. Then I want to do a test restore from a hot backup, how can I know that what is put back on disk is from the hot backup and not the cold backup?
To do the hot backup, I am doing something like this:
Run {
Allocate channel t1 type ‘SBT_TAPE’;
Backup full
Fileperset 2 Format ‘RIGNS_full.%n.%s.%p’ (database);
To restore the database, I want to do something like this:
Run {
Allocate channel t1 type ‘SBT_TAPE’;
Allocate channel d1 type disk;
Restore controlfile to
‘/disk1/oradata/RIGNS/control01.ctl
replicate controlfile
from ‘disk1/oradata/RIGNS/control01.ctl’;
sql ‘alter database mount’;
restore (database);
recover database;
sql ‘alter database open’;
}