Complete database recovery from disk failure is possible only in archivelog mode.Online database backup is possible only in archivelog mode.
Close the database, dismount the database and shutdown the instance
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed...
An instance can be started in (or later altered to be in) restricted mode so that when the database is open connections are limited only to those whose user accounts have been granted the restricted session system privilege.