Home » RDBMS Server » Backup & Recovery » Restoring the COld Backup at different machine...
Restoring the COld Backup at different machine... [message #55531] Wed, 29 January 2003 08:51 Go to next message
Oracle DBA
Messages: 4
Registered: January 2003
Junior Member
hello all,
I have taken a complete backup (cold) .. now i want to create a Duplicate Database on the Remote Machine..
Please let me know the steps..

Thanks
Re: Restoring the COld Backup at different machine... [message #55535 is a reply to message #55531] Wed, 29 January 2003 16:02 Go to previous messageGo to next message
Remi
Messages: 28
Registered: December 2002
Junior Member
You can re-create the controlfile in the new host (os must be the same)

Go to your original db and issue:
alter database backup controlfile to trace;


You can use this script at the remote machine.

Good luck!

Remi

http://askremi.ora-0000.com
Re: Restoring the COld Backup at different machine... [message #55555 is a reply to message #55535] Fri, 31 January 2003 04:50 Go to previous message
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
Previous Topic: RMAN incremental 0 or full backup?
Next Topic: diff between hot, cold backup
Goto Forum:
  


Current Time: Fri Mar 29 05:33:29 CDT 2024