最近在验证、测试备份有效性时,遇到了“ORA-01180: can not create datafile 1”这个错误,顺便结合metalink的官方文档“RMAN restore fails with ORA-01180: can not create datafile 1 (文档 ID 1265151.1)”里面的内容做一个学习、归纳、总结,顺便加深一下理解。 creating datafile fno=1 name=/u01/oradata/SC...
ORA-01180: can not create datafile 1 ORA-01110: data file 1: ‘/u01/oradata/videv/system01.dbf’ 网上看了好多资料都没有解决问题。。。 于是仔细想了下:尝试用最新的控制文件来恢复。 于是备份了一个最新的controlfile ,copy到新的机器上然后问题解决 。
ORA-01180: can not create datafile 1 ORA-01110: data file 1: '/u01/oradata/SCM2/system01.dbf' 当然这个数据文件可能是system01.dbf,也可能是其它任何数据文件。但是如果它是FILE_ID为1数据文件,那么就是关键问题,因为FILE_ID为1是系统数据文件。它无法在RMAN还原过程中被创建。而它又必须从备份中还原(...
ORA-01180: can not create datafile 1 ORA-01110: data file 1: '/<path>/system01.dbf' 1. 2. 3. 4. 5. 6. 7. 8. 9. This error can happen for any datafiles. However, it is a major concern if it is datafile 1. Datafile 1 is the system datafile. It cannot be CREATED during ...
ORA-01180: can not create datafile 1 :解决一例 2013-02-16 16:54 −... seasonzone 1 1751 Oracle 重建控制文件一例 2018-05-23 09:57 −**环境:**OEL 5.7 + Oracle 10.2.0.5 **背景:**在Oracle的运维过程中,时常会遇到一些场景是需要重建控制文件才可以解决的。本文的场景可以通过复制控制文件...
ORA-01180: can not create datafile 1 ORA-01110: data file 1: '/u01/system01.dbf' This error can happen for any datafiles. However, it is a major concern if it is datafile 1. Datafile 1 is the system datafile. It cannot be CREATED during an RMAN restore. It must RESTORED from a ...
Oracle Database - Enterprise Edition - Version 9.2.0.1 and later: RMAN restore fails with ORA-01180: can not create datafile 1
Oracle Database - Standard Edition - Version 11.2.0.2 and later: RMAN restore database fails ORA-01180: can not create datafile 1
ORA-01178: 文件 在最后一个 CREATE CONTROLFILE 之前创建,无法重新创建 ORA-01179: 文件 不存在 ORA-01180: 无法创建数据文件 1 ORA-01181: 文件在最后一个 RESETLOGS 之前创建,无法重新创建 ORA-01182: 无法创建数据文件 - 文件在使用中或在恢复中
ORA-01180: cannot create datafile 1 Cause: datafile 1 cannot be created with the ALTERDATABASECREATEDATA FILE command. Action: Either recover the file from a backup or re-create the database. ORA-01181: file name created before last RESETLOGS, cannot be recreated Cause: An attempt was made...