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: ‘/u01/oradata/videv/system01.dbf’ 网上看了好多资料都没有解决问题。。。 于是仔细想了下:尝试用最新的控制文件来恢复。 于是备份了一个最新的controlfile ,copy到新的机器上然后问题解决 。
最近在验证、测试备份有效性时,遇到了“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...
Oracle Database - Enterprise Edition - Version 9.2.0.1 and later: RMAN restore fails with ORA-01180: can not create datafile 1
首先可以确定的说:ORA-01034:ORACLE not available 说明你的数据库没有启动到mount状态下,执行建库脚本需要数据启动到mount下.是
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 ...
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...
ORA-01178: 文件 在最后一个 CREATE CONTROLFILE 之前创建,无法重新创建 ORA-01179: 文件 不存在 ORA-01180: 无法创建数据文件 1 ORA-01181: 文件在最后一个 RESETLOGS 之前创建,无法重新创建 ORA-01182: 无法创建数据文件 - 文件在使用中或在恢复中
ORA-01180 can not create datafile 1 Cause: An attempt was made to create datafile 1 using ALTER DATABASE CREATE DATAFILE. Action: Recover file from a backup or re-create the database. ORA-01181 file string created before last RESETLOGS, cannot recreate Cause: An attempt was made to use AL...