新接手了几个客户的数据库，数据库真是一团糟糕，什么分区，索引，表空间都十分的乱，最重要的是归档都没有开，竟然还是生产库，更别说什么备份脚本了，最近一直在做备份恢复的整理工作，该归档的停机归档，该建立脚本的建立备份脚本，以前库少，现在库多了，管理多个库不能那么空闲了，现在的库之前做了CRONTAB+RMAN的备份，做了些修改，记录如下：
修改RMAN参数以及备份脚本，实现7天后自动删除失效备份集，同时添加定时任务的执行结果到监控邮件。
1：修改RMAN参数
修改RMAN失效日期为7天，同时修改自动备份控制脚本参数为开启状态。
[oracle@localhost ~]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jun 21 13:59:31 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: GIS (DBID=3650399296)
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;# default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/usr/app/db-server/ora_home/dbs/snapcf_gis.f'; # default
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP on;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
new RMAN configuration parameters are successfully stored
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/usr/app/db-server/ora_home/dbs/snapcf_gis.f'; # default
2：查看过期备份
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 2624 19-JUN-11
Backup Piece 2624 19-JUN-11 /sdb/opt/rman/rman/arch_level_0_GIS_20110619_2635_ibmf959t_1_1
Backup Set 2623 19-JUN-11
Backup Piece 2623 19-JUN-11 /sdb/opt/rman/rman/arch_level_0_GIS_20110619_2636_icmf959t_1_1
3：删除过期备份集
RMAN> delete noprompt obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=94 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=137 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=91 devtype=DISK
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 2624 19-JUN-11
Backup Piece 2624 19-JUN-11 /sdb/opt/rman/rman/arch_level_0_GIS_20110619_2635_ibmf959t_1_1
Backup Set 2623 19-JUN-11
Backup Piece 2623 19-JUN-11 /sdb/opt/rman/rman/arch_level_0_GIS_20110619_2636_icmf959t_1_1
4：修改归档脚本
修改脚本，添加按日期产生文件夹，
[oracle@localhost rman]$ vi archback.sh
# user env
source ~/.bash_profile
export BACK_DATE=`date +%Y%m%d`
export BACKUP_PATH=/sdb/opt/rman
echo `mkdir -p ${BACKUP_PATH}/archivelog/${BACK_DATE}`
rman target / nocatalog msglog=$BACKUP_PATH/archivelog/${BACK_DATE}/arch_0_$BACK_DATE.log << EOF
# need a user and tablespace to create catalog
#connect catalog rman/rman@$ORACLE_SID;
# resync catalog with target
#resync catalog;
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
sql 'alter system archive log current';
backup filesperset 3 format '$BACKUP_PATH/archivelog/${BACK_DATE}/arch_level_0_%d_%T_%s_%U' archivelog all delete input;
release channel c1;
release channel c2;
release channel c3;
}
crosscheck backup;
delete noprompt expired backup;
crosscheck archivelog all;
delete noprompt archivelog until time 'sysdate - 1' all ;
report obsolete;
delete noprompt obsolete;
exit
EOF
# end
5：修改数据备份脚本
[oracle@localhost rman]$ vi fullback.sh
# user env
source ~/.bash_profile
export BACK_DATE=`date +%Y%m%d`
export BACKUP_PATH=/sdb/opt/rman
echo `mkdir -p ${BACKUP_PATH}/rman/${BACK_DATE}`
rman target / nocatalog msglog=$BACKUP_PATH/rman/${BACK_DATE}/bak_0_$BACK_DATE.log << EOF
# need a user and tablespace to create catalog
#connect catalog rman/rman@$ORACLE_SID;
# resync catalog with target
#resync catalog;
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
backup full database include current controlfile tag 'dbk_level_0' format '$BACKUP_PATH/rman/${BACK_DATE}/df_level_0_%d_%T_%s_%U';
sql 'alter system archive log current';
backup filesperset 3 format '$BACKUP_PATH/rman/${BACK_DATE}/arch_level_0_%d_%T_%s_%U' archivelog all delete input;
release channel c1;
release channel c2;
release channel c3;
}
crosscheck backup;
delete noprompt expired backup;
crosscheck archivelog all;
delete noprompt archivelog until time 'sysdate' all ;
report obsolete;
delete noprompt obsolete;
exit
EOF
6：修改Crontab任务
修改如下，增加定时任务失败日志：
[oracle@localhost monitor_client]$ crontab -l
30 01 * * 0 "/usr/app/rman/fullback.sh" >/home/oracle/monitor_client/logs/full_cron.log 2>/home/oracle/monitor_client/logs/full_cron_error.log
00 00 * * 6,1,2,3,4,5 "/usr/app/rman/archback.sh" >/home/oracle/monitor_client/logs/arch_cron.log 2>/home/oracle/monitor_client/logs/arch_cron_error.log
30 7,15 * * * "/home/oracle/monitor_client/client_cron.sh" >/home/oracle/monitor_client/client_cron.log 2>/home/oracle/monitor_client/client_cron_error.log
7：邮件监控脚本修改
增加传送定时任务错误脚本功能，服务器端接收到数据后解析邮件通知
contab参考：
http://blog.csdn.net/sipsir/archive/2009/03/08/3973713.aspx
错误信息重定向参考:
http://www.phpzixue.cn/detail889.shtml
*******************************************
RMAN定时备份脚本(全备+增量备份+控制文件+参数文件)
- ########################################################################
- ## kfc_incremental_hot_database_backup.sh ##
- ## created by NBU TEMP ##
- ## 2012-3-8 ##
- #########################################################################
- #!/bin/ksh
- export LANG=en_US
- BACKUP_DATE=`date +%d`
- RMAN_LOG_FILE=/home/oracle/1028/log/backupinfo.out
- TODAY=`date`
- USER=`id|cut -d "(" -f2|cut -d ")" -f1`
- echo "-----------------$TODAY-------------------">$RMAN_LOG_FILE
- ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
- export ORACLE_HOME
- RMAN=$ORACLE_HOME/bin/rman
- export RMAN
- ORACLE_SID=orcl
- export ORACLE_SID
- ORACLE_USER=oracle
- export ORACLE_USER
- echo "ORACLE_SID: $ORACLE_SID">>$RMAN_LOG_FILE
- echo "ORACLE_HOME:$ORACLE_HOME">>$RMAN_LOG_FILE
- echo "ORACLE_USER:$ORACLE_USER">>$RMAN_LOG_FILE
- echo "==========================================">>$RMAN_LOG_FILE
- echo "BACKUP DATABASE BEGIN......">>$RMAN_LOG_FILE
- echo " ">>$RMAN_LOG_FILE
- #touch $RMAN_LOG_FILE
- chmod 666 $RMAN_LOG_FILE
- WEEK_DAILY=`date +%a`
- case "$WEEK_DAILY" in
- "Mon")
- BAK_LEVEL=1
- ;;
- "Tue")
- BAK_LEVEL=1
- ;;
- "Wed")
- BAK_LEVEL=1
- ;;
- "Thu")
- BAK_LEVEL=1
- ;;
- "Fri")
- BAK_LEVEL=1
- ;;
- "Sat")
- BAK_LEVEL=0
- ;;
- "Sun")
- BAK_LEVEL=1
- ;;
- "*")
- BAK_LEVEL=error
- esac
- export BAK_LEVEL=$BAK_LEVEL
- echo "Today is : $WEEK_DAILY incremental level= $BAK_LEVEL">>$RMAN_LOG_FILE
- RUN_STR="
- BAK_LEVEL=$BAK_LEVEL
- export BAK_LEVEL
- ORACLE_HOME=$ORACLE_HOME
- export ORACLE_HOME
- ORACLE_SID=$ORACLE_SID
- export ORACLE_SID
- $RMAN nocatalog TARGET sys/oracle msglog $RMAN_LOG_FILE append <<EOF
- run
- {
- allocate channel c1 type disk;
- allocate channel c2 type disk;
- backup incremental level= $BAK_LEVEL skip inaccessible filesperset 5 Database format='/home/oracle/1028/backup/orcl_lev"$BAK_LEVEL"_%U_%T' tag='orcl_lev"$BAK_LEVEL"' ;
- sql 'alter system archive log current';
- backup archivelog all tag='arc_bak' format='/home/oracle/1028/backup/arch_%U_%T' skip inaccessible filesperset 5 not backed up 1 times delete input;
- backup current controlfile tag='bak_ctlfile' format='/home/oracle/1028/backup/ctl_file_%U_%T';
- backup spfile tag='spfile' format='/home/oracle/1028/backup/ORCL_spfile_%U_%T';
- release channel c2;
- release channel c1;
- }
- report obsolete;
- delete noprompt obsolete;
- crosscheck backup;
- delete noprompt expired backup;
- list backup summary;
- EOF
- "
- # Initiate the command string
- if [ "$CUSER" = "root" ]
- then
- echo "Root Command String: $RUN_STR" >> $RMAN_LOG_FILE
- su - $ORACLE_USER -c "$RUN_STR" >> $RMAN_LOG_FILE
- RSTAT=$?
- else
- echo "User Command String: $RUN_STR" >> $RMAN_LOG_FILE
- /bin/sh -c "$RUN_STR" >> $RMAN_LOG_FILE
- RSTAT=$?
- fi
- # ---------------------------------------------------------------------------
- # Log the completion of this script.
- # ---------------------------------------------------------------------------
- if [ "$RSTAT" = "0" ]
- then
- LOGMSG="ended successfully"
- else
- LOGMSG="ended in error"
- fi
- echo >> $RMAN_LOG_FILE
- echo Script $0 >> $RMAN_LOG_FILE
- echo ==== $LOGMSG on `date` ==== >> $RMAN_LOG_FILE
- echo >> $RMAN_LOG_FILE
- exit $RSTAT
2020
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
