Re: RMAN guru question

I see in 9ir2, you can autbackup the control file and can restore it as a standalone before even mounting the db, then you can mount the db and start the restore process.

thanks for the info, the experimentation continues :)

joe

DENNIS WILLIAMS wrote:

>Joe - I have been working on a disaster test for RMAN so we can quit doing
>weekly cold backups. I assumed the same as you, that RMAN writes its most
>recent information to the control file as well as the catalog (there is a
>retention parameter, so watch that). I tested no catalog recovery (just the
>control file) with a small practice database and it worked fine. Then I
>tried it with one of our production databases (recovering on a test system).
>RMAN ran for awhile, creating data files, and then stopped. I didn't get
>that issue debugged. Instead on my next try I loaded the RMAN catalog and
>went that route. Got interrupted on another project and haven't gotten back
>to it.
> One thing I have learned from disaster recovering RMAN is that you need
>to write a copy of the control file to the backup tape. While RMAN will
>backup the control file, it can't create it if there is no control file
>present. RMAN must first mount the database and it can't do that unless the
>control file is there. Once it has the database mounted, then RMAN can
>refresh the control file.
> My experience applies to Oracle 8.1.6, using disk file backups.
>Dennis Williams
>DBA
>Lifetouch, Inc.
>dwilliams_at_lifetouch.com
>
>-----Original Message-----
>Sent: Thursday, August 08, 2002 2:57 PM
>To: Multiple recipients of list ORACLE-L
>
>
>I've tested this and it works, i'm looking for verification of theory.
>
>1. built 2nd db for repository.
>2. built repository and registered db
>3. full backup via rman.
>4. disconnect from RMAN
>5. reconnect only to target
>6. shutdown/startup mount target
>7. restore database.
> It states, using controlfile.
>8. recover database.
>
>
>all looks good. my question is even though i'm using a catalog during my
>backup and simulate a total loss of that db by NOT connecting to a catalog
>during restore, it was able to get the info from the control file.
>
>IS this default behavior, that when using RMAN, the control file is ALWAYS
>written to even if a catalog is being used during the backup phase?
>
>Is this a safety net for those who might not be backing up their repository
>database?
>
>thanks, joe
>
>ENV: linux rh 7.3, oracle 9.2.0.1
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: jtesta_at_dmc-it.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).