Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Restore w/old control file and new archive logs

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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 13 May 2002 18:53:15 +0200
Message-ID: <jqrvdu8s41sn2lsnin2b018lumk4nfqrna@4ax.com>


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.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon May 13 2002 - 11:53:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US