Dataguard

Hanh Nguyen

Oct 4, 20153 min read

Steps to perform for Rolling forward a standby database using RMAN incremental backup when primary a

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

0 views0 comments

Hanh Nguyen

Oct 4, 20153 min read

How To Open Physical Standby For Read Write Testing and Flashback

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

1 view0 comments

Hanh Nguyen

Oct 4, 201510 min read

Step By Step of Configuring Oracle 11gR2 (11.2.0.1) RAC to RAC Dataguard:

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...

0 views0 comments

Hanh Nguyen

Oct 3, 201510 min read

11.2 Data Guard Physical Standby Switchover Best Practices using SQL*Plus

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

0 views0 comments

Hanh Nguyen

Oct 3, 201518 min read

How to resolve MRP stuck issues on a physical standby database

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

0 views0 comments

Hanh Nguyen

Oct 3, 20151 min read

8. Step By Step Guide On How To Configure And Test Client-Failover For Dataguard Switchover And Fail

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

2 views0 comments

Hanh Nguyen

Oct 3, 20154 min read

Steps to perform for Rolling forward a standby database using RMAN incremental backup when primary a

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...

1 view0 comments

Hanh Nguyen

Oct 3, 20151 min read

How To Flashback Primary Database In Standby Configuration

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

1 view0 comments

Hanh Nguyen

Oct 3, 20155 min read

Synchronization of primary and standby database due to log transfer gap

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...

0 views0 comments

Hanh Nguyen

Oct 3, 20152 min read

How to Rename a Datafile in Primary Database Within in Physical Dataguard Configuration

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

4 views0 comments

Hanh Nguyen

Oct 3, 20159 min read

Step By Step Guide To Create Physical Standby Database Using RMAN

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...

2 views0 comments