I'm trying to do a restore of a cold backup made with rman in oracle 9i, the question is that I managed to successfully restore the pfile and the controlfile but when I try to give:
RMAN> restore database;
Starting restore at [DATE]
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid = 11 devtype = DISK
RMAN-00571: ======================================================================= =============
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ======================================================================= =============
RMAN-03002: failure of restore command at [date]
RMAN-06026: some targets not found – aborting restore
RMAN-06023: no backup or copy of datafile 16 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
Physically the backup pieces are there but when I do:
list backup of database;
it does not show the missing ones.
I must clarify that the restore I'm doing on a different server, but I keep the same directory structure and the same SID as in the original.
Also I copy the backup rman in the same directory.
When this happens in Oracle 11g I simply launch:
catalog start with
But for 9i there is no such option.
Could you recommend me some solution, please?
The rman script that I use is the following:
shutdown immediate;
startup force dba;
shutdown immediate;
startup mount
run {
set command id to 'ORA9';
allocate channel t1 device type disk;
allocate channel t2 device type disk;
allocate channel t3 device type disk;
allocate channel t4 device type disk;
backup filesperset 1
format '/ Backups / FULL_% d_% u'
(
database
include current controlfile
);
release channel t1;
release channel t2;
release channel t3;
release channel t4;
}
alter database open;
If possible, it would help me a lot more, if you could clarify the similar restore procedure in case the backup is done with tape.
Thank you very much.
Best Answer
As I remember, in 9i when rman is doing backup
"include current controlfile"
then this controlfile does not contain info about currently processing backup. You can check it by restore this controlfile and issue command:You need to backup your controlfile after you do backup of datafiles.
Add
backup current controlfile;
command beforerelease channel t1;
Or configure autobackup of controlfile - I like this option more.