最近在验证、测试备份有效性时,遇到了“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 :解决一例 背景:rac+dataguard异地恢复 报错如下: creating datafile fno=1 name=/u01/oradata/videv/system01.dbf RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure of restore command at 05/10/2011 2...
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还原过程中被创建。而它又必须从备份中还原(...
Often the error is not a problem with RMAN unable to write to the destination drive as one might think by looking at the error message "can not create datafile 1". Cause Sign In To view full details, sign in with your My Oracle Support account. Register Don't have a My Oracle Sup...
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: can not create datafile 1 ORA-01110: data file 1: ‘/gpfs/dataprd/ORCL/datafile/o1_mf_system_3n5w1nky_.dbf’ 原因 还原失败,因为RMAN 认为没有可用的备份来还原,因此它会尝试创建数据文件并应用归档重做日志。但数据文件1无法被重建,因此会失败。
ORA-01180: can not create datafile 1 :解决一例 2013-02-16 16:54 −... seasonzone 1 1731 Oracle 重建控制文件一例 2018-05-23 09:57 −**环境:**OEL 5.7 + Oracle 10.2.0.5 **背景:**在Oracle的运维过程中,时常会遇到一些场景是需要重建控制文件才可以解决的。本文的场景可以通过复制控制文件...
Oracle Database - Standard Edition - Version 11.2.0.2 and later: RMAN restore database fails ORA-01180: can not create datafile 1
Often the error is not a problem with RMAN unable to write to the destination drive as one might think by looking at the error message "can not create datafile 1". CAUSE There are no backups available for use OR The current incarnation is not set correctly ...