OraFAQ Forum: Backup & Recovery » restore cold backup on new server oracle 8i windows 2000 server urgent

Home » RDBMS Server » Backup & Recovery » restore cold backup on new server oracle 8i windows 2000 server urgent

Mon, 28 August 2006 23:30

reyazan
Messages: 53
Registered: February 2005

Member

I have cold backup of oracle 8i on windows 2000 server.
Now i want to restore it on new oracle 8i windows 2000 server

Please provide the steps

Tue, 29 August 2006 02:22

himani3385
Messages: 2
Registered: June 2006
Location: gurgaon

Junior Member

hi
first create initialisation parameter file then
create control file .
and open database with open reset logs..

Tue, 29 August 2006 06:04

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Need more details. What did you use to create the backupset, what files are in your backupset, are you archiving, etc.....)??

Tue, 29 August 2006 23:24

reyazan
Messages: 53
Registered: February 2005

Member

i have backup of all datafiles,redo log files,controls file,
password file and parameter file

and database is in noarchive log mode

Wed, 30 August 2006 05:04

ebrian
Messages: 2794
Registered: April 2006

Senior Member

If you performed a clean shutdown and then did a cold backup, you could:

copy all the files you backed up to the new server (ensuring exact same directory structure and naming conventions)
create a new Windows service for the database using ORADIM
start the new Windows service
if needed, add appropriate listener entries

Previous Topic:	intersting error
Next Topic:	Questions about failover

Goto Forum:

]

Current Time: Mon Dec 23 08:15:23 CST 2024