4 Replies Latest reply: Apr 12, 2012 7:19 PM by 912457 RSS

    RMAN errors

    DBA2011
      2 dbs backups are failing with these errors , looking for command to fix this....

      RMAN-03009: failure of sql command on default channel at 04/14/2010 09:02:56
      RMAN-11003: failure during parse/execution of SQL statement: ALTER SYSTEM ARCHIVE LOG CURRENT
      ORA-16014: log 2 sequence# 8760 not archived, no available destinations
      ORA-00312: online log 2 thread 1: '/gaskit/oradata/mgkq/redo02.log'


      RMAN-06004: ORACLE error from recovery catalog database: RMAN-20005: target database name is
      ambiguous
        • 1. Re: RMAN errors
          sb92075
          looking for command to fix this....
          Looking for the command that generated this output.

          It is hard to fix code we can not see.
          • 2. Re: RMAN errors
            704810
            Hi


            Try to crosscheck your archivelogs and then try to fire your backup.
            • 3. Re: RMAN errors
              EdStevens
              DBA2008 wrote:
              2 dbs backups are failing with these errors , looking for command to fix this....

              RMAN-03009: failure of sql command on default channel at 04/14/2010 09:02:56
              RMAN-11003: failure during parse/execution of SQL statement: ALTER SYSTEM ARCHIVE LOG CURRENT
              ORA-16014: log 2 sequence# 8760 not archived, no available destinations
              ORA-00312: online log 2 thread 1: '/gaskit/oradata/mgkq/redo02.log'


              RMAN-06004: ORACLE error from recovery catalog database: RMAN-20005: target database name is
              ambiguous
              [oracle@vmlnx01 ~]$ oerr ORA 16014
              16014, 00000, "log %s sequence# %s not archived, no available destinations"
              // *Cause:  An attempt was made to archive the named log, but the archive was
              // unsuccessful. The archive failed because there were no archive log
              // destinations specified or all destinations experienced debilitating
              // errors.
              // *Action: Verify that archive log destinations are being specified and/or
              // take the necessary step to correct any errors that may have
              // occurred.

              I'd bet a cookie your archivelog destination is full.
              • 4. Re: RMAN errors
                912457
                Thank you very much. The archive destination was full.