RAM&KRISHNA BLOG

Please follow below steps. NOTE: Here primary & standby already configuared. The below are the steps we are performing on standby database, to make it active standby database. ------------------------------------------------------------- 1. Connect to the standby database. ------------------------------------------------------------- 2. Stop redo apply using the below script SQL>recover managed standby database cancel; --------------------------------------------------------------------------------------------------- 3. Issue the following query to find out if the standby database is performing Redo Apply or real-time apply. If the MRP0 or MRP process exists, then the standby database is applying redo SQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY; --------------------------------------------------------------------------------------------------- 4. Check database tole, open mode using the below script.  SQL>select name, database_role,open_

1. 1.  What are the advantages in using Oracle Data Guard?   Following are the different benefits in using Oracle Data Guard feature in your environment.    High Availability.   Data Protection.   Off-loading Backup operation to standby database.   Automatic Gap detection and Resolution in standby database.   Automatic Role Transition using Data Guard Broker. 22.    What are the different services available in Oracle Data Guard?                 Following are the different Services available in Oracle Data Guard of Oracle database. ü   Redo Transport Services. ü   Log Apply Services. ü   Role -Transitions. 33.  What are the different Protection modes available in Oracle Data Guard? Below are the protection modes available in DG ü   Maximum Protection ü   Maximum Availability ü   Maximum Performance => This is the default protection mode. It provides the highest level of data protection that is possible without affecting the performance of