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