嘗試邏輯恢複ocr裝置,導致了ocr狀態不一致的問題。
在RAC的其中一個節點上執行下面的操作:
bash-2.03# /data/oracle/product/10.2/crs/bin/ocrconfig -export /export/home/oracle/ocr.log
bash-2.03# /data/oracle/product/10.2/crs/bin/ocrconfig -import /export/home/oracle/ocr.log
PROT-19: Cannot proceed while clusterware is running. Shutdown clusterware first
bash-2.03# /etc/init.d/init.crs stop
Shutting down Oracle Cluster Ready Services (CRS):
Nov 21 23:47:25.966 | INF | daemon shutting down
Stopping resources. This could take several minutes.
Successfully stopped CRS resources.
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
Shutdown has begun. The daemons should exit soon.
bash-2.03# /data/oracle/product/10.2/crs/bin/ocrconfig -import /export/home/oracle/ocr.log
bash-2.03# /etc/init.d/init.crs start
Startup will be queued to init within 30 seconds.
由於嘗試利用物理備份的方式恢複ocr的時候,沒有停止其他節點的cluster,因此邏輯恢複操作也沒有停止其他節點的cluster,邏輯恢複完成後,探索資料庫沒有正常啟動,檢查alert檔案,探索資料庫啟動後出現了29702錯誤:
Sun Nov 21 23:47:05 2010
Shutting down instance (abort)
License high water mark = 6
Instance terminated by USER, pid = 18181
Sun Nov 21 23:53:31 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Interface type 1 ce110.0.0.0 configured from OCR for use as a cluster interconnect
Interface type 1 ce0 172.25.0.0 configured from OCR for use as a public interface
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /data/oracle/product/10.2/database/dbs/arch
Autotune of undo retention is turned on.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 318767104
__large_pool_size = 16777216
__java_pool_size = 50331648
__streams_pool_size = 33554432
spfile = /dev/rac/spfiletestrac.ora
sga_target = 1258291200
control_files = /dev/rac/control1.ctl, /dev/rac/control2.ctl, /dev/rac/control3.ctl
db_block_size = 16384
__db_cache_size = 822083584
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
cluster_database = TRUE
cluster_database_instances= 2
thread = 1
instance_number = 1
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_os_authent = TRUE