Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: full recovery

RE: full recovery

From: Rich Holland <holland_at_guidancetech.com>
Date: Wed, 21 Jan 2004 08:54:32 -0800
Message-ID: <F001.005DDC54.20040121085432@fatcity.com>


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).
Received on Wed Jan 21 2004 - 10:54:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US