Backing up the database

To reduce backup complexity and enhance reliability, procedures are developed to assist the user with backup and recovery strategy.

The Tivoli® Netcool® Performance Manager 1.4.5 database uses Oracle features that assist loading performance (for example, SQL*Loader in direct path mode with the unrecoverable option.)

The Tivoli Netcool Performance Manager 1.4.5 database uses DB2 features that assist loading performance (for example, DB2 LOAD with the unrecoverable option.)

The use of these features complicates the backup and recovery strategy. To reduce complexity and enhance reliability, procedures are developed to assist the user with backup and recovery strategy. These procedures must be considered a set of recommendations, requirements, and sample code to assist the user in their environment. Many companies have well-defined procedures in place to perform backup of their databases. With this in mind, a backup procedure that meets IBM requirements with the maximum flexibility for the customer, is developed.

In this section, the difference between required steps and sample steps are detailed.

Warnings

Backup and recovery is a complex area of database administration. When coupled with the use of unrecoverable load methods, it becomes more complex. Make sure that you understand how the system operates and what impact any change has on the ability to recover the database.

Reference Material

IBM recommends the following reference manuals from Oracle:

Oracle Database 12c:

  • Oracle 12c Concepts
  • Oracle 12c Administrator's Guide
  • Oracle 12c Utilities
  • Oracle 12c Backup and Recovery Guide
  • Oracle 12c Recovery Manager User's Guide and Reference

Online versions of manuals can be found at http://docs.oracle.

IBM recommends the following reference manuals:

IBM DB2 10.1 database:

  • Database Administration Concepts and Configuration Reference
  • Data Movement Utilities Guide and Reference
  • Data Recovery and High Availability Guide and Reference

Online versions of manuals can be found on the information center at http://www-01.ibm.com/support/docview.wss?uid=swg27024478.