Note: This is a 10g and above solution
Make a note of the source database dbid (2684779111)
Copy the backupset to your server:
The new location is D:\restoretest\BACKUPSET\2008_07_31
Created the instance using Database Configuration Assistant: Shutdown the instance once its been created.
i) Startup rman
Set oracle_sid=scms
Rman target sys/change_on_install
ii) Set the DBID
RMAN> set dbid=2684779111;
iii) Startup the database in nomount mode
RMAN> startup nomount;
iv) Restore the controlfile from the backup location on new server
RMAN> restore controlfile from 'D:\restoretest\BACKUPSET\2008_07_31\O1_MF_NCSNF_
FULL 31JUL2008_493P1ZD6_.BKP';
v) We now mount the database:
RMAN> alter database mount;
vi) We need to add our copied backupiece to the catalog
RMAN> catalog backuppiece 'D:\restoretest\BACKUPSET\2008_07_31\O1_MF_NNNDF_FULL
31JUL2008_493OSYQX_.BKP';
vii) We now restore the database
RMAN> restore database;
viii) Finally we open our database with the resetlogs command
Alter database open resetlogs;
Well this went well, and database was successfully restored, so can anyone see any potential problems or gotyas?
Message was edited by:
Keith Jamieson