DATAGUARD环境ORA-01111、ORA-01110处理

简介:
故障现象:
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 


本文转自zylhsy 51CTO博客,原文链接:http://blog.51cto.com/yunlongzheng/982961,如需转载请自行联系原作者
相关文章
|
SQL Oracle 关系型数据库
dataguard ORA-01033错误
dataguard ORA-01033错误
266 0
rac中连接pdb时遇到ORA-01033:
sqlplus system/dingjia@192.168.82.139:1528/third
113 0
|
SQL
DATAGUARD(11.2.0.4) ORA-04021
DATAGUARD(11.2.0.4) ORA-04021
243 0
|
SQL Oracle 关系型数据库
Oracle shutdown immediate遭遇ORA-24324 ORA-24323 ORA-01089
一数据库服务器执行shutdown immediate时,遇到了下面ORA错误,如下所示: $ sqlplus / as sysdba   SQL*Plus: Release 10.2.0.4.0 - Production on Fri Aug 5 10:56:24 2016   Copyright (c) 1982, 2007, Oracle.
1659 0
|
SQL Oracle 关系型数据库
|
SQL 网络协议 关系型数据库