STANDBY_FILE_MANAGEMENT 在启用自动备用文件管理后,将在备用数据库上复制主数据库上的操作系统文件添加和删除。此时,我们在主服务器上添加数据文件,而恢复过程(MRP)正在尝试应用存档,由于该参数设置,它将在$ ORACLE_HOME / dbs中创建一个未命名的文件将导致杀死MRP进程,错误如下所示。 当数据库由OMF管理时,修改路...
ORA-01110: data file 13: ‘/u01/app/oracle/oradata/fapdb/UNNAMED0013′ ORA-01157: cannot identify/lock data file 13 – see DBWR trace file 跟客户沟通下来了解到7号应用那边对生产数据库某一表空间增加了一个裸设备文件,通过查询生产数据库确定13号数据文件即7号添加的裸设备文件,照理说不会出现这种...
故障现象: 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 DB...
此时需要注意,o1_mf_gpapp_h4dnw6m6_.dbf,这种命名数据文件的方式很奇怪,一般这种方式多出现在ASM磁盘中,由数据库定义名称,此时我就想到了OMF,查看相关参数,确认此库为OMF管理方式管理数据文件。 此处验证证明了我的猜想,所以修改语句重新执行,修复了此问题。 `alter database create datafile '/data/app/oracle/...
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; ...
ORA-01110 ORA-01111 ORA-01157主备库数据文件路径路径不一致,备库开启ADG应用报错(一切都是套路) ###Begin Now### ### ### ###
ORA-01110: data file 24: '/data/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00024' 刚刚在主库添加了数据文件: SQL> alter tablespace MODEL_BH add datafile '/data2/oradata/datafile/bapp/MODEL_BH010.dbf' size 31g; 然后查看下发现24号数据文件就是刚才添加的那文件: ...
1> 检查dataguard,sid已经正常启动,尝试启动MRP进程起不来,查看alert日志 (10g) 1 Errors in file /home/oracle/admin/oradb/bdump/zjport_mrp0_17798.trc: 2 ORA-01111: name for data file 19 is unknown - rename to correct file 3 ORA-01110: data file 19: '/home/oracle/product/10.2.0/db_1...
ORA-01110: data file7:'/u01/app/oracle/product/12.1.0/dbhome_1/dbs/UNNAMED00007'ORA-10458signalled during:ALTERDATABASEOPENREADONLY/* db agent *//* {0:0:2} */...2.备库查看数据文件SQL>col namefora60SQL>selectfile#,namefromv$datafileorderbyfile#; ...
Errors in file /u01/app/oracle/diag/rdbms/orcldg/orcldg/trace/orcldg_ora_2067.trc:ORA-01111: name for data file 7 is unknown - rename to correct fileORA-01110: data file 7: '/u01/app/oracle/product/12.1.0/dbhome_1/dbs/UNNAMED00007'ORA-01157: cannot identify/lock data file 7 - ...