Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

what is resetlogs

519709Sep 18 2007 — edited Nov 14 2007
I set up the autbackup for control file

CONFIGURE CONTROLFILE AUTOBACKUP ON

and then i backed up the datafile 1 at rman successfully
RMAN>backup datafile 1
after that i literally drop the contol01.ctl file after shuttting down the database,
after that try to startup the database by connecting SYS user i am facing following error
SQL> startup

ORACLE instance started.

Total System Global Area  171966464 bytes
Fixed Size                   787988 bytes
Variable Size             145750508 bytes
Database Buffers           25165824 bytes
Redo Buffers                 262144 bytes
ORA-00205: error in identifying controlfile, check alert log for more info
then i connect to RMAN and restore the controlfile
RMAN>restore controlfile from autobackup
i succed to restore the control file

after restoring the control file when i try to startup the database as a SYS user from sql
it give me ORA-01589: must use RESETLOGS or NORESETLOGS option for database open error what does it mean
SQL> STARTUP
ORACLE instance started.

Total System Global Area  171966464 bytes
Fixed Size                   787988 bytes
Variable Size             145750508 bytes
Database Buffers           25165824 bytes
Redo Buffers                 262144 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
i also try to open the database open resetlogs but not succeded and got new error why?
SQL> ALTER DATABASE OPEN RESETLOGS
  2  /
ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSTEM01.DBF'
now i tried to run the command ALTER DATABASE OPEN RESETLOGS at rman but no succed
Recovery Manager: Release 10.1.0.2.0 - Production

Copyright (c) 1995, 2004, Oracle.  All rights reserved.

RMAN> connect target sys/sys

connected to target database: ORCL (DBID=1161247030)

RMAN> alter database open resetlogs
2> ;

using target database controlfile instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 09/18/2007 00:16:26
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSTEM01.DBF'

Recovery Manager: Release 10.1.0.2.0 - Production
when i recover database..
RMAN> recover database
2> ;

Starting recover at 18-SEP-07
using channel ORA_DISK_1

starting media recovery

archive log thread 1 sequence 10 is already on disk as file E:\ORACLE\PRODUCT\10
.1.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2007_09_18\O1_MF_1_10_3GXMPL1G_.ARC
archive log thread 1 sequence 1 is already on disk as file E:\ORACLE\PRODUCT\10.
1.0\ORADATA\ORCL\REDO03.LOG
archive log filename=E:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELO
G\2007_09_18\O1_MF_1_10_3GXMPL1G_.ARC thread=1 sequence=10
archive log filename=E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO03.LOG thread=1 s
equence=1
media recovery complete
Finished recover at 18-SEP-07
and now when i run
RMAN> alter database open resetlogs
2> ;

database opened

RMAN> startup

database is already started

RMAN> shutdown

database closed
database dismounted
Oracle instance shut down

RMAN>
and from sql prompt now i can startup database succesfully unlike before please tell me what recover database does and what is resetlogs and what the connection of resetlogs to recover database??

tks & regards
umaisi
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 12 2007
Added on Sep 18 2007
2 comments
54,178 views