Redo Log Error.

[Vipassana]

Hi,

I am getting the following error when starting the database:


SQL> startup;
ORACLE instance started.

Total System Global Area 171966464 bytes
Fixed Size 777956 bytes
Variable Size 145760540 bytes
Database Buffers 25165824 bytes
Redo Buffers 262144 bytes
Database mounted.
ORA-00314: log 4 of thread 2, expected sequence# doesn't match
ORA-00312: online log 4 thread 2:
'/home/racuser/nfsmount/oradata/OD10g/redo04.log'

Using Oracle 10g. Can you please help.

[aspdba]

i think the log files are currupt.

alter database open resetlogs;

p.s...Take a backup of the db after resetlogs

[julian]

Add to init.ora:

_ALLOW_RESETLOGS_CORRUPTION = true

and try to open.

[pando]

er, I wouldnt use that paramneter

implications:

The usage of this parameter leads to an in-consistent Database with no other alternative but to rebuild the complete Database. This parameter could be used when we realize that there are no stardard options available and are convinced that the customer understands the implications of using the Oracle's secret parameter. The factors to be considered are ;--
1. Customer does not have a good backup.
2. A lot of time and money has been invested after the last good backup and there is no possibility for reproduction of the lost data.
3. The customer has to be ready to export the full database and import it back after creating a new one.
4. There is no 100% guarantee that by using this parameter the database would come up.
5. Oracle does not support the database after using this parameter for recovery.
6. ALL OPTIONS including the ones mentioned in the action part of the error message have been tried.