请选择 进入手机版 | 继续访问电脑版

ORACLE SOS

 找回密码
 立即注册

QQ登录

只需一步,快速开始

搜索
查看: 5009|回复: 0

11.2 standby 库清理归档技巧

[复制链接]

95

主题

266

帖子

1719

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1719
发表于 2014-3-28 23:22:14 | 显示全部楼层 |阅读模式
在11.2之前的版本中,如果你配置了dataguard会有个烦心的事情,就是要写脚本,定时清理备库的归档日志,如果长期不清理,可能导致备库因为归档满了而hang住。从11.2开始oracle考虑到大家在该问题上的烦恼,做了一些改进,让oracle自动清理备库归档
1.在rman中配置CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
2.归档存放到USE_DB_RECOVERY_FILE_DEST中
oracle就会自动管理备库的归档清理,无需人工干预,下面alert日志自动删除结果:
Fri Mar 28 13:58:22 2014
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/QSNGDG/archivelog/2014_03_16/o1_mf_1_1060_9lbhn5vt_.arc
Archived Log entry 768 added for thread 1 sequence 1340 ID 0xe3ba0ad3 dest 1:
Fri Mar 28 14:01:33 2014
RFS[16]: Selected log 10 for thread 1 sequence 1342 dbid -474355757 branch 837621909
Fri Mar 28 14:01:33 2014
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/QSNGDG/archivelog/2014_03_16/o1_mf_1_1061_9lbhn60k_.arc
Archived Log entry 769 added for thread 1 sequence 1341 ID 0xe3ba0ad3 dest 1:
Fri Mar 28 14:01:33 2014
Media Recovery Waiting for thread 1 sequence 1342 (in transit)
Recovery of Online Redo Log: Thread 1 Group 10 Seq 1342 Reading mem 0
  Mem# 0: /u01/app/oracle/oradata/qsng/std_redo10.log
RFS[16]: Selected log 11 for thread 1 sequence 1343 dbid -474355757 branch 837621909
Fri Mar 28 14:01:34 2014
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/QSNGDG/archivelog/2014_03_16/o1_mf_1_1062_9lbhpww2_.arc
Archived Log entry 770 added for thread 1 sequence 1342 ID 0xe3ba0ad3 dest 1:
Media Recovery Waiting for thread 1 sequence 1343 (in transit)
Recovery of Online Redo Log: Thread 1 Group 11 Seq 1343 Reading mem 0
  Mem# 0: /u01/app/oracle/oradata/qsng/std_redo11.log





Q Q:107644445
Tel:13429648788
Email:dba@xifenfei.com
个人Blog(惜分飞)
提供专业ORACLE技术支持(数据恢复,安装实施,升级迁移,备份容灾,故障诊断,系统优化等)
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|Archiver|手机版|ORACLE SOS 技术论坛

GMT+8, 2024-3-29 20:15 , Processed in 0.018953 second(s), 24 queries .

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表