Recovery is of 2 types :
incomplete recovery
complete recovery
Complete recovery means there will be no loss of data.
In case of incomplete recovery there will be loss of data.
Loss of current online redo log files leads to incomplete recovery.
In case of incomplete recovery we open the database with reset logs.
Whenever we open the database with reset logs, oracle creates brand new online redo logs starting with the log sequence one and generates a new incornation number for the database.
Theonly scenario where we open the database with reset logs but still it is complete recovery is in case of loss of current control file.
Along with the database backup it is also recommanded to backup pfile/spfile and archive logs.
During the process of recovery, oracle applies the generated archive logs in the same sequence.
Prior to 10g, whenever we open the database with reset logs, recommanded to take the backup of database or atleast the current control file.
Prior to 10g, the child incornation archive logs cannot be applied to the parent incornation(because of this reason, recommanded to take the backup of the database).
incomplete recovery
complete recovery
Complete recovery means there will be no loss of data.
In case of incomplete recovery there will be loss of data.
Loss of current online redo log files leads to incomplete recovery.
In case of incomplete recovery we open the database with reset logs.
Whenever we open the database with reset logs, oracle creates brand new online redo logs starting with the log sequence one and generates a new incornation number for the database.
Theonly scenario where we open the database with reset logs but still it is complete recovery is in case of loss of current control file.
Along with the database backup it is also recommanded to backup pfile/spfile and archive logs.
During the process of recovery, oracle applies the generated archive logs in the same sequence.
Prior to 10g, whenever we open the database with reset logs, recommanded to take the backup of database or atleast the current control file.
Prior to 10g, the child incornation archive logs cannot be applied to the parent incornation(because of this reason, recommanded to take the backup of the database).
