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

Sybrand Bakker wrote:
>
> 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.

OK, but he can do a "recover database using backup controlfile until cancel" anyway.

Regards,

Knut Received on Tue May 14 2002 - 09:52:45 CDT