Assuming you have stored the backup sets onto tape (we hope!!), you must first get them off the tape using the OS, and put them back where rman put them when you ran the backup. After that, rman will find the backup sets and restore things where they are supposed to go. If, in the worst-case scenario (everything gets blown away), you must put the control_file.bak back, you copy that "by hand" at the OS level to the location and file name specified in the init.ora. When not using a catalog database, the control file IS your catalog; so it is a most sacred and hallowed object ... even when nothing else is (referring to another thread that had been running). And that is why you make a copy of it AT THE END of the backup.
> -----Original Message----- > From: OraCop [mailto:oracop@;yahoo.com] > Sent: Tuesday, November 12, 2002 4:19 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Backup/Restore > > > Stephen: Thanks a lot for Ur response. > How do U restore from the backup? > have a script? > > > > --- Stephen Lee <[EMAIL PROTECTED]> wrote: > > > > > > You don't say if you are using catalog or not. If > > not, be sure to backup > > control files at end of backup. For what it's worth > > here is what I do for > > disk backups and no catalog. Business critical > > databases use catalog and go > > directly to tape using Networker (P.O.S. ... at > > least on Tru64). I have > > separate scripts for database and log files in case > > the archived log > > destination gets dangerously full (monitored by cron > > job). > > > > For database: > > > > run { > > allocate channel ch1 type disk format > > '/u05/oracle/admin/HRP1/backup/%U_DATA'; > > set command id to 'rman'; > > backup > > tag backup_db_full > > (database include current controlfile); > > release channel ch1; > > } > > > > > > For log files (we are duplexing on this database): > > > > run { > > allocate channel ch1 type disk format > > '/u05/oracle/admin/HRP1/backup/%U_ARCH'; > > set command id to 'rman'; > > change archivelog all crosscheck; > > backup > > (archivelog all delete input); > > backup > > (archivelog like > > '/oracle/app/oracle/admin/HRP1/arch2/%' delete > > input); > > release channel ch1; > > allocate channel ch1 type disk format > > '/u05/oracle/admin/HRP1/backup/%U_CONTROL'; > > backup current controlfile tag='backup'; > > release channel ch1; > > sql "ALTER DATABASE BACKUP CONTROLFILE TO > > ''/u05/oracle/admin/HRP1/backup/CONTROL_FILE.BAK'' > > REUSE"; > > } > > > > > > If the database and all controlfiles got blown away, > > then the > > CONTROL_FILE.BAK is your salvation. > > > > The following "script" is kept handy as a fast > > reference for restoring. I > > run the commands by hand; but the script serves to > > jog my memory as to the > > commands. I've slept since I put this together, but > > I think some of the > > commands are for when you have a catalog. > > > > #!/bin/ksh > > > > ## Define variables for your SID > > export ORACLE_SID=ABCXYZ > > export USER=internal > > export PASS=the_password > > > > ## With Oracle 9.X you must use sqlplus. > > svrmgrl <<-XXX > > connect internal > > startup nomount > > exit > > XXX > > > > rman nocatalog <<-XXX > > connect target ${USER}/${PASS}@${ORACLE_SID} > > > > run { > > > > ### If you have control files, then you don't need > > format when allocating > > channel. > > allocate channel ch1 type disk; > > > > ### When you want to restore up to, but not > > including, a specific log > > sequence number > > ### For example, the database wants log 275, but > > all you have in rman > > catalog are 273 and 274 > > #set until logseq=275 thread=1; > > > > ### When you want to restore to a specific time. > > # set until time "to_date('2001-02-09 > > 02:00:00','YYYY-MM-DD HH24:MI:SS')"; > > > > ### Various syntax possibilities for restoring > > control files > > #restore controlfile to > > '/u01/oradata/ORACLE_SID/control_01.ctl'; > > # restore controlfile to > > '/u02/oradata/ORACLE_SID/control_02.ctl'; > > # restore controlfile to > > '/u06/oradata/ORACLE_SID/control_03.ctl'; > > # replicate controlfile from > > '/u01/oradata/ORACLE_SID/control_01.ctl'; > > ### The following just restores them all. > > ### DO NOT restore controlfile when doing a point > > in time recovery. > > ### Most likely, you will not restore controlfile > > unless you have lost all > > control files. > > ### If you are not using a catalog, then you must > > copy a backup of the > > control file at the OS level. > > # restore controlfile; > > > > sql 'ALTER DATABASE MOUNT'; > > restore database; > > #### You might or might not need restore > > archivelog. > > #### When doing backups to disk, you probably don't > > need it. > > # restore archivelog all; > > recover database; > > #### If control file was restored, then you will > > probably need resetlogs. > > # sql 'ALTER DATABASE OPEN RESETLOGS'; > > sql 'ALTER DATABASE OPEN'; > > > > release channel ch1; > > } > > > > XXX > > > > > > #### If you had to restore the controlfiles (or > > hand-copy in backup > > controfiles), > > #### or if you lost online redo log(s), or if you > > are missing archived > > log(s), > > #### then, you will likely need to recover the > > database by hand using one > > or > > #### more of the following commands. > > > > ## With Oracle 9.X you must use sqlplus. > > ##svrmgrl <<-XXX > > ## connect internal > > ## alter database recover using backup controlfile > > until cancel; > > ## alter database recover using backup controlfile; > > ## alter database recover until cancel; > > ## alter database recover; > > ## alter database open; > > ## alter database open resetlogs; > > ##XXX > > > > #### If you are using a catalog, then you will need > > to reset database > > #### in the catalog after restoring. > > echo "" > > echo " ------ DON'T FORGET ------ DON'T FORGET > > ------" > > echo "Don't forget to RESET DATABASE in RMAN > > catalog." > > echo " ------ DON'T FORGET ------ DON'T FORGET > > ------" > > echo > > > > > > > > > -----Original Message----- > > > From: OraCop [mailto:oracop@;yahoo.com] > > > Sent: Tuesday, November 12, 2002 2:29 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: Backup/Restore > > > > > > > > > Hello, > > > I need to comeup with backup strategy for my > > > production oracle systems running 9iR2 on > > Solaris9. > > > > > > I do have veritas Netbackup installed. I would > > > really appreciate if someone can answer these > > > important questions for me. > > > > > > 1- Do I need to install Veritas Oracle agent > > for > > > backup? > > > 2- What are COMPLETE steps involved to > > > backup/restore if I want to use Veritas for > > > this purpose? > > > 3- I am using following script to create > > backup on > > > === message truncated === > > > __________________________________________________ > Do you Yahoo!? > U2 on LAUNCH - Exclusive greatest hits videos > http://launch.yahoo.com/u2 > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: OraCop > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
