rac-single data guard

注意:*.db_unique_name=''SYK'' 不要改变db_unique_name的值,在参数文件里加上它(show parameter db_unique_name看到的),
但是值不要改变
create spfile='' ASM_RECOVER/syk/spfilesyk.ora'' from pfile=''/home/oracle/pfilesyk.ora'';

也可以直接修改spfile,如下：

ALTER SYSTEM SET DB_UNIQUE_NAME=syk scope=spfile;
alter system set service_names=''syk_rac''
alter system set log_archive_config=''dg_config=(syk,syk_single)'' scope=both;
alter system set LOG_ARCHIVE_DEST_STATE_1=''ENABLE''
alter system set LOG_ARCHIVE_DEST_STATE_2=''ENABLE''
alter system set log_archive_dest_1=''LOCATION=/home/oracle/archive/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES)'' DB_UNIQUE_NAME=''syk''
alter system set log_archive_dest_2=''service=syk_single valid_for=(online_logfiles,primary_role) db_unique_name=syk_single''
alter system set db_file_name_convert=''/oradata/syk'','' ASM_DATA/syk/datafile'',''/oradata/syk'','' ASM_DATA/syk/tempfile''
alter system set log_file_name_convert=''/oradata/syk'','' ASM_DATA/syk/onlinelog'',''/oradata/syk'','' ASM_RECOVER/syk/onlinelog''
alter system set standby_file_management=auto
alter system set fal_server=''syk_single''
alter system set syk1.fal_client=''syk1''
alter system set syk2.fal_client=''syk2''
alter system set STANDBY_ARCHIVE_DEST=''/home/oracle/archive/''

根据上面修改standby库的参数(在standby上操作)
single上参数如下：
syk.__db_cache_size=134217728
syk.__java_pool_size=4194304
syk.__large_pool_size=4194304
syk.__shared_pool_size=67108864
syk.__streams_pool_size=0
*.audit_file_dest=''/u01/app/oracle/admin/syk/adump''
*.background_dump_dest=''/u01/app/oracle/admin/syk/bdump''
*.compatible=''10.2.0.1.0''
*.control_files=''/oradata/syk/control01.ctl'',''/oradata/syk/control02.ctl'',''/oradata/syk/control03.ctl''#Restore
Controlfile
*.core_dump_dest=''/u01/app/oracle/admin/syk/cdump''
*.db_block_size=8192
*.db_domain=''''
*.db_file_multiblock_read_count=16
*.db_file_name_convert='' ASM_DATA/syk/datafile'',''/oradata/syk'','' ASM_DATA/syk/tempfile'',''/oradata/syk''
*.db_name=''syk''
*.db_unique_name=''syk_single''
*.dispatchers=''(PROTOCOL=TCP) (SERVICE=sykXDB)''
*.fal_client=''syk_single''
*.fal_server=''syk1'',''syk2''
*.job_queue_processes=10
*.log_archive_config=''dg_config=(syk,syk_single)''
*.log_archive_dest_1=''location=/home/oracle/archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=syk_single''
*.log_archive_dest_2=''service=syk1 LGWR valid_for=(online_logfiles,primary_role) db_unique_name=syk''
*.log_checkpoints_to_alert=TRUE
*.log_file_name_convert='' ASM_DATA/syk/onlinelog'',''/oradata/syk'','' ASM_RECOVER/syk/onlinelog'',''/oradata/syk''
*.open_cursors=300
*.pga_aggregate_target=71303168
*.processes=300
*.remote_login_passwordfile=''exclusive''
*.service_names=''syk_single''
*.sessions=335
*.sga_target=216006656
*.standby_archive_dest=''/home/oracle/archive''
*.standby_file_management=''auto''
*.thread=1
*.undo_management=''AUTO''
*.undo_tables

凌众科技专业提供服务器租用、服务器托管、企业邮局、虚拟主机等服务，公司网站：http://www.lingzhong.cn 为了给广大客户了解更多的技术信息，本技术文章收集来源于网络,凌众科技尊重文章作者的版权，如果有涉及你的版权有必要删除你的文章，请和我们联系。以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息，谢谢!