Configure Oracle 11gR2 Data Guard in Windows

In Windows, configure Oracle 11gR2 Data Guard. I used to configure Data Guard when I was never in contact with Oracle. Paid download a detailed configuration document for data guard 11g in windows (requires a mailbox), but many of the parameters must be modified according to their own environment, this is quite difficult for a newbie. After 8 days of configuration, we finally achieved initial success. Now we will share with you some of the problems we may encounter during the configuration process. The following sections describe Synchronization Based on the Configuration documentation. Document 2: "When installing oracle, the master database installs the database, and only the software is installed from the slave database. The installation path is drive D. The default path is drive D: \ app \ Administrator \. Put the Instance name orcl Data file in the D: \ Data \ orcl folder, and archive logs in the D: \ Arch_Log folder, the default online log location "l" is the default Instance name after the oracle database is installed. in oracle, each instance name corresponds to a database. I used the Database configuration Assistant tool that comes with oracle to create another instance (which is the same as the Database). The name is "SQL plus" on the tt master Database for configuration, start -- run -- cmd sqlplus/as sysdba; this command means only connecting to the instance does not start the database. Sqlplus/nolog; conn sys/123 @ tt as sysdba; this command connects to the current archive log of the specified database. The command is select name from v $ archived_log. The command for setting the archive log path is: alter system set log_archive_dest_1 = 'location = d: \ arch_log MANDATORY 'scope = both; 3.4 create a parameter file create pfile = 'd: \ initora. ora 'from spfile; 3.5 drag the parameter file cursor to the end. Add the following content and save :........ If you add parameters according to this step, it cannot be started. My initora. the ora file is configured as follows: tt. _ db_cache_size = 322961408tt. _ java_pool_size = 419100004tt. _ large_pool_size = 419100004tt. _ oracle_base = 'd: \ app \ Administrator '# ORACLE_BASE set from environmenttt. _ pga_aggregate_target = 322961408tt. _ sga_target = 482344960tt. _ shared_io_pool_size = 0tt. _ shared_pool_size = 142606336tt. _ streams_pool_size = 0 *. archive_lag_target = 1800 *. audit_file_dest = 'd: \ app \ Administrator \ admin \ tt \ adump '*. au Dit_trail = 'db '*. compatible = '11. 2.0.0.0 '*. control_files = 'd: \ app \ Administrator \ oradata \ tt \ control01.ctl ', 'd: \ app \ Administrator \ flash_recovery_area \ tt \ control02.ctl '*. db_block_size = 8192 *. db_domain = ''*. db_file_name_convert = 'd: \ DATA \ ORCL \ ', 'd: \ DATA \ ORCL \'*. db_name = 'TT '*. db_recovery_file_dest = 'd: \ app \ Administrator \ flash_recovery_area '*. db_recovery_file_dest_size = 4039114752 *. db_unique_name = 'TT '*. diagnos Tic_dest = 'd: \ app \ Administrator '*. dispatchers = '(PROTOCOL = TCP) (SERVICE = ttXDB )'*. fal_client = 'Primary '*. fal_server = 'standby '*. log_archive_config = 'dg _ CONFIG = (tt, standby )'*. log_archive_dest_1 = 'location = D: \ arch_log '*. log_archive_dest_2 = 'service = standby lgwr async VALID_FOR = (ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME = standby '*. log_archive_dest_state_1 = 'enable '*. log_archive_dest_state_2 = 'enable '*. log_ar Chive_format = '% t _ % s _ % r. arc '*. log_file_name_convert = 'd: \ DATA \ ORCL \ ', 'd: \ DATA \ ORCL \'*. memory_target = 804257792 *. nls_language = 'simplified CHINESE '*. nls_territory = 'China '*. open_cursors = 300 *. processes = 150 *. remote_login_passwordfile = 'clusive '*. standby_file_management = 'auto '*. undo_tablespace = 'undotbs1 'Note: Some commands are input in SQL, and some are in the root directory. You can create a new cmd to run the command, if you run the command in the same window, the database may be shut down. 3.8 configure the master database network listener (the same as the slave database) to modify the listener. ora file with the following content: listener. ora Network Configuration File: C: \ oracle \ product \ 10.2.0 \ db_1 \ network \ admin \ listener. ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = d: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS = ONLY: d: \ app \ Administrator \ product \ 11.2.0 \ dbh Ome_1 \ bin \ oraclr11.dll ") (SID_DESC = (GLOBAL_DBNAME = tt) (ORACLE_HOME = d: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1) (SID_NAME = tt ))) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1) (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.166) (PORT = 1521) Modify tnsnames. ora file with the following content: # tnsnames. ora Network Configuration File: d: \ app \ Administrator \ product \ 11. 2.0 \ dbhome_1 \ network \ admin \ tnsnames. ora # Generated by Oracle configuration tools. PRIMARY = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.166) (PORT = 1521) (CONNECT_DATA = (SERVICE_NAME = tt ))) STANDBY = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.121) (PORT = 1521) (CONNECT_DATA = (SERVICE_NAME = tt) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO ))) TT = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.166) (PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = tt ))) 3.12 The Name Of The new instance in the standby database must be the same as that in the primary database. oradim-new-sid tt 3.14 The parameter file in the standby database requires a new system variable. variable name: oracle_sid variable value: tt Note: tt does not perform this step for the original Instance name, resulting in startup errors.. 3.15.3 copy the database RMAN> connect auxiliary sys/sys @ standby this time means to connect to the slave database. If there is a problem, open the command window and enter tnsping 192.168.1.121 as the slave database IP address. If the connection fails, restart OracleOraDb11g_homeTNSListener in the service on the slave database.