ORA-16535:CRS is preventing execution of a broker operation

另外在说一点，我的alert_log没有任何错误是不是我缺少什么组件没有安装呢？比如RAC+DATAGUARD BROKER是不是需要安装companion CD呢？
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
Wed Oct 14 05:31:20 2009
Successfully onlined Undo Tablespace 1.
Wed Oct 14 05:31:20 2009
SMON: enabling tx recovery
Wed Oct 14 05:31:20 2009
LNS: Standby redo logfile selected for thread 1 sequence 51 for destination LOG_ARCHIVE_DEST_2
Wed Oct 14 05:31:20 2009
Database Characterset is UTF8
Wed Oct 14 05:31:20 2009
Instance recovery: looking for dead threads
Instance recovery: lock domain invalid but no dead threads
Wed Oct 14 05:31:21 2009
replication_dependency_tracking turned off (no async multimaster replication found)
Wed Oct 14 05:31:21 2009
ARC1: Standby redo logfile selected for thread 1 sequence 50 for destination LOG_ARCHIVE_DEST_2
Wed Oct 14 05:31:22 2009
Starting background process QMNC
QMNC started with pid=36, OS id=31861
Wed Oct 14 05:31:23 2009
ALTER SYSTEM SET log_archive_dest_2='service="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=rac4)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ustb_XPT)(INSTANCE_NAME=devdb2)(SERVER=dedicated)))"','   LGWR ASYNC NOAFFIRM delay=0 OPTIONAL max_failure=0 max_connections=1   reopen=300 db_unique_name="ustb" register net_timeout=180  valid_for=(online_logfile,primary_role)' SCOPE=BOTH;
Wed Oct 14 05:31:23 2009
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH;
Wed Oct 14 05:31:23 2009
ALTER DATABASE OPEN
Wed Oct 14 05:31:23 2009
ORA-1531 signalled during: ALTER DATABASE OPEN...
Wed Oct 14 05:31:24 2009
Completed: ALTER DATABASE OPEN
Wed Oct 14 05:31:38 2009
ALTER SYSTEM SET log_archive_trace=0 SCOPE=BOTH SID='devdb1';
Wed Oct 14 05:31:38 2009
ALTER SYSTEM SET log_archive_format='%t_%s_%r.dbf' SCOPE=SPFILE SID='devdb1';
Wed Oct 14 05:31:38 2009
ALTER SYSTEM SET standby_archive_dest='' SCOPE=BOTH SID='devdb1';
Wed Oct 14 05:31:38 2009
ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH SID='*';
Wed Oct 14 05:31:38 2009
ALTER SYSTEM SET archive_lag_target=0 SCOPE=BOTH SID='*';
Wed Oct 14 05:31:38 2009
ALTER SYSTEM SET log_archive_max_processes=2 SCOPE=BOTH SID='*';
Wed Oct 14 05:31:39 2009
ALTER SYSTEM SET log_archive_min_succeed_dest=1 SCOPE=BOTH SID='*';
LNS1 started with pid=31, OS id=32348
Wed Oct 14 05:31:46 2009
Thread 1 advanced to log sequence 52
  Current log# 1 seq# 52 mem# 0: +DG1/devdb/onlinelog/group_1.298.700181587
Wed Oct 14 05:31:46 2009
ALTER SYSTEM SET log_archive_dest_2='service="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=rac4)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ustb_XPT)(INSTANCE_NAME=devdb2)(SERVER=dedicated)))"','   LGWR ASYNC NOAFFIRM delay=0 OPTIONAL max_failure=0 max_connections=1   reopen=300 db_unique_name="ustb" register net_timeout=180  valid_for=(online_logfile,primary_role)' SCOPE=BOTH;
Wed Oct 14 05:31:46 2009
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH;
Wed Oct 14 05:31:46 2009
ARC1: Standby redo logfile selected for thread 1 sequence 51 for destination LOG_ARCHIVE_DEST_2
Wed Oct 14 05:31:46 2009
Thread 1 cannot allocate new log, sequence 53
Checkpoint not complete
  Current log# 1 seq# 52 mem# 0: +DG1/devdb/onlinelog/group_1.298.700181587
Wed Oct 14 05:31:47 2009
LNS: Standby redo logfile selected for thread 1 sequence 52 for destination LOG_ARCHIVE_DEST_2
Wed Oct 14 05:31:49 2009
Thread 1 advanced to log sequence 53
  Current log# 2 seq# 53 mem# 0: +DG1/devdb/onlinelog/group_2.297.700181591
Wed Oct 14 05:31:50 2009
LNS: Standby redo logfile selected for thread 1 sequence 53 for destination LOG_ARCHIVE_DEST_2
LNS1 started with pid=31, OS id=4259
Wed Oct 14 05:34:43 2009
Thread 1 advanced to log sequence 54
  Current log# 1 seq# 54 mem# 0: +DG1/devdb/onlinelog/group_1.298.700181587
