Re: Recovery from hot backup question

you are good
but i don't know why do you want to use until time clause? recover all of the log files or you do not need any of that?

Tony Adolph wrote:

> 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 - 15:32:26 CST