In the event of logfile corruption, specifies the number of corrupt blocks that can be tolerated while allowing recovery to proceed. During normal recovery, integer cannot exceed 1. You can only use the TEST clause for a trial recovery if you have restored a backup. Redo is applied normally, but no changes are written to disk, and changes are rolled back at the end of the trial recovery. Specifies a trial recovery to detect possible problems.

In interactive recovery mode (AUTORECOVERY OFF), if a bad log name is entered, errors for the bad log name are displayed and you are prompted to enter a new log name. Do not specify FROM if you have set a file with SET LOGSOURCE.Įnables you to specify the recovery of a full database.Įnables you to specify the recovery of individual tablespaces and datafiles.Ĭontinues media recovery by applying the specified redo log file. If you omit this parameter, SQL*Plus assumes the archived redo log file group is in the location specified by the initialization parameter LOG_ARCHIVE_DEST or LOG_ARCHIVE_DEST_1. The value of location must be a fully specified file location. Specifies the location from which the archived redo log file group is read. You can save time by using the LOGFILE clause to specify the filename if you know the archived filename differs from the filename Oracle Database would generate. You can either accept the generated filename or replace it with a fully qualified filename. If you do not specify either AUTOMATIC or LOGFILE, SQL*Plus prompts you for a filename, suggesting the generated filename. If the file is not found, SQL*Plus prompts you for a filename, displaying a generated filename as a suggestion.

If the file is found, the redo contained in that file is applied. Oracle Database uses the LOG_ARCHIVE_DEST (or LOG_ARCHIVE_DEST_ 1) and LOG_ARCHIVE_FORMAT parameters (or their defaults) to generate the target redo log filename. You must set AUTORECOVERY to ON to use the RECOVER command in iSQL*Plus.īecause of possible network timeouts, it is recommended that you use SQL*Plus command-line, not iSQL*Plus, for long running DBA operations such as RECOVER.Īutomatically generates the name of the next archived redo log file needed to continue the recovery operation. For more information on the RECOVER command, see the Oracle Database Administrator's Guide, the ALTER DATABASE RECOVER command in the Oracle Database SQL Reference, and the Oracle Database Backup and Recovery Basics guide. Performs media recovery on one or more tablespaces, one or more datafiles, or the entire database. Where the parallel_clause has the following syntax:

Where the finish_clause has the following syntax: Where the cancel_clause has the following syntax:

Sql data recovery