Martins Blog

Trying to explain complex things in simple terms

Posts Tagged ‘_log_deletion_policy’

Archivelog retention policy changes in RMAN 11g

Posted by Martin Bach on October 8, 2009

In the past, that means at least until 10.2.x it used to be a bit clumsy to set the archivelog deletion policy to “applied on standby” on both primary and standby database. It involved setting an underscore parameter, as per Metalink Note 728053.1 “Configure RMAN to purge archivelogs after applied on standby”. For reference, the parameter was _log_deletion_policy, and you’d have to bounce the database for it to take effect.

SQL> alter system set "_log_deletion_policy"='ALL' scope=spfile;

Only then could you avoid the error message.Now with 11g that’s a lot easier.

Read the rest of this entry »

Posted in 11g Release 1, 11g Release 2, Oracle, RMAN | Tagged: , , , | 7 Comments »