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 ?
Click Here to Expand Forum to Full Width