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