Re: Missing UNDO & TEMP datafiles in cold backup

From: Manjula Krishnan <oradba.la_at_gmail.com>
Date: Thu, 28 May 2015 07:26:27 -0500
Message-Id: <36FD2A19-632C-4AD9-ABBC-BCCDA8A702F5_at_gmail.com>

Thanks hemant, mark and Connor. Yes, the db was shutdown clean. All db files except undo, control files and redo log files were copied over.

Sent from my iPad

> On May 27, 2015, at 9:18 PM, "Chitale, Hemant K" <Hemant-K.Chitale_at_sc.com> wrote:
>
> If it really is a *COLD* Backup, you can startup the database after you:
> a. Set UNDO_MANAGEMENT=’MANUAL’
> b. Removing the UNDO_TABLESPACE configuration
> In the parameter file.
>
> Then, when the database is OPEN
> 1. CREATE UNDO TABLESPACE ....
> 2. Set UNDO_TABLESPACE
> 3. Reset UNDO_MANAGEMENT to ‘AUTO’
>
> The TempFiles can be added back with ALTER TABLESPACE TEMP ADD TEMPFILE ....
>
> The SID has to match the parameter file name and can be different from DB_NAME and DB_UNIQUE_NAME.
> It would be good practice to use NID to change the DB_NAME and to change the DB_UNIQUE_NAME
>
> Hemant K Chitale
>
>
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Manjula Krishnan
> Sent: Thursday, May 28, 2015 3:53 AM
> To: oracle-l_at_freelists.org
> Subject: Missing UNDO & TEMP datafiles in cold backup
>
> I have all datafiles, control files & redo log files.What do I need to do to restore this database with a different SID?
>
> Thanks,
>
> Manjula
>
> This email and any attachments are confidential and may also be privileged. If you are not the intended recipient, please delete all copies and notify the sender immediately. You may wish to refer to the incorporation details of Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at https://www.sc.com/en/incorporation-details.html

--
http://www.freelists.org/webpage/oracle-l

Received on Thu May 28 2015 - 14:26:27 CEST