dg磁盘组名不对应,配置信息
  4KpIwPC5bsv0 2023年11月02日 53 0

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'
【版权声明】本文内容来自摩杜云社区用户原创、第三方投稿、转载,内容版权归原作者所有。本网站的目的在于传递更多信息,不拥有版权,亦不承担相应法律责任。如果您发现本社区中有涉嫌抄袭的内容,欢迎发送邮件进行举报,并提供相关证据,一经查实,本社区将立刻删除涉嫌侵权内容,举报邮箱: cloudbbs@moduyun.com

上一篇: CommonUpload 下一篇: kali 安装redis
  1. 分享:
最后一次编辑于 2023年11月08日 0

暂无评论

推荐阅读
  xaeiTka4h8LY   2024年05月31日   39   0   0 Hivehadoop
  xaeiTka4h8LY   2024年05月17日   54   0   0 数据库JavaSQL
4KpIwPC5bsv0