standby

How to add a tempfile in primary database in dataguard

If standby_file_management is set to AUTO, as soon as we add a datafile on primary database, same will be created automatically on standby database. But will the same valid for tempfile?? Answer is NO...

Standby redologs in oracle dataguard

The Advantage of having Standby Redo Logs (SLR) is that every records written into the Online RedoLogs of the Primary Database is transferred to the Standby database and written into the Standby Redo ...

How to recreate physical standby controlfile

     Below are the steps for recreating physical standby controlfile. 1. Get the controlfile location [STANDBY] [crayon-5beb0e9ada5f2968171103/] 2. Cancel recovery [STANDBY] [crayon-5beb0e9ada5f839...

ORA-01274: cannot add data file that was originally created as

PROBLEM: After adding a datafile in primary database, recovery process in standby stopped with below error. — Primary database: SQL> alter tablespace prim add datafile size 1g; Tablespace alt...

How to apply psu patch on standby database

                 To apply psu patch on  physical standby database setup, 1st patch need to be applied on standby, and then on primary. Below are the steps.  Download patch from oracle suppo...

How to recover standby database when archive logs are missing in primary

      Normally in DR setup, the archives from primary shipped to standby and applied there. Suppose some of the archives hasn’t been shipped to secondary .But due to intermittence error or human ...

Convert physical standby to snapshot standby database

What is snapshot standby: Snapshot standby is a feature in Oracle 11g that allows doing a read-write operation on the standby database.  i. e we can convert the physical standby database to snapshot ...

How to create physical standby database

                 Here will build a physical standby setup. Our assumption is primary database is already up and running fine And ORACLE_HOME is installed on standby server.   PRIMARY STANDBY...

Oracle data guard concepts

The main features of Oracle data guard is 1. High availablity 2. Data protection 3. Disaster Recovery             A Dataguard configuration consists of one primary database and one or more stand...

MRP0: Background Media Recovery terminated with error 1274

     We were receiving error like MRPO terminated with error 1274,unnamed file added in standby database, when a new data file was added in the primary. Below is the actual error.   [crayon-5b...

Page 1 of 212
Skip to toolbar