AUTORECOVERY
AUTORECOVERY {ON | OFF} 

Controls whether the RECOVER command runs without user intervention. This variable is intended for DBAs.

Keywords

ON

Specifies that autorecovery be used. Autorecovery allows the RECOVER command to be run automatically, as long as the archived log files are located in the destination to which the INIT.ORA file's LOG_ARCHIVE_DEST parameter points.

OFF

Specifies that autorecovery is not enabled and that user intervention is required to specify log file names when using the RECOVER command. This option is the default.

Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.