最近,一同事使用客户使用rman做的全备,进行rac到单机的恢复,但是恢复过程中提示报错ORA-01547&ORA-01194&ORA-01110,意思是恢复过程中缺少保存在内存undo中的数据。 一、问题现象 rman rac全备到单机的异机恢复过程中,提示报错ORA-01547&ORA-01194&ORA-01110。 二、问题分析 首先,看客户的rman备份日志,备份日志中显...
channel ORA_DISK_3: sid=1086 devtype=DISK starting media recovery Oracle Error: ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01194: file 3 needs more recovery to be consistent ORA-01110: data file 3: '+DATA/oradata/fdcd/sysaux.dbf' ...
pfile='/oracle/base/admin/sgpmdb2b/pfile/pfilesgpmdb2b.ora' db_file_name_convert=('/app/oracle/base/oradata/sgpmdb2/','/oracle/base/oradata/sgpmdb2b/'); } 如果顺利的话,数据库会自动重启到open状态, 不顺利的事情十有八九,呵呵。以下是报错 ... b2b/DATA_OUT.DBF datafile 30 switched to...
pfile='/oracle/base/admin/sgpmdb2b/pfile/pfilesgpmdb2b.ora' db_file_name_convert=('/app/oracle/base/oradata/sgpmdb2/','/oracle/base/oradata/sgpmdb2b/'); } 如果顺利的话,数据库会自动重启到open状态, 不顺利的事情十有八九,呵呵。以下是报错 ... b2b/DATA_OUT.DBF datafile 30 switched to...
ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/oracle/oracle11g/oradata/oimprod/system01.dbf' Datafiles are not in backup (V$backup). No file required recovery (V$recover_file). But Fuzzy is Yes for all files (V$datafile_header). ...
ORA_DISK_3channelORA_DISK_3:sid=1086devtype=DISKstartingmediarecoveryOracleError:ORA-01547:warning:RECOVERsucceededbutOPENRESETLOGSwouldgeterrorbelowORA-01194:file3needsmorerecoverytobeconsistentORA-01110:datafile3:'+DATA/oradata/fdcd/sysaux.dbf'RMAN-00571:===RMAN-00569:===ERRORMESSAGESTACKFOLLOWS===RM...
rman复制数据库ORA-01547ORA-01194ORA-01110,强制打开并修改日志文件 2010-07-05 17:21 −我用rman复制数据库,做好前期准备了:创建了路径,建密码文件,参数文件,启动到nomount,用RMAN同时连接到源库和辅助nomount库,当然也提前做了全库备份,并把备份复制到了目标库。 然后执行:run{DUPLICATE TARGET DATABASE .....
51CTO博客已为您找到关于ora-01547 ora-01194 ora-01110的相关内容,包含IT学习相关文档代码介绍、相关教程视频课程,以及ora-01547 ora-01194 ora-01110问答内容。更多ora-01547 ora-01194 ora-01110相关解答可以来51CTO博客参与分享和学习,帮助广大IT技术人实现成长和进步。
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01194: file 3 needs more recovery to be consistent ORA-01110: data file 3: '+DATA/oradata/fdcd/sysaux.dbf' RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002...
ORA-24324: service handle not initialized ORA-01041: internal error. hostdef extension doesn't exist SQL> startup force; ORA-24324: service handle not initialized ORA-01041: internal error. hostdef extension doesn't exist SQL> startup; ORA-24324: service handle not initialized ...