Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page