2007年
-
编辑 删除
undotbs损坏后的恢复
undotbs损坏后的恢复[@more@]1 删除undotbs01.dbf2 连接到数据库 SQL> connect sys/oracle as sysdbaConnected.SQL> startup forceORACLE instance started.Total System Global Area 336662768 bytesFixed Size 450800 bytesVariable Size 117440512 bytesDatabase Buffers 218103808 bytesRedo Buffers 667648 bytesDatabase mounted.ORA-01157: cannot identify/lock data file 2 - see DBWR trace fileORA-01110: data file 2: '/home/oracle/oradata/esal/undotbs01.dbf'3 查看rollback_segmentsSQL> show parameter rollba
