Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Restore w/old control file and new archive logs
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
![]() |
![]() |