Category Archives: Oracle DataGaurd

ARCH wait on SENDREQ

  ROBLEM: ARCHIVE process get hang on Primary Database ——– The problem has been that the standby hardware have some faulty backpane. This has caused processes in the standby to go into what is called as “D” state where the … Continue reading

Posted in Oracle DataGaurd | Leave a comment

Stop and Start Recover managed Standby Database

  To start Redo Apply in the foreground, issue the following SQL statement: SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE;   To start Redo Apply in the background, include the DISCONNECT keyword on the SQL statement   SQL> ALTER DATABASE … Continue reading

Posted in Oracle DataGaurd | Leave a comment

Step by step guide on how to create a physical standby database using RMAN without using duplicate command

Below are the steps to accomplish the task : Step 1: Backup the database that includes backup of datafiles, archivelogs and controlfile for standby Step 2: Move the backups to the standby server Step 3: Make proper changes in the … Continue reading

Posted in Oracle DataGaurd | 6 Comments

How to open Physical standby database in read write mode

Steps are follows If your primary Server has crashed and no hope to start it up, than follow the steps to open Physical stand by database to read write mode . But be very care full once you open the … Continue reading

Posted in Oracle DataGaurd | 2 Comments

Creating Physical Standby Using RMAN DUPLICATE FROM ACTIVE DATABASE

 Creating Physical Standby Using RMAN DUPLICATE FROM ACTIVE DATABASE Steps are below how to create a physical standby database using RMAN DUPLICATE  FROM ACTIVE DATABASE command without shutting down the primary and using primary active database files (No need to … Continue reading

Posted in Oracle DataGaurd | Leave a comment

DATAGUARD REPLICATION STATUS or Data guard synchronization status

How to confirm replication between primary and DR server CHECK ARCHIVE LOGS SEQUENCE ON PRIMARY RAC SERVER Run this query on PRIMARY-SERVER either of nodes  SQL> select thread#, max(sequence#) “Last Primary Seq Generated” from v$archived_log val, v$database vdb where val.resetlogs_change# = … Continue reading

Posted in Oracle DataGaurd | 1 Comment

How to manually create datafile on standby server

DataGaurd issue with datafile creation if standby_file_management is set MANUAL I HAVE SEEN ERROR IN ALERT LOG OF DR-SERVER ERROR IS Errors with log /ora_archive_log/arch/1_20216_750626102.dbf MRP0: Background Media Recovery terminated with error 1274 Wed Sep 12 07:54:45 EEST 2012 Errors … Continue reading

Posted in Oracle DataGaurd | Tagged , | Leave a comment