Oracle 11G RAC的STANDBY环境的一些问题
2008-10-25 12:57:49 来源:WEB开发网而实例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...
- ››oracle 中 UPDATE nowait 的使用方法
- ››Oracle ORA-12560解决方法
- ››Oracle 10g RAC 常用维护命令
- ››Oracle如何在ASM中定位文件的分布
- ››Oracle的DBMS_RANDOM.STRING 的用法
- ››oracle 外部表导入时间日期类型数据,多字段导入
- ››Oracle中查找重复记录
- ››oracle修改用户登录密码
- ››Oracle创建删除用户、角色、表空间、导入导出等命...
- ››Oracle中登陆时报ORA-28000: the account is lock...
- ››Oracle数据库在配置文件中更改最大连接数
- ››Oracle中在pl/sql developer修改表的两种方式
更多精彩
赞助商链接