WEB开发网
开发学院数据库Oracle Oracle 11G RAC的STANDBY环境的一些问题 阅读

Oracle 11G RAC的STANDBY环境的一些问题

 2008-10-25 12:57:49 来源:WEB开发网   
核心提示: 而实例2尝试启动数据库则会报错:SQL>startupORACLE 例程已经启动,TotalSystemGlobalArea1.7108E+10bytesFixedSize2101632bytesVariableSize3478638208bytesDatabaseBuffers1.

而实例2尝试启动数据库则会报错:

SQL>startup

ORACLE 例程已经启动。

TotalSystemGlobalArea1.7108E+10bytes
FixedSize2101632bytes
VariableSize3478638208bytes
DatabaseBuffers1.3623E+10bytes
RedoBuffers4431872bytes数据库装载完毕。
ORA-01187:由于验证测试失败而无法从文件1读取
ORA-01110:数据文件1:'+DATA/rac11g/rac11g_system_1_1g'
  
SQL>selectinstance_namefromv$instance;
INSTANCE_NAME
----------------
rac11g2

如果说这个错误不是很明确,那么alert文件里面的错误信息就清楚多了:

Errorsinfile/data/oracle/diag/rdbms/rac11g_s/rac11g2/trace/rac11g2_dbw0_1093.trc:
ORA-01186:file1failedverificationtests
ORA-01108:file1isinbackupormediarecovery
ORA-01110:datafile1:'+DATA/rac11g/rac11g_system_1_1g'
File1notverifiedduetoerrorORA-01108
Errorsinfile/data/oracle/diag/rdbms/rac11g_s/rac11g2/trace/rac11g2_dbw0_1093.trc:
ORA-01186:file2failedverificationtests
ORA-01108:file2isinbackupormediarecovery
ORA-01110:datafile2:'+DATA/rac11g/rac11g_sysaux_1_1g'
File2notverifiedduetoerrorORA-01108
Errorsinfile/data/oracle/diag/rdbms/rac11g_s/rac11g2/trace/rac11g2_dbw0_1093.trc:
ORA-01186:file3failedverificationtests
ORA-01108:file3isinbackupormediarecovery
ORA-01110:datafile3:'+DATA/rac11g/rac11g_undotbs1_1_4g'
File3notverifiedduetoerrorORA-01108
Errorsinfile/data/oracle/diag/rdbms/rac11g_s/rac11g2/trace/rac11g2_dbw0_1093.trc:
ORA-01186:file4failedverificationtests
ORA-01108:file4isinbackupormediarecovery
ORA-01110:datafile4:'+DATA/rac11g/rac11g_undotbs2_1_4g'
File4notverifiedduetoerrorORA-01108
Errorsinfile/data/oracle/diag/rdbms/rac11g_s/rac11g2/trace/rac11g2_dbw0_1093.trc:
ORA-01186:file5failedverificationtests
ORA-01108:file5isinbackupormediarecovery
ORA-01110:datafile5:'+DATA/rac11g/rac11g_users_1_4g'
File5notverifiedduetoerrorORA-01108
Errorsinfile/data/oracle/diag/rdbms/rac11g_s/rac11g2/trace/rac11g2_dbw0_1093.trc:
ORA-01186:file6failedverificationtests
ORA-01108:file6isinbackupormediarecovery
ORA-01110:datafile6:'+DATA/rac11g/rac11g_ndmain_1_32g'
File6notverifiedduetoerrorORA-01108
Errorsinfile/data/oracle/diag/rdbms/rac11g_s/rac11g2/trace/rac11g2_dbw0_1093.trc:
ORA-01186:file7failedverificationtests
ORA-01108:file7isinbackupormediarecovery
ORA-01110:datafile7:'+DATA/rac11g/rac11g_ndmain_2_32g'
File7notverifiedduetoerrorORA-01108
Errorsinfile/data/oracle/diag/rdbms/rac11g_s/rac11g2/trace/rac11g2_dbw0_1093.trc:
ORA-01186:file8failedverificationtests
ORA-01108:file8isinbackupormediarecovery
ORA-01110:datafile8:'+DATA/rac11g/rac11g_ndmain_3_32g'
File8notverifiedduetoerrorORA-01108
Errorsinfile/data/oracle/diag/rdbms/rac11g_s/rac11g2/trace/rac11g2_dbw0_1093.trc:
ORA-01186:file9failedverificationtests
ORA-01108:file9isinbackupormediarecovery
ORA-01110:datafile9:'+DATA/rac11g/rac11g_ndmain_4_32g'
File9notverifiedduetoerrorORA-01108
Errorsinfile/data/oracle/diag/rdbms/rac11g_s/rac11g2/trace/rac11g2_dbw0_1093.trc:
ORA-01186:file10failedverificationtests
ORA-01108:file10isinbackupormediarecovery
ORA-01110:datafile10:'+DATA/rac11g/rac11g_ndmain_5_32g'
File10notverifiedduetoerrorORA-01108
Errorsinfile/data/oracle/diag/rdbms/rac11g_s/rac11g2/trace/rac11g2_dbw0_1093.trc:
ORA-01186:file11failedverificationtests
ORA-01108:file11isinbackupormediarecovery
ORA-01110:datafile11:'+DATA/rac11g/rac11g_ndmain_6_32g'
File11notverifiedduetoerrorORA-01108
Errorsinfile/data/oracle/diag/rdbms/rac11g_s/rac11g2/trace/rac11g2_dbw0_1093.trc:
ORA-01186:file12failedverificationtests
ORA-01108:file12isinbackupormediarecovery
ORA-01110:datafile12:'+DATA/rac11g/rac11g_undotbs1_2_32g'
File12notverifiedduetoerrorORA-01108
Errorsinfile/data/oracle/diag/rdbms/rac11g_s/rac11g2/trace/rac11g2_dbw0_1093.trc:
ORA-01186:file13failedverificationtests
ORA-01108:file13isinbackupormediarecovery
ORA-01110:datafile13:'+DATA/rac11g/rac11g_undotbs2_2_32g'
File13notverifiedduetoerrorORA-01108
Errorsinfile/data/oracle/diag/rdbms/rac11g_s/rac11g2/trace/rac11g2_dbw0_1093.trc:
ORA-01186:file14failedverificationtests
ORA-01108:file14isinbackupormediarecovery
ORA-01110:datafile14:'+DATA/rac11g/rac11g_perfstat_1_8g'
File14notverifiedduetoerrorORA-01108
Errorsinfile/data/oracle/diag/rdbms/rac11g_s/rac11g2/trace/rac11g2_dbw0_1093.trc:
ORA-01186:file201failedverificationtests
ORA-01122:databasefile201failedverificationcheck
ORA-01110:datafile201:'+DATA/rac11g/rac11g_temp_1_4g'
ORA-01203:wrongincarnationofthisfile-wrongcreationSCN
File201notverifiedduetoerrorORA-01122
Errorsinfile/data/oracle/diag/rdbms/rac11g_s/rac11g2/trace/rac11g2_dbw0_1093.trc:
ORA-01186:file202failedverificationtests
ORA-01122:databasefile202failedverificationcheck
ORA-01110:datafile202:'+DATA/rac11g/rac11g_temp_2_16g'
ORA-01206:fileisnotpartofthisdatabase-wrongdatabaseid
File202notverifiedduetoerrorORA-01122
ORA-1187signalledduring:ALTERDATABASEOPEN...

Tags:Oracle RAC STANDBY

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接