Skip to Content
Unix Backup and Recovery
book

Unix Backup and Recovery

by W. Curtis Preston
November 1999
Intermediate to advanced
736 pages
22h 46m
English
O'Reilly Media, Inc.
Content preview from Unix Backup and Recovery

Physical Backups Without a Storage Manager

Storage managers can be very expensive, so they are not always available for every application. Even if you have a storage manager, you may not want to spend several thousand dollars per server for the Oracle interface. This section discusses methods that can be used to safely back up Oracle without using a storage manager. You can back up to disk and then back that disk up using your normal backup procedures, or you can back up directly to tape.

Like most RDBMSs, Oracle databases can reside on cooked filesystem files or raw disk devices. Unlike Sybase and Informix DBAs, though, Oracle DBAs typically have put their databases on cooked files. There is a very good reason for this: if all of the database files are accessible via the filesystem, backing up is very simple. That is because copying the data can be done by any standard copy (cp) utility or backup (dump, cpio) utility.

Backups can be done offline (a cold backup) or online (a hot backup).

Cold Backup

A cold backup of an Oracle database that is based on filesystem files is the easiest of all database backups. This is because most companies already have some system that backs up their filesystem files. It could be a homegrown program that runs dump, or it could be a commercial backup product. To perform a cold backup of an Oracle database, simply shut down Oracle before running the normal backup. Oracle will do a checkpoint, flushing any data stored in memory to disk, and then stop all ...

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

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’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.
Head of Cybersecurity
QuotationMarkI 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.
Field Engineer
QuotationMarkI’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.
Data Platform Tech Lead
QuotationMarkI'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.
Mark W.
Embedded Software Engineer

You might also like

Oracle® Solaris 11 System Administration

Oracle® Solaris 11 System Administration

Bill Calkins

Publisher Resources

ISBN: 1565926420Catalog PageErrata