Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Restore w/old control file and new archive logs
pmatt69 wrote:
> I have been practicing doing backups and restores of 8.1.7 on Solaris. I
> can successfully restore all or some of the tablespaces using the backup
> files, current control files, and complete set of archive logs. This helps
> if we lose a datafile, or mistakenly delete something critical. My question
> is this: how do I a complete restore from a hotbackup (including control
> files), yet also roll forward using all the archive logs created since the
> hot backup. I want to deal with the scenario where we have lost all
> datafiles, control files, redo logs, etc, yet we have a complete hotbackup
> set from a week ago plus a full weeks worth of archive logs.
>
> We are not using RMAN.
>
> Thanks,
>
> Matt
>
If I remember, the (semi) syntax is like:
recover database using backup controlfile [untill cancel | date_time spec]
/Svend Received on Mon May 13 2002 - 15:30:31 CDT