OS환경 : Oracle Linux 6.8 (64bit)
DB 환경 : Oracle Database 11.2.0.4
에러 : RMAN backup 시 해당 에러 발생
#rman backup 진행
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 | $ rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Fri Mar 30 17:01:57 2018 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL (DBID=1494725233) RMAN> backup database; Starting backup at 30-MAR-18 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=44 device type=DISK channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00005 name=/oracle/app/oracle/oradata/orcl/jshts01.dbf input datafile file number=00007 name=/oracle/app/data01.dbf input datafile file number=00001 name=/oracle/app/oracle/oradata/orcl/system01.dbf input datafile file number=00002 name=/oracle/app/oracle/oradata/orcl/sysaux01.dbf input datafile file number=00009 name=/oracle/app/oracle/oradata/orcl/users02.dbf input datafile file number=00010 name=/oracle/app/oracle/oradata/orcl/undotbs02.dbf input datafile file number=00008 name=/oracle/app/data02.dbf input datafile file number=00004 name=/oracle/app/oracle/oradata/orcl/users01.dbf input datafile file number=00006 name=/oracle/app/oracle/oradata/orcl/fda_01.dbf channel ORA_DISK_1: starting piece 1 at 30-MAR-18 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/30/2018 17:02:26 ORA-19502: write error on file "/oracle/app/oracle/backup/orcl_08sv3j09_1_1", block number 154240 (block size=8192) ORA-27072: File I/O error Additional information: 4 Additional information: 154240 Additional information: 733184 |
#백업 실패
해결 방법 : rman 백업 공간 확인 후 재실행
#rman 백업 공간 확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | RMAN>show all; using target database control file instead of recovery catalog RMAN configuration parameters for database with db_unique_name ORCL are: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 5 DAYS; CONFIGURE BACKUP OPTIMIZATION ON; CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oracle/app/oracle/backup/control/%F'; CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/oracle/app/oracle/backup/orcl_%U'; CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/app/oracle/product/11.2.0/db_1/dbs/snapcf_orcl.f'; # default |
#파일시스템 공간 확인
1 2 3 4 5 | $ df -h Filesystem Size Used Avail Use% Mounted on /dev/sda1 9.5G 3.1G 6.0G 35% / tmpfs 1004M 225M 779M 23% /dev/shm /dev/sda3 26G 24G 1.2G 96% /oracle |
/oracle 파일시스템 96%사용중!
#공간 확보용으로 불필요 파일 제거
1 2 | $ rm -rf oracle_test/ $ rm -rf ora_bak/ |
#파일시스템 공간 재확인
1 2 3 4 5 | $ df -h Filesystem Size Used Avail Use% Mounted on /dev/sda1 9.5G 3.1G 6.0G 35% / tmpfs 1004M 225M 779M 23% /dev/shm /dev/sda3 26G 18G 7.4G 70% /oracle |
#rman backup 재진행
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 | $ rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Fri Mar 30 17:07:34 2018 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL (DBID=1494725233) RMAN> backup database; Starting backup at 30-MAR-18 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=42 device type=DISK channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00005 name=/oracle/app/oracle/oradata/orcl/jshts01.dbf input datafile file number=00007 name=/oracle/app/data01.dbf input datafile file number=00001 name=/oracle/app/oracle/oradata/orcl/system01.dbf input datafile file number=00002 name=/oracle/app/oracle/oradata/orcl/sysaux01.dbf input datafile file number=00009 name=/oracle/app/oracle/oradata/orcl/users02.dbf input datafile file number=00010 name=/oracle/app/oracle/oradata/orcl/undotbs02.dbf input datafile file number=00008 name=/oracle/app/data02.dbf input datafile file number=00004 name=/oracle/app/oracle/oradata/orcl/users01.dbf input datafile file number=00006 name=/oracle/app/oracle/oradata/orcl/fda_01.dbf channel ORA_DISK_1: starting piece 1 at 30-MAR-18 channel ORA_DISK_1: finished piece 1 at 30-MAR-18 piece handle=/oracle/app/oracle/backup/orcl_09sv3jaq_1_1 tag=TAG20180330T170737 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25 Finished backup at 30-MAR-18 Starting Control File Autobackup at 30-MAR-18 piece handle=/oracle/app/oracle/backup/control/c-1494725233-20180330-00 comment=NONE Finished Control File Autobackup at 30-MAR-18 |
#정상완료됨
#sqlplus 에서 backup 현황 확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 | $ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Fri Mar 30 17:08:15 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning option SQL> set lines 132 set pages 100 col KEY for 9,999 col INPUT_TYPE for a12 col STATUS for a10 col JOB_TIME for a8 col RATIO for 999 col INPUT_SEC for a10 col OUTPUT_SEC for a10 select SESSION_KEY KEY, INPUT_TYPE, STATUS, to_char(START_TIME,'mm/dd/yy hh24:mi') start_time, to_char(END_TIME,'mm/dd/yy hh24:mi') end_time, TIME_TAKEN_DISPLAY job_time, OPTIMIZED, round(COMPRESSION_RATIO, 0) Ratio, INPUT_BYTES_PER_SEC_DISPLAY Input_Sec, OUTPUT_BYTES_PER_SEC_DISPLAY Output_Sec from V_$RMAN_BACKUP_JOB_DETAILS order by 1 / KEY INPUT_TYPE STATUS START_TIME END_TIME JOB_TIME OPT RATIO INPUT_SEC OUTPUT_SEC ------ ------------ ---------- -------------- -------------- -------- --- ----- ---------- ---------- 29 DB FULL FAILED 03/30/18 17:02 03/30/18 17:02 00:00:25 NO 1 52.98M 48.32M 33 DB FULL COMPLETED 03/30/18 17:07 03/30/18 17:08 00:00:27 NO 1 71.78M 66.68M 4 rows selected. |
원인 : 백업할 파일시스템의 사용가능 용량 부족
참조 :