This discussion is archived
2 Replies Latest reply: Apr 10, 2013 7:05 AM by Flávio Soares RSS

RMAN backup error

Meenakshy singh Newbie
Currently Being Moderated
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 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

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