Monday, May 9, 2016

Create PFILE of DataGuard (Standby Server)

For DataGuard, pfile creation is a important step, following are a standby server pfile example:

Primary Server: testbk
Standby Server: dcstdb

*.audit_file_dest='/u02/app/oracle/admin/dcstdb/adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='+REDO/dcstdb/controlfile/current.256.910371717','+CONTROL/dcstdb/controlfile/current.256.910371719'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_create_online_log_dest_1='+REDO'
*.db_create_online_log_dest_2='+CONTROL'
*.db_domain='nblitd.com'
*.db_file_name_convert='TESTBK','DCSTDB'
*.db_name='testbk'
*.db_recovery_file_dest='+FRA'
*.db_recovery_file_dest_size=85899345920
*.db_unique_name='dcstdb'
*.diagnostic_dest='/u02/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=dcpdbXDB)'
*.fal_client='DCSTDB'
*.fal_server='TESTBK'
*.filesystemio_options='SETALL'
testbk1.instance_number=1
*.log_archive_config='DG_CONFIG=(testbk,dcstdb)'
*.log_archive_dest_1='SERVICE=testbk NOAFFIRM ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=testbk'
*.log_archive_dest_2='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=dcstdb'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s_%r.arc'
*.log_archive_max_processes=10
*.log_file_name_convert='TESTBK','DCSTDB'
*.memory_target=8589934592
*.open_cursors=5000
*.processes=5000
*.remote_login_passwordfile='exclusive'
*.session_cached_cursors=5000
*.sessions=7524
*.standby_file_management='AUTO'
testbk1.thread=1
testbk1.undo_tablespace='UNDOTBS1'

No comments:

Post a Comment