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.
[EMAIL PROTECTED]
-----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: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
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: [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).
