| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Restore from cold to new server
J. Dex,
Sure you can!
Load all of the files to the server. Take note of the locations of all of the database files (log files, data files and control files if they exist on tape).
Create a skeleton init.ora file naming the location of things that are needed (like control files, archive log directories, bdump, udump etc.). You can guess values for the tunable parameters (various pools and caches). These really don't matter for now. Just make them large enough to get the database to open.
On another database, issue an "alter database backup controlfile to trace". Copy the trace files created to your new server. Edit it to include the names of all the database files that you restored. Note that this trace file gives you the opportunity to create new control files if you do not have them.
Once you have this file set, startup no mount and run this file through sqlplus. Check the alert log for errors.
This sounds like fun!! Good Luck!
Tom
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of J. Dex
Sent: Thursday, September 29, 2005 11:24 AM
To: oracle-l_at_freelists.org
Subject: Restore from cold to new server
I have received an OS backup from another server. I don't have an init
and
the only controlfile I have is a controlfile from trace from a clone
(with a
different SID name) of the original database. Is there a way to get the
original database going on this new server without the init and
controlfile
from the original (especially since I don't have the ORACLE_SID info and
system password for the original)?
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 29 2005 - 10:36:24 CDT
 |
 |