RAC 开启归档日志

1:先调整
sql>alter system set log_archive_dest_1='LOCATION=/arch' scope=spfile sid='lcamDB1';
sql>alter system set log_archive_dest_1='LOCATION=/arch' scope=spfile sid='lcamDB2';
sql>alter system set log_archive_format ='arch1_%s_%R_%T.arc' scope=spfile sid='lcamdb1';
sql>alter system set log_archive_format ='arch2_%s_%R_%T.arc' scope=spfile sid='lcamdb2';
 srvctl stop database -d lcamdb -o immediate


-- startup database in mount mode
 srvctl start database -d lcamdb -o mount


-- enable archvive logging
4:$ sqlplus / as sysdba
sql> alter database archivelog;


5:-- stop database
$ srvctl stop database -d lcamdb -o immediate


6:-- restart all database instances
$ srvctl start database -d lcamdb
7:调整归档空间
alter system set DB_RECOVERY_FILE_DEST_SIZE=500g


[oracle@lcamdb1 archive_lcamdb1]$ srvctl status database -d lcamdb
Instance lcamdb1 is running on node lcamdb1
Instance lcamdb2 is running on node lcamdb2


配置自动清理脚步
arch_space_usage=`df -m|grep /arch | grep -v /arch01 |awk '{if($4/1>80)print $NF" Filesystem space usage ."$4}'`
if test -z "$arch_space_usage"; then
 echo " `date`:Archive space not greater than 80 %" >> /tmp/arch_dir.log
else
 echo " `date`:Archive space greater than 80%" >> /tmp/arch_dir.log
rm -rf /arch/*.arc >> /tmp/arch_dir.log
fi


删除5天前的数据Vi del_lcam_data.sh
#bin/sh
filename=`find /tmp01/archive_lcamdb1/*.arc -mtime +5`
rm -rf $filename 


一般需要把归档日志放到存储上，所以需要进一步的做调整！ 还有接入磁带库！以及备份等工作！

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28869493/viewspace-2121559/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28869493/viewspace-2121559/