Recovery from hot backup question

From: Tony Adolph <tony.adolph_at_viaginterkom.de>
Date: Thu, 11 Nov 1999 13:41:22 GMT
Message-ID: <80eh22$oh2$1@nnrp1.deja.com>

Hello all.

I am rebuilding a database from a hotbackup from another database. The hot backup contains all the datafiles, the control files and the recent archive redo logs. The online redo logs are not used and to ensure nothing is missing from the backup the "current" online redo log is archived at the end of the backup proceduer. All is then copied to tape. (The pfile on the new server is "compatible" with the backup)

Question:
Is the following procedure the best way to restore:

copy files from tape to new server (different locations due to space constraints).

SVRMGR23> startup mount
SVRMGR23> alter database rename file 'from' to 'to'
SVRMGR23> alter database recover until time 'YYYY-MM-DD:HH24:MI:SS'

Where the time is the date of the last archive redo log write. SVRMGR23> alter database open resetlogs

or is there a better / more effective way to do this?

Thanks for any info

Regards
Tony Adolph

PS Oracle 7.3.4.0.0 on NT 4

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 11 1999 - 07:41:22 CST