RE: full recovery

I hadn't noticed the previous messages in this thread and haven't read Robert Freeman's book yet.
But I don't think that an ALTER DATABASE BACKUP CONTROLFILE TO TRACE would mean that you would lose RMAN Recovery Information from the *current* *online* controlfile.
The Trace generated would only allow you to create a *new* controlfile and that, obviously, would not have any RMAN records in it. What your backups should include are _binary_ backups of the controlfile, not Trace file backups. You can then use the _binary_ backup to perform a restore/recovery.
{A Trace file backup additionally is good as it still allows you to capture the database structure}
Hemant

At 08:54 AM 21-01-04 -0800, you wrote:
>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).

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated 05-Jan-04}

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

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).