Completed: alter database create datafile '/opt/app/oracle/RHYS/undotbs01.dbf' alter database open Errors in file /opt/app/oracle/diag/rdbms/rhys/RHYS/trace/RHYS_ora_3714.trc: ORA-01113: file 3 needs media recovery ORA-01110: data file 3: '/opt/app/oracle/RHYS/undotbs01.dbf' ORA-1...
最近,一同事使用客户使用rman做的全备,进行rac到单机的恢复,但是恢复过程中提示报错ORA-01547&ORA-01194&ORA-01110,意思是恢复过程中缺少保存在内存undo中的数据。 一、问题现象 rman rac全备到单机的异机恢复过程中,提示报错ORA-01547&ORA-01194&ORA-01110。 二、问题分析 首先,看客户的rman备份日志,备份日志中显...
(这个参数允许在数据不一致的情况下打开) *.undo_management='AUTO' 修改为*.undo_management='MANUAL'(#正常启库后修改为原值AUTO) (这个参数是让UNDO表空间由自动管理变手动管理) 增加此句 *._corrupted_rollback_segments=(_SYSSMU12$)(#正常启库后去掉此句) (屏蔽出错的事务回滚段,根据ALERT提示ORA-01555...
1、删除坏的UNDOTBS01.DBF,将备份的回退文件UNDOTBS01.DBF拷回原处; 2、进入SQLPLUS; 3、startup; 系统出错提示: ORA-01157: cannot identify/lock data file 2 - see DBWR trace file ORA-01110: data file 2: '/home/oracle/oradata/esal/undotbs01.dbf' 4、recover database; 系统自动恢复; 5、ale...
(这个参数是让UNDO表空间由自动管理变手动管理) 增加此句 *._corrupted_rollback_segments=(_SYSSMU12$)(#正常启库后去掉此句) (屏蔽出错的事务回滚段,根据ALERT提示ORA-01555: snapshot too old: rollback segment number 12 with name "_SYSSMU12$" too small) ...
After changing the Undo tablespace to a new tablespace and making the old undo tablespace offline, you observe following errors while performing database operations.ORA-00604: error occurred at recursive SQL level 1 ORA-00376: File xx Cannot be Read at This Time ORA-01110: data file 2: '...
当你的数据库因为ORA-00600/ORA-07445或其他ORA-报错，或丢失关键的system表空间数据文件，或ASM diskgroup损坏时均可以考虑采用PRM-DUL来做恢复。PRM-DUL采用独创的DataBridge恢复技术，直接从数据文件中抽取数据后可以像DBLINK那样直接插入到新建数据库中，而无需数据落地成为DMP文件占用空间。
/u01/app/oracle/oradata/orcl/undotbs01.dbf FILE# --- NAME --- 4 /u01/app/oracle/oradata/orcl/users01.dbf 5 /u01/app/oracle/oradata/orcl/users02.dbf SQL> alter database datafile 5 offline; Database altered. SQL> alter database ...
ORA-600[4913]错误的2个argument的含义, 该ORA-600[4913]属于内核undo事务模块 [a] Undo record seq number [b] Redo record seq number ORA-600[4913]相关的bug如下：14034244 11.2.0.3.BP09, 12.1.0.0 Lost write type corruption using ASM in 11.2.0.3 8240762 10.2.0.5,11.1...
FILE# --- NAME --- --- 1 /u01/app/oracle/oradata/orcl/system01.dbf 2 /u01/app/oracle/oradata/orcl/sysaux01.dbf 3 /u01/app/oracle/oradata/orcl/undotbs01.dbf FILE# --- NAME --- --- 4