August 2005
Intermediate to advanced
154 pages
4h 48m
English
Content preview from Oracle DBA Pocket Guide
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,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
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.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.