Author: Michael Dinh

Management and Troubleshooting Features: Data Guard Command-Line Interface (DGMGRL) 19c

With Oracle Data Guard promising high availability, data protection and disaster recovery for enterprise data, it’s useful to understand the Data Guard command-line interface (DGMGRL) which enables you to control and monitor a Data Guard configuration from the DGMGRL prompt…

Read More >

CreateGoldImage Followup – Is CreateGoldImage Required for Cloning Oracle Home?

On October 31, 2019, I blogged about How To Use CreateGoldImage For Cloning In 19c. CreateGoldImage seems like a nice new feature; however, it’s also very buggy. Here are a few bugs: 2641469.1 27432355.8 27432338.8 I received a suggestion to use tar…

Read More >

Caution: Using AutoUpgrade with Multiple Databases from the Same ORACLE_HOME

Here’s a short and sweet post. “In Deploy mode, AutoUpgrade also confirms that the upgrade has succeeded, and moves database files such as sqlnet.ora, tnsnames.ora, and listener.ora from the source home to the target home. After these actions are complete,…

Read More >

Data Guard Listener Networking

I’m currently reviewing an environment to create a third standby. One of the challenges is that there isn’t any sort of consistent naming convention. One example is “db_name” and “db_unique_name.” Firstly, don’t name db_unique_name using a number (for example, hawk1,…

Read More >

Conventions Make for Easy Automation

I talk a lot about implementing conventions, which usually results in easy automation. Here are examples of shell scripts you can run from any host to manage the Data Guard environment. You should be able to use the same framework…

Read More >

Use RMAN KEEP Backup To Roll Back From an Upgrade

There is a requirement to back up a database before an application upgrade to be able to rollback. Guarantee Restore Point (GRP) was first considered by us; however, it looks like there is insufficient space from Flash Recovery Area (FRA)….

Read More >

Let DataGuard Broker Do ALL The Work

What’s the reason for implementing DataGuard Broker? It does all the work. eg. Test system has been shutdown and upon startup, encountered error as shown. Shutdown database and startup mount. Check DataGuard status using dgmgrl. Note: standby recovery was automatically…

Read More >

How to Stop All Database Instances Running From ORACLE_HOME

At times, there may be a requirement to stop database instances, for example, to perform patching. When there is only one database instance running on the server, it is sufficient to stop the instance using srvctl stop instance -d db_unique_name…

Read More >

How to Test Data Guard Fast-Start Failover by Shutting Down Standby Server

This post will demonstrate the procedure for testing Oracle Data Guard Fast-Start Failover by shutting down the server where the standby database is running from. The environment is a single instance database without any grid infrastructure components. Review primary host…

Read More >

How to Test Data Guard Fast-Start Failover by Shutting Down Primary Server

This post will demonstrate the procedure to test Oracle Data Guard Fast-Start Failover by shutting down the server where the primary database is running from. The environment is a single instance database without any grid Infrastructure components. The same process…

Read More >
Page 1 of 712345...Last Page »