Automating the Recovery
You can control whether you want to perform a manual (
autorecovery off) or an automatic recovery (autorecovery on). To do this, enter the appropriate SQLPLUS command before you enter the Recover command.The required offline redo log files are automatically processed without requiring any user entry. The names and paths of the offline redo log files are derived from the init.ora parameters
log_archive_dest and log_archive_format, which means that that required offline redo log files must first be imported under the appropriate names (see Setting Up Archiving).If the files cannot be imported under
log_archive_dest, you can override the source specified in archive_log_dest by entering the command set logsource = <log source>. This means the files will now be expected in the directory identified under logsource.The processing of the individual redo log files must be initiated by the user (default value).
In the process, Oracle automatically suggests a file derived from
log_archive_dest (or logsource) and log_archive_format. Press RETURN to accept this value.You can also explicitly enter the name of the redo log files.
Enter