Transcription

An Oracle White PaperJune 2014Protecting Oracle Database Appliance – TapeBackup with CommVault Simpana

Protecting Oracle Database Appliance -Tape Backup with CommVault SimpanaDisclaimerThe following is intended to outline our general product direction. It is intended for information purposes only,and may not be incorporated into any contract. It is not a commitment to deliver any material, code, orfunctionality, and should not be relied upon in making purchasing decisions. The development, release, and timingof any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

Protecting Oracle Database Appliance -Tape Backup with CommVault SimpanaIntroduction . 1Hardware and Software . 2Simpana CommServe/Media Server . 3Oracle StorageTek Library and Tape Drives . 3OS . 3Backup Software . 3Connectivity . 3Ethernet . 3Serial Attached SCSI (SAS) . 3Diagram of Configuration . 3Date Synchronization . 4Oracle StorageTek Tape Configuration . 4Physical Attachments . 4Library Monitoring . 4Library Drive OS Verification . 5Required tnsnames.ora Changes . 6Initial Simpana Configuration . 7Modify /etc/hosts files . 7Install Simpana . 7Configure Simpana Tape Library and Tape Drives . 7Configure Simpana Storage Policy . 10Modify Simpana Storage Policy. 10Client Configuration . 12Add and Configure Oracle RAC Client . 13Discover Instances . 15Modify Client Properties . 16Create New Subclient for the RAC Client . 17Backup and Restore of Database. 18Backup Database . 18Restoring the Database . 19Restoring the Controlfile . 19Restoring the Database . 21Private Network Configuration. 23OS Setup . 23Configure Private Network Interface in Simpana . 23Simpana Tuning . 24Set Simpana Storage Policy Block Size . 24Set Simpana RAC Client Block Size . 25Conclusion . 25Additional Resources . 26

Protecting Oracle Database Appliance -Tape Backup with CommVault SimpanaIntroductionThe Oracle Database Appliance is an engineered system consisting of hardware, software, and storagethat saves customers time and money by simplifying deployment, maintenance, and support of highavailability database solutions. The Oracle Database Appliance provides double or triple mirroredredundancy using Automatic Storage Management software. The Database Appliance is comprised oftwo nodes, each having its own dedicated power, memory, CPU, RAID control, etc. to allow for maximumredundancy. It allows for single instance, Real Application Clusters (RAC) One Node or full Oracle RACconfigurations. Additionally, the Database Appliance supports virtualization using Oracle Virtual Machine(OVM). With the high level of redundancy, the chances of a physical failure are remote but still possible(ex. natural disaster or fire). There is also the possibility of logical corruption such as inadvertentlydeleted records or errors in programming. Due to the possibility of a disaster and/or logical corruption, it isstill necessary to backup up the database to provide an extra layer of data protection, along with offsitestorage capabilities. Oracle StorageTek (STK) Tape Libraries and Oracle StorageTek Tape Drives offercost effective solutions for meeting Recovery Point Objectives (RPO) and Recovery Time Objectives(RTO) for the Oracle Database Appliance. The information in this document details how to setupCommVault Simpana to backup the Oracle Database Appliance using Oracle StorageTek tape products.The information in this document is intended to detail basic configuration of CommVault Simpana on theOracle Database Appliance to allow for RMAN backups directly to tape. A restore example, privatenetwork example, and performance tuning example are also included to assist with providing additionalknowledge on using Simpana with the Oracle Database Appliance, and to assist with optimizing yourbackup environment.1

Protecting Oracle Database Appliance - Tape Backup with CommVault SimpanaHardware and SoftwareBelow is a summary of the hardware and software utilized for Oracle Database Appliance tape tests.Note: The below table only lists the combinations of hardware/software that were tested. There are newergenerations of hardware/software available. The Oracle Database Appliance has the x4-2 version available and theSimpana Media Server could be an x4-2. Based on the results of testing two generations it is not expected thatperformance will differ appreciably (especially in a two to four tape drive setup) as resources on the lowestversions of the Oracle Database Appliance (V1) and Simpana Media Server (x4170 M2) were not beingconsumed. Until a major component on the transfer bus is upgraded (Faster SAS card or newer LTO drive) theperformance characteristics should remain similar across generations of servers, Oracle Database Appliances andSimpana software.TABLE1.TEST ENVIRONMENTHARDWARE/SOFTWAREVERSIONPURPOSEOracle Database ApplianceV1, Appliance Manager 2.1.0.3.0Database ApplianceX3-2, Appliance Manager 2.6.0.0.0Oracle Linux5.5 (Oracle Database Appliance V1)OS on Database Servers5.8 (Oracle Database Appliance X3-2)Microsoft Windows ServerR2-SP1OS on Backup ServerOracle Linux 5.5 Kernel kernel-2.6.18-194.32.1.0.1.el5Kernel on Database Servers2008 R2 EnterpriseOracle Linux Kernel(V1)Oracle Linux 5.8 Kernel 2.6.32-300.32.5.el5uek (X3-2)CommVault Simpana9.0 SP6 (Used for Oracle Database Appliance V1 testing)Backup Software9.0 SP10a (Used for Oracle Database Appliance X3-2testing)Oracle Sun x4170 M2Oracle Sun X3-2Base Hardware (Used for Oracle Database Appliance V1CommVault Simpanatesting)CommServe/Media ServerBase Hardware (Used for Oracle Database Appliance X3-2testing)Oracle StorageTek SL150Latest FirmwareTape Library for BackupLTO-5 Half Height TapeLatest Firmware (Used for Oracle Database Appliance V1Tape Drives for BackupDrives (2)testing)LTO-6 Half Height TapeLatest Firmware (Used for Oracle Database Appliance X3-2Drives (2)testing)6Gb SAS HBASGX-SAS6-EXT-Z(or Oracle StorageTekSL500 or SL24/48)Tape Connectivity to MediaServer2

