System News
Approaches to Backup and Recovery for Oracle Databases
How to Use the Snapshot Feature of the Sun Storage 7000 Unified Storage System
July 30, 2009,
Volume 137, Issue 5

Oracle database backup and restore techniques for the Sun Storage 7000 Unified Storage System
 

The BigAdmin paper on "Backup and Recovery for Oracle Databases With Snapshot Feature of Sun Storage 7000 Unified Storage System" makes the most of the web-based GUI common to all products in the Sun Storage 7000 Unified Storage System family. Authors Sridhar Ranganathan and Jeffrey Wright note that this common feature enables their research on the methodologies to be followed for performing backup and recovery operation of Oracle databases using the snapshot, clone, and rollback features to generalize to the entire product line.

The comprehensive data protection features that provide instant snapshots, cloning, rollback, and remote replication in the Sun Storage 7000 Series Unified Storage System can make database protection and maintenance tasks easier for systems and database administrators responsible for Oracle database administration, the authors write.

Among the topics the paper covers are:

  • Consistent cold-backup point-in-time copy using the snapshot feature
  • Hot-backup point-in-time copy using the snapshot feature
  • Using the clone feature for backup, test, and data verification
  • Using the rollback feature to restore database files

In their study the authors used Oracle versions 9.2, 10.2 and 11.1.6 as well as the Solaris 10 5/08 OS for SPARC and x64 platforms, along with Red Hat Enterprise Linux (RHEL) 5.2 x64.

The paper provides information on the projects and file system details in the study, and it also notes that the Oracle database was already running on the database server (client) accessing the Sun Storage 7000 Unified Storage System for the database using the NFS protocol. Further, the user, roles, project, and SSH were configured as described in these BigAdmin articles about the Sun Storage 7000 Unified Storage System:

Deploying Oracle Databases Using NFS on Sun Storage 7000 Unified Storage System Deploying Oracle ASM Using iSCSI on Sun Storage 7000 Unified Storage System

The paper points out that Sun Storage 7000 Unified Storage System provides a convenient way to take a point-in-time snapshot copy of either the share or the project containing the database files. Snapshots are read-only copies. In a project level snapshot, every share under the project has its own copy of the snapshot, all with the same snapshot name. The snapshot uses a copy-on-write method and hence doesn't occupy any space at the beginning. When new data is written to the share, the old copy is written to the snapshot. The Sun Storage 7000 Unified Storage System can support an unlimited number of snapshots, all of which are dependent on the parent share.

Also included in the paper are the scripts required for a cold backup, as well as those necessary for a hot backup. In addition, the processes for cloning and accessing snapshots are outlined.

Finally, the authors take up the ability of the Sun Storage 7000 Unified Storage System to restore a file system or the LUN by employing rollback of file shares. The script for this process is provided as well. The manual process for restoration of selected data files from a snapshot is also outlined.

More Information

Sun Storage 7000 Unified Storage System

Disaster Recovery Solution for Oracle Databases Using Remote Replication

Read More ... [...read more...]

Keywords:

fullsource
 

Other articles in the OpenStorage section of Volume 137, Issue 5:

See all archived articles in the OpenStorage section.

Popular Articles in
Vol 197, Issue 4
Popular IT Articles





Popular Articles in
Vol 197, Issue 4
Popular IT Articles


News and Solutions for Users of Solaris, Java and Oracle's Sun hardware products
Just the news you need, none of what you don't – 42,000+ Members – 24,000+ Articles Published since 1998