151: channel ORA_DISK_1: starting datafile backupset restore 1. 152: channel ORA_DISK_1: specifying datafile(s) to restore from backup set 1. 153: restoring datafile 00002 to /u01/app/oracle/oradata/EPPS/undotbs01.dbf 1. 154: restoring datafile 00005 to /u02/oradata/EPPS/escmowner_d0...
150:using channel ORA_DISK_1 151:channel ORA_DISK_1: starting datafile backupset restore 152:channel ORA_DISK_1: specifying datafile(s) to restore from backup set 153:restoring datafile 00002 to /u01/app/oracle/oradata/EPPS/undotbs01.dbf 154:restoring datafile 00005 to /u02/oradata/EPPS/e...
最近,一同事使用客户使用rman做的全备,进行rac到单机的恢复,但是恢复过程中提示报错ORA-01547&ORA-01194&ORA-01110,意思是恢复过程中缺少保存在内存undo中的数据。 一、问题现象 rman rac全备到单机的异机恢复过程中,提示报错ORA-01547&ORA-01194&ORA-01110。 二、问题分析 首先,看客户的rman备份日志,备份日志中显...
150:using channel ORA_DISK_1 151:channel ORA_DISK_1: starting datafile backupset restore 152:channel ORA_DISK_1: specifying datafile(s) to restore from backup set 153:restoring datafile 00002 to /u01/app/oracle/oradata/EPPS/undotbs01.dbf 154:restoring datafile 00005 to /u02/oradata/EPPS/e...
12:channel ORA_DISK_1: SPFILE restore from autobackup complete 13:Finished restore at 02-APR-14 Step 3:关闭数据库后,利用还原spfile的初始化文件启动数据库 1:RMAN> shutdown immediate; 2:Oracle instance shut down 3:RMAN> startup nomount pfile=/u01/app/oracle/product/10.2.0/db_1/dbs/initEPPS...
ORA-01547 warning: RECOVER succeeded but OPEN RESETLOGS would get error below Cause Media recovery with one of the incomplete recovery options ended without error. However, if the ALTER DATABASE OPEN RESETLOGS command were attempted now, it would fail with the specified error. The most likely ...
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below 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$re...
Oracle Database - Enterprise Edition - Version 11.2.0.4 and later: ORA-01547 ORA-01152: File 1 Was Not Restored From A Sufficiently Old Backup
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' ...
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...