December 2002
Intermediate to advanced
928 pages
85h 29m
English
RECOVER
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.
Takes the database out of online backup mode.
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 ...