Incomplete Recovery Incomplete recovery reconstructs the database to a prior point in time (before the time of the failure). Note: This situation results in the loss of data from transactions committed after the time of recovery. This data will need to be reentered manually if required. Perform this recovery only when absolutely necessary. Incomplete recovery can be a difficult and time-consuming operation. To performing incomplete recovery, you need: A valid offline or online backup of all of the datafiles made before the recovery point All archived logs from the backup until the specified time of recovery Incomplete recovery is typically used when a complete recovery. | User-Managed Incomplete Recovery Objectives After completing this lesson, you should be able to do the following: Describe the steps of incomplete recovery Perform an incomplete database recovery Identify the loss of current online redo log files Incomplete Recovery Overview Instance SGA Redo log buffer Data buffer Large Pool Locks Shared pool Data dict. cache Shared SQL and PL/SQL PMON DBWn SMON LGWR CKPT ARCn User process Server process PGA User process Server process PGA Parameter file Password file Archived log files 1 1 Database Datafile 1 Datafile 2 Datafile 3 Control files Redo log file 1 Redo log file 2 0 1 1 1 Incomplete Recovery Incomplete recovery reconstructs the database to a prior point in time (before the time of the failure). Note: This situation results in the loss of data from transactions committed after the time of recovery. This data will need to be reentered manually if required. Perform this recovery only when absolutely necessary. Incomplete recovery can be | User-Managed Incomplete Recovery Objectives After completing this lesson, you should be able to do the following: Describe the steps of incomplete recovery Perform an incomplete database recovery Identify the loss of current online redo log files Incomplete Recovery Overview Instance SGA Redo log buffer Data buffer Large Pool Locks Shared pool Data dict. cache Shared SQL and PL/SQL PMON DBWn SMON LGWR CKPT ARCn User process Server process PGA User process Server process PGA Parameter file Password file Archived log files 1 1 Database Datafile 1 Datafile 2 Datafile 3 Control files Redo log file 1 Redo log file 2 0 1 1 1 Incomplete Recovery Incomplete recovery reconstructs the database to a prior point in time (before the time of the failure). Note: This situation results in the loss of data from transactions committed after the time of recovery. This data will need to be reentered manually if required. Perform this recovery only when absolutely necessary. Incomplete recovery can be a difficult and time-consuming operation. To performing incomplete recovery, you need: A valid offline or online backup of all of the datafiles made before the recovery point All archived logs from the backup until the specified time of recovery Incomplete recovery is typically used when a complete recovery operation fails. Situations Requiring Incomplete Recovery Complete recovery fails because an archived log is lost. All unarchived redo log files and a datafile are lost. User error An important table was dropped. Invalid data was committed in a table. Current control file is lost and a backup control file must be used to open the database. Common Situations Requiring the Performance of Incomplete Recovery Missing archive: A complete recovery operation fails because of a bad or missing archived log. Recovery can only be completed to a time in the past, prior to applying the archived log. Loss of redo logs: Redo logs were not mirrored and you lost a redo log before it was archived, .
