dg磁盘组名不对应,配置信息
需要注意convert转换,设置convert需要写入到spfile
备库pfile参考,需要将备库的磁盘名手动进行修改替换
orcl.__db_cache_size=4362076160
orcl.__java_pool_size=469762048
orcl.__large_pool_size=536870912
orcl.__oracle_base='/u01/oracle'#ORACLE_BASE set from environment
orcl.__pga_aggregate_target=4227858432
orcl.__sga_target=8589934592
orcl.__shared_io_pool_size=0
orcl.__shared_pool_size=3087007744
orcl.__streams_pool_size=0
*._cleanup_rollback_entries=10000
*._clusterwide_global_transactions=FALSE
*._cursor_obsolete_threshold=100
*._optim_peek_user_binds=FALSE
*._optimizer_adaptive_cursor_sharing=FALSE
*._optimizer_extended_cursor_sharing_rel='NONE'
*._optimizer_extended_cursor_sharing='NONE'
*._optimizer_use_feedback=FALSE
*._PX_use_large_pool=TRUE
*._rollback_segment_count=500
*._undo_autotune=FALSE
*.archive_lag_target=1800
*.audit_file_dest='/u01/oracle/admin/orcladg/adump'
*.audit_trail='NONE'
*.compatible='11.2.0.4.0'
*.control_file_record_keep_time=39
*.control_files='+ORCLBKLV_DATA/orcladg/controlfile/current.261.1147460957','+ORCLBKLV_DATA/orcl/controlfile/current.260.1147460957'
*.db_block_checking='MEDIUM'
*.db_block_checksum='FULL'
*.db_block_size=8192
*.db_create_file_dest='+ORCLBKLV_DATA'
*.db_domain=''
*.db_file_name_convert='+DATA','+ORCLBKLV_DATA'
*.db_files=1024
*.db_lost_write_protect='TYPICAL'
*.db_name='orcl'
*.db_recovery_file_dest='+ORCLBKLV_DATA'
*.db_recovery_file_dest_size=107374182400
*.db_writer_processes=8
*.deferred_segment_creation=FALSE
*.diagnostic_dest='/u01/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.enable_ddl_logging=TRUE
*.fal_client='orclADG'
*.fal_server='orcl'
*.log_archive_config='DG_CONFIG=(orcladg, orcl)'
*.log_archive_dest_1='LOCATION=+ORCLBKLV_DATA VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcladg'
*.log_archive_dest_2='SERVICE=orcl LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_file_name_convert='+DATA','+ORCLBKLV_DATA'
*.max_dump_file_size='102400000'
*.open_cursors=300
*.parallel_degree_policy='MANUAL'
*.parallel_force_local=TRUE
*.parallel_max_servers=128
*.pga_aggregate_target=4204789760
*.processes=8000
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_max_size=26843545600
*.sga_target=8589934592
*.standby_file_management='AUTO'
*.undo_retention=43200
*.undo_tablespace='UNDOTBS1'
*.db_unique_name=orcladg
主库pfile参考
orcl.__db_cache_size=4362076160
orcl.__java_pool_size=469762048
orcl.__large_pool_size=536870912
orcl.__oracle_base='/u01/oracle'#ORACLE_BASE set from environment
orcl.__pga_aggregate_target=4227858432
orcl.__sga_target=8589934592
orcl.__shared_io_pool_size=0
orcl.__shared_pool_size=3087007744
orcl.__streams_pool_size=0
*._cleanup_rollback_entries=10000
*._clusterwide_global_transactions=FALSE
*._cursor_obsolete_threshold=100
*._optim_peek_user_binds=FALSE
*._optimizer_adaptive_cursor_sharing=FALSE
*._optimizer_extended_cursor_sharing_rel='NONE'
*._optimizer_extended_cursor_sharing='NONE'
*._optimizer_use_feedback=FALSE
*._PX_use_large_pool=TRUE
*._rollback_segment_count=500
*._undo_autotune=FALSE
*.archive_lag_target=1800
*.audit_file_dest='/u01/oracle/admin/orcl/adump'
*.audit_trail='NONE'
*.compatible='11.2.0.4.0'
*.control_file_record_keep_time=39
*.control_files='+DATA/orcl/controlfile/current.261.1147460957','+DATA/orcl/controlfile/current.260.1147460957'
*.db_block_checking='MEDIUM'
*.db_block_checksum='FULL'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_file_name_convert='+DATA','+ORCLBKLV_DATA'
*.db_files=1024
*.db_lost_write_protect='TYPICAL'
*.db_name='orcl'
*.db_recovery_file_dest='+DATA'
*.db_recovery_file_dest_size=107374182400
*.db_writer_processes=8
*.deferred_segment_creation=FALSE
*.diagnostic_dest='/u01/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.enable_ddl_logging=TRUE
*.fal_client='orcl'
*.fal_server='orclADG'
*.log_archive_config='DG_CONFIG=(orcl, orcladg)'
*.log_archive_dest_1='LOCATION=+DATA VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl'
*.log_archive_dest_2='SERVICE=orcladg LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcladg'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_file_name_convert='+DATA','+ORCLBKLV_DATA'
*.max_dump_file_size='102400000'
*.open_cursors=300
*.parallel_degree_policy='MANUAL'
*.parallel_force_local=TRUE
*.parallel_max_servers=128
*.pga_aggregate_target=4204789760
*.processes=8000
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_max_size=26843545600
*.sga_target=8589934592
*.standby_file_management='AUTO'
*.undo_retention=43200
*.undo_tablespace='UNDOTBS1'