Restore RMAN backup to different machine.
I am having issue restoring Oracle 9i RMAN backup to completely different machine.
these are the steps I have done.
1. I have RMAN backups on the new backup folder on the new machine.
2.Restored the SPFile for backup.
3. Created DatabaseService and password file.
4.restored the control file
5.Started and mounted the instance via RMAN
I have followed the steps exactly mentioned on http://www.orafusion.com/art_rman3.htm
However after mounting the instance I cannot restore the database.
The reason is RMAN tried to restore from the original backup location which is
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'M:\OracleBackup\......
It doesn't let me change the location as the controlfile is backup control file.
How do I change location so that it will point to the new folder where I have copied the backups.
In 10g there is RMAN command to CATALOG backuppiece but it is not possible to change in Oracle 9i.
Does anyone have any idea ?
Restore RMAN backup to different machine
I know this post is many years old, but did you find a solution to this restore problem that says unable to open file ? I am running into the same problem and wondered if you ever found out. I am trying to restore my RMAN backup from production server(9i) to a test server(9i). I was able to do all the steps upto restoring the database. It's exactly like you mentioned in your post. RMAN does not find the new back up. Let me know please.