log_archive_config='dg_config=(primary,standby)'
log_archive_dest_1='location=/u01/data/primary/arc'
log_archive_dest_2='service=standby async valid_for=(all_logfiles,all_roles) db_unique_name=STANDBY'
log_archive_dest_state_1='enable'
log_archive_dest_state_2='enable'
log_archive_format='%t_%s_%r.arc'
log_archive_max_processes=10
log_file_name_convert='/u01/data/primary/arc','/u01/data/primary/arc'
fal_client='PRIMARY'
fal_server='STANDBY'
standby_file_management='auto'
remote_login_passwordfile='exclusive'
这里要注意：
log_archive_dest_2这个参数中db_unique_name的值为备库的db_unique_name，最好完全与备库一致，包括大小写
log_file_name_convert的值中，第一个值为主库的归档日志目录，第二个为备库的归档日志目录
[oracle@localhost dbs]$ cat initPRIMARY.ora
PRIMARY.__db_cache_size=1191182336
PRIMARY.__java_pool_size=16777216
PRIMARY.__large_pool_size=16777216
PRIMARY.__oracle_base='/u01/app'#ORACLE_BASE set from environment
PRIMARY.__pga_aggregate_target=1677721600
PRIMARY.__sga_target=1610612736
PRIMARY.__shared_io_pool_size=0
PRIMARY.__shared_pool_size=369098752
PRIMARY.__streams_pool_size=0
*.compatible='11.2.0'
*.control_files='/u01/data/primary/primary/control01.ctl','/u01/data/primary/primary/control02.ctl'
*.core_dump_dest='/u01/app/oracle/admin/primary/cdump'
*.db_block_size=8192
*.db_name='PRIMARY'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=53687091200
*.db_unique_name='PRIMARY'
*.fal_client='PRIMARY'
*.log_archive_config='dg_config=(primary,standby)'
*.log_archive_dest_1='location=/u01/data/primary/arc'
*.log_archive_dest_2='service=standby async valid_for=(all_logfiles,all_roles) db_unique_name=STANDBY'
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='enable'
*.log_archive_format='%t_%s_%r.arc'
*.log_archive_max_processes=10
*.log_file_name_convert='/u01/data/primary/arc','/u01/data/primary/arc'
*.nls_date_format='YYYY-MM-DD hh24:mi:ss'
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=300
*.pga_aggregate_target=1669332992
*.processes=1000
*.remote_login_passwordfile='exclusive'
*.sessions=1105
*.sga_target=1610612736
*.standby_file_management='auto'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS01'
复制代码
5、主库创建pfile和passwordfile后，拷贝到备库的相同路径下
注意，使用orapwd创建口令文件时，一定要使用ignorecase选项。否则启动备库后，可能会在alert文件中提示ORA-16191错误。这个问题有可能是Oracle 11g中的一个bug，我被他困扰折磨了老半天...
[oracle@localhost data]$ cd $ORACLE_HOME/dbs
[oracle@localhost dbs]$ orapwd file=orapwPRIMARY password=sys force=y ignorecase=y
[oracle@localhost dbs]$ ls
hc_PRIMARY.dat init.ora lkPRAMARY lkTDB1 orapwPRIMARY orapwtdb1 spfiletdb1.ora
hc_tdb1.dat initPRIMARY.ora lkPRIMARY lkTEST orapwPRIMARY.bak spfilePRIMARY.ora
[oracle@localhost dbs]$ scp -r orapwPRIMARY initPRIMARY.ora 172.26.29.4:/u01/app/oracle/product/11.2.0/db_1/dbs
oracle@172.26.29.4's password:
orapwPRIMARY 100% 1536 1.5KB/s 00:00
initPRIMARY.ora