Part-B - Configuration at the Standby database


This is the extension of Part-A configuration at the Primary instance. Once you successfully complete the setup on the primary database, please do follow the upcoming steps. If not, it is highly recommended to follow Part-A - Configuration at the Primary database. If you directly landed up on this page, I would suggest you please have a visit to Oracle Dataguard Concepts and Implementation

On the Standby database:



10. Edit the tns entry in the standby database and do tnsping of both services


     




    11. Make  an entry in oratab and set the env variable






      12. Edit the pfile which is copied from primary and edit pwfile name as stand 
        Before edit,


        After edit,






        13. Start the instance to nomount state



          14. Create spfile and verify the unique name,





          15. Check the connectivity between databases,


            Create a static listener or use UR=A




            16. As this manual setup, restore the control file and datafile,






              17. Create redo logs and standby redo logs in the standby database,

                Make the standby file management manual and create it,


                18. Create redo and standby with the same format and size(mandatory) of primary to identify easily,


                That is all. Congrats. We have successfully configured the Physical Standby Dataguard and it is up & running. Please do visit other posts related to Oracle. 



                Recent Posts