oracle让数据文件online,[求助]数据文件为recover状态,如何让其ONLINE

数据库的数据文件变为recover状态,如何让其ONLINE,如下是个人的操作步骤:

SQL> select status,name from v$datafile;

STATUS  NAME

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

SYSTEM  /opt/oracle/oradata/dzj01/system01.dbf

ONLINE  /opt/oracle/oradata/dzj01/sysaux01.dbf

ONLINE  /opt/oracle/oradata/dzj01/users01.dbf

RECOVER /opt/oracle/product/10.2/db_1/dbs/ultranms_performance.dbf

RECOVER /opt/oracle/product/10.2/db_1/dbs/ultranms_big.dbf

ONLINE  /opt/oracle/product/10.2/db_1/dbs/ultranms_small.dbf

ONLINE  /opt/oracle/product/10.2/db_1/dbs/ultranms_index.dbf

ONLINE  /opt/oracle/product/10.2/db_1/dbs/ultranms_default.dbf

ONLINE  /opt/oracle/oradata/dzj01/undotbs.dbf

9 rows selected.

SQL> alter database datafile '/opt/oracle/product/10.2/db_1/dbs/ultranms_big.dbf' online;

alter database datafile '/opt/oracle/product/10.2/db_1/dbs/ultranms_big.dbf' online

*

ERROR at line 1:

ORA-01113: file 6 needs media recovery

ORA-01110: data file 6: '/opt/oracle/product/10.2/db_1/dbs/ultranms_big.dbf'

SQL> recover datafile 6;

ORA-00279: change 17000140 generated at 11/08/2007 14:52:17 needed for thread 1

ORA-00289: suggestion :

/opt/oracle/flash_recovery_area/DZJ01/archivelog/2008_02_29/o1_mf_1_1174_%u_.arc

ORA-00280: change 17000140 for thread 1 is in sequence #1174

Specify log: {=suggested | filename | AUTO | CANCEL}

auto

ORA-00308: cannot open archived log

'/opt/oracle/flash_recovery_area/DZJ01/archivelog/2008_02_29/o1_mf_1_1174_%u_.ar

c'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

ORA-00308: cannot open archived log

'/opt/oracle/flash_recovery_area/DZJ01/archivelog/2008_02_29/o1_mf_1_1174_%u_.ar

c'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

SQL> recover datafile 6;

ORA-00279: change 17000140 generated at 11/08/2007 14:52:17 needed for thread 1

ORA-00289: suggestion :

/opt/oracle/flash_recovery_area/DZJ01/archivelog/2008_02_29/o1_mf_1_1174_%u_.arc

ORA-00280: change 17000140 for thread 1 is in sequence #1174

Specify log: {=suggested | filename | AUTO | CANCEL}

cancel

Media recovery cancelled.

SQL> alter database datafile 6 online;

alter database datafile 6 online

*

ERROR at line 1:

ORA-01113: file 6 needs media recovery

ORA-01110: data file 6: '/opt/oracle/product/10.2/db_1/dbs/ultranms_big.dbf'