ORA-01113: file 1 needs media recovery ORA-01110: data file 1:

简介: 把下面两个隐含参数加入到pfile中
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/app/oracle/oradata/guangxi/system01.dbf'


把下面两个隐含参数加入到pfile中

*._allow_terminal_recovery_corruption=true
*._allow_resetlogs_corruption= TRUE

重新启动数据库

SQL> startup force pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initguangxi.ora';
ORACLE instance started.
Total System Global Area 1235959808 bytes
Fixed Size      2252784 bytes
Variable Size    956301328 bytes
Database Buffers   268435456 bytes
Redo Buffers      8970240 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/app/oracle/oradata/guangxi/system01.dbf'
SQL> recover database;
Media recovery complete.
SQL> alter database open;
Database altered.


相关文章
|
存储
rman备份失败:ORA-00245: control file backup failed; target is likely on a local file system
rman备份失败:ORA-00245: control file backup failed; target is likely on a local file system
164 0
|
Oracle 关系型数据库 数据库
|
SQL 关系型数据库
ORA-01336: specified dictionary file cannot be opened
这篇介绍使用Logminer时遇到ORA-01336: specified dictionary file cannot be opened错误的各种场景   1:dictionary_location参数的路径最后多了一个/符号。
1328 0
|
Oracle 关系型数据库 Shell
[20171121]rman backup as copy 2.txt
[20171121]rman backup as copy 2.txt --//昨天测试backup as copy ,备份时备份文件的文件头什么时候更新.是最后完成后还是顺序写入备份文件.
1013 0
|
Oracle 关系型数据库 Linux
[20171121]rman backup as copy.txt
[20171121]rman backup as copy.txt --//上个星期做数据文件块头恢复时,提到使用rman备份数据文件时,文件头数据库信息是最后写入备份集文件的,在filesperset=1的情况 --//下写入备份集文件中的倒数第2块就是文件头的备份.
1228 0
|
Oracle 关系型数据库 数据库
[20170616]recover copy of datafile 6.txt
[20170616]no copy of datafile 6 found to recover.txt --//最近几天一直被这个问题纠缠,我虽然不知道问题在哪来,还是找到简单的解决方法,做1个记录: --//链接:http://www.
1153 0

热门文章

最新文章