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...