Sample Header Ad - 728x90

Restoring RMAN backup in Oracle 9i to another server

1 vote
1 answer
1449 views
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; Would the restore procedure be similar in case the backup is done with tape?
Asked by Arnaldo Raxach (145 rep)
Dec 20, 2017, 09:23 PM
Last activity: Sep 21, 2021, 12:13 PM