[ORACLE 11G - DATAGUARD] ARCHIVELOG DELETION POLICY ON STANDBY

Using this configuration on physical standby databases will enable automatic deletion of archived logs on the standby database. Using this policy requires that the database uses a FRA.

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

[ORACLE DB 11G-DATAGUARD] Clone Oracle Database Standby Node

We have an Oracle DB using Dataguard configuration with one node DC - running as Primary mode, one node DR - running as Standby mode. Now we need to create one more other node in standby mode - read only, running as report DB server. Let's using these steps to build new standby by clone standby node.

On Standby:
- Stop recovery mode on Standby node
- shutdown standby mode.
- create pfile from spfile.
- copy pfile,orapwSID file, controlfile,datafile,redologfile,standbylogfile.
- startup mount -> start recovery mode.
On Primary:
- Add tnsnames.ora -> point to new standby.
- Add log_archive_config -> add New Standby service
- Add log_archive_dest_xxx -> Point to New Standby service
- Add log_archive_dest_state_xxx -> enable;
On New Standby:
- Modify pfile.
- startup pfile nomount;
- create spfile from pfile.
- alter database mount; (Rename datafile, if path on standby #)

- start recovery mode.

Check Oracle Dataguard status.