I am a sql dba, I am having only a little knowledge on Oracle. looking for help regarding oracle db restore.
I am having an Oracle 10g cold backup, i need to restore this on Oracle 11g setup, can you please help me understanding the process how to perform.
Oracle DB refresh on 11g using 10g Cold backup
oracleoracle-11g
Related Question
- How to take Oracle backup and restore
- How to restore operational Oracle 11g Database from full backup
- What is the most simple and easiest way to backup and restore on oracle 11g
- Oracle 11.2: Backup and recovery strategy based on full cold backup plus expdp
- Oracle 11g Rman restore with another database name from backup in windows platform
- Understanding of Oracle Statement-Level Read Consistency between Oracle 10g and 10g+
Best Answer
Datapump command like impdp can be used for importing the 10g DB contents into the 11g DB.
Update:
The above datapump command is an example of logical backup which can be done when a database is in running mode. Below are the common steps followed during a logical backup and restore:
Export(Backup) of full DB is taken in old server:
expdp system/password@db10g full=Y directory=DIRECTORY_ON_SERVER dumpfile=DUMPFILE_NAME.dmp logfile=LOGFILE_NAME.log
Dumpfile moved to new server
Import(Restore) dumpfile in the new server:
impdp system/password@db11g full=Y directory=DIRECTORY_ON_SERVER dumpfile=DUMPFILE_NAME.dmp logfile=LOGFILE_NAME.log
Now coming back to the actual question, what you are asking is a restore of the cold backup in 11g DB server.
The restore of the cold backup can be done by using RMAN command(s) as below:
I assume that you have taken backup of all the necessary files during the cold backup process.
Hope this helps you !!
Please share your progress with regard to this :)