Abongwa

I agree with you : Here is the proof

*** Without Log switches ***

SVRMGR> alter database datafile '/u06/oradata/testDB/users_TESTDB.dbf' offline;
Statement processed.
SVRMGR> alter database datafile '/u06/oradata/testDB/users_TESTDB.dbf' online;
alter database datafile '/u06/oradata/testDB/users_TESTDB.dbf' online
*
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: '/u06/oradata/testDB/users_TESTDB.dbf'
SVRMGR> shutdown abort;
ORACLE instance shut down.
SVRMGR> startup mount;
ORACLE instance started.
Total System Global Area 25444776 bytes
Fixed Size 94632 bytes
Variable Size 24989696 bytes
Database Buffers 204800 bytes
Redo Buffers 155648 bytes
Database mounted.
SVRMGR> alter database recover datafile '/u06/oradata/testDB/users_TESTDB.dbf';
Statement processed.
SVRMGR> alter database open;
Statement processed.
SVRMGR>


Case 2: *** With Logswitches ....
SVRMGR> alter database datafile '/u06/oradata/testDB/users_TESTDB.dbf' offline;
Statement processed.
SVRMGR> alter database datafile '/u06/oradata/testDB/users_TESTDB.dbf' online;
alter database datafile '/u06/oradata/testDB/users_TESTDB.dbf' online
*
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: '/u06/oradata/testDB/users_TESTDB.dbf'
SVRMGR> alter system switch logfile;
Statement processed.
SVRMGR> alter system switch logfile;
Statement processed.
SVRMGR> alter system switch logfile;
Statement processed.
SVRMGR> alter system switch logfile;
Statement processed.
SVRMGR> alter system switch logfile;
Statement processed.
SVRMGR> alter system switch logfile;
Statement processed.
SVRMGR> alter system switch logfile;
Statement processed.
SVRMGR> alter system switch logfile;
Statement processed.
SVRMGR> alter system switch logfile;
Statement processed.
SVRMGR> alter system switch logfile;
Statement processed.
SVRMGR> recover datafile '/u06/oradata/testDB/users_TESTDB.dbf';
ORA-00279: change 337664 generated at 05/08/2002 15:14:22 needed for thread 1
ORA-00289: suggestion : /u06/oradata/testDB/arch/arch_1_798.arc
ORA-00280: change 337664 for thread 1 is in sequence #798
Specify log: {=suggested | filename | AUTO | CANCEL}

Log applied.
Media recovery complete.


Case 3: With Log Switches...
SVRMGR> alter database datafile '/u06/oradata/testDB/users_TESTDB.dbf' offline;
Statement processed.
SVRMGR> alter database datafile '/u06/oradata/testDB/users_TESTDB.dbf' online;
alter database datafile '/u06/oradata/testDB/users_TESTDB.dbf' online
*
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: '/u06/oradata/testDB/users_TESTDB.dbf'
SVRMGR> alter system switch logfile;
Statement processed.
SVRMGR> alter system switch logfile;
Statement processed.
SVRMGR> alter system switch logfile;
Statement processed.
SVRMGR> alter system switch logfile;
Statement processed.
SVRMGR> alter system switch logfile;
Statement processed.
SVRMGR> alter system switch logfile;
Statement processed.
SVRMGR> alter system switch logfile;
Statement processed.
SVRMGR> alter system switch logfile;
Statement processed.
SVRMGR> alter system switch logfile;
Statement processed.
SVRMGR> alter system switch logfile;
Statement processed.
SVRMGR> alter system switch logfile;
Statement processed.
SVRMGR> shutdown abort;
ORACLE instance shut down.
SVRMGR> startup mount;
ORACLE instance started.
Total System Global Area 25444776 bytes
Fixed Size 94632 bytes
Variable Size 24989696 bytes
Database Buffers 204800 bytes
Redo Buffers 155648 bytes
Database mounted.
SVRMGR> alter database recover datafile '/u06/oradata/testDB/users_TESTDB.dbf';
alter database recover datafile '/u06/oradata/testDB/users_TESTDB.dbf'
*
ORA-00279: change 337678 generated at 05/08/2002 15:21:07 needed for thread 1
ORA-00289: suggestion : /u06/oradata/testDB/arch/arch_1_808.arc
ORA-00280: change 337678 for thread 1 is in sequence #808
SVRMGR> recover datafile '/u06/oradata/testDB/users_TESTDB.dbf';
ORA-00275: media recovery has already been started
SVRMGR> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SVRMGR> startup mount;
ORACLE instance started.
Total System Global Area 25444776 bytes
Fixed Size 94632 bytes
Variable Size 24989696 bytes
Database Buffers 204800 bytes
Redo Buffers 155648 bytes
Database mounted.
SVRMGR> recover datafile '/u06/oradata/testDB/users_TESTDB.dbf';
ORA-00279: change 337678 generated at 05/08/2002 15:21:07 needed for thread 1
ORA-00289: suggestion : /u06/oradata/testDB/arch/arch_1_808.arc
ORA-00280: change 337678 for thread 1 is in sequence #808
Specify log: {=suggested | filename | AUTO | CANCEL}

Log applied.
Media recovery complete.
SVRMGR>