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.
Sun Storage 7000 Unified Storage System
Disaster Recovery Solution for Oracle Databases Using Remote Replication
Read More ...