Re: Restore w/old control file and new archive logs

Knut Talman <knut.talman_at_mytoys.de> wrote in message news:<3CE0DF90.ED93F4A4_at_mytoys.de>...
> Sybrand Bakker wrote:
> >
> > On Mon, 13 May 2002 10:44:51 -0400, "pmatt69" <pmatt69_at_hotmail.com>
> > 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
> > >
> >
> > recover database using backup controlfile until cancel
> >
> > if you don't have any controlfile at all, you're toast.
>
> If he knows the location and size of all datafiles and log files he can create a
> new controlfile, can't he?
>
> Regards,
>
> Knut

Sure, but this won't pick up SCN info, as far as I am aware of.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Tue May 14 2002 - 09:31:37 CDT