August 2000
Intermediate to advanced
288 pages
7h 50m
English
Content preview from Oracle Parallel ProcessingBecome 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.
Backing Up an OPS Database
Backing up an OPS database is much the same as backing up a standalone database. There are only a few differences to be aware of. This section presents a brief review of database backup concepts and points out the differences between backing up a standalone instance and backing up an OPS database. We’ll briefly discuss ARCHIVELOG mode, cold and hot backups, and the use of standby databases and the Oracle8 Recovery Manager from an OPS.
ARCHIVELOG Mode
An Oracle database can run in either NOARCHIVELOG mode or ARCHIVELOG mode. In NOARCHIVELOG mode, the redo log files are recycled and overwritten without being saved offline. In ARCHIVELOG mode, the redo log files are archived before they are overwritten. Running in NOARCHIVELOG mode leaves open the possibility of data loss in the event of a failure. Complete and up-to-the-minute recovery from a failure is possible only when running in ARCHIVELOG mode. You must run the database in ARCHIVELOG mode if you want to do any of the following:
Recover completely from a media failure
Perform point-in-time recovery
Perform a hot (online) backup
The following sections describe how to enable ARCHIVELOG mode and set the corresponding initialization parameters.
Setting initialization parameters for ARCHIVELOG mode
To run a parallel server database in ARCHIVELOG mode, set the following three initialization parameters on each instance:
- LOG_ARCHIVE_START
Enables automatic archiving. When this parameter is set to TRUE, Oracle will ...
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.