| os crash [message #150947] |
Mon, 12 December 2005 03:30  |
maoro
Messages: 312
Registered: May 2005
|
Senior Member |
|
|
hello
i had an oracle server running on win xp, for some reasons they want to format the system , reinstall windows xp ,oracle server9i and restore the database ,
i have a daily cold backup for the database.
i just need ut help over the appropriate steps for doing so .
here the steps that i have :
1-installation of winxp
2-installation of orcale server9i
3- on sqlplys>startup nomount
4-create database with the same name as the old
5-copy the cold backup to drive d for example
6-edit the init parameter file to point to the location of the restored control files.
on sqlplus>
alter database mount
alter database open
shall i create the datatbase as i stated in step 4 , using the restored datafiles , control files , redo files ...
or just editing the init file is enough so no need to create the database
plz help
thanks for your time.
|
|
|
|
| Re: os crash [message #150953 is a reply to message #150947] |
Mon, 12 December 2005 04:58  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
No need to create the database, its already there.
You can search the forum for copying/cloning the database. It will help.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
