[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.