2 Replies Latest reply: Apr 10, 2013 9:05 AM by Flávio Soares RSS

    RMAN backup error

    Meenakshy singh
      Hi All,

      Oracle version is Oracle9i Enterprise Edition Release 9.2.0.8.0.

      This time I have RMAN issue with dataguard mode.RMAN backup is running everyday.but since one week I am getting error.
      Error seems like OSD error.

      Below is the Rman logs:-

      Recovery Manager: Release 9.2.0.8.0 - Production

      Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

      RMAN> connect target /
      +2> run {+
      +3> crosscheck archivelog all;+
      +4> delete noprompt archivelog until time 'sysdate-7';+
      +5> }+

      +6>+

      connected to target database: EBT (DBID=1648439414)

      using target database controlfile instead of recovery catalog
      allocated channel: ORA_DISK_1
      channel ORA_DISK_1: sid=16 devtype=DISK
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE2\EBT_1_113778.ARC recid=227834 stamp=811664193
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE\EBT_1_113809.ARC recid=227925 stamp=811667280
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE2\EBT_1_113809.ARC recid=227927 stamp=811667280
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE\EBT_1_113810.ARC recid=227928 stamp=811667337
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE2\EBT_1_113810.ARC recid=227930 stamp=811667337
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE\EBT_1_113811.ARC recid=227931 stamp=811781007
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE2\EBT_1_114073.ARC recid=228719 stamp=812300202
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE2\EBT_1_114074.ARC recid=228722 stamp=812300307
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE\EBT_1_114074.ARC recid=228720 stamp=812300306
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE\EBT_1_114075.ARC recid=228723 stamp=812300409
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE2\EBT_1_114075.ARC recid=228725 stamp=812300409
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE\EBT_1_114076.ARC recid=228726 stamp=812300477
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE2\EBT_1_114076.ARC recid=228728 stamp=812300477
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE\EBT_1_114077.ARC recid=228729 stamp=812300592
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE2\EBT_1_114077.ARC recid=228731 stamp=812300592
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE\EBT_1_114078.ARC recid=228732 stamp=812300712
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE2\EBT_1_114078.ARC recid=228734 stamp=812300712
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE\EBT_1_114079.ARC recid=228735 stamp=812300781
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE2\EBT_1_114079.ARC recid=228737 stamp=812300781
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE\EBT_1_114080.ARC recid=228738 stamp=812300880
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE2\EBT_1_114080.ARC recid=228740 stamp=812300880
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE\EBT_1_114081.ARC recid=228741 stamp=812300948
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE2\EBT_1_114081.ARC recid=228743 stamp=812300948
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE\EBT_1_114082.ARC recid=228744 stamp=812301057
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE2\EBT_1_114082.ARC recid=228746 stamp=812301057
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE\EBT_1_114083.ARC recid=228747 stamp=812341047
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE2\EBT_1_114083.ARC recid=228749 stamp=812341047
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE\EBT_1_114084.ARC recid=228750 stamp=812341047
      validation succeeded for archived log
      archive log filename=E:\ORACLE\ORADATA\EBT\ARCHIVE2\EBT_1_114084.ARC recid=228752 stamp=812341047
      Crosschecked 614 objects


      released channel: ORA_DISK_1
      allocated channel: ORA_DISK_1
      channel ORA_DISK_1: sid=16 devtype=DISK
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03009: failure of delete command on ORA_DISK_1 channel at 04/10/2013 06:01:26
      ORA-27056: skgfrdel: could not delete file
      OSD-04024: Unable to delete file.
      O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.

      Recovery Manager complete.

      Can anyone tell me how to recover this error?

      Thanks,
      Meena
        • 1. Re: RMAN backup error
          user639304
          Hi,

          The error is just saying that archive log files can't be deleted because another process is using them. I guess that if exit from RMAN and try to delete them (at OS level) , you won't be able to delete. Or just exit from RMAN and go to the directory of log file and do an ls -l to see (I assume you are using Linux/Unix).
          • 2. Re: RMAN backup error
            Flávio Soares
            Hi Meenakshy

            Check what the process that are using your file. Following the sample:
            # lsof  |grep /oracle/undo/ts_undo01.dbf
            oracle    29547    oracle  274uW     REG                8,3  1572872192   14778371 /oracle/undo/ts_undo01.dbf
            oracle    29549    oracle  256u      REG                8,3  1572872192   14778371 /oracle/undo/ts_undo01.dbf
            oracle    29551    oracle  279u      REG                8,3  1572872192   14778371 /oracle/undo/ts_undo01.dbf
            oracle    29553    oracle  274u      REG                8,3  1572872192   14778371 /oracle/undo/ts_undo01.dbf
            oracle    29555    oracle  272u      REG                8,3  1572872192   14778371 /oracle/undo/ts_undo01.dbf
            oracle    29559    oracle  260u      REG                8,3  1572872192   14778371 /oracle/undo/ts_undo01.dbf
            oracle    29561    oracle  256u      REG                8,3  1572872192   14778371 /oracle/undo/ts_undo01.dbf
            
            # ps -p 29547 -o cpu,command,user
            CPU COMMAND                     USER
              - ora_dbw0_tp05               oracle