Re: No resetlogs after database recovery

Hi,

if you lost your datafiles, but not your redolog, archived redo logs and controlfiles, there is no need for a RECOVER UNTIL CANCEL. A RECOVER UNTIL CANCEL is a incomplete recovery, and you have to RESETLOG. Instead, restore all your datafiles, be sure to not overwrite your available controlfiles, and

connect internal
startup mount
recover database
.
.
I suppose that the recovery process will ask after some time for a archived log sequence, which you don't find, but this is your CURRENT redolog file. Enter this name, and recovery should complete.

alter database open

Literature: Oracle 8.x Backup and Recovery Guide

Hope that helps
 Thomas
 thomas.schwickert_at_anzag.de

if you lost
jamesyang_at_163.net (James) wrote in message news:<86815f22.0107182257.ea5e12b_at_posting.google.com>...
> Suppose we lost all the data files due to the hardware failure but all
> the online redo logs and archive redo logs that exist on another disk
> are available in the right place. After restoring the latest backup,
> we need recovery the database as below:
>
> CONNECT INTERNAL
> SET AUTORECOVERY OFF
> STARTUP MOUNT
> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL
> ALTER DATABASE OPEN RESETLOGS;
>
> The problem is I do NOT want to resetlogs because it will start the
> sequene number from 1 again. Can I use below command (or else) to
> recovery the database without resetlogs?
>
> CONNECT INTERNAL
> SET AUTORECOVERY OFF
> STARTUP MOUNT
> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL NOW
> ALTER DATABASE OPEN;
>
> In addition, in which book can I find the detail inform of the command
> RECOVER DATABASE...
>
> Thanks for help comment.
> jamesyang_at_163.net
Received on Thu Jul 19 2001 - 04:53:05 CDT