Re: what if recovery catalog is lost?

Yes, it is very possible. That would work as well as a cold backup. I just wanted the archivelogs too.

Regards,
Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, May 29, 2002 3:18 AM

> Ruth,
>
> Do you know if it's possible to make backup of recovery catalog using
> export/import?
>
> Regards,
> Alexandre
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, May 28, 2002 6:08 PM
>
>
> > 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).
> >
>
> --
> 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).