Home » RDBMS Server » Backup & Recovery » restore on rman catalog database
restore on rman catalog database [message #142394] Fri, 14 October 2005 08:00 Go to next message
alanm
Messages: 284
Registered: March 2005
Senior Member

Hello All,
I am using the following script to backup the rman catalog database.

su - oracle <<EOF
cd /home/oracle
. RMAN.ksh
cd /home/oracle/rman_scripts
rman target system/tommy nocatalog

run {
allocate channel c1 type 'SBT_TAPE' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin/tdpo.opt)';
allocate channel c2 type 'SBT_TAPE' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin/tdpo.opt)';
backup
incremental level 0
format '/tmp/rman_%s.bak'
(database include current controlfile ) ;
change archivelog all crosscheck;
backup archivelog all
delete input
format 'RMAN_%s.arch';
sql 'alter system archive log current';
}
EOF


I am using the nocatalog option which uses the control_file_record_keep_time parameter.

how do you then perform a restore of this database.
can anyone let me have the syntax of a command to perform the restore.

best regards

Alan.
Re: restore on rman catalog database [message #142405 is a reply to message #142394] Fri, 14 October 2005 08:27 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
the same way you would restore a regular database as discussed in
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmrecov.htm#1014957
If that procedure fails, you neeed to look into something else
If the recovery catalog database is lost or damaged, and recovery of the recovery catalog database through the normal Oracle recovery procedures is not possible, then you must re-create the catalog. Examples of this worst-case scenario include:

    * A catalog database that has never been backed up
    * A catalog database that has been backed up, but cannot be recovered because the datafile backups or archived logs are not available

You have these options for partially re-creating the contents of the missing catalog:

    * Issue CATALOG commands to recatalog archived redo logs, backup control files, and datafile copies. Because the CATALOG command does not support recataloging of backup pieces or backup sets, you can re-create information about backup sets only by using the RESYNC CATALOG command.
    * Use the RESYNC CATALOG command to extract metadata from a control file and rebuild the recovery catalog. Note that you automatically lose any metadata that was contained in old control file records that aged out of the control file.

      Depending on the state of the target control file, you can:
          o Resynchronize from the current control file
          o Resynchronize from a control file copy

and you no need to do an RMAN backup on catalog database ( would be nice to have, but no need).
Just take an export after every backup.
You can easily schedule this .
Previous Topic: Using RMAN ...!!!
Next Topic: what is best? backup set or image copy!!!!
Goto Forum:
  


Current Time: Fri Apr 19 20:24:23 CDT 2024