Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: what if recovery catalog is lost?
I have put my recovery catalog database in archivelog mode. I do a cold
backup of the database and the archivelogs each Friday. This way I won't
lose it.
Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Tuesday, May 28, 2002 4:58 AM
> Hi,
>
> That strange, but this has never come to my mind before.
> Ideally, the recovery catalog should be on other than production server
(and
> it always was for me). And recovery catalog's database should be copied as
> well. Perhaps, using production database for recovery catalog.
> What if recovery catalog and production database crash at the same time
and
> there is no way to recovery database with recovery catalog?
> I need the functionality of RMAN with recovery catalog, but I don't have
> separate server :( so I'm going to place it on the same server, but
> different database. I'm going to backup both databases symbiothically
using
> each other as recovery catalog.
> If something goes wrong and server crashes with both databases, I will
have
> backup copies but no catalog.
>
> >>Recovery scenarios:<<
>
> --1. I could create empty recovery catalog and collect all information
again
> with CATALOG comand, but this works only when target database is open.
> Right?
>
> --2. Another possibility is to use RESYNC CATALOG FROM BACKUP CONTROL FILE
> should work fine, doesn't it? The only problem is that last structural
> changes are not available.
>
> --3. I'm not sure about third scenario - recovery target database without
> recovery catalog with backups taken while recovere catalog existed.
>
> I'm going to test this cases before set it up in production and I'd like
to
> know about you experience in that area.
>
> Thanks in advance.
>
> Alexandre
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Alexandre Gorbatchev
> INET: alexandre.gorbatchev_at_avermann.de
>
> 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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: rgramolini_at_tax.state.vt.us 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).Received on Tue May 28 2002 - 11:08:32 CDT
![]() |
![]() |