Re: Missing UNDO & TEMP datafiles in cold backup

From: Manjula Krishnan <oradba.la_at_gmail.com>
Date: Thu, 28 May 2015 11:04:08 -0500
Message-ID: <CAB-FsKwsZ6mGcAfkijHVaPQing-v1k6o8t9VND52yzrLjURa-Q_at_mail.gmail.com>



Sorry, if it sounds confusing. I have all control files, redo log files and application database files. The undo & temp datafiles were on a different file system and there was too much workplace "drama" at the same time, so I missed copying those over while the database was down. I just want to restore this to another server and make it functional if we need to extract any old data.

On Thu, May 28, 2015 at 9:06 AM, Mark J. Bobak <mark_at_bobak.net> wrote:

> 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 - 18:04:08 CEST

Original text of this message