ORA-01111: namefordatafile1071isunknown-renametocorrectfileORA-01110:datafile1071:'/opt/oracle/products/19.3.0/dbs/UNNAMED01071'ORA-01157: cannot identify/lockdatafile1071-see DBWR tracefileORA-01111: namefordatafile1071isunknown-renametocorrectfileORA-01110:datafile1071:'/opt/oracle/products/19.3.0/...
环境:Oracle 11g RAC For Linux 6,该库为DataGuard备库 1. 特定用户查询数据时报错,如下: ERROR: ORA-01157: cannot identify/lock data file 226 - see DBWR trace file ORA-01110: data file 226: '+DG_DATA02/racdb/blsp_temp.dbf' 在备库中其它用户查询数据时正常,其它的临时表空间状态也正常。 2...
ORA-01110: data file 226: '+DG_DATA02/racdb/blsp_temp.dbf'SQL> 这时候，再去删除报错的数据...
ORA-19909: datafile 1 belongs to an orphan incarnation ORA-01110: data file 1: '+DATA_DG01/beiacce/system01.dbf' 这个报错是由incarnation引起的。 检查主备库incarnation信息 主库: ofs00biiacc002>rman target / Recovery Manager: Release 10.2.0.3.0 - Production on Tue Jul 2 17:04:41 2013 ...
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'...
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'...
alter database add standby logfile '/u01/app/oradata/DT/standby04.log' size 200m; 创建完成后查询是否成功 SQL> select group#,status,type,member from v$logfile; GROUP# STATUS TYPE MEMBER --- --- --- --- 3 ONLINE /u01/app/oradata/DT/redo03.log 2 ONLINE /u01/app/oradata/DT/redo0...
6 ORA-01110: data file 19: '/home/oracle/product/10.2.0/db_1/dbs/UNNAMED00019' 7 MRP0: Background Media Recovery process shutdown (oradb) 查看alert日志发现datafile为19的数据库文件缺失,尝试重新创建 1 ALTER SYSTEM SET standby_file_management='MANUAL' SCOPE=BOTH; 2 alter...
一：主备库正常切换（switchover) 1）：检查主库状态 selectname,database_role,switchover_statusfromv$database; 1：查询结果为TOSTANDBY 正常状况，可以切换。 2：查询结果为空的 Dataguard配置不正确，确认dataguard配置， （例如： 所有LOG_ARCHIVE_DEST_n参数是否正确。 tnsnames.ora里面是否配置...
SQL>alterdatabaserecover managed standbydatabase;alterdatabaserecover managed standbydatabase*ERRORatline 1:ORA-00283: recovery session canceled duetoerrorsORA-01111:namefordata file 14isunknown - renametocorrect fileORA-01110: data file 14:'/data/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00014'...