-- Over view
Active Data Guard Technical Overview – Physical Standby
1) Prepare static listeners and TNS entries specific for Data Guard
2) Prepare Primary CDB with Data Guard Initialization parameters and standby logs
3) Create Standby instance for Primary copy
4) Copy Primary Database to Standby Instance via RMAN
5) Alter Standby Database Initialization parameters (listener, logs, etc)
6) Sync TDE wallet as needed (Copy from Primary to Standby O.S. location)
7) Create Data Guard Broker Configuration (dgmgrl)
8) For Real Time apply SET PROPERTY ArchiveLagTarget='0'
9) Create / Schedule job to remove applied logs from Standby
How to Setup Active DataGuard on Exadata (Doc ID 1580796.1)
People Soft ADG implementation
1) Create secondary Data Guard user in DB. (SYSADMDG)
2) Create secondary Data Guard Symbolic ID in PS (SYSADM2)
3) Run PS provided scripts to prepare DB user (create DB links, synonyms, grants)
4) Add Standby Database info to App and Job server config files.
5) Configure PIA for which jobs are read only.
Advantages of Oracle Active Data Guard with Real Time Apply
1) High Availability Standby for failover / switchover
2) Off load database backups
3) Off load reporting and near real time read only activities.
4) Little to no down time patching (dependent on the application)
5) Application testing and roll-back with Snapshot Standby
Comentarios