Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN recovery question...

Re: RMAN recovery question...

From: Syed Jaffar Hussain <sjaffarhussain_at_gmail.com>
Date: Tue, 30 Jan 2007 09:32:46 +0300
Message-ID: <97b7fd2f0701292232h619b8a89v750f0a7b0a20866@mail.gmail.com>


Hi,

According to OracleR2 documentation:

6.2.1.2 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.

Note:
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 file.

http://download-uk.oracle.com/docs/cd/B19306_01/backup.102/b14192/recov002.htm#BRBSC03607

Regards,

Jaffar

On 1/30/07, Don Seiler <don_at_seiler.us> wrote:
>
> I am running 10.2 (always have been). I'll try this again without
> pre-deleting them.
>
> Don
>
> On 1/29/07, Niall Litchfield <niall.litchfield_at_gmail.com> wrote:
> > Yes. Fixed, I believe, in 10.2
> >
> >
> > On 1/29/07, Don Seiler <don_at_seiler.us> wrote:
> > >
> > > For some reason I have to manually delete the old tempfiles before
> > > RMAN is able to restore them from backup. I could never understand
> > > why. Has anyone else seen anything like this?
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

http://jaffardba.blogspot.com/
http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
----------------------------------------------------------------------------------
"Winners don't do different things. They do things differently."

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 30 2007 - 00:32:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US