Monthly Archives: April 2010

Precautions before a shutdown a database

Before a shutdown the Production or any important database, take some basic precaution besides the backup. Create an init parameter file from current spfile (If database is using spfile) In case, If database is not mounting / coming up or … Continue reading

Posted in precautions before a shutdown a database oracle 10g | Tagged , | Leave a comment

Managing Archive Gaps Manually on Standby Database Setup

To determine if there is an archive gap on your physical standby database SQL> SELECT * FROM V$ARCHIVE_GAP; THREAD# LOW_SEQUENCE# HIGH_SEQUENCE# ———– ————- ————– 1 12499 12511 In this case, Standby database is waiting for archive log 12499 SQL> select … Continue reading

Posted in Data Guard | Tagged | 4 Comments