This discussion is archived
11 Replies Latest reply: Nov 6, 2013 9:10 PM by MahirM.Quluzade RSS

error on starup

TheHades0210 Newbie
Currently Being Moderated

Dear Experts,

 

Upon starting up an instance I was prompted by this;

 

Enter password:
Connected to an idle instance.

 

SQL> startup
ORACLE instance started.

 

Total System Global Area  417546240 bytes
Fixed Size                  2213936 bytes
Variable Size             364906448 bytes
Database Buffers           41943040 bytes
Redo Buffers                8482816 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 25838
Session ID: 191 Serial number: 3
SQL> select name from v$database;
ERROR:
ORA-03114: not connected to ORACLE
SQL>

 

Im running 11g on OLE 5U7.

 

Thanks in advance,

Hades

  • 1. Re: error on starup
    TSharma-Oracle Guru
    Currently Being Moderated

    Please post the last few lines of your alert.log file.

  • 2. Re: error on starup
    TheHades0210 Newbie
    Currently Being Moderated

    Hi,

     

    Sorry for the late reply. Here is a line in alert log.'

     

    Wed Nov 06 21:10:32 2013

    ALTER DATABASE OPEN

    Errors in file /u01/app/oracle/diag/rdbms/orc18/orc18/trace/orc18_ora_4110.trc:

    ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

    ORA-1589 signalled during: ALTER DATABASE OPEN...

     

    Regards,

    Hades

  • 3. Re: error on starup
    TheHades0210 Newbie
    Currently Being Moderated

    Currently my error is when i startup the instance im having this reply.

     

    SQL> startup

    ORACLE instance started.

     

    Total System Global Area  417546240 bytes

    Fixed Size                  2213936 bytes

    Variable Size             364906448 bytes

    Database Buffers           41943040 bytes

    Redo Buffers                8482816 bytes

    Database mounted.

    ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

     

     

    SQL>

    As for the version of the instance.

    BANNER

    --------------------------------------------------------------------------------

    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

    PL/SQL Release 11.2.0.1.0 - Production

    CORE    11.2.0.1.0      Production

    TNS for Linux: Version 11.2.0.1.0 - Production

    NLSRTL Version 11.2.0.1.0 - Production

     

     

    BR,

    Hades

  • 4. Re: error on starup
    Nicolas.Gasparotto Oracle ACE
    Currently Being Moderated

    You showed two different errors.

    Is it an all of sudden error ? Is the database a copy of an other ? Please tell us a bit more.

     

    Nicolas.

  • 5. Re: error on starup
    TheHades0210 Newbie
    Currently Being Moderated

    Hi,

     

    yes, the first error is when i tried to start the db. Tried some fixing and end up on the last error i posted. i tried recover until cancel but had the same. The instance is created from a base instance and was used for development. This instance was working fine until it suddenly it cant be opened anymore.

     

    BR,

    Hades

  • 6. Re: error on starup
    Nicolas.Gasparotto Oracle ACE
    Currently Being Moderated

    We don't know what you've tried so far ("Tried some fixing" does not mean anything to me), why you did a recover, and why the database "crashed" in first place that you were not able to start it. Why the startup was needed by the way ?

    At this stage of your environment and actions knowledge, really difficult to help from the other side of the network.

    I hope you have a valid backup, else take one immediately before going further.

     

    Nicolas.

  • 7. Re: error on starup
    TheHades0210 Newbie
    Currently Being Moderated

    sorry for that. no backup was made on this instance. any advise you can give aside from backup?

     

    here is some info, hop this can be helpful.

    [oracle@oracle1 _dump]$ export ORACLE_SID=orc

    [oracle@oracle1 _dump]$ sqlplus sys as sysdba

     

    SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 6 21:53:25 2013

     

    Copyright (c) 1982, 2009, Oracle.  All rights reserved.

     

    Enter password:

    Connected to an idle instance.

     

    SQL> startup mount

    ORACLE instance started.

     

    Total System Global Area  417546240 bytes

    Fixed Size                  2213936 bytes

    Variable Size             364906448 bytes

    Database Buffers           41943040 bytes

    Redo Buffers                8482816 bytes

    Database mounted.

    SQL> alter database open resetlogs;

    alter database open resetlogs

    *

    ERROR at line 1:

    ORA-01194: file 1 needs more recovery to be consistent

    ORA-01110: data file 1: '/u01/app/oracle/oradata/orc/system01.dbf'

     

     

    SQL>

     

     

    BR,

    Hades

  • 8. Re: error on starup
    MahirM.Quluzade Guru
    Currently Being Moderated

    Is database archivelog mode?

     

    If yes, connect to RMAN,

     

    RMAN> recover database;

    RMAN> alter database open;

     

    - if you  getting same error, then

     

    RMAN> sql 'alter database open resetlogs';

     

     

    Regards

    Mahir M. Quluzade

  • 9. Re: error on starup
    Nicolas.Gasparotto Oracle ACE
    Currently Being Moderated

    You are not able to give us explanation about what happened at the beginning.

    You are not able to provide any steps you followed so far to try to get out of your problem.

    You have now issue on recovery.

    You don't have backup*.

    I'm sorry, but you are in big troubles now.

     

    Nicolas.

     

    *backup includes archivelog (?)... Message was edited by: Nicolas.Gasparotto

  • 10. Re: error on starup
    TheHades0210 Newbie
    Currently Being Moderated

    Sorry.No backup was made. Indeed im in deep trouble on this.

     

    Seems im on my on now.

     

    Thanks for all your comment and help.

  • 11. Re: error on starup
    MahirM.Quluzade Guru
    Currently Being Moderated

    It is big problem. You haven't any  backup.

    If it is production database, then you  must talk with  support.

     

    You can create a new database, if this is test database.

     

    Regards

    Mahir M. Quluzade

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points