‘6. RAC’

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: Scripts to check if archive logs are being shipped and applied to standby

1. Steps to check archive logs are being shipped and applied to standby. AT PRIMARY: A.  Check the status. Note: Status should return valid for standby destination set lines 500 column destination format a35 wrap column process format a7 column archiver format a8 column ID format 99 select dest_id “ID”,destination,status,target,archiver,schedule,process,mountid from v$archive_dest ; Sample Output: B. […]

March 17, 2014 · Sanjay · No Comments
Posted in: 3. All Scripts, 6. RAC, 7. High Availability