2 Replies Latest reply: Apr 29, 2013 12:14 AM by Mahir M. Quluzade RSS

    Restore was failing and I shutdown the oracle. Now oracle isn't startingup!

    974413
      I screwed up my system while restoring!! When restore failed I unknowingly shutdown the oracle, now it is not starting up!!

      RMAN> connect target /;

      connected to target database: TESTDB (DBID=1246032582)

      RMAN> startup nomount pfile='/opt/oracle_homes/oracle/rdbms/11.2.0/dbs/initTESTDB1.ora';

      database is already started

      RMAN> restore controlfile from '/backup/database/c-1246032582-20130428-00';

      Starting restore at 28-APR-13
      using target database control file instead of recovery catalog
      allocated channel: ORA_DISK_1
      channel ORA_DISK_1: SID=2105 instance=TESTDB1 device type=DISK
      allocated channel: ORA_DISK_2
      channel ORA_DISK_2: SID=2198 instance=TESTDB1 device type=DISK

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of restore command at 04/28/2013 18:02:40
      RMAN-06496: must use the TO clause when the database is mounted or open

      RMAN> alter database mount;

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of alter db command at 04/28/2013 18:03:24
      ORA-01100: database already mounted

      RMAN> restore database;

      Starting restore at 28-APR-13
      using channel ORA_DISK_1
      using channel ORA_DISK_2

      channel ORA_DISK_1: starting datafile backup set restore
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of restore command at 04/28/2013 18:03:34
      ORA-19573: cannot obtain sub-exclusive enqueue for datafile 3

      RMAN> exit

      Recovery Manager complete.

      oracle@xyTESTdb01 # srvctl status database -d TESTdb
      Instance TESTDB1 is running on node xyTESTdb01
      Instance TESTDB2 is running on node xyTESTdb02

      oracle@xyTESTdb01 # !sqlplus
      sqlplus / as SYSDBA

      SQL*Plus: Release 11.2.0.2.0 Production on Sun Apr 28 18:03:54 2013
      Copyright (c) 1982, 2010, Oracle. All rights reserved.

      Connected to:
      Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
      With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
      Data Mining and Real Application Testing options

      SQL> shutdown immediate;
      Database closed.
      Database dismounted.
      ORACLE instance shut down.

      SQL> startup;
      ORA-01506: missing or illegal database name
      SQL> startup
      ORA-01506: missing or illegal database name


      Oracle went down!!!!!!!!!


      SQL> startup;
      ORA-01506: missing or illegal database name
      SQL>
      SQL> shutdown immediate;
      ORA-01034: ORACLE not available
      ORA-27101: shared memory realm does not exist
      Solaris-AMD64 Error: 2: No such file or directory
      SQL>


      from RMAN,

      RMAN> connect target /

      connected to target database (not started)

      RMAN>
        • 1. Re: Restore was failing and I shutdown the oracle. Now oracle isn't startingup!
          Hemant K Chitale
          Your database was already MOUNTed, possibly OPEN when you attempted the restore !!

          If the database did not need a restore at all and was good, you should be able to use srvctl to startup the database instances on the two nodes.


          Hemant K Chitale
          • 2. Re: Restore was failing and I shutdown the oracle. Now oracle isn't startingup!
            Mahir M. Quluzade
            971410 wrote:
            I screwed up my system while restoring!! When restore failed I unknowingly shutdown the oracle, now it is not starting up!!

            RMAN> connect target /;

            connected to target database: TESTDB (DBID=1246032582)

            RMAN> startup nomount pfile='/opt/oracle_homes/oracle/rdbms/11.2.0/dbs/initTESTDB1.ora';

            database is already started
            Database is already started
            RMAN> restore controlfile from '/backup/database/c-1246032582-20130428-00';

            Starting restore at 28-APR-13
            using target database control file instead of recovery catalog
            allocated channel: ORA_DISK_1
            channel ORA_DISK_1: SID=2105 instance=TESTDB1 device type=DISK
            allocated channel: ORA_DISK_2
            channel ORA_DISK_2: SID=2198 instance=TESTDB1 device type=DISK

            RMAN-00571: ===========================================================
            RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
            RMAN-00571: ===========================================================
            RMAN-03002: failure of restore command at 04/28/2013 18:02:40
            RMAN-06496: must use the TO clause when the database is mounted or open
            Database is mounted : failure of restore command
            >
            RMAN> alter database mount;

            RMAN-00571: ===========================================================
            RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
            RMAN-00571: ===========================================================
            RMAN-03002: failure of alter db command at 04/28/2013 18:03:24
            ORA-01100: database already mounted
            Database already mounted
            RMAN> restore database;

            Starting restore at 28-APR-13
            using channel ORA_DISK_1
            using channel ORA_DISK_2

            channel ORA_DISK_1: starting datafile backup set restore
            RMAN-00571: ===========================================================
            RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
            RMAN-00571: ===========================================================
            RMAN-03002: failure of restore command at 04/28/2013 18:03:34
            ORA-19573: cannot obtain sub-exclusive enqueue for datafile 3

            RMAN> exit

            Recovery Manager complete.
            Why you are doing this steps?

            oracle@xyTESTdb01 # srvctl status database -d TESTdb
            Instance TESTDB1 is running on node xyTESTdb01
            Instance TESTDB2 is running on node xyTESTdb02
            Your RAC testdb database is runing on two nodes.
            oracle@xyTESTdb01 # !sqlplus
            sqlplus / as SYSDBA

            SQL*Plus: Release 11.2.0.2.0 Production on Sun Apr 28 18:03:54 2013
            Copyright (c) 1982, 2010, Oracle. All rights reserved.

            Connected to:
            Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
            With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
            Data Mining and Real Application Testing options

            SQL> shutdown immediate;
            Database closed.
            Database dismounted.
            ORACLE instance shut down.

            SQL> startup;
            ORA-01506: missing or illegal database name
            SQL> startup
            ORA-01506: missing or illegal database name


            Oracle went down!!!!!!!!!


            SQL> startup;
            ORA-01506: missing or illegal database name
            SQL>
            SQL> shutdown immediate;
            ORA-01034: ORACLE not available
            ORA-27101: shared memory realm does not exist
            Solaris-AMD64 Error: 2: No such file or directory
            SQL>


            from RMAN,

            RMAN> connect target /

            connected to target database (not started)

            RMAN>
            Then connect to database with sqlplus agin.
            oracle@xyTESTdb01 # !sqlplus
            sqlplus / as SYSDBA
            
            SQL> create pfile='/u01/pfileTestdb.ora' from spfile;
            Please paste here pfileTestdb.ora.

            Regards
            Mahir M. Quluzade