Restoring RMAN backup in Oracle 9i to another server

oracleoracle-9irman

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:

list backup summary;

You need to backup your controlfile after you do backup of datafiles.

Add backup current controlfile; command before release channel t1; Or configure autobackup of controlfile - I like this option more.

CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/Backups/%F';