Re: Missing UNDO & TEMP datafiles in cold backup

From: Mark J. Bobak <mark_at_bobak.net>
Date: Thu, 28 May 2015 14:06:49 +0000
Message-ID: <CAFQ5ACLtzm7CkuS1Y6mhzg5tL4DdrGZjcXkaLYOFPu1zrS2mKQ_at_mail.gmail.com>

The controlfile not being available complicates the matter a bit. Is the original database still running somewhere? If so, you can do a 'alter database backup controlfile to trace;' and then edit the result as necessary. If that's not an option, you'll need to manually rebuild your controlfile. Not impossible, but not fun either...

As long as db was shut down cleanly (not shutdown abort), the missing undo is probably not the end of the world.

There are many possibilities here. I strongly recommend opening an SR with Oracle for specific guidance in your case.

-Mark

On Thu, May 28, 2015 at 8:27 AM Manjula Krishnan <oradba.la_at_gmail.com> wrote:

> 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 <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 - 16:06:49 CEST