Oracle 11g Datagurad Configuration


  • Install the database software only on primary and standby node
  • Configure the network on the both node
  • On primary node create the database
  • 1234567891011121314151617181920
  • Configure the listener and database services in the primary node named it your primary database name

2122232425

  • Restart the listener using the command lsnrctl stop,lsnrctl start

27

  • Do the following steps in the primary node
  • set the following parameter in the primary node
  • Check the database in archive log mode if not in that mode enable the archive log

28  2930313233

  • backup the database using the rman command

34

  • copy the database password file from  primary to standby database node
  • Rename the copied database password file in standby node
  • Create the parameter file using the below command in standby node

3536 3738

  • rename the password file

40

  • Start the standby database with nomount mode in standby node

41

  • Add the listener and database services in standby node named it your standby database name

4243

  • Restart the listener (stop and start) on the standby node

44

  • Add the primary standby database name in the service name on primary node and standby node
  • This example shows only adding on primary and  do the same steps on the standby node

4546474849505152

  • Restart the listener  on primary node and standby node also

5354

  • Create the directories for the standby database on standby node
  • Backup the database using the rman command

5556

  • After completion of the backup create the script like given bellow

57

  • On the primary node connect target and auxiliary database and it connected                   successfully run the script

5960

  • In primary node give the bellow command to generate the log

61

  • Check the database status on the standby node

62

  • In standby node check if the logs are applied here logs are not applied

63

  • Give the bellow command to apply the log on the standby database
  • Once the command is executed log are automatically shipped to standby node

646566

  • This steps are used to configure the dataguard
  • Set dg_broker_start value true on both node follow the steps

6768

  • Add the database services on the both nodes
  • Named it given bellow
  • Restart the listener on both node

69707172

  • In standby node set the parrameter local_listener=stydata

73

  • In the primary node create the dataguard configuration
  • Enable the dataguard configuration
  • Do the switchover process

767879

  • Check the standby node database status after the switch over process

           The standby node database will be opened and primary node database

           Will be in mounted

8081

 

No Comments

Leave a Reply

Your email address will not be published. Required fields are marked *