RMAN resync of catalog to controlfile

From: Joseph S Testa <jtesta_at_dmc-it.com>
Date: Wed, 05 Mar 2003 06:19:23 -0800
Message-ID: <F001.0056096A.20030305061923@fatcity.com>

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). Received on Wed Mar 05 2003 - 08:19:23 CST