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. > [EMAIL PROTECTED] > > > -----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: [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). > > 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: [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).
