(r3) DatabaseRecovery < Deployment

~~EditAttach~~Printable

r3 - 2016-06-23 - 08:19:24 - PaulEllisYou are here: TWiki >

Deployment Web > DeploymentPlanningAndDesign > ApproachesToImplementingHAAndDR > DatabaseRecovery

<div id="header-title" style="padding: 10px 15px; border-width:1px; border-style:solid; border-color:#FFD28C; background-image: url(<nop>https://jazz.net/wiki/pub/Deployment/WebPreferences/TLASE.jpg); background-size: cover; font-size:120%">
---+!! <img src="https://jazz.net/wiki/pub/Deployment/WebPreferences/uc.png" alt="uc.png" width="50" height="50" align="right"> Database recovery
%DKGRAY% Authors: Main.StevenBeard <br>
Build basis: None
%ENDCOLOR%</div></sticky>

<!-- Page contents top of page on right hand side in box -->
<sticky><div style="float:right; border-width:1px; border-style:solid; border-color:#DFDFDF; background-color:#F6F6F6; margin:0 0 15px 15px; padding: 0 15px 0 15px;">
%TOC{title="Page contents"}%
</div></sticky>

<sticky><div style="margin:15px;"></sticky>

---++ Use the best available database backup technologies

Depending on the database vendor chosen, various different database backup utilities are available. If you use IBM DB2, on-line backups are available and provide a way to keep quality backups with minimal interruption. See the DB2 documentation for details on enabling on-line backups. Some specific settings are required in the area of log file management. Even with a solid backup story, scheduling occasional downtime for a full backup is wise. On Jazz.net, on-line database backups are taken nightly and in conjunction with transaction logs. Up to the last committed transaction can be restored. Off-line backups occur only when migrations or host system configuration changes are completed.

When you use an Oracle database, configure for ARCHIVE LOG mode. You can use the Oracle RMAN utility or Enterprise manager to take backups and schedule them on a periodic basis in conjunction with archive logs. The same tools can provide functionality to restore the database in case of failure. There might be other components that need to be backed up, like instance configuration settings, to exactly restore the database to original configuration.

In addition to backing up your Jazz repository databases, back up data that defines your application server configuration or configurations. The key items to backup from the Jazz application servers include: the jazz.war file, the workitemindex directory, the teamserver properties, the profile.ini file, the update-site directory, and the conf directory.

Also back up the following files from your web server: server.xml, web.xml, tomcat-users.xml (Tomcat), or the !WebSphere profiles when using !WebSphere Application Server. !WebSphere Application Server provides a backup utility for doing this.

*Tip:* Deploy the Jazz repositories on an enterprise-ready database technology. Use the functionality and features available with that technology to best minimize downtime for backup and restore operations. Use standard enterprise backup procedures and policies with respect to backup media and offsite storage. Test these technologies and procedures, and document the specific approaches and procedures in place in your environment. For details on database backup technologies and concerns, see the [[https://jazz.net/library/article/67][Deployment Guide for Jazz Team Server]] and the [[https://jazz.net/library/article/542][Getting Started with Rational Team Concert 3.x: A Deployment Guide]].

---++ Database tier clustering

A common strategy for high availability in the database tier is the use of DB2 HADR or Oracle RAC capabilities.
---+++ IBM DB2

   * See [[https://jazz.net/library/article/464/][Configuring IBM DB2 9.7 HADR for RTC]].
---+++ Oracle

   * Demonstrated with Oracle RAC technology in [[https://jazz.net/jazz/web/projects/Jazz%20Collaborative%20ALM#action=com.ibm.team.workitem.viewWorkItem&id=189875][Task 189875]].
---+++ Microsoft SQL Server

   * There are plans to demonstrate HA capabilities with SQL Server, but this is not yet complete. See [[https://jazz.net/jazz/web/projects/Jazz%20Collaborative%20ALM#action=com.ibm.team.workitem.viewWorkItem&id=151210][Enhancement 151210]].
   * Vote for this enhancement to be implemented in the RFE community [[https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=44350][44350]]. 

---+++++!! Related topics: [[ApproachesToImplementingHAAndDR][Approaches to implementing high availability and disaster recovery for Rational Jazz environments]]

---+++++!! External links:          

   * None

---+++++!! Additional contributors: None

<sticky></div></sticky>

Deployment.DatabaseRecovery moved from Deployment.DatabseRecovery on 2014-03-13 - 10:47 by Main.sbeard -

Deployment

Community information and contribution guidelines

Status icon key:

To do
Under construction
New
Updated
Constant change
None - stable page

Smaller versions of status icons for inline text:

Copyright © by IBM and non-IBM contributing authors. All material on this collaboration platform is the property of the contributing authors.
Contributions are governed by our Terms of Use. Please read the following disclaimer.
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.