Skip to Main Content
Oracle DBA Pocket Guide
book

Oracle DBA Pocket Guide

by David C. Kreines
August 2005
Intermediate to advanced content levelIntermediate to advanced
154 pages
4h 48m
English
O'Reilly Media, Inc.
Content preview from Oracle DBA Pocket Guide
70
|
Oracle DBA Pocket Guide
managed_clause :=
MANAGED STANDBY DATABASE
[{NODELAY | [TIMEOUT] integer | CANCEL [IMMEDIATE
[NOWAIT]} |
[DISCONNECT [FROM SESSION]] [FINISH [NOWAIT]]]
RECOVER 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. Note
that you can use the RECOVER option of the SQL ALTER
DATABASE command to perform the same operations.
END BACKUP
Takes the database out of online backup mode.
AUTOMATIC
Causes the name of the next archived redo file to be automati-
cally 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 can also be
implemented with the SET AUTORECOVERY ON
statement.
FROM location
The location of the archived log file group. If this parameter is
missing, SQL*Plus uses the value specified in the LOG_
ARCHIVE_DEST initialization parameter.
LOGFILE filename
Specifies the name of the log file to be used for recovery.
TEST
Lets you run a trial recovery to determine if there are prob-
lems with the files that will be used in the recovery process. A
trial recovery reads through the required files but does not
write the specified changes to disk.
ALLOW integer CORRUPTION
Specifies how many corrupt blocks can be found ...
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 PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Oracle RMAN Pocket Reference

Oracle RMAN Pocket Reference

Darl Kuhn, Scott Schulze

Publisher Resources

ISBN: 9780596528843