| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Recovery from hot backup question
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.
Or "recover until cancel" with auto, so it just trickles through the logs until it cannot find any more...
You could also recover in parallel if time is of the essence. --
"Some days you're the pigeon, and some days you're the statue." Received on Thu Nov 11 1999 - 05:38:00 CST
 |
 |