Oracle邏輯恢複ocr導致的ORA-29702錯誤

來源:互聯網
上載者:User

嘗試邏輯恢複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

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.