| Creating new Database from Datafiles [message #71586] |
Tue, 26 November 2002 07:57  |
msh
Messages: 11
Registered: July 2002
|
Junior Member |
|
|
Hi,
Suppose My database is running in Archivelog mode. And my DB went down. But i have the backup of datafiles and control files in addition to archivelog files. How can i copy and create another database with that files on another machine.What steps has to be taken. Please anybody let em know.
Rgds,
msh..
|
|
|
|
| Re: Creating new Database from Datafiles [message #71588 is a reply to message #71586] |
Tue, 26 November 2002 08:09  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
1. issue alter datbase backup control file to trace ( from the source db)
2. do a clean shutdown of the source database. (do not
open it, until u can successfully COPY the databse
to another machine,and new datdabase is OPEN).
3. create the same directory structure in target machine
(else , u can use the backup of controlfile to
recreate one there...let this be last choice)
4. copy the files from source to target.
copy the initsid.ora, control files, datafiles etc...
5. in the new machine( where oracle is installed already)
set the new ORACLE_SID
set the new ORACLE_HOME
set the new ORACLE_BASE.
edit the copied init.ora file.
update all the entries like controlfile location
logfiles location (if there is a change )
6. start the instance with this new initsid.ora.
mount the database
open the database.
----------------------------------------------------------------------
1. If the directory structure is different,
then take the backup of controlfile ( from trace)
and alter the file locations in it.
recreate the control file to relfect the new locations.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
