oracle1537,dataguard 出现ORA-16136错误

先看备库的

$ cat /oracle/product/10.2.0/db_1/dbs/inithis1.ora

his2.__db_cache_size=637534208

his1.__db_cache_size=1157627904

his2.__java_pool_size=16777216

his1.__java_pool_size=16777216

his2.__large_pool_size=16777216

his1.__large_pool_size=16777216

his2.__shared_pool_size=989855744

his1.__shared_pool_size=469762048

his2.__streams_pool_size=0

his1.__streams_pool_size=0

*.audit_file_dest='/oracle/product/10.2.0/admin/his/adump'

*.background_dump_dest='/oracle/product/10.2.0/admin/his/bdump'

*.cluster_database_instances=2

*.cluster_database=TRUE

*.compatible='10.2.0.3.0'

*.control_files='/dev/racc_ctl1_512M','/dev/racc_ctl2_512M'#Restore Controlfile

*.core_dump_dest='/oracle/product/10.2.0/admin/his/cdump'

*.db_block_size=8192

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_name='acc'

*.db_recovery_file_dest_size=3221225472

*.db_unique_name='his'

*.FAL_CLIENT='his'

*.FAL_SERVER='acc'

his1.instance_number=1

his2.instance_number=2

*.job_queue_processes=10

his1.local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 10.188.1.13) (PORT = 1521))'

his2.local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 10.188.1.14) (PORT = 1521))'

*.log_archive_config='dg_config= (acc,his)'

his1.LOG_ARCHIVE_DEST_1='location=/arch1 valid_for=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=his'

his2.LOG_ARCHIVE_DEST_1='location=/arch2 valid_for=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=his'

*.LOG_ARCHIVE_DEST_2='SERVICE=acc LGWR ASYNC valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=acc'

*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'

*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'

*.log_archive_format='%t_%s_%r.arc'

*.open_cursors=300

*.pga_aggregate_target=2097152000

*.processes=800

*.remote_listener='LISTENERS_his'

*.REMOTE_LOGIN_PASSWORDFILE='EXCLUSIVE'

*.sessions=885

*.sga_target=1677721600

*.STANDBY_FILE_MANAGEMENT='AUTO'

his2.thread=2

his1.thread=1

*.undo_management='AUTO'

*.undo_tablespace='UNDOTBS1'

his1.undo_tablespace='UNDOTBS1'

his2.undo_tablespace='UNDOTBS2'

*.user_dump_dest='/oracle/product/10.2.0/admin/his/udump'

再看主库的

$ cat /oracle/product/10.2.0/db_1/dbs/initacc1.ora

acc1.__db_cache_size=1241513984

acc2.__db_cache_size=637534208

acc1.__java_pool_size=16777216

acc2.__java_pool_size=16777216

acc1.__large_pool_size=16777216

acc2.__large_pool_size=16777216

acc1.__shared_pool_size=385875968

acc2.__shared_pool_size=989855744

acc1.__streams_pool_size=0

acc2.__streams_pool_size=0

*.audit_file_dest='/oracle/product/10.2.0/admin/acc/adump'

*.background_dump_dest='/oracle/product/10.2.0/admin/acc/bdump'

*.cluster_database_instances=2

*.cluster_database=true

*.compatible='10.2.0.3.0'

*.control_files='/dev/racc_ctl1_512M','/dev/racc_ctl2_512M'

*.core_dump_dest='/oracle/product/10.2.0/admin/acc/cdump'

*.db_block_size=8192

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_name='acc'

*.db_recovery_file_dest_size=3221225472

*.fal_client='acc'

*.fal_server='his'

acc1.instance_number=1

acc2.instance_number=2

*.job_queue_processes=10

acc1.local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 10.188.1.8) (PORT = 1521))'

acc2.local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 10.188.1.9) (PORT = 1521))'

*.log_archive_config='dg_config=(acc,his)'

acc1.log_archive_dest_1='location=/arch1'

acc2.log_archive_dest_1='location=/arch2'

*.log_archive_dest_1='location=/arch2 valid_for=(all_logfiles,all_roles) db_unique_name=acc'

*.log_archive_dest_2='service=his valid_for=(online_logfile,primary_role) db_unique_name=his'

*.log_archive_format='%t_%s_%r.arc'

*.open_cursors=300

*.pga_aggregate_target=2097152000

*.processes=800

*.remote_listener='LISTENERS_ACC'

*.remote_login_passwordfile='exclusive'

*.sessions=885

*.sga_target=1677721600

*.standby_file_management='AUTO'

acc2.thread=2

acc1.thread=1

*.undo_management='AUTO'

*.undo_tablespace='UNDOTBS1'

acc1.undo_tablespace='UNDOTBS1'

acc2.undo_tablespace='UNDOTBS2'

*.user_dump_dest='/oracle/product/10.2.0/admin/acc/udump'