cyprusgaq.blogg.se - Hot backup in oracle 10g steps

Mount the database with this control fileĬatalog start with '/ora_backup/test/amit/'

Output file name=+DATA_DG/amit/controlfile/control01.ctl Using target database control file instead of recovery catalogĬhannel ORA_DISK_1: SID=505 device type=DISKĬhannel ORA_DISK_1: restoring control fileĬhannel ORA_DISK_1: restore complete, elapsed time: 00:00:03 Rman log=/ora_backup/test/amit/restore.log << EOF Login to RMAN prompt and restore the controlfile Total System Global Area 5344731136 bytesĤ. Startup nomount pfile='/ora_backup/test/amit/initamit.ora'Ĭreate spfile from pfile='/ora_backup/test/amit/initamit.ora' *.undo_tablespace='UNDO' # as the backup is of 10g database, we have to keep it UNDO# *.db_name='amit'#Reset to original value by RMAN *.control_files='+DATA_DG/amit/controlfile/control01.ctl','+DATA_DG/amit/controlfile/control02.ctl'#Set by RMAN *.audit_file_dest='/opt/oracle/admin/amit/adump'

PFB steps to restore and upgrade a 10.2 version database to 11.2 version :-Ģ. Yesterday I got a requirement to restore one of my 10g database Rman backup, now all our 10g database servers were decommissed.