首页 > 代码库 > undo文件丢失或损坏
undo文件丢失或损坏
startup mount
cp +DATA/ora11g/datafile/undotbs1.dbf
alter database rename file
‘+DATA/ora11g/datafile/undotbs1.258.833721555‘ to ‘+DATA/ora11g/datafile/undotbs1.dbf‘;
select file#,name from v$datafile;
recover datafile 3;
alter database open;
----------------------------------------------------------------------------------------------------------------------------------
示例
SYS@ora11g>startup
ORACLE instance started.
Total System Global Area 830930944 bytes
Fixed Size 2231048 bytes
Variable Size 616563960 bytes
Database Buffers 205520896 bytes
Redo Buffers 6615040 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
ORA-01110: data file 3: ‘+DATA/ora11g/datafile/undotbs1.258.833721555‘
cp +DATA/ora11g/datafile/undotbs1.dbf
SYS@ora11g>alter database rename file ‘+DATA/ora11g/datafile/undotbs1.258.833721555‘ to ‘+DATA/ora11g/datafile/undotbs1.dbf‘;
Database altered.
SYS@ora11g>select file#,name from v$datafile;
FILE# NAME
---------- ---------------------
1 +DATA/ora11g/datafile
/system.256.833721555
2 +DATA/ora11g/datafile
/sysaux.257.833721555
3 +DATA/ora11g/datafile
/undotbs1.dbf
4 +DATA/ora11g/datafile
/users.259.833721555
5 +DATA/ora11g/datafile
/example.269.83372171
1
SYS@ora11g>recover datafile 3;
Media recovery complete.
SYS@ora11g>alter database open;
Database altered.
undo文件丢失或损坏