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

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
Re: recover from cold backup [message #57589 is a reply to message #57575] Tue, 24 June 2003 21:54 Go to previous message
Messages: 146
Registered: July 2002
Senior Member
in your db issue:
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: Fri Jun 02 06:32:19 CDT 2023