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
58
|
Oracle DBA Pocket Guide
User-Managed Backup and Recovery
It is possible to back up and recover a database using a com-
bination of operating system commands. While automated
recovery is fully supported by Oracle using the RMAN util-
ity, many Oracle DBAs still prefer to manage backups
directly.
Archivelog mode
When you run the database in archivelog mode, Oracle saves
a copy of the redo logs into separate files called offline redo
ROWS=Y CONTENT=ALL
SHOW SQLFILE
SKIP_UNUSABLE_INDEXES SKIP_UNUSABLE_INDEXES
STATISTICS No corresponding parameter
STREAMS_CONFIGURATION STREAMS_CONFIGURATION
STREAMS_INSTANTIATION No corresponding parameter
TABLES TABLES
TABLESPACES This parameter still exists, but some of its functionality
is now performed using the TRANSPORT_TABLESPACES
parameter
TOID_NOVALIDATE No corresponding parameter; OIDs are no longer used
for type validation
TOUSER REMAP_SCHEMA
TTS_OWNERS No corresponding parameter
USERID No corresponding parameter; this information is
supplied as the username/password when you invoke
Import
VOLSIZE No corresponding parameter; tapes are no longer
supported
Table 3. Comparison of Original Import and Data Pump Import
parameters (continued)
Original Import Data Pump Import
Backup and Recovery
|
59
logs. Just as it uses the redo logs to perform the roll-forward
process when restarting ...
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