Re: Recovery from hot backup question

Hi,

I am using recover until time or recover until cancel to make sure I do not accidently "roll into" the old online redo logs. I guess that the hub of my question is; whats the best way to recover using all of the archived redo. I think that if I try a "recover database (auto)" it will try to apply all archived logs then the online logs (which are old).

Tony
  Feher Lajos <feherl_at_finit.hu> wrote:
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 15 1999 - 07:20:38 CST