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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of J. Dex
Sent: Thursday, September 29, 2005 11:24 AM
To: oracle-l@xxxxxxxxxxxxx
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)?

_________________________________________________________________
Don't just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/

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

Other related posts: