RMAN recovery question...

  • From: "Wolfson Larry - lwolfs" <lawrence.wolfson@xxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 5 Feb 2007 12:41:22 -0600

We've got a large database moving to new hardware.  It's currently being
backed up with 12 tape drives and with the new equipment they want to
restore with 24.
Oracle 9.2 and Netbackup 5.1.
Also they want to use the original Netbackup catalog as it's so big.
I'm not big on RMAN but I didn't think this would an issue.  Then
someone mentioned there might be a limit on the Veritas license for
Anyone know where we can verify this license issue?  No one here has
offered anything.


From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Syed Jaffar Hussain
Sent: Tuesday, January 30, 2007 12:33 AM
To: don@xxxxxxxxx
Cc: Niall Litchfield; jkstill@xxxxxxxxx; DIANNA.GIBBS@xxxxxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx; Thomas.Mercadante@xxxxxxxxxxxxxxxxx
Subject: Re: RMAN recovery question...

According to OracleR2 documentation: Re-Creation of Temporary Tablespaces in Whole Database Restore
and Recovery

After restore and recovery of a whole database, when the database is
opened, any missing temporary tablespaces recorded in the control file
version of the RMAN repository are re-created with their previous
creation size, AUTOEXTEND and MAXSIZE attributes.


Only temporary tablespaces that are missing are re-created. If a
tempfile is still present at the location recorded in the RMAN
repository but has an invalid header, then RMAN does not re-create the



On 1/30/07, Don Seiler <don@xxxxxxxxx> wrote: 

        I am running 10.2 (always have been).  I'll try this again
        pre-deleting them.
        On 1/29/07, Niall Litchfield <niall.litchfield@xxxxxxxxx> wrote:
        > Yes. Fixed, I believe, in 10.2
        > On 1/29/07, Don Seiler < don@xxxxxxxxx <mailto:don@xxxxxxxxx>
> wrote:
        > >
        > > For some reason I have to manually delete the old tempfiles
        > > RMAN is able to restore them from backup.  I could never
        > > why.  Has anyone else seen anything like this? 

Best Regards,
Syed Jaffar Hussain
Oracle ACE
8i,9i & 10g OCP DBA

"Winners don't do different things. They do things differently." 
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally privileged.

If the reader of this message is not the intended recipient, you are 
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.

If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.

Thank you.

Other related posts: