CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED
Applies to:
Oracle Server - Enterprise Edition - Version: 10.1 to 10.2
Information in this document applies to any platform.
Purpose
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.
[@more@]Scope and Application
RMAN backups on standby database in Data Guard environment
RMAN backups in Max Performance/Max Availability 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.
NOTE: To make the change in an spfile, double quotes must be used around parameter name:
alter system set "_log_deletion_policy"=ALL scope=spfile sid='*';
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
References
Bug 5261960 - RMAN-8591 STANDBY DESTIONATION MUST BE MANDERATORY WHILE MAX PERFORMANCE
Errors
RMAN-8591 WARNING: invalid archivelog deletion policy
http://www.itpub.net/viewthread.php?tid=957569&extra=&page=1
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/18841027/viewspace-1052531/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle OCP 1Z0 053 Q286(Configure Archivelog Deletion Policy)OracleHive
- Bug 5483067: UNSHIPPED LOGS DELETED DELETION POLICY TO APPLIEDdeleteAPP
- DG歸檔自動刪除 & _log_deletion_policy
- oracle 11g rman configure retention policy to recovery window of days系列一Oracle
- Paimon Deletion VectorAI
- Filter-Policy過濾策略&Route-policyFilter
- Script to find Whether patches is applied in Oracle EBSAPPOracle
- Laravel Policy 使用Laravel
- Restore ArchivelogRESTHive
- Content Security Policy
- Laravel Policy 寫法Laravel
- Delete Dataguard ArchivelogdeleteHive
- 配置ARCHIVELOG 模式Hive模式
- RMAN - backup archivelog all 與 backup database plus archivelog 區別HiveDatabase
- manual database deletion for oracle10g on solaris10DatabaseOracle
- Trust Region Policy OptimizationRust
- Backup policy(備份策略)
- rman restore archivelog logRESTHive
- [zt] crosscheck archivelog allROSHive
- 轉至archivelog模式Hive模式
- rman configure
- Swift代理報錯Optional can only be applied to members of an @objc protocolSwiftAPPOBJProtocol
- 補接_oracle rac_node addition and deletion for clusterware or softwareOracle
- Deterministic Policy Gradient AlgorithmsGo
- Unable to load SELinux PolicyLinux
- Oracle OCP(58):ARCHIVELOG 管理OracleHive
- Archivelog & Noarchivelog mode in RMANHive
- set autotrace on [configure]
- ./configure 幫助
- CodeForces - 1430D String Deletion (思維)
- oracle9i(9204)_manual deletion of db_引注Oracle
- Content Security Policy (CSP) 介紹
- Web 頁面 Meta 的 Referrer PolicyWeb
- open policy agent 語法總結
- Laravel 許可權 Policy 學習Laravel
- Content Security Policy 入門教程
- VPD--Virtual Private Database / Oracle PolicyDatabaseOracle
- restore archivelog 的各種用法RESTHive