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

Name

ALTER SYSTEM SUSPEND/RESUME

Synopsis

ALTER SYSTEM SUSPEND | RESUME

SQL*Plus command. Suspends all I/O operations to the database to accommodate third-party products that require this type of pause.

At many sites, third-party tools are used to mirror an Oracle database. You can back up the mirrored database without affecting online operations by splitting the mirror and then backing it up. However, some mirrored systems cannot be split while there are I/O operations occurring, so in these cases you will have to suspend I/O while you are splitting the mirror.

Make sure to put the relevant tablespaces in BACKUP mode before you suspend I/O and take them back out of BACKUP mode after you resume I/O operations.

Note that there are many other options for the ALTER SYSTEM command in addition to those shown here. That command is described in Chapter 7. See the index for specific pointers to the discussion of additional command keywords.

Keywords

SUSPEND

Suspends all I/O operations to all database files.

RESUME

Resumes I/O operations to all database files.

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