Name

SET AUTORECOVERY

Synopsis

The AUTORECOVERY setting causes the RECOVER command to run without user intervention, as long as the archived log files are in the destination pointed to by the LOG_ARCHIVE_DEST parameter and the names conform to the LOG_ARCHIVE_FORMAT parameter.

Syntax

SET AUTORECOVERY {OFF | ON}

Parameters

OFF

Turns off autorecovery. This is the default setting.

ON

Turns on autorecovery, causing the RECOVER command to run without user intervention.

Get Oracle SQL*Plus: The Definitive Guide, 2nd Edition 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.