January 2007
Intermediate to advanced
760 pages
25h 14m
English
Content preview from Backup & RecoveryBecome 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.
Chapter 16. Oracle Backup and Recovery
Oracle is a very popular commercial relational database management system with a very large installed base. Oracle can be backed up using two very different methods, and each method has its advantages and disadvantages—and its strong supporters and detractors.
Two Backup Methods
The backup and recovery method with the most history is now called user-managed backup. A user-managed backup consists of putting the Oracle database into a “backup friendly” state, then backing up its files using whatever tool strikes your fancy. Once the files have been backed up, you can take the database out of its “backup friendly” state. User-managed backup is documented and supported, but is not what Oracle would prefer you do.
The preferred method of backing up Oracle databases is the Recovery Manager (rman), which was first available in Oracle 8. The rman utility can be used independently or with a commercial
backup utility to back up Oracle to disk or tape. It offers a number of advantages over
user-managed backups, including incremental backups, data integrity checks, block-level
media recovery, and guided restores. Those who have learned rman swear by it, especially the new and improved version available in Oracle
10g.
Tip
As of this writing, approximately half the Oracle community is using rman and half is performing user-managed backups. Both
methods will be covered in this chapter, starting with this comparison of the
two.
rman
rman has a number of advantages ...
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.