11gR2 DataGuard参数文件(pfile/spfile)设置模板
来源:互联网 发布:李选民淘宝上卖的真吗 编辑:程序博客网 时间:2024/05/01 13:06
主机:
orcl.__db_cache_size=771751936
orcl.__java_pool_size=16777216
orcl.__large_pool_size=16777216
orcl.__oracle_base='/u01/app/oracle'
orcl.__pga_aggregate_target=1308622848
orcl.__sga_target=2046820352
orcl.__shared_io_pool_size=0
orcl.__shared_pool_size=1224736768
orcl.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/orcl/control01.ctl'
*.db_block_size=8192
*.db_name='orcl'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=4039114752
*.db_unique_name='orcl'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.fal_client='orcl'
*.fal_server='orcl_sd'
*.local_listener='LISTENER_ORCL'
*.log_archive_config='dg_config=(orcl,orcl_sd)'
*.log_archive_dest_1='location=/archivelog valid_for=(all_logfiles,all_roles) db_unique_name=orcl'
*.log_archive_dest_2='service=orcl_sd valid_for=(online_logfiles,primary_role) db_unique_name=orcl_sd'
*.memory_target=3349151744
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.standby_file_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.db_file_name_convert='/u01/app/oracle/oradata/orcl_sd/','/u01/app/oracle/oradata/orcl/'
*.log_file_name_convert='/u01/app/oracle/oradata/orcl_sd/','/u01/app/oracle/oradata/orcl/'
备机:
orcl.__db_cache_size=1476395008
orcl.__java_pool_size=16777216
orcl.__large_pool_size=16777216
orcl.__oracle_base='/u01/app/oracle'
orcl.__pga_aggregate_target=1342177280
orcl.__sga_target=2013265920
orcl.__shared_io_pool_size=0
orcl.__shared_pool_size=486539264
orcl.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/orcl_sd/control01.ctl'
*.db_block_size=8192
*.db_name='orcl'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=4039114752
*.db_unique_name='orcl_sd'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.fal_client='orcl_sd'
*.fal_server='orcl'
*.local_listener='LISTENER_ORCL'
*.log_archive_config='dg_config=(orcl,orcl_sd)'
*.log_archive_dest_1='location=/archivelog valid_for=(all_logfiles,all_roles) db_unique_name=orcl_sd'
*.log_archive_dest_2='service=orcl valid_for=(online_logfiles,primary_role) db_unique_name=orcl'
*.memory_target=3349151744
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.standby_file_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.db_file_name_convert='/u01/app/oracle/oradata/orcl/','/u01/app/oracle/oradata/orcl_sd/'
*.log_file_name_convert='/u01/app/oracle/oradata/orcl/','/u01/app/oracle/oradata/orcl_sd/'
- 11gR2 DataGuard参数文件(pfile/spfile)设置模板
- 参数化文件:pfile,spfile
- ORALE参数文件(spfile/pfile)
- Oracle 的参数文件pfile与spfile
- oracle的参数文件 pfile和spfile
- Oracle pfile/spfile参数文件详解
- oracle的参数文件 pfile和spfile
- 创建参数文件spfile.ora pfile.ora
- oracle 参数文件 pfile/spfile ---详解
- Oracle 初始化参数文件pfile和spfile
- Oracle初始化参数文件spfile 和 pfile
- oracle的参数文件:pfile和spfile
- oracle的参数文件,服务器参数文件pfile,spfile
- Oracle 9i pfile/spfile 参数文件详解
- Oracle 9i/10g pfile/spfile 参数文件详解
- oracle参数文件的说明之pfile与spfile
- Oracle 9i pfile/spfile 参数文件详解
- 创建和管理Oracle初始化参数文件pfile、spfile
- C语言去除字符串首尾空格,trim()函数实现
- 通信基础
- 集算器协助MongoDB计算之交叉汇总
- Codeforces 614 A Link/Cut Tree
- 1040: [ZJOI2008]骑士 基环+内向树 DP
- 11gR2 DataGuard参数文件(pfile/spfile)设置模板
- 线程、互斥锁与条件变量实例理解
- Android自定义视图和属性
- 图片旋转,鼠标滚轮缩放,镜像,切换图片js代码
- 快速理解Docker - 容器级虚拟化解决方案
- 浅谈MVP架构及开发模式
- Poj 2251 Dungeon Master
- Linux 无法开机 显示 an error occurred during the file system
- Android酷炫实用的开源框架