Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN resync of catalog to controlfile

RE: RMAN resync of catalog to controlfile

From: Joseph S Testa <jtesta_at_dmc-it.com>
Date: Wed, 05 Mar 2003 11:19:28 -0800
Message-ID: <F001.0056112E.20030305111928@fatcity.com>


the catalog has all of the current backup info, so if i lose the repository(before taking a backup after rebuilding the controlfile), I'm SOL. I logged a tar and oracle's response is, no way to push catalog info back into the controlfile.

joe

> Joe - I'm confused. If you rebuild the controlfile, what good is the
backup
> information stored in the catalog? Other than maybe deciding to
revert to a
> time before the rebuild, and you're going to need the catalog for that
> anyway.
>
> Dennis Williams
> DBA, 40%OCP, 100% DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Wednesday, March 05, 2003 8:19 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Robert, and all of you other RMAN gurus.
>
> scenario 1: repository unavailable, so rman backup was done using
> controlfile only. upon later successful connection to repository,
the
> backup info was pushed from controlfile to repository(YEA).
>
> scenario 2: I have to rebuild the controlfile and have a rman
> repository. so i do a resync in rman, rebuild the controlfile and
> connect back to repository, doing a resync HOPING that the
controlfile
> gets updated with info from repository, no such luck. I did a dump
of
> the controlfile(via alter session set events 'immediate trace name
> controlf level 10'), looking for the section on BACKUP SET RECORDS
and
> BACKUP PIECE RECORDS and there is nothing there.
>
> so my question is this: is the resync only a one way push, i
> understand oracle's mentality about not overwriting the backup
records
> in the controlfile since that should be the true information, but is
> there a way to force oracle/rman to push the repository info back
into
> the controlfile, i've not found a solution for this.
>
> if anyone is interested in the dump files, let me know and i'll make
> them available on the web so you can see what I'm talking about.
>
> thanks, joe
>
>
>
>
> Joseph S Testa
> Chief Technology Officer
> Data Management Consulting
> p: 614-791-9000
> f: 614-791-9001
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Joseph S Testa
> INET: jtesta_at_dmc-it.com
>
> 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: 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.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> 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: 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).
>
>

Joseph S Testa
Chief Technology Officer
Data Management Consulting
p: 614-791-9000
f: 614-791-9001

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

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: 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 Wed Mar 05 2003 - 13:19:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US