Chapter 15. Backup, restore, and disaster recovery of Oracle using N series 309
Use server operating system–level commands to copy data to create backups
Use NDMP commands to back up data to an N series product
Use NDMP commands to back up data to a tape storage device
Use third-party backup tools to back up the IBM System Storage N series to tape or to
other storage devices
15.1.1 Creating online backups using Snapshot copies
The IBM System Storage N series Snapshot technology makes extremely efficient use of
storage by storing only block-level changes between creating each successive Snapshot
copy. Since the Snapshot process is virtually instantaneous, backups are fast and simple.
Snapshot copies can be automatically scheduled. They can be called from a script running on
a server, or they can be created via SnapDrive or SnapManager.
Data ONTAP includes a scheduler to automate Snapshot backups. Use automatic Snapshot
copies to back up non application data, such as home directories.
Database and other application data should be backed up when the application is in its
backup mode. For Oracle Databases this means placing the database tablespaces into hot
backup mode prior to creating a Snapshot copy.
15.1.2 Recovering individual files from a Snapshot copy
Individual files and directories can be recovered from a Snapshot copy by using native
commands on the server, such as the UNIX cp command or dragging and dropping in
Microsoft Windows. Data can also be recovered using the single-file SnapRestore command.
Use the method that works most quickly.
15.1.3 Recovering data using SnapRestore
SnapRestore quickly restores a file system to an earlier state preserved by a Snapshot copy.
SnapRestore can be used to recover an entire volume of data or individual files within that
When using SnapRestore to restore a volume of data, the data on that volume should belong
to a single application. Otherwise operation of other applications may be adversely affected.
The single-file option of SnapRestore allows individual files to be selected for restore without
restoring all of the data on a volume. Be aware that the file being restored using SnapRestore
cannot exist anywhere in the active file system. If it does, the appliance will silently turn the
single-file SnapRestore into a copy operation. This may result in the single-file SnapRestore
taking much longer than expected (normally the command executes in a fraction of a second)
and also requires that sufficient free space exist in the active file system.
Note: IBM System Storage N series recommends using Snapshot copies for performing
cold or hot backup of Oracle Databases. No performance penalty is incurred for creating a
Snapshot copy. We recommend that you turn off the automatic Snapshot scheduler and
coordinate the Snapshot copies with the state of the Oracle Database.