linux oracle ora-01157,Oracle Data Guard ORA-01157 ORA-01110 ORA-27037错误的解决方法（我的试验...

Oracle Data Guard ORA-01157 ORA-01110

ORA-27037错误，真的很让人心烦，但是解决问题的最好办法还是去查看相关的bdump目录中查看告警日志，日志中出现了大量的错误，但是还是要耐下心来对错误进行分析，同时我也在网上寻找了大量的资料进行参阅，但是发现其实问题很简单，在把主数据库bjdb上生成的初始化参数文件拷贝到备用数据库(shdb)的过程中，自己没有把相关的数据文件的存放目录进行修正，于是匆匆就执行了Create

spfile from

pfile的语句，然后习惯性的用spfile启动备用数据库(shdb)到mount状态并且把主数据库(bjdb)置为打开状态，完成后进行了在主数据库bjdb进行归档日志的切换，发现data

guard根本没有把主数据库中的信息传递到备用数据库中来，于是静下心来认认真真地查看观察发现，我的备用数据库(shdb)中的pfile(initshdb.ora)y与spfile的信息严重不匹配，于是重新同步了一下spfile，DG的切换顺利完成，哈哈哈，开心

Tue Mar 25 08:57:37 2014

Errors in file

/u01/app/oracle/admin/shdb/bdump/shdb_dbw0_28551.trc:

ORA-01157: cannot identify/lock data file 1 - see DBWR trace

file

ORA-01110: data file 1:

'/u01/app/oracle/oradata/prod/system01.dbf'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

Tue Mar 25 08:57:37 2014

Errors in file

/u01/app/oracle/admin/shdb/bdump/shdb_dbw0_28551.trc:

ORA-01157: cannot identify/lock data file 2 - see DBWR trace

file

ORA-01110: data file 2:

'/u01/app/oracle/oradata/prod/undotbs01.dbf'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

Tue Mar 25 08:57:37 2014

Errors in file

/u01/app/oracle/admin/shdb/bdump/shdb_dbw0_28551.trc:

ORA-01157: cannot identify/lock data file 3 - see DBWR trace

file

ORA-01110: data file 3:

'/u01/app/oracle/oradata/prod/sysaux01.dbf'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

Tue Mar 25 08:57:37 2014

Errors in file

/u01/app/oracle/admin/shdb/bdump/shdb_dbw0_28551.trc:

ORA-01157: cannot identify/lock data file 4 - see DBWR trace

file

ORA-01110: data file 4:

'/u01/app/oracle/oradata/prod/users01.dbf'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

Tue Mar 25 08:57:37 2014

Errors in file

/u01/app/oracle/admin/shdb/bdump/shdb_dbw0_28551.trc:

ORA-01157: cannot identify/lock data file 5 - see DBWR trace

file

ORA-01110: data file 5:

'/u01/app/oracle/oradata/prod/example01.dbf'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

MRP0: Background Media Recovery terminated with error 1110

Tue Mar 25 08:57:37 2014

Errors in file

/u01/app/oracle/admin/shdb/bdump/shdb_mrp0_28593.trc:

ORA-01110: data file 1:

'/u01/app/oracle/oradata/prod/system01.dbf'

ORA-01157: cannot identify/lock data file 1 - see DBWR trace

file

ORA-01110: data file 1:

'/u01/app/oracle/oradata/prod/system01.dbf'

Tue Mar 25 08:57:37 2014

Errors in file

/u01/app/oracle/admin/shdb/bdump/shdb_mrp0_28593.trc:

ORA-01110: data file 1:

'/u01/app/oracle/oradata/prod/system01.dbf'

ORA-01157: cannot identify/lock data file 1 - see DBWR trace

file

ORA-01110: data file 1:

'/u01/app/oracle/oradata/prod/system01.dbf'

Tue Mar 25 08:57:37 2014