ORA-01111: name for data file 119 is unknown - rename to correct file

简介:
背景:
新建设的DATAGUARD数据库,主库早上某表空间增加数据裸设备rdata91_disk作为数据文件后从库应用日志失败。
经查因为standby_file_management状态非AUTO引起。

现象:ORACLE从库出现如下错误:
Media Recovery Log /archivelog/archive_1_41730_614088933.arc
File #119 added to control file as 'UNNAMED00119' because
the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL
The file should be manually created to continue.
Errors with log /archivelog/archive_1_41730_614088933.arc
Some recovered datafiles maybe left media fuzzy
Media recovery may continue but open resetlogs may fail

执行alter database recover managed standby database disconnect from session;出现如下错误:
Mon Dec 17 11:27:54 2012
Errors in file /home/oracle/admin/lstandby/bdump/lstandby_mrp0_495730.trc:
ORA-01111: name for data file 119 is unknown - rename to correct file
ORA-01110: data file 119: '/home/oracle/database/dbs/UNNAMED00119'
ORA-01157: cannot identify/lock data file 119 - see DBWR trace file
ORA-01111: name for data file 119 is unknown - rename to correct file
ORA-01110: data file 119: '/home/oracle/database/dbs/UNNAMED00119'

解决方法:
alter database rename file '/home/oracle/database/dbs/UNNAMED00119' to '/dev/rdata91_disk';
ALTER DATABASE CREATE DATAFILE  '/dev/rdata91_disk';

或者
ALTER DATABASE CREATE DATAFILE  '/home/oracle/database/dbs/UNNAMED00120'  AS  '/dev/rdata92_disk';

最后不要忘记
ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO; 



本文转自zylhsy 51CTO博客,原文链接:http://blog.51cto.com/yunlongzheng/1091944,如需转载请自行联系原作者
 
相关文章
InvalidJobConfException: Output directory not set
InvalidJobConfException: Output directory not set
58 0
ftok info: No such file or directory
ftok info: No such file or directory
186 0
perhaps your file is in a different file format and youneed to use a different restore operator?
perhaps your file is in a different file format and youneed to use a different restore operator?
151 0
|
SQL 关系型数据库 Oracle
ORA-01466: unable to read data - table definition has changed
1. Oracle建议我们等待大约5分钟之后再进行flashback query新创建的表,否则可能会碰到这个错误ORA-01466: unable to read data - table definition has changed.
1788 0
|
机器学习/深度学习
成功解决NotFoundError (see above for traceback): Failed to create a directory: ; No such file or directo
成功解决NotFoundError (see above for traceback): Failed to create a directory: ; No such file or directo
|
SQL 监控
backup log is terminating abnormally because for write on file failed: 112(error not found)
昨天遇到一个案例,YourSQLDba做事务日志备份时失败,检查YourSQLDba输出的错误信息如下:   yMaint.backups backup log [gewem] to disk = 'M:\DB_BACKUP\LOG_BACKUP\xxxx_[2016-11-22_01h11m05_Tue]_logs.
1235 0
|
关系型数据库 数据库管理 Oracle
Input path does not exist: file:/.......
注意看是file不存在并不是hdfs,好奇怪,突然明白应该是路径不对,必须加上hdfs://hostname:port/file。 我为什么饭这样的错误是因为前一阵谢了HDFS的曹组,谢了全局FileSystem,那么下面就不比要hdfs://hostname:port/了。
1479 0