Re: No resetlogs after database recovery

Hi James,

 If you are performing partial recovery, then it is needed to open the database with RESETLOGS mode. In any other case, it is not needed.

Chirag Shah
Oracle Administrator

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:12:21 CDT