oracle datafile损坏,急求，系统断电后 oracle 11g 无法启动，recover datafile 3的修复办法！！...

能否给一个实例，sql命令？11g的

我在网上搜到的是9i的。

如下：

３ 查看rollback_segments

SQL> show parameter rollback

NAME TYPE VALUE

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

fast_start_parallel_rollback string LOW

max_rollback_segments integer 37

rollback_segments string

transactions_per_rollback_segment integer 5

４ 修改初始化参数

###########################################

# System Managed Undo and Rollback Segments

###########################################

undo_management=MANUAL

undo_retention=10800

undo_tablespace=undotbs01

rollback_segments='SYSTEM'

５ 启动数据库

SQL> connect sys/oracle as sysdba

Connected.

SQL> startup force

ORACLE instance started.

...

Database mounted.

ORA-01157: cannot identify/lock data file 2 - see DBWR trace file

ORA-01110: data file 2: '/home/oracle/oradata/esal/undotbs01.dbf'

６将undotbs01离线；

SQL> alter database datafile '/home/oracle/oradata/esal/undotbs01.dbf' offline drop;

Database altered.

SQL> alter database open;

Database altered.

７删除undotbs01

SQL> drop tablespace undostb01;

Tablespace dropped.

８创建新的UNDO文件

SQL> create undo tablespace undotbs1 datafile '/home/oracle/oradata/esal/undotbs01.dbf' size 200M autoextend on;

Tablespace created.

９修改参数文件；

SQL> create spfile from pfile;

File created.

将参数文件修改如下：

###########################################

# System Managed Undo and Rollback Segments

###########################################

undo_management=AUTO

undo_retention=10800

undo_tablespace=undotbs01

１０重新打开数据库

SQL> connect xxx/xxx@xxx as sysdba

Connected.

SQL> startup force

ORACLE instance started.

Database mounted.

Database opened.

不知是否可行？