RE: recatalogging rman backupset pieces in 9i
Date: Thu, 3 Jul 2014 19:24:36 +0000
Message-ID: <1AFD62082EEAF0448EF1815139687F1324B9E9A1_at_NC2PWEX504.us.ad.lfg.com>
I wonder if you can run it in another database? Maybe create a temporary one?
Chris Ruel * Oracle Database Administrator cruel_at_lfg.com<mailto:cruel_at_lfg.com> * Desk:317.759.2172 * Cell 317.523.8482
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Adams, Matthew (GE, Appl & Light)
Sent: Thursday, July 03, 2014 3:14 PM
To: Niall Litchfield
Cc: oracle-l_at_freelists.org
Subject: RE: recatalogging rman backupset pieces in 9i
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
Notice of Confidentiality: **This E-mail and any of its attachments may contain
Lincoln National Corporation proprietary information, which is privileged, confidential,
or subject to copyright belonging to the Lincoln National Corporation family of
companies. This E-mail is intended solely for the use of the individual or entity to
which it is addressed. If you are not the intended recipient of this E-mail, you are
hereby notified that any dissemination, distribution, copying, or action taken in
relation to the contents of and attachments to this E-mail is strictly prohibited
and may be unlawful. If you have received this E-mail in error, please notify the
sender immediately and permanently delete the original and any copy of this E-mail
and any printout. Thank You.**
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 03 2014 - 21:24:36 CEST