DATAGUARD环境ORA-01111、ORA-01110处理
原创
©著作权归作者所有:来自51CTO博客作者zylhsy的原创作品,请联系作者获取转载授权,否则将追究法律责任
故障现象:
Errors in file /home/oracle/admin/zjport/bdump/zjport_mrp0_17798.trc:
ORA-01111: name for data file 19 is unknown - rename to correct file
ORA-01110: data file 19: '/home/oracle/product/10.2.0/db_1/dbs/UNNAMED00019'
ORA-01157: cannot identify/lock data file 19 - see DBWR trace file
ORA-01111: name for data file 19 is unknown - rename to correct file
ORA-01110: data file 19: '/home/oracle/product/10.2.0/db_1/dbs/UNNAMED00019'
Wed Sep 5 11:10:08 2012
MRP0: Background Media Recovery process shutdown (zjport)
故障处理:
ALTER SYSTEM SET standby_file_management='MANUAL' SCOPE=BOTH;
alter database create datafile '/home/oracle/product/10.2.0/db_1/dbs/UNNAMED00019' as '/u01/oracle/oradata/zjport/test02.dbf'
ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH;
ALTER DATABASE RECOVER managed standby database disconnect from session
上一篇:又到了通宵实施季
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
ora-01157和ora-01110错误修复
ora-01157和ora-01110错误
修复 database cannot 数据库连接 identify -
DATAGUAR备库无法OPEN报ORA-10458:ORA-01152:ORA-01110
SQL> alter database open read only;alter database open read only*ERROR at line 1:ORA-10458: standby database requires recoveryORA-01152: file 1 was not restored from a sufficiently old backupORA-01110: data file 1: '/oracle/oradata/BSTYLE/system.309.766573511'
ORA-01110 ORA-10458 ORA-01152 Error 12154 -
ora-01110错误之异常恢复
ora-01110错误之异常恢复
ora-01110 异常恢复 -
针对ORA-01111, ORA-01110, ORA-01157的处理
针对ORA-01111, ORA-01110, ORA-01157的处理
Oracle数据库 晟数学院 报错处理 -
执行insert时报错ORA-00372、ORA-01110
执行insert时报错ORA-00372、ORA-01110
ORA-00372 ORA-01110 READ ONLY
















