2 Replies Latest reply: Oct 4, 2012 12:54 AM by orawarebyte RSS

    RMAN-03009

    Fayn_dba
      Recovery Manager: Release 11.1.0.6.0 - Production on Thu Oct 4 02:00:04 2012

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

      connected to target database: ORCL (DBID=1238977257)

      RMAN>
      RMAN> RUN {
      2> BACKUP INCREMENTAL LEVEL 0 DATABASE;
      3> crosscheck backup;
      4> crosscheck backupset;
      5> delete noprompt obsolete;
      6> }
      7> EXIT;
      Starting backup at 04-OCT-12
      using target database control file instead of recovery catalog
      allocated channel: ORA_DISK_1
      channel ORA_DISK_1: SID=508 device type=DISK
      channel ORA_DISK_1: starting incremental level 0 datafile backup set
      channel ORA_DISK_1: specifying datafile(s) in backup set
      input datafile file number=00021 name=/u02/app/oracle/oradata/orcl/users02.dbf
      input datafile file number=00022 name=/u02/app/oracle/oradata/orcl/users03.dbf
      input datafile file number=00030 name=/u02/app/oracle/oradata/orcl/users05.dbf
      input datafile file number=00033 name=/u02/app/oracle/oradata/orcl/users07.dbf
      input datafile file number=00034 name=/u02/app/oracle/oradata/orcl/users08.dbf
      input datafile file number=00004 name=/u02/app/oracle/oradata/orcl/users01.dbf
      input datafile file number=00029 name=/u02/app/oracle/oradata/orcl/users04.dbf
      input datafile file number=00032 name=/u02/app/oracle/oradata/orcl/users06.dbf
      input datafile file number=00020 name=/u02/app/oracle/oradata/orcl/system02.dbf
      input datafile file number=00002 name=/u02/app/oracle/oradata/orcl/sysaux01.dbf
      input datafile file number=00005 name=/u02/app/oracle/oradata/orcl/DEV_DATA01.dbf
      input datafile file number=00003 name=/u02/app/oracle/oradata/orcl/undotbs01.dbf
      input datafile file number=00037 name=/u02/app/oracle/oradata/orcl/users10.dbf
      input datafile file number=00031 name=/u02/app/oracle/oradata/orcl/mmi_prod04.dbf
      input datafile file number=00016 name=/u02/app/oracle/oradata/orcl/DEV_DATA02.dbf
      input datafile file number=00017 name=/u02/app/oracle/oradata/orcl/DEV_DATA03.dbf
      input datafile file number=00018 name=/u02/app/oracle/oradata/orcl/DEV_DATA04.dbf
      input datafile file number=00019 name=/u02/app/oracle/oradata/orcl/DEV_DATA05.dbf
      input datafile file number=00027 name=/u02/app/oracle/oradata/orcl/mmi_prod02.dbf
      input datafile file number=00028 name=/u02/app/oracle/oradata/orcl/mmi_prod03.dbf
      input datafile file number=00026 name=/u02/app/oracle/oradata/orcl/mmi_prod01.dbf
      input datafile file number=00024 name=/u02/app/oracle/oradata/orcl/all_idx01.dbf
      input datafile file number=00025 name=/u02/app/oracle/oradata/orcl/all_idx02.dbf
      input datafile file number=00035 name=/u02/app/oracle/oradata/orcl/users09.dbf
      input datafile file number=00001 name=/u02/app/oracle/oradata/orcl/system01.dbf
      input datafile file number=00006 name=/u02/app/oracle/oradata/orcl/DEV_INDX01.dbf
      input datafile file number=00023 name=/u02/app/oracle/oradata/orcl/DEV_INDX02.dbf
      input datafile file number=00011 name=/u02/app/oracle/oradata/orcl/PATH_TBL01.dbf
      input datafile file number=00036 name=/u02/app/oracle/oradata/orcl/all_idx03.dbf
      input datafile file number=00007 name=/u02/app/oracle/oradata/orcl/DEV_TEMP01.dbf
      input datafile file number=00008 name=/u02/app/oracle/oradata/orcl/KYA_IDX01.dbf
      input datafile file number=00009 name=/u02/app/oracle/oradata/orcl/LOB_IMAGE01.dbf
      input datafile file number=00010 name=/u02/app/oracle/oradata/orcl/PATH_IDX01.dbf
      input datafile file number=00012 name=/u02/app/oracle/oradata/orcl/RIS_DATA01.dbf
      input datafile file number=00013 name=/u02/app/oracle/oradata/orcl/RIS_INDX01.dbf
      input datafile file number=00014 name=/u02/app/oracle/oradata/orcl/TS_FREE01.dbf
      input datafile file number=00015 name=/u02/app/oracle/oradata/orcl/TS_RV11201.dbf
      channel ORA_DISK_1: starting piece 1 at 04-OCT-12
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/04/2012 03:59:09
      ORA-19502: write error on file "/media/disk-1/ora_df795751210_s780_s1", block number 13957633 (block size=8192)
      ORA-27072: File I/O error
      Linux-x86_64 Error: 2: No such file or directory
      Additional information: 4
      Additional information: 13957633
      Additional information: 778240

      Recovery Manager complete.


      whats the solution
        • 1. Re: RMAN-03009
          415289
          ORA-19502: write error on file "/media/disk-1/ora_df795751210_s780_s1", block number 13957633 (block size=8192)
          ORA-27072: File I/O error
          Linux-x86_64 Error: 2: No such file or directory
          "/media/disk-1" location not available to write the backup piece.
          choose correct location.
          • 2. Re: RMAN-03009
            orawarebyte
            check the mount point "/media/disk-1/" either exist or not at OS using following command.

            df -ha

            Khurram