Skip to Main Content
Oracle SQL*Plus: The Definitive Guide
book

Oracle SQL*Plus: The Definitive Guide

by Jonathan Gennick
March 1999
Intermediate to advanced content levelIntermediate to advanced
528 pages
14h 39m
English
O'Reilly Media, Inc.
Content preview from Oracle SQL*Plus: The Definitive Guide

RECOVER

The RECOVER command initiates media recovery on a database, a tablespace, or a datafile. Chapter 10 provides an explanation of how recovery works. You must be connected as SYSDBA, SYSOPER, or INTERNAL in order to use this command.

RECOVER [DATABASE [[UNTIL {CANCEL|CHANGE system_change_number|TIME date_time}
                  [USING BACKUP CONTROLFILE]
                  [PARALLEL([DEGREE {num_of_procs|DEFAULT}
                  |INSTANCES {num_of_inst|DEFAULT}]...)
                  |NOPARALLEL]
                  |TABLESPACE tablespace_name [,tablespace_name...]
                  [PARALLEL([DEGREE {num_of_procs|DEFAULT}
                  |INSTANCES {num_of_inst|DEFAULT}]...)
                  |NOPARALLEL]
                  |DATAFILE datafile_name [,datafile_name...]
                  [PARALLEL([DEGREE {num_of_procs|DEFAULT}
                  |INSTANCES {num_of_inst|DEFAULT}]...)
                  |NOPARALLEL]

where:

RECOVER DATABASE

Initiates media recovery on the entire database. The database must be mounted, but not open.

RECOVER TABLESPACE tablespace_name

Initiates media recovery on the specified tablespace or list of tablespaces. A maximum of 16 tablespaces may be recovered with one command. The tablespace(s) must be offline, but the database must be mounted and open.

RECOVER DATAFILE datafile_name

Initiates media recovery on the specified datafile or list of datafiles. Unlike with tablespaces, there is no limit on the number of datafiles you can recover with one command. The datafiles to be recovered must be offline. As long as none of the datafiles are part of the SYSTEM tablespace, the database may remain open.

UNTIL CANCEL

Allows you to recover one log file at a time, with the opportunity ...

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 SQL*Plus: The Definitive Guide, 2nd Edition

Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Jonathan Gennick
Oracle PL/SQL Programming, Third Edition

Oracle PL/SQL Programming, Third Edition

Steven Feuerstein, Bill Pribyl
Oracle SQL

Oracle SQL

Dan Hotka

Publisher Resources

ISBN: 1565925785Supplemental ContentCatalog PageErrata