配置 Oracle 10g 單例項物理dataguard和邏輯standby

rac的結構和單例項結構配置轉換方面可能就是邏輯standby在配置時需要注意CLUSTER_DATABASE這個引數，其他都是一樣的[@more@]

[oracle@yl254-20 ~]$ more pr.ora
prdb.__db_cache_size=100663296
prdb.__java_pool_size=4194304
prdb.__large_pool_size=4194304
prdb.__shared_pool_size=226492416
prdb.__streams_pool_size=0
*.audit_file_dest='/u01/app/admin/prdb/adump'
*.background_dump_dest='/u01/app/admin/prdb/bdump'
*.compatible='10.2.0.3.0'
*.control_files='/u02/oradata/prdb/control01.ctl'
*.core_dump_dest='/u01/app/admin/prdb/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='prdb'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=prdbXDB)'
*.fal_client='prdb'
*.fal_server='lstdb'
*.job_queue_processes=10
*.log_archive_dest_1='location=/u02/arch/prdb valid_for=(all_logfiles,all_roles) db_unique_name=prdb'
*.log_archive_dest_2='service=lstdb lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=prdb'
*.open_cursors=300
*.pga_aggregate_target=114294784
*.processes=1500
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=1655
*.sga_target=343932928
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/admin/prdb/udump'

[oracle@yl254-20 ~]$ more st.ora
lstdb.__db_cache_size=104857600
lstdb.__java_pool_size=4194304
lstdb.__large_pool_size=4194304
lstdb.__shared_pool_size=222298112
lstdb.__streams_pool_size=0
*.audit_file_dest='/u01/app/admin/lstdb/adump'
*.background_dump_dest='/u01/app/admin/lstdb/bdump'
*.compatible='10.2.0.3.0'
*.control_files='/u02/oradata/lstdb/control01.ctl'
*.core_dump_dest='/u01/app/admin/lstdb/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_file_name_convert='/u02/oradata/prdb','/u02/oradata/lstdb'
*.db_name='LSTDB'#db_name is auto changed when db converts to logical standby
*.db_name='prdb'
*.db_unique_name='lstdb'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=lstdbXDB)'
*.fal_client='lstdb'
*.fal_server='prdb'
*.job_queue_processes=10
*.log_archive_dest_1='location=/u02/arch/lstdb valid_for=(all_logfiles,all_roles) db_unique_name=lstdb'
*.log_archive_dest_2='service=prdb lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=lstdb'
*.log_archive_dest_state_2='ENABLE'
*.log_file_name_convert='/u02/oradata/prdb','/u02/oradata/lstdb'
*.open_cursors=300
*.pga_aggregate_target=114294784
*.processes=1500
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=1655
*.sga_target=343932928
*.standby_archive_dest='location=/u02/arch/lstdb'
*.standby_file_management='auto'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/admin/lstdb/udump'