Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

User-Managed Backup and Recovery

User-managed backup and recovery is a process that allows you to back up and restore your Oracle database by issuing an appropriate combination of operating system commands, SQL*Plus commands, and custom Oracle utility commands.

At this time, Recovery Manager (RMAN), described later in this chapter, has largely replaced user-managed backup and recovery, and Oracle Corporation is no longer enhancing its older user-managed backup and recovery processes. RMAN provides all of the capabilities of user-managed backup and recovery, offers quite a few additional features, and is easier to use than user-managed backup and recovery.

Nevertheless, user-managed backup and recovery still works, and there may be reasons why you may prefer to use this method. For example, you may be supporting Oracle databases prior to Oracle8, when RMAN was introduced; your staff may not be as familiar with RMAN as with these older procedures; or your own administrative plan may not yet have been changed to embrace RMAN.

With user-managed backup and recovery, you can make either consistent or inconsistent backups. The processes differ depending on what type of backup you are performing:

Consistent backup

To make a consistent backup, you must shut down the database normally. Consistent backups are the only type of backup supported in NOARCHIVELOG mode, because recovery cannot be performed in this mode.

Inconsistent backup

You can make an inconsistent backup with the database (or ...

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 Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page