Below are the steps for recreating physical standby controlfile. 1. Get the controlfile location [STANDBY] SQL> show parameter control_files NAME TYPE VALUE --------------------------------...
standby
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. Media Reco...
scripts to monitor standby database
FIND THE ARCHIVE LAG BETWEEN PRIMARY AND STANDBY: select LOG_ARCHIVED-LOG_APPLIED "LOG_GAP" from (SELECT MAX(SEQUENCE#) LOG_ARCHIVED FROM V$ARCHIVED_LOG WHERE DEST_ID=1 AND ARCHIVED='YES'), (SE...
How to find log gap between primary and standby db
Use the below query to find the applied archive log gap between primary and standby oracle database. select LOG_ARCHIVED-LOG_APPLIED "LOG_GAP" from (SELECT MAX(SEQUENCE#) LOG_ARCHIVED FROM V$ARCHIVED_...