Skip to Content
author's profile photo Former Member
Former Member

DATABASE STARTUP ERROR

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Jun 16, 2008 at 06:24 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 06:55 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 10:43 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 10:54 AM

    Hi Markus ,

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

    Regards

    Selvan

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.