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 SVRMGR command before you enter the Recover command.

• set autorecovery on

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 Archiving Parameters).

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 = . This means the files will now be expected in the directory identified under logsource .

• set autorecovery off

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

• cancel
to interrupt or cancel the recovery.
• auto
to continue the recovery in automatic mode from this point.
• from
to change the log source.