Wed Oct 14 05:34:44 2009
LNS: Standby redo logfile selected for thread 1 sequence 54 for destination LOG_ARCHIVE_DEST_2
Wed Oct 14 05:35:09 2009
ARC1: Standby redo logfile selected for thread 1 sequence 53 for destination LOG_ARCHIVE_DEST_2
Wed Oct 14 05:35:25 2009
ALTER SYSTEM SET service_names='DEVDB','UPRI' SCOPE=MEMORY SID='devdb1';
Wed Oct 14 05:35:27 2009
Reconfiguration started (old inc 2, new inc 4)
List of nodes:
0 1
Global Resource Directory frozen
Communication channels reestablished
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
Wed Oct 14 05:35:29 2009
LMS 0: 0 GCS shadows cancelled, 0 closed
Wed Oct 14 05:35:29 2009
LMS 1: 0 GCS shadows cancelled, 0 closed
Set master node info
Submitted all remote-enqueue requests
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Wed Oct 14 05:35:29 2009
LMS 0: 1181 GCS shadows traversed, 661 replayed
Wed Oct 14 05:35:29 2009
LMS 1: 1244 GCS shadows traversed, 769 replayed
Wed Oct 14 05:35:29 2009
Submitted all GCS remote-cache requests
Post SMON to start 1st pass IR
Fix write in gcs resources
Reconfiguration complete
Wed Oct 14 05:36:03 2009
ALTER SYSTEM SET log_archive_dest_2='service="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=rac4)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ustb_XPT)(INSTANCE_NAME=devdb2)(SERVER=dedicated)))"','   LGWR ASYNC NOAFFIRM delay=0 OPTIONAL max_failure=0 max_connections=1   reopen=300 db_unique_name="ustb" register net_timeout=180  valid_for=(online_logfile,primary_role)' SCOPE=BOTH;
Wed Oct 14 05:36:03 2009
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH;
Wed Oct 14 05:36:03 2009
ALTER SYSTEM SET log_archive_trace=0 SCOPE=BOTH SID='devdb1';
Wed Oct 14 05:36:04 2009
ALTER SYSTEM SET log_archive_format='%t_%s_%r.dbf' SCOPE=SPFILE SID='devdb1';
Wed Oct 14 05:36:04 2009
ALTER SYSTEM SET standby_archive_dest='' SCOPE=BOTH SID='devdb1';
Wed Oct 14 05:36:14 2009
Thread 1 cannot allocate new log, sequence 55
Checkpoint not complete
  Current log# 1 seq# 54 mem# 0: +DG1/devdb/onlinelog/group_1.298.700181587
LNS1 started with pid=31, OS id=6640
Wed Oct 14 05:36:20 2009
Thread 1 advanced to log sequence 55
  Current log# 2 seq# 55 mem# 0: +DG1/devdb/onlinelog/group_2.297.700181591
Wed Oct 14 05:36:21 2009
LNS: Standby redo logfile selected for thread 1 sequence 55 for destination LOG_ARCHIVE_DEST_2
Wed Oct 14 05:36:24 2009
Shutting down archive processes
ARCH shutting down
ARC2: Archival stopped
Wed Oct 14 05:36:29 2009
Thread 1 cannot allocate new log, sequence 56
Checkpoint not complete
  Current log# 2 seq# 55 mem# 0: +DG1/devdb/onlinelog/group_2.297.700181591
Wed Oct 14 05:36:30 2009
ARC1: Standby redo logfile selected for thread 1 sequence 54 for destination LOG_ARCHIVE_DEST_2
Wed Oct 14 05:36:36 2009
Thread 1 advanced to log sequence 56
  Current log# 1 seq# 56 mem# 0: +DG1/devdb/onlinelog/group_1.298.700181587
Wed Oct 14 05:36:37 2009
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
LNS: Standby redo logfile selected for thread 1 sequence 56 for destination LOG_ARCHIVE_DEST_2
下面是pfile信息：devdb1.__db_cache_size=411041792
devdb2.__db_cache_size=419430400
devdb1.__java_pool_size=4194304
devdb2.__java_pool_size=4194304
devdb1.__large_pool_size=4194304
devdb2.__large_pool_size=4194304
devdb1.__shared_pool_size=180355072
devdb2.__shared_pool_size=171966464
devdb1.__streams_pool_size=0
devdb2.__streams_pool_size=0
*.audit_file_dest='/opt/admin/devdb/adump'
*.background_dump_dest='/opt/admin/devdb/bdump'
*.cluster_database_instances=2
*.cluster_database=true
*.compatible='10.2.0.1.0'
*.control_files='+DG1/devdb/controlfile/current.299.700181581'
*.core_dump_dest='/opt/admin/devdb/cdump'
*.db_block_size=8192
*.db_create_file_dest='+DG1'
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='devdb'
*.db_unique_name='UPRI'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=devdbXDB)'
*.fal_client='DEVDB'
*.fal_server='STBDB'
devdb2.instance_number=2
devdb1.instance_number=1
*.job_queue_processes=10
*.log_archive_config='dg_config=(upri,ustb)'
*.log_archive_dest_1='location=+DG1/devdb valid_for=(all_logfiles,all_roles) db_unique_name=upri'
*.log_archive_dest_2='service=stbdb lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=ustb'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=201326592
*.processes=150
*.remote_listener='LISTENERS_DEVDB'
*.remote_login_passwordfile='exclusive'
*.service_names='DEVDB'
*.sga_target=605028352
*.standby_file_management='AUTO'
devdb2.thread=2
devdb1.thread=1
*.undo_management='AUTO'
devdb2.undo_tablespace='UNDOTBS2'
devdb1.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/opt/admin/devdb/udump'

调试易

ORA-16535:CRS is preventing execution of a broker operation

解决方案 »