‘7. High Availability’

RAC Interview questions

  RAC Questions and Answers

November 30, 2015 · Sanjay · No Comments
Posted in: 1. DB Admin, 6. RAC, 7. High Availability

RAC Database stop and start steps

  Steps to Shutdown/Start RAC Database 1. Shutdown Oracle Home process accessing database. 2. Shutdown RAC Database Instances on all nodes. 3. Shutdown All ASM instances from all nodes. 4. Shutdown Node applications running on nodes. 5. Shut down the Oracle Cluster ware or CRS. Starting steps are from 5 to 1(means which stopped last should be started 1st). […]

November 29, 2015 · Sanjay · No Comments
Posted in: 1. DB Admin, 2. ASM, 6. RAC, 7. High Availability

Data guard broker commands

$dgmgrl / $dgmgrl sys/pwd $dgmgrl sys/pwd@oltp $dgmgrl sys/test@dgprimary “show database ‘prod’” $dgmgrl -logfile observer.log / “stop observer” $dgmgrl -silent sys/test@dgprimary “show configuration verbose” $dgmgrl / “show configuration verbose” ADD – Adds a standby database to the broker configuration. DGMGRL> ADD DATABASE db_name [AS CONNECT IDENTIFIER IS conn_identifier] [MAINTAINED AS {PHYSICAL|LOGICAL}]; DGMGRL> ADD DATABASE ‘testdb’ AS […]

November 29, 2015 · Sanjay · No Comments
Posted in: 6. RAC, 7. High Availability

HA: Switchover to standby using dataguard broker and manually

In this post we will discuss the steps to switchover from Primary Database to Physical Standby database. 1. Switchover using data guard broker(dgmgrl) 2. Switchover using sql   1. Switchover using data guard broker(dgmgrl) Note: While connecting as sys user ensure using sys/pwd (not sys /as sysdba). 1. See the current configuration. DGMGRL> show configuration […]

March 19, 2014 · Sanjay · No Comments
Posted in: 7. High Availability