Neoview Backup User's Guide HP Part Number: 634099-001 Published: February 2011 Edition: Neoview Release 2.5 and VTS 7.04.
© Copyright 2011 Hewlett-Packard Development Company, L.P. Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor’s standard commercial license. The information contained herein is subject to change without notice.
Table of Contents About This Guide...............................................................................................................7 Supported Releases.................................................................................................................................7 New and Changed Information in This Edition.....................................................................................7 Document Organization.................................................................
HP_METRICS.BAR_JOB_STATUS_VW3 View...............................................................................31 HP_METRICS.BAR_JOB_STATUS_VW4 View...............................................................................31 HP_METRICS.BAR_JOB_STATUS_VW5 View...............................................................................32 A Related Documentation...............................................................................................33 Neoview Customer Library .................
List of Tables 2-1 2-2 4-1 4-2 4-3 4-4 Neoview VTS System Status Field Information for 7.03.41..........................................................14 Neoview VTS System Status Field Information for 7.04.02..........................................................16 OVERALL_BAR_JOB_STATUS Field Definitions.........................................................................24 BAR_JOB_STATUS Field Definitions............................................................................................
List of Examples 4-1 4-2 4-3 4-4 4-5 4-6 4-7 6 HPDM Display of HP_METRICS.OVERALL_BAR_JOB_STATUS_VW1 View...........................27 HPDM Display of HP_METRICS.OVERALL_BAR_JOB_STATUS_VW2 View...........................28 HPDM Display of HP_METRICS.BAR_JOB_STATUS_VW1 View...............................................30 HPDM Display of HP_METRICS.BAR_JOB_STATUS_VW2 View...............................................30 HPDM Display of HP_METRICS.BAR_JOB_STATUS_VW3 View.....................................
About This Guide This guide describes tools and commands that Neoview customers can use to monitor or manage backup operations on the Neoview Data Warehousing Platform for Business Intelligence. Supported Releases This guide supports Neoview Release 2.5 – including VTS release 7.04.02 – and all subsequent Neoview releases until otherwise indicated in a replacement publication. New and Changed Information in This Edition This guide is new.
1 About the Neoview Platform and Backups This chapter describes some software and hardware components and concepts that are vital to understanding how backups are performed on the Neoview platform. Backups are made possible by the Neoview Transaction Manager working in concert with Removable Media for Disaster Recovery (RMDR) software and the Neoview Virtual TapeServer (VTS).
For more information about the System Monitor, see the HPDM online help or the HP Database Manager (HPDM) User Guide. Neoview Virtual TapeServer (VTS) The Neoview Virtual TapeServer (VTS) is a disk-based appliance that provides continuous backup capabilities. The VTS enables the recovery of database objects to any point in time within the supported recovery window. The VTS is an optional product and is not included in standard Neoview platform configurations.
• • Loss of the Neoview VTS (and, consequently, access to virtual tapes) Loss of the segment, cluster, or entire site as a result of a disaster, whether natural or man-made VTS-Based Removable Media for Disaster Recovery (RMDR) Software The full-segment backup implemented by the server-based RMDR software resides on the VTS.
2 Viewing the VTS System Status and VTS RMDR Service Window To support backups, your Neoview platform must include a virtual tapeserver (VTS) attached to each segment. You can access information about each VTS from a browser. The VTS System Status page contains information about the VTS and its virtual tape devices. From the System Status page, you can also display the VTS RMDR Service Page to configure a VTS RMDR service window.
Table 2-1 (page 14) describes the fields shown in the System Status page for VTS software 7.03.41. Table 2-1 Neoview VTS System Status Field Information for 7.03.41 Box Box Title Field Description [1] System Host The host name of the Neoview VTS. Time The current date and time. Version The version of software installed on the Neoview VTS. Created The date on which the installed Neoview VTS software was created.
Example System Status Page for VTS Software 7.04.02 Table 2-2 (page 16) describes the fields shown in the System Status page for VTS software 7.04.02. Example System Status Page for VTS Software 7.04.
Table 2-2 Neoview VTS System Status Field Information for 7.04.02 Box Box Title Field Description [1] System Host The host name of the Neoview VTS server. Time The current date and time. Version The version of software (including patches) installed on the Neoview VTS server. Created The date on which the installed Neoview VTS software was created. EMS The active status of EMS, which enables the Neoview VTS to send messages and errors to the Neoview platform.
Displaying the VTS RMDR Service Page The VTS RMDR Service page enables you to configure the VTS Automated Removable Media Disaster Recovery (RMDR) feature. The VTS RMDR feature integrates Neoview VTS with enterprise backup management applications (BMAs). It provides a way for the Neoview host to trigger an external backup of data that was dumped to the Neoview VTS server, as part of a disaster recovery backup. To automate the VTS RMDR feature, you can define a service window.
NOTE: These instructions configure only the VTS to which you are connected. To configure RMDR on all VTSs, you must repeat the steps on every VTS attached to the system. To do this . . . Use these steps Schedule a VTS RMDR service window 1. In the Configuration section of the page, select one of the following options to configure how often you want the VTS RMDR window to occur: One time – Runs the VTS RMDR window once. You must select a start date. Weekly/Daily – Runs on the day(s) you select.
3 Stored Procedures for Managing Backup Jobs In Neoview Release 2.5, you can start, stop, and get information about a backup operation by using these stored procedures for Java (SPJs): • • • “START_JOB_BACKUP Stored Procedure” (page 19) “STATUS_JOB_BACKUP Stored Procedure” (page 20) “STOP_JOB_BACKUP Stored Procedure” (page 21) START_JOB_BACKUP Stored Procedure The START_JOB_BACKUP stored procedure: • • • Determines the status of the currently executing backup operation.
STATUS_JOB_BACKUP Stored Procedure The STATUS_JOB_BACKUP stored procedure displays the status of the last backup operation or the currently executing backup operation. STATUS_JOB_BACKUP can be used when a backup job is in automatic or manual initiation mode. This stored procedure is available for use only by super-group users, HP support, and users belonging to ROLE.DBA. Syntax CALL NEO.HP_SP.STATUS_JOB_BACKUP(?) Parameters This procedure has no input parameters.
STOP_JOB_BACKUP Stored Procedure The STOP_JOB_BACKUP stored procedure checks the status of the currently executing backup operation, and then stops it on all segments. STOP_JOB_BACKUP can be used when a backup job is in automatic or manual initiation mode. NOTE: It can take several minutes to completely stop an executing backup job. Use the STATUS_JOB_BACKUP SPJ to confirm that the backup job has stopped. See “STATUS_JOB_BACKUP Stored Procedure” (page 20).
4 Repository Tables and Views for Backup Jobs Release 2.5 stores status information for the backup jobs in two repository tables: • “MANAGEABILITY.METRICS.OVERALL_BAR_JOB_STATUS Table” (page 24) • “MANAGEABILITY.METRICS.BAR_JOB_STATUS Table” (page 25) This guide provides field definitions for the repository tables, but the tables are not available directly to users. To access information in the tables, you can use any of seven views.
MANAGEABILITY.METRICS.OVERALL_BAR_JOB_STATUS Table Repository tables contain historical job operation information. For each backup job that runs successfully, one row (per segment) is written to the BAR_JOB_STATUS table. Overall data for each backup job is stored in the OVERALL_BAR_JOB_STATUS table. Table 4-1 OVERALL_BAR_JOB_STATUS Field Definitions Field Name Data Type Description PLATFORM_NAME CHAR(64) NO DEFAULT Name of platform (composed of the first five characters of the system name).
MANAGEABILITY.METRICS.BAR_JOB_STATUS Table For the MANAGEABILITY.METRICS.BAR_JOB_STATUS repository table, one row is written per segment for each successful overall job. Table 4-2 BAR_JOB_STATUS Field Definitions Field Name Data Type Description OVERALL_START_UTC_TS TIMESTAMP(6) NO DEFAULT, NOT NULL, NOT DROPPABLE Start time of the overall backup job run in UTC. PK; Leading clustering key.
Repository Views for Backup Jobs This section describes the views that provide information about recent backup jobs: • “HP_METRICS.OVERALL_BAR_JOB_STATUS_VW1 View” (page 26) • “HP_METRICS.OVERALL_BAR_JOB_STATUS_VW2 View” (page 28) • “HP_METRICS.BAR_JOB_STATUS_VW1 View” (page 29) • “HP_METRICS.BAR_JOB_STATUS_VW2 View” (page 30) • “HP_METRICS.BAR_JOB_STATUS_VW3 View” (page 31) • “HP_METRICS.BAR_JOB_STATUS_VW4 View” (page 31) • “HP_METRICS.
Table 4-3 HP_METRICS.OVERALL_BAR_JOB_STATUS_VW1 (continued) Field Name Data Type Description STATUS CHAR(64) NO DEFAULT Overall current status of backup job run; status of each segment affects the overall status. Example: If backup fails in one segment, STATUS is set to BACKUP_FAILED.
HP_METRICS.OVERALL_BAR_JOB_STATUS_VW2 View The HP_METRICS.OVERALL_BAR_JOB_STATUS_VW2 view returns aggregated data grouped by OVERALL_START_UTC_TS.
HP_METRICS.BAR_JOB_STATUS_VW1 View The HP_METRICS.BAR_JOB_STATUS_VW1 view provides important information about online dumps for each segment. This information includes the start time of the overall backup job, the segment number, the online dump pass number, the platform name, the start time and end time for each online dump pass, the synchronized file recovery time, and the total number of files dumped during the online dump pass. Table 4-4 HP_METRICS.
Example 4-3 HPDM Display of HP_METRICS.BAR_JOB_STATUS_VW1 View HP_METRICS.BAR_JOB_STATUS_VW2 View The HP_METRICS.BAR_JOB_STATUS_VW2 view returns aggregated data grouped by PASS_NUM and OVERALL_START_UTC_TS. The view includes these columns: • PASS_NUM • OVERALL_START_UTC_TS • OVERALL_START_LCT_TS • TOTAL_NUM_FILES_DUMPED • TOTAL_NUM_FILES_NOT_DUMPED • TOTAL_NUM_BYTES_DUMPED For information about each column, see Table 4-4 (page 29). Example 4-4 HPDM Display of HP_METRICS.
HP_METRICS.BAR_JOB_STATUS_VW3 View The HP_METRICS.BAR_JOB_STATUS_VW3 view returns aggregated data grouped by SEGMENT_ID and OVERALL_START_UTC_TS. The view includes these columns: • OVERALL_START_UTC_TS • OVERALL_START_LCT_TS • TOTAL_NUM_FILES_DUMPED • TOTAL_NUM_FILES_NOT_DUMPED • TOTAL_NUM_BYTES_DUMPED For information about each column, see Table 4-4 (page 29). Example 4-5 HPDM Display of HP_METRICS.BAR_JOB_STATUS_VW3 View HP_METRICS.BAR_JOB_STATUS_VW4 View The HP_METRICS.
Example 4-6 HPDM Display of HP_METRICS.BAR_JOB_STATUS_VW4 View HP_METRICS.BAR_JOB_STATUS_VW5 View The HP_METRICS.BAR_JOB_STATUS_VW5 view returns the RPO timestamp (TS) along with the set of NSFR timestamps (unique per SEGMENT_ID) per OVERALL_START_UTC_TS. The view includes these columns: • SEGMENT_ID • OVERALL_START_UTC_TS • OVERALL_START_LCT_TS • RECOVERY_POINT_OBJ_UTC_TS • RECOVERY_POINT_OBJ_LCT_TS • NSFR_UTC_TS • NSFR_LCT_TS For information about each column, see Table 4-4 (page 29).
A Related Documentation This guide is part of the HP Neoview customer library, which can be found at: http://www.hp.com/go/neoviewdocs Neoview Customer Library The manuals in the Neoview customer library are listed here for your convenience.
Neoview Workload Management Information about using Neoview Workload Management Services (WMS) to Services Guide manage workload and resources on a Neoview data warehousing platform.
Index B B2D, 9 B2D2T, 9 BMA (backup management application), 11 Browsers, 13 C Comments, 7 Customer library, 33 D D2T, 9 Data recovery, 11 Document organization, 7 Documentation, related, 33 Dumps, 9 F Feedback, 7 G GCSC, 11 H HP, contacting, 11 HPDM, 9, 26 I Internet Explorer, 13 L LCT (local civil time), 19 M Manuals, Neoview, 33 Metric Miner, 26 Mozilla Firefox, 13 N Neoview Virtual TapeServer (VTS), 10 P Service Page, 17 VTS-based, 11 RPO time, 10 S SQL Whiteboard, 26 Stored procedures in Ja
