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,如需转载请自行联系原作者
 
相关文章
成功解决OSError: Unable to open file (truncated file: eof = 8388608, sblock->base_addr = 0, stored_eof =
成功解决OSError: Unable to open file (truncated file: eof = 8388608, sblock->base_addr = 0, stored_eof =
成功解决OSError: Unable to open file (truncated file: eof = 8388608, sblock->base_addr = 0, stored_eof =
|
Python
ERROR: file or directory not found: xx.py
​ 1、问题出现原因 在vscode中已导入pytest框架,做自动化demo小测试,运行Python文件一直出现如题错误,截图如下: ERROR: file or directory not found: xx.py  2、解决办法 1)直接把该文件移到当前主目录下,放在PYTHON-STUDY下 2)VSCode中右键tuopan.py文件,选择[在集成终端中打开],或者通过CD命令进入到tuopan.py文件所在目录 然后输入以下命令即可: 注:上述命令不是换行,在d:/前有空格 ,第一行信息为python所在安装路径,空格后的换行为运行的python文件的所在路径  
155 0
ftok info: No such file or directory
ftok info: No such file or directory
191 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?
155 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.
1791 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.
1237 0
|
SQL Oracle 关系型数据库
Online Data Files move
online data files move,move online,
1694 0
|
Oracle 关系型数据库 Linux
[20180109]disk file operations.txt
[20180110]disk file operations.txt --//调查生产系统相关disk file operations问题,记录一下: 1.环境: XXXX> @ &r/ver1 PORT_STRING                  ...
1102 0
|
关系型数据库 数据库管理 Oracle