This discussion is archived
2 Replies Latest reply: Oct 3, 2012 10:54 PM by 316993 RSS

RMAN-03009

Fayn_dba Newbie
Currently Being Moderated
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

Legend

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