RE: recatalogging rman backupset pieces in 9i

From: Adams, Matthew (GE, Appl & Light) <"Adams,>
Date: Thu, 3 Jul 2014 19:14:20 +0000
Message-ID: <D4EBD31A58EB64419330A4F471BB2F2415DF7694_at_CINURCNA02.e2k.ad.ge.com>



With the database not recovered yet, I can’t run pl/sql packages

From: Niall Litchfield [mailto:niall.litchfield_at_gmail.com] Sent: Thursday, July 03, 2014 3:13 PM
To: Adams, Matthew (GE, Appl & Light)
Cc: oracle-l_at_freelists.org
Subject: Re: recatalogging rman backupset pieces in 9i

There is or used to be a MOS note on cataloguing that used as Chris says dbms_backup_restore. Definitely worth a search and maybe try an SR (of course 9i may not get a great response).

On Thu, Jul 3, 2014 at 7:05 PM, Adams, Matthew (GE, Appl & Light) <MATT.ADAMS_at_ge.com<mailto:MATT.ADAMS_at_ge.com>> wrote: Scenerio: rebuilding a 9i database after complete systems failure. Control files and Data files from last rman complete backup have been restored. Attempt to recover forward to the point of failure (or as close as we can get). Not using a catalog, and obviously, control files do not know about archive log backups done since last full backup. The archive log backups were done as sets, not individual files.

I know that in 9i, rman did not support re-catalogging backup sets, only individual files.

Is there any way around this? I need to either get the information about backupset pieces into the control files, or extract the individual archived redo log files from them, so I could to the recovery manually.

Any suggestions would be appreciated.

Matt Adams

--

Niall Litchfield
Oracle DBA
http://www.orawin.info
--

http://www.freelists.org/webpage/oracle-l Received on Thu Jul 03 2014 - 21:14:20 CEST

Original text of this message