Dataguard parameter file notes

Dataguard parameter file note environment: ######################################## ############ master database: 192.168.220.3 slave Database: the master database of 192.168.220.4 is the same as the slave database version. SQL> select * from v $ version; BANNER implements Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-ProdPL/SQL Release 10.2.0.1.0-ProductionCORE 10.2.0.1.0 ProductionTNS for Linux: Version 10.2.0.1.0-ProductionNLSRTL Version 10.2.0.1.0-Production main database db_name, sid SQL> select instance_name from v $ instance; INSTANCE_NAME ---------------- orcl SQL> show parameter db_name NAME TYPE VALUE --------------- ------------------------------ db_name string ice ## listener #################### ########################### master database: # listener. ora Network Configuration File:/home/app/oracle10/product/10.2.0.1/net Work/admin/listener. ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME =/home/app/oracle10/product/10.2.0.1) (PROGRAM = extproc )) (SID_DESC = (SID_NAME = orcl) (ORACLE_HOME =/home/app/oracle10/product/10.2.0.1) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.220.3) (PORT = 152 (1) (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC0) "listener. ora "24L, 617C slave Database: # listener. ora Network Configuration File:/home/app/oracle10/product/10.2.0.1/network/admin/listener. ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME =/home/app/oracle10/product/10.2.0.1) (PROGRAM = extproc )) (SID_DESC = (SID_NAME = orcl) (ORACLE_HOME =/home/app/oracle10/product/10.2.0.1) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.220.4) (PORT = 1521) (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC0) "listener. ora "24L, 617C ### tnsnames ################################### ############ master database: # tnsnames. ora Network Configuration File:/home/app/oracle10/product/10.2.0.1/network/admin/tnsna Mes. ora # Generated by Oracle configuration tools. orcl = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.220.3) (PORT = 1521) (CONNECT_DATA = (SERVICE_NAME = orcl ))) orcl2204 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.220.4) (PORT = 1521) (CONNECT_DATA = (SERVICE_NAME = orcl ))) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC0) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO ))) orcl = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.220.3) (PORT = 1521) (CONNECT_DATA = (SERVICE_NAME = orcl ))) orcl2204 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.220.4) (PORT = 1521) (CONNECT_DATA = (SERVICE_NAME = orcl ))) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC0) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO ))) slave Database: [oracle @ localhost admin] $ vi tnsnames. ora # tnsnames. ora Network Configuration File:/home/app/oracle10/product/10.2.0.1/network/admin/tnsnames. ora # Generated by Oracle configuration tools. ORCL = (DESCRIPTION = (ADDRESS_LIST = (AD DRESS = (PROTOCOL = TCP) (HOST = 192.168.220.3) (PORT = 1521) (CONNECT_DATA = (SERVICE_NAME = orcl ))) orcl2204 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.220.4) (PORT = 1521) (CONNECT_DATA = (SERVICE_NAME = orcl ))) # pfile ##################################### ########### parameter explanation: this buffer is in 512 bytes and can be set in the async parameter. For example, async = 20480 indicates that the buffer is 10 MB. Master Database:/home/app/oracle10/product/10.2.0.1/dbs/initorcl. ora [oracle @ localhost dbs] $ cat initorcl. oraorcl. _ db_cache_size = 92274688orcl. _ java_pool_size = 4192134orcl. _ large_pool_size = 4192134orcl. _ shared_pool_size = 62914560orcl. _ streams_pool_size = 0 *. audit_file_dest = '/home/app/oracle10/admin/ice/adump '*. background_dump_dest = '/home/app/oracle10/admin/ice/bdump '*. compatible = '10. 2.0.1.0 '*. control_files = '/home/app/oracle10/oradata/ice/control01.ctl', '/home/app/oracle10/oradata/ice/control02.ctl ', '/home/app/oracle10/oradata/ice/control03.ctl '*. core_dump_dest = '/home/app/oracle10/admin/ice/cdump '*. db_block_size = 8192 *. db_domain = 'orcl '*. db_file_multiblock_read_count = 16 *. db_name = 'ice '*. db_recovery_file_dest = '/home/app/oracle10/flash_recovery_area '*. db_recovery_file_dest_size = 2147483648 *. dispatchers = '(PROTOCOL = TCP) (SERVICE = orclXDB )'*. job_queue_processes = 10 *. open_cursors = 300 *. pga_aggregate_target = 16777216 *. processes = 150 *. remote_login_passwordfile = 'clusive '*. sga_target = 167772160 *. undo_management = 'auto '*. undo_tablespace = 'undotbs1 '*. user_dump_dest = '/home/app/oracle10/admin/ice/udump '*. LOG_ARCHIVE_CONFIG = 'dg _ CONFIG = (orcl, orcl2204) 'log _ archive_dest_1 = 'location =/home/app/oracle10/archive01 VALID_FOR = (ALL_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME = orcl 'Log _ archive_dest_state_1 = enablelog_archive_dest_2 = 'service = orcl2204 lgwr async = 40960 VALID_FOR = (ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME = orcl2204 'Log _ archive_dest_state_2 = enablelog_archive_start = truelog_archive_format = '% t _ % s _ % r. arc 'Log _ archive_max_processes = 2fal_server = orcl2204fal_client = orcldb_unique_name = orcl [oracle @ localhost dbs] $ standby database: [oracle @ localhost admin] $ cd/home/app/oracle10/product/10.2.0.1/dbs [oracle @ localhost dbs] $ cat initorcl. ora orcl. _ db_cache_size = 92274688orcl. _ java_pool_size = 4192134orcl. _ large_pool_size = 4192134orcl. _ shared_pool_size = 62914560orcl. _ streams_pool_size = 0 *. audit_file_dest = '/home/app/oracle10/admin/ice/adump '*. background_dump_dest = '/home/app/oracle10/admin/ice/bdump '*. compatible = '10. 2.0.1.0 '*. control_files = '/home/app/oracle10/oradata/ice/control01.ctl', '/home/app/oracle10/oradata/ice/control02.ctl ', '/home/app/oracle10/oradata/ice/control03.ctl '*. core_dump_dest = '/home/app/oracle10/admin/ice/cdump '*. db_block_size = 8192 *. db_domain = 'orcl '*. db_file_multiblock_read_count = 16 *. db_name = 'ice '*. db_recovery_file_dest = '/home/app/oracle10/flash_recovery_area '*. db_recovery_file_dest_size = 2147483648 *. dispatchers = '(PROTOCOL = TCP) (SERVICE = orclXDB )'*. job_queue_processes = 10 *. open_cursors = 300 *. pga_aggregate_target = 16777216 *. processes = 150 *. remote_login_passwordfile = 'clusive '*. sga_target = 167772160 *. undo_management = 'auto '*. undo_tablespace = 'undotbs1 '*. user_dump_dest = '/home/app/oracle10/admin/ice/udump '*. LOG_ARCHIVE_CONFIG = 'dg _ CONFIG = (orcl, orcl2204) 'log _ archive_dest_1 = 'location =/home/app/oracle10/archive VALID_FOR = (ALL_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME = orcl2204 'Log _ archive_dest_state_1 = enablelog_archive_dest_2 = 'service = orcl2204 lgwr async VALID_FOR = (ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME = ORCL 'Log _ archive_dest_state_2 = enablelog_archive_start = truelog_archive_format = '% t _ % s _ % r. arc 'Log _ archive_max_processes = 2fal_server = orclfal_client = orcl2204db_unique_name = orcl2204 [oracle @ localhost dbs] $