Posts

Oracle 11g Active Data Guard

Steps to configure Oracle 11g Active Data Guard:  ==================================================== Server details  Primary Server: hostname: vmnsedb01 Db_name : nsewebdv DB unique name: nsewebdv DB Service name: nsewebdv sys password: N5EwEbdV ++++++++++++++++++++++++ Standby Server hostname: vmnsedb02 Db_name : nsewebdv DB unique name :nsewebsb DB Service name :nsewebsb sys password: N5EwEbdV ==================================================== In Primary Database  STEP:1# Enable force logging: sql> select force_logging from v$database;   #Output: No sql> alter database force logging; sql> select force_logging from v$database;   #Output: Yes STEP:2# Enable archiving: sql> shut immediate; sql> startup mount; sql> alter database archivelog; sql> alter database open; sql> archive log list  #Output: Enable STEP:3# Create a password file for primary and standby. Password should be same for both prim...