[ORACLE] RMAN Incremental backup 및 확인

증분백업에 대해서 .. 

lv0 = 처음 전체 백업 / lv1= lv0 대비 바뀐것만 백업

lv0 백업

#!/bin/bash
export ORACLE_SID=wintrg
export ORACLE_UNQNAME=wintrg
export ORACLE_UNQNAME_LOWER=`echo $ORACLE_UNQNAME | tr A-Z a-z`
export EDITOR=vi
export LANG=C
export ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1
export DT=`date +%Y%m%d%H%M`
/u01/app/oracle/product/19.0.0.0/dbhome_1/bin/rman target / log /u01/backup/log/${ORACLE_SID}_lv0_${DT}.log << EOF
RUN {
allocate channel ch0 device type disk format '/u01/backup/wintrg_%U';
allocate channel ch1 device type disk format '/u01/backup/wintrg_%U';
backup incremental level 0 database tag='L0';
sql 'alter system archive log current';
sql 'alter system archive log current';
sql 'alter system archive log current';
backup current controlfile tag 'CONTROLFILE';
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
}
EOF

RMAN> list backup;

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Incr 0  185.84M    DISK        00:00:04     14-APR-25
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: L0
        Piece Name: /u01/backup/wintrg_093msmam_9_1_1
  List of Datafiles in backup set 3
  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- --------- ----------- ------ ----
  2    0  Incr 687844     14-APR-25              NO    /u01/app/oracle/oradata/WINTRG/sysaux01.dbf
  4    0  Incr 687844     14-APR-25              NO    /u01/app/oracle/oradata/WINTRG/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Incr 0  476.81M    DISK        00:00:11     14-APR-25
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: L0
        Piece Name: /u01/backup/wintrg_083msmam_8_1_1
  List of Datafiles in backup set 4
  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- --------- ----------- ------ ----
  1    0  Incr 687842     14-APR-25              NO    /u01/app/oracle/oradata/WINTRG/system01.dbf
  3    0  Incr 687842     14-APR-25              NO    /u01/app/oracle/oradata/WINTRG/undotbs01.dbf

백업셋이 생겼다

 

데이터를 좀 변경해줬따

 

lv1 백업

#!/bin/bash
export ORACLE_SID=wintrg
export ORACLE_UNQNAME=wintrg
export ORACLE_UNQNAME_LOWER=`echo $ORACLE_UNQNAME | tr A-Z a-z`
export EDITOR=vi
export LANG=C
export ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1
export DT=`date +%Y%m%d%H%M`
/u01/app/oracle/product/19.0.0.0/dbhome_1/bin/rman target / log /u01/backup/log/${ORACLE_SID}_lv1_${DT}.log << EOF
RUN {
allocate channel ch0 device type disk format '/u01/backup/wintrg_%U';
allocate channel ch1 device type disk format '/u01/backup/wintrg_%U';
backup as backupset incremental level 1 filesperset 32 database tag "L1";
sql 'alter system archive log current';
sql 'alter system archive log current';
sql 'alter system archive log current';
backup archivelog all delete input ;
backup spfile tag 'SPFILE';
backup current controlfile tag 'CONTROLFILE';
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
}

 

레벨 1 백업이 생겼다

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
9       Incr 1  6.01G      DISK        00:00:44     15-APR-25
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: L1
        Piece Name: /u01/backup/wintrg_0f3murda_15_1_1
  List of Datafiles in backup set 9
  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- --------- ----------- ------ ----
  1    1  Incr 944769     15-APR-25              NO    /u01/app/oracle/oradata/WINTRG/system01.dbf
  2    1  Incr 944769     15-APR-25              NO    /u01/app/oracle/oradata/WINTRG/sysaux01.dbf
  7    1  Incr 944769     15-APR-25              NO    /u01/app/oracle/oradata/WINTRG/HIS_I08_01.dbf
  9    1  Incr 944769     15-APR-25              NO    /u01/app/oracle/oradata/WINTRG/PAM_I08_01.dbf
  10   1  Incr 944769     15-APR-25              NO    /u01/app/oracle/oradata/WINTRG/EMR_D08_01.dbf
  11   1  Incr 944769     15-APR-25              NO    /u01/app/oracle/oradata/WINTRG/EMR_I08_01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10      Incr 1  9.44G      DISK        00:00:53     15-APR-25
        BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: L1
        Piece Name: /u01/backup/wintrg_0e3murda_14_1_1
  List of Datafiles in backup set 10
  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- --------- ----------- ------ ----
  3    1  Incr 944767     15-APR-25              NO    /u01/app/oracle/oradata/WINTRG/undotbs01.dbf
  4    1  Incr 944767     15-APR-25              NO    /u01/app/oracle/oradata/WINTRG/users01.dbf
  5    1  Incr 944767     15-APR-25              NO    /u01/app/oracle/oradata/WINTRG/SEC_D08_01.dbf
  6    1  Incr 944767     15-APR-25              NO    /u01/app/oracle/oradata/WINTRG/HIS_D08_01.dbf
  8    1  Incr 944767     15-APR-25              NO    /u01/app/oracle/oradata/WINTRG/PAM_D08_01.dbf

 

 

이 인크리멘탈 백업이 과연 먹었을까 ? 확인하는 방법

select d.INCREMENTAL_LEVEL, d.FILE#, d.CHECKPOINT_CHANGE#, d.COMPLETION_TIME,
       d.INCREMENTAL_CHANGE#, d.USED_CHANGE_TRACKING,d.DATAFILE_BLOCKS,
       d.BLOCKS_READ,d.USED_OPTIMIZATION, p.tag
from v$backup_datafile d,v$backup_piece p
where d.file#!=0 and p.set_stamp=d.set_stamp and p.SET_COUNT=d.SET_COUNT 
order by FILE#, COMPLETION_TIME desc;

조회 했을때

 

이렇게 값이 나온다.

datafile_block = 데이터파일의 실제 block 수

blocks_read = 백업 때 읽은 block 수 

 

Incremental_level = 1 에서 DATAFILE_BLOCKS > BLOCKS_READ가 성립되어야 인크리멘탈 백업이 잘 되고 있다는 것.

똑같은 경우는 걍 다읽는거지 . .

이미지 백업 받으면 똑같이 나온다