Add the following parameters in the initialization parameter file of the standby database
(ADDRESS = (PROTOCOL = TCP)(HOST =![how to configure standby database in oracle 10g how to configure standby database in oracle 10g](https://docs.oracle.com/cd/B14117_01/server.101/b10822/odg_arch.gif)
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)ĮNABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
(ADDRESS = (PROTOCOL = TCP)(HOST =# Generated by Oracle configuration tools. # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora Setup the connectivity (listener.ora and tnsnames.ora) for the primary and standby databases. *.log_archive_dest_2='service=stnd valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=stnd'ģ.
![how to configure standby database in oracle 10g how to configure standby database in oracle 10g](https://oracle-base.com/articles/12c/images/multitenant-overview/multitenant-dataguard-control.png)
*.log_archive_dest_1='location=use_db_recovery_file_dest valid_for=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=prim' *.db_recovery_file_dest_size=2070572032 #(I have it as nearly 2 GB) *.dispatchers='(PROTOCOL=TCP) (SERVICE=primXDB)' *.control_files='/u01/app/oracle/oradata/prim/control01.ctl','/u01/app/oracle/oradata/prim/control02.ctl' *.audit_file_dest='/u01/home/oracle/admin/prim/adump' Prim._oracle_base='/u01/home/oracle'#ORACLE_BASE set from environment Add the following parameters in the initialization parameter file of the primary database.
![how to configure standby database in oracle 10g how to configure standby database in oracle 10g](https://thedbadmin.com/wp-content/uploads/2020/07/TDE-min-768x403.png)
Orapwd file=$ORACLE_HOME/dbs/orapwPRIM password=oracle force=yĢ.
#How to configure standby database in oracle 10g password#
Check if the primary database is using the password file or not. Initialization parameter “db_unique_name” should be different on primary and standby databases.ġ. Initialization parameter “db_name” should be same on both primary and standby database. Primary database should be in archivelog mode.įorced Logging is on in Primary database (sql>alter database force logging ) Some key points before proceeding with the physical standby setup.