Originally posted by pando
Code:
case 2

sys@DEV817>alter database datafile 'D:\ORACLE\ORADATA\DEV817\DATA_SMALL01.DBF' offline;

Database altered.

sys@DEV817>alter database datafile 'D:\ORACLE\ORADATA\DEV817\DATA_SMALL01.DBF' online;
alter database datafile 'D:\ORACLE\ORADATA\DEV817\DATA_SMALL01.DBF' online
*
ERROR at line 1:
ORA-01113: file 8 needs media recovery
ORA-01110: data file 8: 'D:\ORACLE\ORADATA\DEV817\DATA_SMALL01.DBF'


sys@DEV817>alter database recover datafile 'D:\ORACLE\ORADATA\DEV817\DATA_SMALL01.DBF';

Database altered.
do you read the documentation at all?
this is all documentated, you do recover when mounted, alter database recover with database online [/B]
I am sorry. I might forget some details in the docs. However, is there a hard rule saying:

Use Recover Datafile when in mount mode
Use Alter database recover datafile when in open mode

??
I don't think so. (Would u please show me the link to the doc.)

Also, I made the following test. While the db is still open, I COULD NOT use "alter database recover datafile". Your input is very appreciated.

SQL> alter database datafile '/export/home/u01/oradata/ktvw/users01.dbf' offline;

Database altered.

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> alter database datafile '/export/home/u01/oradata/ktvw/users01.dbf' online;
alter database datafile '/export/home/u01/oradata/ktvw/users01.dbf' online
*
ERROR at line 1:
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: '/export/home/u01/oradata/ktvw/users01.dbf'


SQL> alter database recover datafile '/export/home/u01/oradata/ktvw/users01.dbf';
alter database recover datafile '/export/home/u01/oradata/ktvw/users01.dbf'
*
ERROR at line 1:
ORA-00279: change 479108523 generated at 05/07/2002 15:42:09 needed for thread 1
ORA-00289: suggestion : /export/home/u03/arch/ktvw/arch_1_667.arc
ORA-00280: change 479108523 for thread 1 is in sequence #667


SQL>