|
|
|
|
| Re: Restoring the COld Backup at different machine... [message #55555 is a reply to message #55535] |
Fri, 31 January 2003 04:50  |
kareka
Messages: 18
Registered: January 2003
|
Junior Member |
|
|
having backed up all the u need to copy those in the desired location on the target machine....
give command
startup pfile = (the path of the directory of the new placed parameter file)
this would start up the instance.
make sure the control file that you have copied is kept in the directory as mentioned n the parameter file or change the path as required......
now the db would mount but not open giving error of not finding the datafiles in the path mentioned in the controlfile
use
alter datafile move 'old_filename_path' to 'new_path';
this step is repeated for every datafile as asked by the appearing message;
finally the database could be opened up
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
