In order to implement Standby Database we enable 'Forced Logging'. u01/app/oracle/oradata/white/users01.dbf u01/app/oracle/oradata/white/sysaux01.dbf
![how to configure standby database in oracle 10g how to configure standby database in oracle 10g](https://pavandba.files.wordpress.com/2009/10/dg1.jpg)
u01/app/oracle/oradata/white/system01.dbf Step by Step Implementation of a Physical Standby EnvironmentĪrchive destination USE_DB_RECOVERY_FILE_DEST Verify the Physical Standby Database Is Performing Properly Set Up the Environment to Support the Standby Database on the standby node.ħ. Configure the listener and tnsnames to support the database on both nodesĥ. Prepare an Initialization Parameter File for the Standby DatabaseĤ. Backup the Primary Database and transfer a copy to the Standby node.ģ. Create a Control File for the Standby DatabaseĢ. Having followed these steps to implement the Physical Standby you need to follow these steps:ġ. Set Primary Database Initialization Parameters Once you have your primary database up and running these are the steps to follow:ĥ. Oracle Home is on identical path on both nodes Ssh is configured for user oracle on both nodes Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 Necessary to implement Data Guard Physical Standby manually.Ģ Linux servers, Oracle Distribution 2.6.9-55 EL i686 i386 GNU/Linux All RAC preinstall requisites are then in place and no additional configuration was In this example I did use 2 hosts, that host a RAC database.
![how to configure standby database in oracle 10g how to configure standby database in oracle 10g](https://www.fatihacar.com/blog/resimler/Oracle19c_RAC_and_Active_Data_Guard.jpg)
Manually setting up a Physical standby database is a simple task when all prerequisites and setup steps are carefully met and executed. Standby database name: black on rac1 machineĬreating a Data Guard Physical Standby environment, General Review. Primary database name: white on rac2 machine 10g Data Guard, Physical Standby Creation, step by step