Warning: Creating default object from empty value in /home/customer/www/gavinsoorma.com/public_html/wp-content/themes/specular/admin/inc/class.redux_filesystem.php on line 29
January | 2015 | Oracle DBA – Tips and Techniques
News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Performing a database clone using a Data Guard Snapshot Database

  • Posted by Gavin Soorma
  • On January 28, 2015
  • 1 Comments
Some times we need to have an exact replica of the production database data to urgently test an issue encountered in production. If the production database is very large having a clone process running on the production server or taking a fresh full database backup just for the clone is also not desirable as well […]
Read More
 

Minimal Downtime Cross Platform Migration and 12c Database Upgrade using Data Guard

  • Posted by Gavin Soorma
  • On January 27, 2015
  • 0 Comments
This note describes the procedure used to perform a minimal downtime platform migration from Windows to Linux as well as a database upgrade from Oracle 11.2.0.4 to Oracle 12c (12.1.0.2). We create a Data Guard physical standby database using the DUPLICATE FROM ACTIVE DATABASE feature, followed by a switchover and then we activate the standby […]
Read More
 

EM12c Cloud Control Metric Extensions – Monitor failed DBMS SCHEDULER Jobs

  • Posted by Gavin Soorma
  • On January 13, 2015
  • 0 Comments
So what are Metric Extensions? As the name implies metric extensions enables us to extend the out-of-the-box monitoring capabilities of Enterprise Manager and customize it according to the requirements of our specific environment. Very often we may have some monitoring and alerting requirements for which metrics are not available in OEM and we are having  to […]
Read More