Protecting Oracle Database Appliance - Tape Backup with CommVault SimpanaSimpana CommServe/Media ServerTo manage the backup and recovery operations on the Oracle Database Appliance, a 1u single processor machinehas plenty of resources as the CommServe/Media Server for Simpana. Refer to the Simpana documentation linkin the Additional Resources for information.Oracle StorageTek Library and Tape DrivesOracle StorageTek SL150 with two LTO-6 tape drives. An Oracle StorageTek SL500 or Oracle StorageTekSL24/48 can also be used as the tape library.OSThe CommVault Simpana CommServe/Media Server has Windows Server 2008 R2 Enterprise installed.Backup SoftwareSimpana 9.0 SP6 or above and associated licensing.ConnectivityThis section explains the different interfaces that will be utilized in this environment.EthernetThe Simpana CommServe/Media Server requires a GbE or 10GbE connection to the Oracle Database Appliancedepending on which interface will be used for backup.Serial Attached SCSI (SAS)A single SAS HBA card in the Simpana CommServe/Media Server is used to attach each tape drive directly to thebackup server.Diagram of ConfigurationFigure 1: Physical components and connections for Oracle Database Appliance tape solution.3

Protecting Oracle Database Appliance - Tape Backup with CommVault SimpanaDate SynchronizationEnsure you are using Network Time Protocol (NTP) or have all the dates/times between all servers involved inthis configuration in sync.Oracle StorageTek Tape ConfigurationThe Oracle StorageTek (STK) SL150 is a modular library system with high capacity and high reliability which canbe attached to a host via fiber channel or SAS. This configuration will utilize a SAS connection. The SL150 is abridged library which means robot control commands are channeled through one of the tape drives (no separateconnection for the robot). If this is a new library, follow the instructions in the SL150 documentation to setup thelibrary. Following the initial setup of the SL150; connect the tape drives to the Simpana CommServe/MediaServer. To connect the SL150 to the Sun X3-2 Simpana CommServe/Media Server use SAS cables to hook eachtape drive to the SAS ports on the Sun X3-2 HBA card. (See figures 2 & 3):Physical AttachmentsFigure 2: Rear of Oracle StorageTek SL150 tape library with two LTO SAS attached drives.Figure 3: Rear of Oracle Sun Server X3-2 with multi-pronged SAS cable connected to SAS HBA card.Note: An STK SL150 is featured in this paper. The STK SL500 or STK SL24/48 Library can also be used inOracle Database Appliance backup configurations. The physical attachment of a SAS SL500 or SAS SL24/48 willbe identical to using a SAS connected SL150 as all are bridged libraries, meaning robot control is achieved over thephysical tape drive connection.Library Monitoring4

Protecting Oracle Database Appliance - Tape Backup with CommVault SimpanaAfter initial library configuration, the Oracle StorageTek Library Browser User Interface (BUI) can be used tomonitor, re-configure and operate the SL150 library. SL150 BUI is pictured in figure 4.Note: The BUI is not available on STK SL500 or STK SL24/48 as the SL500 is managed using the StorageTekLibrary Console (SLC) and the SL24/48 is managed using a built-in web GUI.Figure 4: Oracle StorageTek SL150 Modular Tape Library BUI.Library Drive OS VerificationUse the Windows Device Manager to verify you can see the tape library and LTO-6 tape drives on the SimpanaCommServe/Media Server: (See figure 5):Figure 5: Windows Device manager showing tape library and two tape drives.From the above output the tape library and two LTO-6 (Ultrium 6) drives are present.5

Protecting Oracle Database Appliance - Tape Backup with CommVault SimpanaRequired tnsnames.ora ChangesIn order to evenly spread the backup load across the database servers, each database server must be able to openRMAN channels on the other database server. This requires modifications to the tnsnames.ora file on eachdatabase server.1) Modify the /u01/app/oracle/product/11.2.0.3/dbhome 1/network/admin/tnsnames.ora file with a texteditor. Original file appears below:# tnsnames.ora Network Configuration File:/u01/app/oracle/product/11.2.0.3/dbhome 1/network/admin/tnsnames.ora# Generated by Oracle configuration tools.ISR (DESCRIPTION (ADDRESS (PROTOCOL TCP)(HOST hamms-scan)(PORT 1521))(CONNECT DATA (SERVER DEDICATED)(SERVICE NAME isr)))2) Modify the file to look as follows:# tnsnames.ora Network Configuration File:/u01/app/oracle/product/11.2.0.3/dbhome 1/network/admin/tnsnames.ora# Generated by Oracle configuration tools.ISR (DESCRIPTION (ADDRESS (PROTOCOL TCP)(HOST hamms-scan)(PORT 1521))(CONNECT DATA (SERVER DEDICATED)(SERVICE NAME isr)))ISR1 (DESCRIPTION (ADDRESS (PROTOCOL TCP)(HOST hamms1)(PORT 1521))(CONNECT DATA (SERVER DEDICATED)(SERVICE NAME isr)(SID isr1)))ISR2 (DESCRIPTION (ADDRESS (PROTOCOL TCP)(HOST hamms2)(PORT 1521))(CONNECT DATA (SERVER DEDICATED)(SERVICE NAME isr)(SID isr2)))6

Protecting Oracle Database Appliance - Tape Backup with CommVault Simpana3) After modifying tnsnames.ora verify ownership/permissions on the file to ensure they are correct: Owner should be oracle Group should be oinstall Permissions should be rw-r----- or 640 octalInitial Simpana ConfigurationCommVault Simpana configuration for tape backup with the Oracle Database Appliance is comprised of severaltasks including setup at the OS level, installation of the