在单机上创建物理的Oracle9i standby数据库

核心提示： 要注意这个控制文件的名字不要和Primary的控制文件名字重复2.4 为Standby数据库准备初始化参数文件名字：SQL> CREATE PFILE='C:\DataGuard\Pstandby\DEMO\initpstandby' FROM SPFILE;2.5

要注意这个控制文件的名字不要和Primary的控制文件名字重复

2.4 为Standby数据库准备初始化参数文件名字：

SQL> CREATE PFILE='C:\DataGuard\Pstandby\DEMO\initpstandby' FROM SPFILE;

2.5 设定初始化Physical Standby Database参数

*.aq_tm_processes=1

*.background_dump_dest='D:\oracle\admin\DEMO\bdump'

*.compatible='9.2.0.0.0'

*.control_files='C:\DataGuard\Pstandby\DEMO\DEMOSTANDBY.CTL'

*.core_dump_dest='D:\oracle\admin\DEMO\cdump'

*.db_block_size=8192

*.db_cache_size=19922944

*.db_domain=''

*.db_file_multiblock_read_count=32

*.db_name='DEMO'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=DEMOXDB)'

*.fast_start_mttr_target=300

*.hash_area_size=1048576

*.hash_join_enabled=TRUE

*.instance_name='pstandby'

*.java_pool_size=20971520

*.job_queue_processes=10

*.large_pool_size=7340032

*.log_archive_dest_1='location=d:\oracle\oradata\demo\archive'

*.log_archive_start=TRUE

*.open_cursors=300

*.optimizer_mode='FIRST_ROWS'

*.pga_aggregate_target=17825792

*.processes=150

*.query_rewrite_enabled='TRUE'

*.remote_login_passwordfile='EXCLUSIVE'

*.shared_pool_size=33554432

*.sort_area_size=1048576

*.star_transformation_enabled='TRUE'