Solution 1) On the standby database, stop the managed recovery process (MRP) SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;...

Solution Using a combination of Data Guard, restore points, and Flashback Database, a physical standby database can be opened temporarily...

This document explains the step by step process of building the 11g R2 (11.2.0.1) 3-Node RAC primary to 2-Node RAC Physical Standby...

// // // // // // // // Solution I. Prerequisites / Preparation These are items that should only have to be done once during...

Would you like to explore this Topic further with other Oracle Customers, Oracle Employees and Industry Experts ?? You can discuss this...

Solution Configure the Client Failover 1. Create and Start a new service on primary which will be used to connect to the database. SQL>...

The steps in this section can used to resolve problems if a physical standby database has lost or corrupted archived redo data or has an...

Goal How to flashback primary database in standby configuration. Solution To Flashback primary database execute following steps : 1....

PURPOSE ——- The purpose of this document is; a) How to verify whether there is a gap in the log transfer from the primary to the standby...

Goal How to rename a datafile in the primary database and manually propagate the changes to the standby database. When you rename one or...

APPLIES TO: Oracle Database – Enterprise Edition – Version 9.0.1.0 to 11.2.0.3 [Release 9.0.1 to 11.2] Information in this document...