Sometimes OS team may request for outage on standby database server for maintenance activites. In that we need to stop the log shipping to avoid error in the alert log. Run below commands to disable and enable the log shipping. primary db -> prod standby db – > proddr 1. Login to primary db server […]

Below script is helpful in monitoring lag in standby database and send mail to DBAs in case the lag is increasing. For the script to work, make sure dataguard broker is enabled between primary and standby database.   SEE DGBROKER ARTICLE:  How to setup dgbroker in oracle 12c: Useful dgmgrl commands:   SCRIPT PREPARATION: PRIMARY […]

This articles contains useful dgmgrl commands to manage the dataguard environments. 1. Setup DG broker in the standby setup.(Run on both primary and standby) – For standalone db : ALTER SYSTEM SET dg_broker_config_file1 = ‘\U01\oradata\dr1node.dat’ scope=both sid=’*’; ALTER SYSTEM SET dg_broker_config_file2 = ‘\U01\oradata\dr2node.dat’ scope=both sid=’*’; — For oracle RAC/ASM file system; ALTER SYSTEM SET dg_broker_config_file1 […]

Dataguard broker is used to automate monitoring and controlling standby setups. It is very much useful, when the organization has multiple standby sites. In this article, we will see, how to enable dg broker configuration in existing standby setup. NOTE – Before setting dgbroker, make sure standby setup is ready. SEE ALSO – Setup physical […]

If standby_file_management is set to AUTO, as soon as we add a datafile on primary database, same will be created automatically on standby database. But will the same valid for tempfile?? Answer is NO. Adding tempfiles to TEMP tablespaces in primary database, will not automatically create on standby database. Because no redo is generated, while […]

The Advantage of having Standby Redo Logs (SLR) is that every records written into the Online RedoLogs of the Primary Database is transferred to the Standby database and written into the Standby Redo Logs at the same time. therefore, you it minimizes the probability of Data Loss on the Standby Database. Without Standby Redo Logs, […]

During peak business hours, It is not advised to export data from production .(as it might impact the performance). So if we have a physical standby database, we can export data using datapump from standby database. PRE-REQUISITES: 1. Physical standby database should be in READ-ONLY MODE (ACTIVE DATAGUARD) 2.We cannot run expdp directly on physical […]

Active dataguard means, the standby database is open with read only mode, even when redo logs are getting applied in real time. Below are the benefit of using active dataguard. Reporting queries can be offloaded to standby database. Physical block corruptions are repaired automatically either at primary or physical standby database. RMAN backups can be […]

     Below are the steps for recreating physical standby controlfile. 1. Get the controlfile location [STANDBY] SQL> show parameter control_files NAME TYPE VALUE ———————————— ———– —————————— control_files string /archive/NONPLUG/NONCDB/contro l01.ctl, /archive/NONPLUG/NONC DB/control02.ctl 2. Cancel recovery [STANDBY] alter database recover managed standby database cancel; 3. Shutdown standby [ STANDBY] SQL> SHUTDOWN IMMEDIATE Database closed. Database […]

      Development wanted to do some changes in the dev database, which needs to be rolled back once testing is over. So we have chosen to create flashback restore point before they do the changes and flashback the database, once testing is over. Now there is a little twist. This is a data […]