TRẦN VĂN BÌNH MASTER: [VIP5] Bí kíp backup level dữ liệu lớn với nhiều channel và backup read only dữ liệu cũ

Mục đích: Với các Database dung lượng lớn (>5TB) thì thường có dữ liệu cũ, không thay đổi do đó để giảm thời gian backup trước giờ làm việc (thường là 8h00 hàng ngày) ta phải read only/offline tablespace cũ để giảm dung lượng backup cho các tablespace chạy chính. Sau đây tôi sẽ chia sẻ với các bạn các script để backup để đảm bảo an toàn, nhanh chóng cho Database:

Script backup level 0:

$ vi /u01/oracle/backup_db/scripts/backup_db_level_0.rcv

RUN

{

Crosscheck archivelog all;

Delete noprompt expired archivelog all;

DELETE BACKUP COMPLETED BEFORE 'SYSDATE-4' DEVICE TYPE DISK;

ALLOCATE CHANNEL c1 DEVICE TYPE DISK format '/s01/backup_db/dbaviet/c1_dbaviet_level0_ora_df%T_s%s_s%p';

ALLOCATE CHANNEL c2 DEVICE TYPE DISK format '/s02/backup_db/dbaviet/c2_dbaviet_level0_ora_df%T_s%s_s%p';

ALLOCATE CHANNEL c3 DEVICE TYPE DISK format '/s03/backup_db/dbaviet/c3_dbaviet_level0_ora_df%T_s%s_s%p';

ALLOCATE CHANNEL c4 DEVICE TYPE DISK format '/s04/backup_db/dbaviet/c4_dbaviet_level0_ora_df%T_s%s_s%p';

ALLOCATE CHANNEL c5 DEVICE TYPE DISK format '/s01/backup_db/dbaviet/c5_dbaviet_level0_ora_df%T_s%s_s%p';

ALLOCATE CHANNEL c6 DEVICE TYPE DISK format '/s02/backup_db/dbaviet/c6_dbaviet_level0_ora_df%T_s%s_s%p';

ALLOCATE CHANNEL c7 DEVICE TYPE DISK format '/s03/backup_db/dbaviet/c7_dbaviet_level0_ora_df%T_s%s_s%p';

ALLOCATE CHANNEL c8 DEVICE TYPE DISK format '/s04/backup_db/dbaviet/c8_dbaviet_level0_ora_df%T_s%s_s%p';

ALLOCATE CHANNEL c9 DEVICE TYPE DISK format '/s01/backup_db/dbaviet/c9_dbaviet_level0_ora_df%T_s%s_s%p';

ALLOCATE CHANNEL c10 DEVICE TYPE DISK format '/s02/backup_db/dbaviet/c10_dbaviet_level0_ora_df%T_s%s_s%p';

ALLOCATE CHANNEL c11 DEVICE TYPE DISK format '/s03/backup_db/dbaviet/c11_dbaviet_level0_ora_df%T_s%s_s%p';

ALLOCATE CHANNEL c12 DEVICE TYPE DISK format '/s04/backup_db/dbaviet/c12_dbaviet_level0_ora_df%T_s%s_s%p';

ALLOCATE CHANNEL c13 DEVICE TYPE DISK format '/s01/backup_db/dbaviet/c13_dbaviet_level0_ora_df%T_s%s_s%p';

ALLOCATE CHANNEL c14 DEVICE TYPE DISK format '/s02/backup_db/dbaviet/c14_dbaviet_level0_ora_df%T_s%s_s%p';

ALLOCATE CHANNEL c15 DEVICE TYPE DISK format '/s03/backup_db/dbaviet/c15_dbaviet_level0_ora_df%T_s%s_s%p';

ALLOCATE CHANNEL c16 DEVICE TYPE DISK format '/s04/backup_db/dbaviet/c16_dbaviet_level0_ora_df%T_s%s_s%p';

ALLOCATE CHANNEL c17 DEVICE TYPE DISK format '/s01/backup_db/dbaviet/c17_dbaviet_level0_ora_df%T_s%s_s%p';

ALLOCATE CHANNEL c18 DEVICE TYPE DISK format '/s02/backup_db/dbaviet/c18_dbaviet_level0_ora_df%T_s%s_s%p';

ALLOCATE CHANNEL c19 DEVICE TYPE DISK format '/s03/backup_db/dbaviet/c19_dbaviet_level0_ora_df%T_s%s_s%p';

ALLOCATE CHANNEL c20 DEVICE TYPE DISK format '/s04/backup_db/dbaviet/c20_dbaviet_level0_ora_df%T_s%s_s%p';

ALLOCATE CHANNEL c21 DEVICE TYPE DISK format '/s01/backup_db/dbaviet/c21_dbaviet_level0_ora_df%T_s%s_s%p';

ALLOCATE CHANNEL c22 DEVICE TYPE DISK format '/s02/backup_db/dbaviet/c22_dbaviet_level0_ora_df%T_s%s_s%p';

ALLOCATE CHANNEL c23 DEVICE TYPE DISK format '/s03/backup_db/dbaviet/c23_dbaviet_level0_ora_df%T_s%s_s%p';

ALLOCATE CHANNEL c24 DEVICE TYPE DISK format '/s04/backup_db/dbaviet/c24_dbaviet_level0_ora_df%T_s%s_s%p';

BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 0 DATABASE FILESPERSET 10 SKIP READONLY SKIP OFFLINE MAXSETSIZE 40 G TAG LEVEL0;

BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL FILESPERSET 4 TAG ARCH delete input;

#Delete noprompt archivelog until time 'sysdate-1';

CROSSCHECK BACKUP;

DELETE NOPROMPT EXPIRED BACKUP;

DELETE OBSOLETE;

}

-- Tạo file shell

$ vi /u01/oracle/backup_db/scripts/run_backup_db_level_0.sh

target='target /'

rcvcat='nocatalog'

freq=24

time=`date '+%H%M%S'`

cmdfile=/u01/oracle/backup_db/scripts/backup_db_level_0.rcv

msglog=/u01/oracle/backup_db/log/level0/rman_level0_$time.log

#rman $target $rcvcat cmdfile $cmdfile msglog $msglog

rman target / cmdfile=/u01/oracle/backup_db/scripts/end_backup.rcv

rman $target $rcvcat cmdfile $cmdfile

exit

-- Sau đó đặt vào crontab Backup full (level 0) vào 00h00 thứ 4, chủ nhật

00 00 * * 3,6 "/u01/oracle/backup_db/scripts/run_backup_db_level_0.sh "

Script backup level 1

$ vi /u01/oracle/backup_db/scripts/backup_db_level_1.rcv