Undo file is missing or corrupted

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;

--------------------------------------------------------------------------------------------------------------- -------------------

Example

[Email Protected]>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

[Email protected]>alter database rename file ' +data/ora11g/datafile/undotbs1.258.833721555 ' to ' +data/ora11g/ DATAFILE/UNDOTBS1.DBF ';

Database altered.

[Email protected]>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

[Email protected]>recover datafile 3;

Media recovery complete.

[Email protected]>alter database open;

Database altered.

Undo file is missing or corrupted