Igor - Hopefully you won't lose your repository at the same time you lose
all your production database controlfiles. However, if that is happens,
hopefully you were outside the computer room at that moment. ;-)
So, you should be able to recover your repository and/or take a fresh
backup.
I should point out that even if you use an RMAN repository, the recovery
information is still stored in the control files, so you can still perform a
control file recovery. But Jared is correct that it is much more difficult
if you must try to recover the control file from the RMAN backup piece. That
is why I separately back up the control file (binary backup) after the RMAN
backup. I understand this is all much better in 9i.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Thursday, January 09, 2003 7:49 AM
To: Multiple recipients of list ORACLE-L
Doesn't the same apply to database repository, when it's lost?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 08, 2003 4:14 PM
> And how does one go about restoring a database when all control files
> are lost, and the only recovery data is stored in the control file?
>
> This doesn't sound very reasonable.
>
> Jared
>
>
>
>
>
>
> "Deshpande, Kirti" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 01/08/2003 11:44 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc:
> Subject: RE : RMAN Repository
>
>
> Joe,
> That's what I have heard (from 2 Oracle University
> Professors/Lecturers/Demonstrators). But no one would tell me when it may
> happen. We do not use RMAN (yet) so I did not pursue it further.
>
> - Kirti
>
> -----Original Message-----
> Sent: Wednesday, January 08, 2003 1:08 PM
> To: Multiple recipients of list ORACLE-L
>
>
> <snip>
>
> Obilgatory oracle statement/question: rumor has it by some instructors
> that RMAN repository is going away and only control file recoveries
> will be possible, truth or fiction?
>
> joe
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Deshpande, Kirti
> INET: [EMAIL PROTECTED]
>
> 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: [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).
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> 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: [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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Igor Neyman
INET: [EMAIL PROTECTED]
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: [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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
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: [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).
