Oracle in a Nutshell

Name

RECOVER

Synopsis

RECOVER {general_clause | managed_clause | END BACKUP}

general_clause :=
[AUTOMATIC] [FROM location]
        {{full_database_recovery_options | 
        partial_database_recovery_options |
        LOGFILE filename}
        {[TEST | ALLOW integer CORRUPTION]} ... |
        CONTINUE [DEFAULT] | CANCEL}
        [PARALLEL [integer]]

full_database_recovery_options := 
[STANDBY] DATABASE 
        [{UNTIL {CANCEL | TIME date | CHANGE integer} |
        USING BACKUP CONTROLFILE]

partial_database_recovery_options :=
TABLESPACE tablespace_name [, tablespace_name] . . . |
        DATAFILE datafile_name [, datafile_name] . . . |
        STANDBY {TABLESPACE tablespace_name [, tablespace_name] . . . |
                DATAFILE datafile_name [, datafile_name] . . .}
                UNTIL [CONSISTENT WITH] CONTROLFILE

managed_clause :=
        MANAGED STANDBY DATABASE
        [{NODELAY | [TIMEOUT] integer | CANCEL [IMMEDIATE] [NOWAIT]} |
        [DISCONNECT [FROM SESSION]] [FINISH [NOWAIT]]]

SQL*Plus command. Applies the appropriate log files to a datafile to restore the database. This operation rolls forward the transactions from the logs and then rolls back the uncommitted transactions.

You can use the RECOVER option of the SQL ALTER DATABASE statement to perform the same operations.

Keywords

END BACKUP

Takes the database out of online backup mode.

AUTOMATIC

Causes the name of the next archived redo file to be automatically generated, based on the LOG_ARCHIVE_DEST and LOG_ARCHIVE_FORMAT parameters. If no file matching the automatically generated name exists, SQL*Plus prompts you for the name of the file. This functionality ...