
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