Skip to Main Content
Oracle SQL*Plus: The Definitive Guide
book

Oracle SQL*Plus: The Definitive Guide

by Jonathan Gennick
March 1999
Intermediate to advanced content levelIntermediate to advanced
528 pages
14h 39m
English
O'Reilly Media, Inc.
Content preview from Oracle SQL*Plus: The Definitive Guide

Database Backup and Recovery

Beginning with version 8.1, SQL*Plus implements commands to manage the archiving of redo log files and to perform point-in-time recovery of a database. In order to understand how these commands work, and to place them in their proper context, you need to understand something of how backup and recovery work in an Oracle environment.

This section explains the two fundamental approaches to backing up an Oracle database, and shows you how SQL*Plus may fit into your backup process. Archive logging will be explained, and you will see how SQL*Plus can be used to start, stop, and monitor that process. Finally, you will see how the SQL*Plus RECOVER command can be used to apply archive logs to a restored database in order to get up-to-the-minute recovery.

If you are responsible for backing up an Oracle database, please do not depend on just this one chapter to show you how to do that properly. There are several excellent books on the subject. One you should become very familiar with is the Oracle8 Backup and Recovery Guide — it’s one of the manuals in the Oracle documentation set. Another book worth looking at is the Oracle8 Backup and Recovery Handbook, by Rama Velpuri and Anand Adkoli (Oracle Press, 1998). In addition, Oracle offers the three-day-long Oracle8 Backup and Recovery Workshop.

Tip

Of all the things that a database administrator is responsible for, protecting the data is probably first on the list.

The discussion of backup and recovery in this chapter ...

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.
Start your free trial

You might also like

Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Jonathan Gennick
Oracle PL/SQL Programming, Third Edition

Oracle PL/SQL Programming, Third Edition

Steven Feuerstein, Bill Pribyl
Oracle SQL

Oracle SQL

Dan Hotka

Publisher Resources

ISBN: 1565925785Supplemental ContentCatalog PageErrata