RE: full recovery

Sorry it took so long to get back to you; I've been caching the list for awhile and am just starting to catch up. :-)

Page 43, in the grey box with title 'Re-Creating the Controlfile: RMAN Users Beware!'

Rich

--
Rich Holland        (913) 645-1950        SAP Technical Consultant
print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E<FP\@:&%C:V5R\"\@\`\`");



> -----Original Message-----

> From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] On Behalf Of

> DENNIS WILLIAMS

> Sent: Friday, November 07, 2003 3:55 PM

> To: Multiple recipients of list ORACLE-L

> Subject: RE: full recovery

> 

> Rich - Could you point to the place where Robert states that bit about

> controlfiles to trace? Thanks.

> 

> Dennis Williams

> DBA

> Lifetouch, Inc.

> dwilliams_at_lifetouch.com

> 

> -----Original Message-----

> Sent: Friday, November 07, 2003 1:59 PM

> To: Multiple recipients of list ORACLE-L

> 

> 

> I believe that an 'alter database backup controlfile to trace' loses the

> RMAN data stored in the control files if you're not using a repository (if I

> remember right from RF's book).

> 

> Since we're not using a repository, we've got controlfile autobackup on (in

> 9i use 'configure controlfile autobackup on').  We dump these disk copies

> via filesystem backups as a safety measure.  We also do a backup database,

> archivelogs, and then control (but all in one step; I'm not sure I'm clear

> on the reason for separating them into three backup sets)....

> 

> Rich

> --

> Rich Holland        (913) 645-1950        SAP Technical Consultant

> print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E<FP\@:&%C:V5R\"\@\`\`");

> 

> > -----Original Message-----

> > From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] On

> > Behalf Of Mercadante, Thomas F

> > Sent: Friday, October 24, 2003 2:35 PM

> > To: Multiple recipients of list ORACLE-L

> > Subject: RE: full recovery

> >

> >

> > AK,

> >

> > First, your normal backup should backup your database in the following

> > order:

> >

> > Database, archivelogs and then control file.  I actually do

> > this in three

> > separate Rman steps.  This is so that the most recent control file is

> > backups up after all of the data.  This allows your to perform an

> > incoimplete-recovery-restore to as late a time as possible.

> > Also, consider

> > adding a database trigger that, upon startup, perform an

> > "alter database

> > backup controlfile to trace;"  Keep a copy of this trace file

> > someplace safe

> > as a sanity check.  You could use it to recreate your

> > controlfiles if all

> > else fails.

> >

> > Your recovery steps are as follows:

> >

> > 1. restore oracle software from tape.

> > 2. restore config files ( init.ora , listener. ora ).

> > 3. startup instance with nomount.

> > 4. run Rman to restore the control file from tape.

> > 5. Alter database mount

> > 6. run Rman to restore database files

> > 7. alter database open resetlogs.

> > 8. perform a brand-new Rman backup (database, logs & controlfile)

> >

> > turn the system back to the users (with many back-pats from

> > management).

> >

> > You should be testing this on a regular basis.

> >

> > Good Luck!

> >

> > Tom Mercadante

> > Oracle Certified Professional

> >

> > -----Original Message-----

> > Sent: Friday, October 24, 2003 2:15 PM

> > To: Multiple recipients of list ORACLE-L

> >

> >

> > Here is a scenerio :

> > I am taking full database backup everynight using rman to tape . which

> > includes archive logs and control file. Not using

> > catalog.Also have a backup

> > of complete file system including oracle software and

> > configuration files (

> > init.ora , listener.ora etc.. )

> > I lost the host on a particular day at 12 am afternoon. Now I want to

> > restore this db to latest possible time to another host (

> > with same name )

> >

> 

> --

> Please see the official ORACLE-L FAQ: http://www.orafaq.net

> --

> Author: Rich Holland

>   INET: holland_at_guidancetech.com

> 

> 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: ListGuru_at_fatcity.com (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.net

> --

> Author: DENNIS WILLIAMS

>   INET: DWILLIAMS_at_LIFETOUCH.COM

> 

> 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: ListGuru_at_fatcity.com (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.net
-- 
Author: Rich Holland
  INET: holland_at_guidancetech.com

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: ListGuru_at_fatcity.com (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).