As with 11g Oracle comes with a new feature for Oracle Data Guard: Active Data guard. And with Active Data Guard enabled we can use Block Change Tracking feature for the physical standby database. Now, what is Block Change Tracking? Block Change Tracking: RMAN change tracking feature for incremental backups improves incremental backup performance by recording […]
Monthly Archives: May 2018
Role Transition Switchover and Failover
In Data Guard environment your database operates in one of two Role. 1.Primary Database 2.Standby Database. To know more about it Oracle Dataguard You can have Physical, Logical or Snapshot database in Standby role. Primary and Standby roles are mutually exclusive. With Data Guard role management service we can change this role dynamically and can achieve […]
Preparing to Create a Logical Standby Database
Prior to that, we need to create the Physical Standby. Logical Standby Database : SQL Apply Architecture We need to perform following steps before creating Logical Standby Database : 1. Primary Database must be in Archive log mode. Check your database is in archive log mode or not. If not enable it for archive log. […]
Physical Standby Data Guard Health Check
Physical Standby Data Guard Health Check : After creating any DR server, our main concern is that it should be in synchronized state So if an outage occurs at Production database, we can move to standby database as soon as possible. To know more about it Oracle Dataguard We have following steps to check Data Guard […]
Lag in an Active Data Guard Configuration
Oracle 11g comes up with a New Feature on Oracle Data Guard that is Active Data Guard. In Active Data Guard we can use a real-time query on Standby Database and can gain benefits by offloading read-only workload to Standby Database. To know more about Active Data Guard Oracle Active Data Guard Overview and Architecture […]
Benefits of Implementing a Logical Standby Database
Logical Standby Database in Data Guard environment stays in a Read, Write mode that is fully updatable mode. Logical Standby Database provides following benefits over any other standby database in data guard : To know more about Logical Standby Architecture: Logical Standby Database: SQL Apply Architecture The database is opened in READ, WRITE mode in logical […]
Configure DG broker
The Data Guard broker logically groups these primary and standby databases into a broker configuration that allows the broker to manage and monitor them together as an integrated unit. You can manage a broker configuration using either the Oracle Enterprise Manager graphical user interface or the Data Guard command-line interface. To know more about it […]
Lock and unlock statistics on a table in Oracle Database
Today we are going to have a look at steps we use for lock/unlock statistics on a table. In the world of technology, we all love to work with one click. The way we DBAs would like to work in the same tradition as we know sometimes we may not want to analyze a table automatically […]
Bypass the AFTER LOGON trigger in Oracle Database
Today we are going to have to look on “Bypass the execution of the AFTER LOGON trigger“. Problem: You might have AFTER LOGON trigger for auditing and because of faulty logic (infinite loop) or the space in auditing table is full or some other problem connected to trigger, no users are able to connect to […]
SQL*Plus Customize User Profile in Oracle Database
Being Oracle DBA we all are aware of the relationship between instance and database. Today we are going to have look on “SQL*Plus Customize User Profile“. On daily basis, DBAs works on SQL*Plus at many stages of the database. Execution of all commands on the correct database is the main focus of any DBA. We have to perform multiple […]