RMAN backups in Max Performance/Max Availability Data Guard Environment [ID 331924.1]
	Modified 28-DEC-2010     Type BULLETIN     Status PUBLISHED

In this Document
  Purpose
  Scope and Application
  RMAN backups in Max Performance/Max Availability Data Guard Environment
  References

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.1 - Release: 10.1 to 10.2
Information in this document applies to any platform.http://www.cndba.cn/Dave/article/864

When using 'configure archive log deletion policy to applied on standby' on primary database, allow RMAN to consider *both* mandatory and optional destinations when determining which logs on primary can be deleted.

RMAN backups on standby database in Data Guard environment

The 10g RMAN-Data Guard paper states that 'archive log deletion policy applied on standby' only checks that a log has been applied on all mandatory standby databases.

However, Data Guard best practice for Max Performance and Max Availability modes is to *not* use mandatory standby (so that primary does not hang in the event of online logs filling up). Therefore, the following parameter must be set:

 _log_deletion_policy='ALL'

This will allow RMAN to delete logs from the Flash Recovery Area on primary database host that have been applied to all standby databases (whether mandatory or optional). Database will require bounce after setting this parameter.http://www.cndba.cn/Dave/article/864

NOTE:  To make the change in an spfile, double quotes must be used around parameter name: http://www.cndba.cn/Dave/article/864

alter system set "_log_deletion_policy"=ALL scope=spfile sid='*'; http://www.cndba.cn/Dave/article/864

NOTE: attempt to set this configuration in RMAN without this parameter setting may result in error:

RMAN> configure archivelog deletion policy to applied on standby;

new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN-08591: WARNING: invalid archivelog deletion policy

BUG:5261960 - RMAN-8591 STANDBY DESTINATION MUST BE MANDATORY WHILE MAX PERFORMANCE

 

 

 http://www.cndba.cn/Dave/article/864

 http://www.cndba.cn/Dave/article/864

---------------------------------------------------------------------------------------------------

Blog： http://blog.csdn.net/tianlesoftware

网上资源： http://tianlesoftware.download.csdn.net http://www.cndba.cn/Dave/article/864

相关视频：http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx

DBA1 群：62697716(满); DBA2 群：62697977(满) DBA3 群：62697850(满)   http://www.cndba.cn/Dave/article/864

DBA 超级群：63306533(满); DBA4 群： 83829929 DBA5群： 142216823

聊天 群：40132017

--加群需要在备注说明Oracle表空间和数据文件的关系，否则拒绝申请http://www.cndba.cn/Dave/article/864

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle 11g