thanks, joe
Tim Gorman wrote:
Joe,
Thinking outside the box a little...
How about if you query the recovery catalog views on RMAN repository database, using a technique of "SQL-generating-RMAN"?
Connecting to the recovery catalog database, you could query the RC_BACKUP_CONTROLFILE view to generate a series of CATALOG CONTROLFILECOPY commands, query the RC_BACKUP_DATAFILE view to generate a series of CATALOG DATAFILECOPY commands, and query the RC_BACKUP_REDOLOG view to generate a series of CATALOG ARCHIVELOG commands. Of course, you'd have to join all these views to RC_BACKUP_SETS and RC_BACKUP_PIECES in order to get the actual filenames/file handle-names as well, so query wouldn't be quite trivial, but nothing too crazy.
So, your queries in SQL*Plus against the RMAN recovery catalog database would spool out a script of RMAN commands. Then exit SQL*Plus and connect to RMAN in NOCATALOG mode to run the generated commands against the target database.
I'd be concerned about the after-effect of doing this when you finally do a subsequent RESYNC CATALOG, but until I get a chance to test this sometime next week, perhaps some enterprising soul might consider giving it a try in a test environment?
What do you think?
-Tim
----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, March 05, 2003 12:19 PM
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 thebackup
information stored in the catalog? Other than maybe deciding torevert to a
thetime 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,
backup info was pushed from controlfile to repository(YEA).controlfile
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
gets updated with info from repository, no such luck. I did a dumpof
the controlfile(via alter session set events 'immediate trace nameand
controlf level 10'), looking for the section on BACKUP SET RECORDS
BACKUP PIECE RECORDS and there is nothing there.records
so my question is this: is the resync only a one way push, i
understand oracle's mentality about not overwriting the backup
in the controlfile since that should be the true information, but isinto
there a way to force oracle/rman to push the repository info back
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).
-- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the "CACHE"
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe 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).
