Recovery from failed hot backup
When oracle database hotbackup is running and suddenly system is crashed.
. When you start the database it will raise errors like file# needs recovery.
Recovery process
Svrmgrl> CONNECT INTERNAL;
connected
Svrmgrl> STARTUP NOMOUNT;
Oracle instance started
Database mounted
Svrmgrl> ALTER DATABASE OPEN;
Now errors will be raised like
ORA-01113 File 2 needs media recovery
ORA-1110 : data file 2: '/vol01/PCDB/p_data02.dbf'
Svrmgrl> ALTER DATABASE DATAFILE '/vol01/PCDB/p_data02.dbf' END BACKUP;
Statement processed
Svrmgrl> ALTER DATABASE OPEN;