Errors in file /oracle/app/oracle/diag/rdbms/racdb/racdb1/trace/racdb1_dbw0_3455.trc:
ORA-01186: file 201 failed verification tests
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '+DATA/racdb/tempfile/temp.286.859438605'
File 201 not verified due to error ORA-01157
Dictionary check complete
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
Wed Oct 29 09:18:23 2014
SMON: enabling tx recovery
Re-creating tempfile +DATA/racdb/tempfile/temp.286.859438605 as /oracle/oradata/racdb/RACDB/datafile/o1_mf_temp_b50j2zdh_.tmp
Database Characterset is ZHS16GBK
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Wed Oct 29 09:18:32 2014
QMNC started with pid=24, OS id=3743
Wed Oct 29 09:18:33 2014
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
Wed Oct 29 09:18:45 2014
Starting background process CJQ0
Wed Oct 29 09:18:45 2014
CJQ0 started with pid=27, OS id=3763
Wed Oct 29 09:18:45 2014
Completed: alter database open resetlogs
三、总结
由上可知，当Oracle数据库在恢复时（也就是执行’alter database open resetlogs’时），如果之前Oracle数据库的存储方式为ASM模式，打开数据库时数据库会自动在相应目录创建redo日志，当之前Oracle数据库的存储方式为裸设备、文件模式，打开数据库时数据库会查找原裸设备或者目录，并创建原有目录结构，无法创建时则报错。如需更改，需手动设置。 可见ASM自动管理是很有好处的，当然， 作为技术人员，我们可以更严谨一些（自动的东西有时也不靠谱），在执行open之前，修改redo日志目录。在做hpux之前，我已反复查看操作命令及相关文档，总会百密一疏，当然，由于之前恢复的是ASM模式下并无此问题，再者应变、应急处理能力还有待提高。
--------------------------------------推荐阅读 --------------------------------------
--------------------------------------分割线 --------------------------------------