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 >
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 >
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 >
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 >
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 >
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 >
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 >
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 >
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 >
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 >
© Copyright 2020 Pythian Group Inc. ® ALL RIGHTS RESERVED.
PYTHIAN®, LOVE YOUR DATA®, and ADMINISCOPE® are trademarks and registered trademarks owned by Pythian in North America and certain other countries, and are valuable assets of our company. Other brands, product and company names on this website may be trademarks or registered trademarks of Pythian or of third parties. Use of trademarks without permission is strictly prohibited.