Datafile Recovery ( OPEN Database Recovery)
This type of Recovery can only be done if the datafiles to be recovered do not belong to the SYSTEM Tablespace.
Note: Database running in ARCHIVELOG Mode
SVRMGR> STARTUP MOUNT
SVRMGR> ALTER DATABASE DATAFILE '/dsk01/ORACLE/reco/users01.dbf' OFFLINE;
SVRMGR> ALTER DATABASE OPEN;
SVRMGR> RECOVER DATAFILE '/dsk01/ORACLE/reco/users01.dbf';
(APPLY REQD. ARCHIVELOG FILES)SVRMGR> ALTER DATABASE DATAFILE '/dsk01/ORACLE/reco/users01.dbf' ONLINE;