DATABASE STARTUP ERROR

[Former Member]

Hi Gurus ,

We running SAP R/3 4.7 with Oracle 9i , Last week one Harddrive fail in that server , So we change the Harddisk and restart the server . After that we face the problem at the Database startup . Here below i mentioned the error .

SQL> startup

ORACLE instance started.

Total System Global Area 701046856 bytes

Fixed Size 454728 bytes

Variable Size 377487360 bytes

Database Buffers 321912832 bytes

Redo Buffers 1191936 bytes

Database mounted.

ORA-00322: log 5 of thread 1 is not current copy

ORA-00312: online log 5 thread 1: 'F:\ORACLE\DEV\MIRRLOGE\LOG_G15M2.DBF'

ORA-00322: log 5 of thread 1 is not current copy

ORA-00312: online log 5 thread 1: 'E:\ORACLE\DEV\ORIGLOGE\LOG_G15M1.DBF'

SQL>

Kindly give me the solution for resove the problem .

Regards

Selvan

[Former Member]

Hi Markus ,

Kindly give me the steps for this as per my error .

Regards

Selvan

[markus_doehr2]

Steps to copy a file?Not sure what you are asking about...

That file is an archive log which is usually backed up frequently. If you don´t have this file any more you´re lost.

I HIGHLY suggest you get someone on your side who has experience with a database recover if you´ve never done this before and if you have no clue what you are doing. A database recover is a critical action.

If it´s a production system I suggest you open an OSS call with appropriate priority and let the support folks assist you.

Markus

[Former Member]

Hi Deepak ,

As per your advice , I run the command ALTER DATABASE RECOVER UNTIL CANCEL ; , But it ends with error . I below mentioned thet error .

SQL> ALTER DATABASE RECOVER UNTIL CANCEL;

ALTER DATABASE RECOVER UNTIL CANCEL

*

ERROR at line 1:

ORA-00279: change 2530235295 generated at 06/12/2008 09:05:07 needed for thread

1

ORA-00289: suggestion : F:\ORACLE\DEV\ORAARCH\DEVARCHARC03345.001

ORA-00280: change 2530235295 for thread 1 is in sequence #3345

SQL>

Kindly sugest me to resolve this issue .

Regards

Selvan

[markus_doehr2]

You need to put the given archive log in the place so the database can continue to recover.

Markus

[Former Member]

Hi Stefen ,

We using Raid % configuration of disks , These are Hot Swapable , So We just replace the harddive and Rebuild the RAID 5 ARRAY , Thats All .

Regards

Selvan

[Former Member]

Hi

1. Shutdown the database.

2. Do a cold backup of all files if possible. If not hope for the best. I would highly recommend it. This will allow you to put it back if this doesn't work so you can try other options.

3. Issue the following commands at the svrmgrl prompt:

STARTUP MOUNT

SET AUTORECOVERY ON;

ALTER DATABASE RECOVER UNTIL CANCEL; REM Enter "CANCEL" when it promps you.

ALTER DATABASE OPEN RESETLOGS;

4. Backup

Best of luck !!!

[stefan_koehler]

Hello Selvan,

ok in this case i guess that the redo log files got corrupted by the crash or by mirroring the disks.

Have you shutdown your database correct or did it crash?

If not you can only perform an incomplete recovery because of both members of the redologroup are corrupted.

If your database was shutdown normal you can try a complete recover and a recreation of the redolog group.

Good luck.

Regards

Stefan

[stefan_koehler]

Hello Selvan,

how did you restore your database after the hard disk failure?

http://o2f-00322.ora-code.com/

It seems that you have done something wrong by the restore.

Regards

Stefan