Doing a restore from an RMAN backup to a freshly deployed Oracle Database Appliance seems like a\u00a0conceivable scenario, so I figured it would be nice to have tried it at least once.<\/p>\n
For this test, I have a backupset on \/s01\/backup\/testdb\/\u00a0<\/em>and no backup catalog. I have deployed the ODA using the parameter file from the original deploy, so that network and grid infrastrcuture configuration as well as database and instance names are the same.<\/p>\n First, we need the DBID of the old database. One place to see it is in the file name of the control file auto backup. The first number is the DBID:\u00a0testdb_c-60599356-20121022-03<\/p>\n We must also figure out the controfile autobackup format, I have it set to\u00a0\/s01\/backup\/testdb\/testdb_%F<\/em><\/p>\n Similarly we need the location of the SPFILE on the new database, which we can find with\u00a0show parameter spfile<\/em>.\u00a0In this case it’s\u00a0+DATA\/testdb\/testdb.ora<\/em><\/p>\n Now we can shut down the instance on both nodes, and fire up RMAN on node 1 to restore the SPFILE.<\/p>\n set ORACLE_SID=testdb1 Ok, we first restored the spfile and converted it to a dummy pfile – just so we could get the newly deployed spfile out of the way, start the database from the pfile, and restore the spfile back to it’s original location. Next up is the control files:<\/p>\n startup nomount; That was rather easy. If you do have archive logs or backup pieces that are newer than the control file snapshot, they should now be cataloged:<\/p>\n catalog archivelog \/s01\/secondary_archive\/2012_10_23_testdb_4445.arc;<\/p><\/blockquote>\n I don’t have anything to add, so I’m all set for restore.<\/p>\n alter database mount; Since I don’t have a copy of the most current archive log, I must then settle for an incomplete recovery and open the database with resetlogs;<\/p>\n alter database open resetlogs;<\/p><\/blockquote>\n Database is back in business. Any changes between time of backup \u00a0and \u00a0time of failure are lost.<\/p>\n","protected":false},"excerpt":{"rendered":" Doing a restore from an RMAN backup to a freshly deployed Oracle Database Appliance seems like a\u00a0conceivable scenario, so I figured it would be nice to have tried it at least once. For this test, I have a backupset on … Continue reading
\nrman target \/
\nset DBID = \u00a060599356;
\nstartup nomount;
\nset \u00a0CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘\/s01\/backup\/testdb\/testdb_%F’;
\nrestore spfile to pfile ‘\/tmp\/dummy.ora’ from autobackup;
\nshutdown immediate;
\nstartup nomount pfile=’\/tmp\/dummy.ora’;
\nrestore spfile to ‘+DATA\/testdb\/spfiletestdb.ora’ from autobackup;
\nshutdown immediate;<\/p><\/blockquote>\n
\nrestore controlfile from autobackup;
\nshutdown immediate;
\nstartup nomount;<\/p><\/blockquote>\n
\nrestore database;
\nrecover database;<\/p><\/blockquote>\n