使用裸設備的方式裝載數據庫﹐可為什么老是出現如此錯誤呢﹖﹖﹖ORA-00209: control f

显示全部楼层 · 2015-7-23 16:30:53

使用裸設備的方式裝載數據庫﹐可為什么老是出現如此錯誤呢﹖﹖﹖ORA-00209: control file blocksize mismatch, check alert log for more info
RAC環境﹕
二個節點﹐使用手動的方式安裝的數據庫。
/dev/raw/raw5是用來存放服務參數文件的設備
SQL> startup nomount pfile='/oracle/ora9/product/9.2/dbs/initrac491.ora.bak';
ORACLE instance started.
Total System Global Area 72422560 bytes
Fixed Size
451744 bytes
Variable Size
46137344 bytes
Database Buffers 25165824 bytes
Redo Buffers
667648 bytes
SQL> create spfile='/dev/raw/raw5' from pfile='/oracle/ora9/product/9.2/dbs/initrac491.ora.bak';
File created.
SQL> shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> startup pfile='/oracle/ora9/product/9.2/dbs/initrac491.ora'
ORACLE instance started.
Total System Global Area101782828 bytes
Fixed Size
451884 bytes
Variable Size
50331648 bytes
Database Buffers 50331648 bytes
Redo Buffers
667648 bytes
ORA-00209: control file blocksize mismatch, check alert log for more info
為什么會出現如上錯誤呢﹖﹖﹖具體參數如下﹕﹕

initrac491.ora.bak:
*.background_dump_dest='/oracle/ora9/admin/rac/bdump'
*.cluster_database_instances=2
*.compatible='9.2.0.0.0'
*.control_files=('/dev/raw/raw6','/dev/raw/raw7')
*.core_dump_dest='/oracle/ora9/admin/rac/cdump'
*.db_block_size=8192
*.db_cache_size=25165824
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='rac'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
rac492.instance_name='rac492'
rac491.instance_name='rac491'
rac492.instance_number=2
rac491.instance_number=1
*.java_pool_size=8388608
*.large_pool_size=2388608
rac492.local_listener='(address=(protocol=tcp)(host=rac26)(port=1521))'
rac491.local_listener='(address=(protocol=tcp)(host=rac49)(port=1521))'
*.open_cursors=300
*.pga_aggregate_target=20165824
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_listener='LISTENERS_RAC'
rac492.remote_listener='(address=(protocol=tcp)(host=rac49)(port=1521))'
rac491.remote_listener='(address=(protocol=tcp)(host=rac26)(port=1521))'
*.remote_login_passwordfile='exclusive'
*.service_names='rac49'
*.shared_pool_size=13886080
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
rac492.thread=2
rac491.thread=1
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
rac492.undo_tablespace='UNDOTBS2'
rac491.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/oracle/ora9/admin/rac/udump'
initrac491.ora:
*.db_name='rac'
*.cluster_database = TRUE
*.cluster_database_instances =4
rac491.instance_name='rac491'
rac492.instance_name='rac492'
rac491.instance_number=1
rac492.instance_number=2
*.service_names='rac49'
rac491.thread=1
rac492.thread=2
rac491.local_listener='(address=(protocol=tcp)(host=rac49)(port=1521)) '
rac491.remote_listener='(address=(protocol=tcp)(host=rac26)(port=1521)) '
rac492.local_listener='(address=(protocol=tcp)(host=rac26)(port=1521)) '
rac492.remote_listener='(address=(protocol=tcp)(host=rac49)(port=1521)) '
rac491.undo_tablespace=UNDOTBS1
rac492.undo_tablespace=UNDOTBS2
ifile='/dev/raw/raw5'
control_files='/dev/raw/raw6','/dev/raw/raw7'

千问 · 2015-7-23 16:30:53

哪位兄弟幫忙看看啊

千问 · 2015-7-23 16:30:53

可能是控制文件坏了，重新建立试试。

千问 · 2015-7-23 16:30:53

算了﹐自已搞定了﹐看來還是提問的水平不到家啊