Home » RDBMS Server » Backup & Recovery » recover from cold backup
recover from cold backup [message #57575] Tue, 24 June 2003 06:21 Go to next message
Istvan Elek
Messages: 2
Registered: August 2002
Junior Member
Hi!

My name is Steven.
I want to establish a test database from an active database which is in another server and path.
I have everyday cold backup.
What should i do?
My opinion is to copy backup data files and control files and redo files to the same path on the computer which have the test database.
Should i redo control files?
Should i make the same tablespaces in test database like the original database?
How can i establish the test database from original one with cold backup?

Thak you for your help
Steven
Re: recover from cold backup [message #57589 is a reply to message #57575] Tue, 24 June 2003 21:54 Go to previous message
ctg
Messages: 146
Registered: July 2002
Senior Member
in your db issue:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
this will create a script file in your USER_DUMP_DEST. Copy your backup datafiles, redo logs and this trace file to your other machine. modify this script so it has the STARTUP NOMOUNT, CREATE CONTROLFILE, RECOVER DATABASE, ALTER DATABASE OPEN, etc in it (take out all comments). If your files are going to be in a different directory, just modify the script and run it.
Previous Topic: Backup help.
Next Topic: killing sessions prior to backing up a database
Goto Forum:
  


Current Time: Thu Mar 28 12:52:05 CDT 2024