dataguard oracle 归档管理脚本

管理部分

如果没有启用database force logging,则备库对/*+ append */操作，nologging操作，会报坏块；

建议表空间force logging或者database force logging;

--force logging /nologging 测试

alter database force logging;select force_logging from dba_tablespaces;select force_logging from v$database;alter tablespace test force logging;select  logging,table_name,tablespace_name from user_tables where table_name ='TEST';alter tablespace test no force logging;select tablespace_name,logging,force_logging from dba_tablespaces;

##配置主库的归档删除策略

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;

--传过去就删除

CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO STANDBY;

备库删除脚本

vi delete_archive.sh

#!/bin/shsource /home/oracle/.bash_profileexport ORACLE_SID=standbyTABLE='v$archived_log'$ORACLE_HOME/bin/sqlplus -silent "/ as sysdba" <
增加定时任务：crontab -e
0 1 * * *  su - oracle -c     /home/oracle/scripts/delete_archive.sh 1
备库自启动脚本：
vi /etc/rc.local
su - oracle -c /home/oracle/scripts/start_db.shvi start_db.shsource /home/oracle/.bash_profilelsnrctl startexport ORACLE_SID=standbysqlplus / as sysdba <