Starting with Oracle 12c you can grant the ‘SYSDG’ Administration Privilege to a User so they can perform Data Guard-related operations including using Data Guard Broker. It is no longer necessary to use SYS or SYSDBA for Data Guard Administration. Just grant this Privilege to a User in SQL*PLUS: SQL> grant sysdg to [USER]; Example: […]
oracle 12c
Oracle Data Guard 12c – Creating a Physical Standby from Primary
For the purposes of this post, the following environment is used as an example to describe the procedure: Primary db_name and db_unique_name: BOSTON Standby db_name: BOSTON (same as primary db_name) Standby db_unique_name: CHICAGO Directory: /u01/app/oracle Note: We cannot create a physical standby at PDB(plugable Database) level. It should be at CDB(Container Database) level i.e entire […]
Oracle 12C Enhancements for Cascaded Standby Databases
This post explains the Enhancements for Cascaded Standby Databases in Oracle 12c. There are new Possibilities for cascading Standby Databases in Oracle 12c. The main Differents between Oracle 12c and the previous Releases are: Real-Time Cascading Far Sync Standby Database Data Guard Broker now supports cascaded Standby Database However, you can still only cascade a […]
How to Disable Oracle Net Tracing without stopping server process
When Oracle Net server tracing is invoked using sqlnet.ora (see example below) tracing on the affected server processes will continue throughout the process lifetime. If tracing needs to be stopped without stopping the server process the following method can be used. Example: static server tracing using sqlnet.ora trace_level_server = 16 trace_directory_server = /tmp diag_adr_enabled = […]
Oracle 12c New Feature: LREG Background Process
Instance registration in Oracle Net 12c behaves differently. In 12c and higher, there is a new background process called ora_lreg_sid-name. In previous releases, PMON always handled instance registration logic. In 12c, LREG (Listener REGistration) now takes over with the instance registration logic. LREG (Listener REGistration) – Registers instance information with the listener. – It is […]
How to Optimize a Data Guard Configuration
In this post, we will see how to monitor the configuration performance of data guard along with optimization of SQL apply and redo transport for best performances. Monitoring Configuration Performance by Using Enterprise Manager Cloud Control Graphical charts on the Performance Overview page: Redo Generation Rate: Shows the redo generation rate (in KB per second) […]
Patching and Upgrading Databases in Oracle Data Guard Configuration
Data Guard Standby-First Patch Apply A typical database patch consists of two main steps: step 1) patch installation consisting of patching the Oracle Database Home or Grid Infrastructure Home or both. step 2) patch post-installation consisting of running SQL scripts or SQL commands. A Standby-First Patch only executes step 1 to a physical standby environment. […]
How to Configure client connectivity in Oracle Data Guard configuration (Implement failover procedures)
Connecting to the Appropriate Environment A physical standby database not using Active Data Guard maintains the database in a mounted mode and would not normally allow listener connections for normal users. However, with Active Data Guard, the database is open read-only to allow reporting against the physical standby. Also, the addition of logical standby databases […]
How to Use Recovery Manager (RMAN) to back up and restore files in a Data Guard configuration
Using RMAN to Back Up and Restore Files in a Data Guard Configuration Recovery Manager (RMAN) can be used to back up and recover a standby database. Backups that you make on a physical standby database are usable at a primary database or another standby database. A recovery catalog is required when you use RMAN […]
How to Enable Fast-Start Failover using Enterprise Manager
Fast-start failover enables the Data Guard broker to rapidly and automatically failover to a previously chosen standby database without requiring manual intervention. This feature increases the availability of your database in the event of a disaster by reducing the need for you to perform a failover operation manually. Fast-start failover can only be used in […]