ORA-20200: Database/Instance does not exist in STATS$DATABASE_INSTANCE
When attempting to run a Statspack instance report using spreport.sql the following error is generated.
Read more »
Installing and Configuring Statspack
With the addition of the Active Workload Repository (AWR) and Active Session History (ASH) in Oracle Database 10g and higher it might seem a little odd to still be talking about Statspack. Both AWR and ASH require an Oracle Diagnostics Pack license which is limited to the Enterprise Edition of the database.
Read more »
Convert a Physical Standby Database into a Snaphot Standby Database Using Oracle Enterprise Manager 11gR1 Grid Control
Oracle Database 11g introduced the Snapshot Standby feature in Data Guard. Using this feature you can use your physical standby database to temporary process transactions. If you have a need to test out application fixes or new functionality you can leverage your physical standby while still protecting the primary database.
Read more »
Convert a Physical Standby Database into a Snapshot Standby Database Using the Data Guard Command Line Interface
This document will detail the steps to convert a physical standby database to a snapshot database using the Data Guard Command Line Interface. If you would like to know more about snapshot databases or how to perform the conversion manually see the post Convert a Physical Standby Database into a Snapshot Standby Database.
Read more »
Convert a Physical Standby Database into a Snapshot Standby Database
Oracle Database 11g introduced the Snapshot Standby feature in Data Guard. Using this feature you can use your physical standby database to temporary process transactions. If you have a need to test out application fixes or new functionality you can leverage your physical standby while still protecting the primary database.
Read more »