ALTER DATABASE RECOVER DATABASE UNTIL CANCEL;
ALTER DATABASE RECOVER DATABASE USING BACKUP CONTROLFILE.
ALTER DATABASE OPEN RESETLOGS;
It seems that your instance crashed, and your lost redo log is needed by instance recovery.
In such case, the only solution is restore backup(no matter hot or cold) and do incomplete recovery.
If you really have no any backup, the only final solution is use undocumented parameter:
and startup mount database,
Recover database until cancel
Alter database open resetlogs.
Do full exp and rebuild your database.
I think _allow_resetlogs_corruption is the only solution you have since you have no backups. But it should be used only with Oracle's guidance. If you have Oracle support, then better take their help.
But if you want to do it on your own, then better take backup of current database, before using this parameter.
Do you realize this thread was TEN years old?
Originally Posted by DBAtom
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
I don't think that spammer's care. I would not buy from soaring turkey consulting, just because they spam a forum...
Originally Posted by PAVB
How tacky is that!
this space intentionally left blank
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 117442128 bytes
Database Buffers 163577856 bytes
Redo Buffers 2973696 bytes
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1:
then again create the control file
SQL> startup nomount
Create controlfile reuse set database "chaitu"
LOGFILE GROUP 1 ('/u01/app/oracle/product/10.2.0/db_1/oradata/chaitu/redo01.log') SIZE 51200K,
GROUP 2 ('/u01/app/oracle/product/10.2.0/db_1/oradata/chaitu/redo02.log') SIZE 51200K,
GROUP 3 ('/u01/app/oracle/product/10.2.0/db_1/oradata/chaitu/redo03.log') SIZE 51200K
Control file created.
SQL> alter database mount;
SQL> alter database open resetlogs;
try this it will work
Click Here to Expand Forum to Full Width