管理部分如果没有启用database force logging,则备库对操作,nologging操作,会报坏块;建议表空间force logging或者database force logging;--f
管理部分
如果没有启用database force logging,则备库对操作,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/sh
source /home/oracle/.bash_profile
export ORACLE_SID=standby
TABLE='v$archived_log'
$ORACLE_HOME/bin/sqlplus -silent "/ as sysdba" <<EOF
set heading off;
set pagesize 0;
set term off;
set feedback off;
set linesize 199;
set trims on ;
set verif off;
spool /home/oracle/scripts/del_arch.sh;
select 'rm -rf '||name from v\$archived_log where DELETED='NO' and APPLIED='YES';
spool off;
exit;
EOF
chmod +x /home/oracle/scripts/del_arch.sh
sh /home/oracle/scripts/del_arch.sh
rman target / <<EOF
crosscheck archivelog all;
delete noprompt expired archivelog all;
exit;
EOF
增加定时任务: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.sh
vi start_db.sh
source /home/oracle/.bash_profile
lsnrctl start
export ORACLE_SID=standby
sqlplus / as sysdba <<EOF
startup;
recover managed standby database using current logfile disconnect from session;
exit
--结束END--
本文标题: dataguard oracle 归档管理脚本
本文链接: https://www.lsjlt.com/news/44311.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0