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.
