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@xxxxxxxxx>
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@xxxxxx>
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@xxxxxxxxxxxxx [
mailto:oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx>] *On
Behalf Of *Manjula Krishnan
*Sent:* Thursday, May 28, 2015 3:53 AM
*To:* oracle-l@xxxxxxxxxxxxx
*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
