1 Reply Latest reply: Sep 18, 2013 3:24 AM by DK2010 RSS

    RMAN-03009: failure of backup command on ORA_DISK_1... continued

    Dan8

      Thanks for your input guys.

      As said in previous post, I still can't backup though I followed your instructions.

       

      Another problem happened and I had to recover.

      The recovery went well but another problem arises.

       

      Here the recovery output :

      Database Instance: db11gr2  >

      Recovery Succeeded

      See Recovery Results below.

       

      Recovery Results

          [Open Database]   [Re-assess Failures]   [OK]

        

      Recovery Results

      Recovery Manager: Release 11.2.0.1.0 - Production on Mon Sep 16 22:55:52 2013

       

      Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

       

      RMAN>

      connected to target database: DB11GR2 (DBID=1654366455, not open)

      using target database control file instead of recovery catalog

       

      RMAN>

      echo set on

       

       

      RMAN> REPAIR FAILURE USING REPAIRID 649 NO OPEN DATABASE NOPROMPT;

      Strategy: The repair includes complete media recovery with no data loss

      Repair script: /u01/app/oracle/diag/rdbms/db11gr2/db11gr2/hm/reco_1605305993.hm

       

      contents of repair script:

      # recover database

      recover database;

      executing repair script

       

      Starting recover at 16-SEP-13

      allocated channel: ORA_DISK_1

      channel ORA_DISK_1: SID=20 device type=DISK

       

      starting media recovery

       

      archived log for thread 1 with sequence 32 is already on disk as file /u01/app/oracle/oradata/db11gr2/redo02.log

      archived log file name=/u01/app/oracle/oradata/db11gr2/redo02.log thread=1 sequence=32

      media recovery complete, elapsed time: 00:00:16

      Finished recover at 16-SEP-13

      repair failure complete

       

       

      RMAN> exit;

       

      Recovery Manager complete.

       

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

       

      issue 1: Login error

       

      Error

      Your username and/or password are invalid.

       

      though I entered the correct information. This is what I used to key in when the database was working fine.

      username: SYS

      password: admin

      connect as: SYSDBA

       

       

      issue 2:

       

      However when doing what that follow i got nothing.

       

      [oracle@localhost ~]$ sqlplus / as sysdba

       

      SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 17 11:50:10 2013

       

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

       

      Connected to an idle instance.

       

      SQL>

      SQL> select STATUS, DATABASE_STATUS from v$instance;

      select STATUS, DATABASE_STATUS from v$instance

      *

      ERROR at line 1:

      ORA-01034: ORACLE not available

      Process ID: 0

      Session ID: 0 Serial number: 0

       

       

      SQL> select CONTROLFILE_CREATED, CONTROLFILE_TIME, CONTROLFILE_TYPE, RESETLOGS_TIME from v$database;

      select CONTROLFILE_CREATED, CONTROLFILE_TIME, CONTROLFILE_TYPE, RESETLOGS_TIME from v$database

      *

      ERROR at line 1:

      ORA-01034: ORACLE not available

      Process ID: 0

      Session ID: 0 Serial number: 0

       

      Does anyone has a way for resolution ?

       

      Thanks. Dan.