MEDIA FAILURE - BASIC RECOVERY
Note: Database running in ARCHIVELOG Mode
Restore the datafiles damaged (Do not restore any ONLINE REDO LOG FILES & UNDAMAGED DATA FILES)
SVRMGR> STARTUP MOUNT
SVRMGR> SET AUTORECOVERY ON
(If number of archived redo log files is very large use this option)or
SVRMGR> RECOVER DATABASE
; (Enter AUTO when prompted for an archived redo log file name)Log Applied
Media Recovery Complete
SVRMGR> ALTER DATABASE OPEN
;