NetBackup IT Analytics Help
- Section I. Introducing NetBackup IT Analytics
- Section II. Certified configurations
- Portal and database servers
- Data Collector server configurations
- Capacity Manager configurations
- Array/LUN performance Data Collection
- EMC Isilon array performance metrics
- NetApp Cluster-Mode performance metrics
- EMC Symmetrix enhanced performance metrics
- Host access privileges, sudo commands, ports, and WMI proxy requirements
- Cloud configurations
- Virtualization Manager configurations
- File Analytics configurations
- Fabric Manager configurations
- Backup Manager configurations
- ServiceNow configurations
- Internal TCP port requirements
- Section III. End user
- Understand the portal
- About the Admin tab
- Explore your inventory
- Hierarchy toolbar to organize your data
- Show objects
- Use attributes to organize your data
- Pin reports - saving reports with inventory objects
- Assign attributes in the inventory list view
- Get acquainted with reports
- About badging
- Generate and maintain reports
- Select Report Scope
- Group hosts by attributes
- Search for hosts in the report Scope Selector
- Backup Manager advanced scope selector settings
- Solution reports scope selector settings
- Units of Measure in Reports
- Customize report filter logic
- Sort columns in reports
- Convert tabular report to chart
- Distribute, share, schedule, and alert
- Scheduling Exported Reports and Dashboards
- Organize reports
- Work with the dynamic template designer
- Dynamic Template Designer Quick Start
- Converting to a Homogeneous, Product-Specific Template
- Dynamic Template Function Configurations
- Create Fields with the Field Builder
- Scope Selector Component - Custom Filter
- Configure a Bar Chart Dynamic Template
- Steps to Create a Bar Chart Dynamic Template
- Configure an Area/Stacked Area Chart Dynamic Template
- Line Charts for Performance Metrics
- Line Chart Field Requirements
- One Object Per Line Chart, One or More Metrics Per Chart
- Multiple Objects Per Line Chart, One Metric Per Chart
- Example of a Stacked Bar Chart Dynamic Template
- Create a Sparkline Chart in a Tabular Dynamic Template
- Adding or Editing Methods
- Validate and Save a Method
- Work with the SQL template designer
- Configure SQL Template Scope Selector Components
- Sample SQL Queries
- Number, Size, Date, and Time Formatting
- Alignment, Aggregation, Bar Type, and Bar Type Color
- Pipelined functions for report query building
- APTlistOfDates
- aptStringConcat
- getServerAttributeValue
- getObjectAttributeValue
- getChildServerGroupContextById
- getServerGroupContextById
- secsToHoursMinSecs
- APTgetTapeDriveStatusName
- getFullPathname
- listJobSummaryAfterRestart
- listJobSummaryAfterRestartNBW
- listJobSummaryAfterRestart for NetWorker Backup Jobs
- listOfBackupWindowDates
- listChargebackCatByVOLSDetail
- listChargebackCatByNcVolDetail
- listChargebackCatByFSDetail (for HNAS)
- listChargebackCatByFSDetail (for EMC Isilon)
- listChargebackByLUNSummary
- listChargebackByLUNDetail
- listChargebackCatByLUNSummary
- listChargebackCatByLUNDetail
- Alert configuration
- Add/Edit an Alert Policy
- Manage hosts, backup servers, and host groups
- NetBackup Master Servers
- Manage attributes and objects
- Provide Portal access and user privileges
- Setting / Resetting passwords
- Managing user group home pages (Administrator)
- Configure master schedules and backup windows
- Add, edit, and move policies
- Add/Edit a threshold policy
- Capacity Chargeback policy types
- Solutions administration
- Manage and monitor data collection
- About data collection tasks
- Add/Edit data collectors
- Review collectors and collection status
- Upgrade Data Collectors
- Work with Capacity Manager host data collection
- Host access requirements
- Manage credentials
- Configure host discovery policies to populate the host discovery and collection view
- Validate host connectivity
- Search and export in host discovery and collection
- Propagate probe settings: Copy probes, paste probes
- Discovery policies for Veritas NetBackup
- View and manage system notifications
- Customize with advanced parameters
- Access control advanced parameters
- General Data Collection advanced parameters
- Cloud data collection advanced parameters
- Host discovery and collection advanced parameters
- Backup Manager advanced parameters
- Capacity Manager advanced parameters
- File Analytics advanced parameters
- Virtualization Manager advanced parameters
- Manage your Portal environment
- Analyze files
- Troubleshoot the Portal
- Retrieving log files
- Debug
- Attribute inheritance overrides
- Understand report data caching
- Understand the portal
- Section IV. Report Reference
- Introduction to NetBackup IT Analytics
- Alert Reports
- Risk Mitigation Solution Reports
- Risk Mitigation Reports
- Storage Optimization Solution Reports
- System Administration Reports
- Oracle Job Overview
- Capacity Manager Reports
- Application Capacity Reports
- Array Capacity Utilization Reports
- Array Capacity & Utilization (Generic Data)
- Array Capacity & Utilization (IBM SVC View)
- Array Capacity and Utilization (IBM XIV View)
- Array Capacity and Utilization (NetApp View)
- Array Capacity and Utilization (NetApp Cluster)
- NetApp Storage System Detail
- Array Capacity and Utilization (OpenStack Swift)
- IBM Array Site Summary
- IBM Array Detail
- LUN Utilization Summary
- NetApp Aggregate Detail
- NetApp Cluster-Mode Aggregate Detail
- NetApp Plex Details
- NetApp Volume Details
- NetApp Cluster-Mode Volume Detail
- NetApp StorageGrid Tenant Summary
- Available/Reclaimable Capacity Reports
- Capacity at Risk Reports
- Capacity Chargeback Reports
- Host Capacity Utilization Reports
- SnapMirror Reports
- SnapVault Reports
- Capacity Forecasting Reports
- Storage Performance Reports
- Mission Control for Performance Analysis
- Thin Provisioning Reports
- Hitachi Dynamic Provisioning Pool Utilization
- File Analytics Reports
- Virtualization Manager Reports
- Understanding the Datastore
- VM Server Detail
- VM Snapshot Summary
- VM Detail
- Datastore Utilization Summary
- Datastore Detail
- Fabric Manager Reports
- Host to Storage Dashboard
- Backup Manager Management Reports
- Error Log Summary
- Job Duration Report
- Veeam Backup & Replication Job Summary Report (Homogeneous)
- Veeam and RMAN Job Details Report
- Adding a Note to a Job
- Job Volume Summary Report
- NetBackup deduplication to MSDP savings
- Backup Administration Reports
- Host Details
- IBM Spectrum Protect (TSM) Storage Pools Dashboard
- Backup Media Management Reports
- TSM Tape Media Detail Table
- Backup Service Level Agreement (SLA) Reports
- Determining and Improving Backup Start Time Performance
- Determining and Improving Backup Success Performance
- Determining and Improving Backup Duration Performance
- Backup Storage Utilization Reports
- Backup Manager Forecasting Reports
- Backup Billing and Usage Reports
- Backup Policies Reports
- HP Data Protector Backup Specification Detail
- Public Cloud Reports
- Section V. NetBackup IT Analytics Exporter Installation and Configuration
- Section VI. Data Collector Installation and Troubleshooting
- Installing the Data Collector Software
- Validating Data Collection
- Uninstalling the Data Collector
- Manually Starting the Data Collector
- Data Collector Troubleshooting
- Host resources: Check host connectivity using standard SSH
- Host resources: Generating host resource configuration files
- Configuring parameters for SSH
- CRON Expressions and Probe Schedules
- Clustering Data Collectors with VCS and Veritas NetBackup (RHEL 7)
- Clustering Data Collectors with VCS and Veritas NetBackup (Windows)
- Maintenance Scenarios for Message Relay Server Certificate Generation
- Installing the Data Collector Software
- Section VII. Data Collection for the Cloud
- Pre-Installation Setup for Amazon Web Services (AWS)
- Create an AWS IAM user
- Link AWS accounts for Collection of consolidated billing data
- Pre-Installation Setup for OpenStack Ceilometer
- Pre-Installation Setup for OpenStack Swift
- Pre-Installation Setup for Microsoft Azure
- Google Cloud Platform (GCP)
- Pre-Installation Setup for Amazon Web Services (AWS)
- Section VIII. Data Collection for Data Protection (Backup)
- Introduction
- Pre-Installation setup for Commvault Simpana
- Open TCP/IP access to the Commvault database
- Set up a read-only user in the CommServe server
- Pre-Installation setup for Cohesity DataProtect
- Pre-Installation setup for EMC Avamar
- Import EMC Avamar server information
- Pre-Installation setup for EMC Data Domain Backup
- Pre-Installation setup for EMC NetWorker
- Architecture overview (EMC NetWorker)
- Pre-Installation setup for Dell EMC NetWorker Backup & Recovery
- Pre-Installation setup for generic backup
- CSV format specification
- Pre-Installation setup for HP Data Protector
- Architecture overview (HP Data Protector)
- Configure the Data Collector server in Cell Manager (HP Data Protector)
- Pre-Installation setup for IBM Spectrum Protect (TSM)
- Architecture overview (IBM Spectrum Protect -TSM)
- Import IBM Spectrum Protect (TSM) information
- Pre-Installation setup for IBM Spectrum Protect Plus
- Pre-Installation setup for NAKIVO Backup & Replication
- Pre-Installation setup for Veritas Backup Exec
- Pre-Installation setup for Veritas NetBackup
- Prerequisites to use SSH and WMI (Veritas NetBackup)
- Prerequisites for NetBackup collection over SSH (Kerberos option)
- Veritas NetBackup 8.1 (or later) requirements for centralized collection
- Configuring file analytics in NetBackup Data Collector policy
- Pre-Installation setup for Veritas SaaS backup
- Pre-Installation setup for Oracle Recovery Manager (RMAN)
- Pre-Installation setup for Rubrik Cloud Data Management
- Pre-Installation setup for Veeam Backup & Replication
- Discovery policies for Veritas NetBackup
- About Discovery types
- About SNMP probes
- Appendix B. Load Historic Events
- Load Veritas NetBackup events
- Section IX. Data Collection for Fabrics
- Section X. Data Collection for File Analytics
- Pre-Installation Setup for File Analytics
- Host Discovery and Collection File Analytics probe
- Adding a File Analytics Data Collector policy
- File Analytics Export Folder Size and Folder Depth
- Pre-Installation Setup for File Analytics
- Section XI. Data Collection for Replication
- Section XII. Data Collection for Storage (Capacity)
- Data Collection for Capacity Overview
- Pre-Installation setup for Compute Resources
- Pre-Installation Setup for Dell Compellent
- Pre-Installation Setup for DELL EMC Elastic Cloud Storage (ECS)
- Pre-Installation Setup for EMC Data Domain Storage
- Pre-Installation Setup for EMC Isilon
- Pre-Installation Setup EMC Symmetrix
- Pre-Installation Setup for Dell EMC Unity
- Pre-Installation Setup for EMC VNX Celerra
- Pre-Installation Setup for EMC VNX CLARiiON
- Pre-Installation Setup for EMC VPLEX
- Pre-Installation Setup for EMC XtremIO
- Pre-Installation Setup for Hitachi Block
- Configuring a Hitachi Device manager user
- Pre-Installation Setup for Hitachi Content Platform (HCP)
- Hitachi content platform system management console
- Hitachi content platform tenant management console
- Pre-Installation Setup Hitachi NAS
- Pre-Installation Setup for Hitachi Vantara All-Flash and Hybrid Flash Storage
- Host Inventory Pre-Installation Setup
- Host Access Privileges, Sudo Commands, Ports, and WMI Proxy Requirements
- Configure host Discovery policies to populate the host Inventory
- Validate host connectivity
- Host Inventory search and host Inventory export
- Configure and edit host probes
- Propagate Probe Settings: Copy Probes, Paste Probes
- Pre-Installation Setup for HP 3PAR
- Pre-Installation Setup for HP EVA
- Pre-Installation setup for HPE Nimble Storage
- Pre-Installation Setup for Huawei OceanStor
- Pre-Installation Setup for IBM COS
- Pre-Installation Setup for IBM Enterprise
- Pre-Installation Setup for NetApp E-Series
- Pre-Installation Setup for IBM SVC
- Pre-Installation Setup for IBM XIV
- Pre-Installation Setup for Infinidat InfiniBox
- Pre-installation setup for FUJITSU Data Collector
- Pre-Installation setup for Infinidat InfiniGuard
- Pre-Installation Setup for NetApp-7
- Pre-Installation setup for NetApp StorageGRID
- Pre-Installation Setup for Microsoft Windows Server
- Pre-Installation Setup for NetApp Cluster
- Pre-Installation Setup for Pure Storage FlashArray
- Pre-Installation Setup for Veritas NetBackup Appliance
- Section XIII. Data Collection for Virtualization
- Pre-Installation setup for VMware
- Pre-Installation setup for IBM VIO
- Pre-Installation setup for Microsoft Hyper-V
- Section XIV. System Administration
- Preparing for Updates
- Backing Up and Restoring Data
- Monitoring NetBackup IT Analytics
- Accessing NetBackup IT Analytics Reports with the REST API
- Defining NetBackup Estimated Tape Capacity
- Automating Host Group Management
- Categorize host operating systems by platform and version
- Load relationships between hosts and host group
- Automate NetBackup utilities
- Scheduling utilities to run automatically
- Attribute Management
- Importing Generic Backup Data
- Backup Job Overrides
- Managing Host Data Collection
- System Configuration in the Portal
- Performance Profile Schedule Customization
- Configuring AD/LDAP
- Configuring Single Sign On (SSO) Using Security Assertion Markup Language (SAML)
- Changing Oracle Database User Passwords
- Integrating with CyberArk
- Tuning NetBackup IT Analytics
- Defining Report Metrics
- Working with Log Files
- Portal and data collector log files - reduce logging
- Data collector log file naming conventions
- Portal log files
- SNMP Trap Alerting
- SSL Certificate Configuration
- Configure virtual hosts for portal and / or data collection SSL
- Keystore on the portal server
- Portal Properties: Format and Portal Customizations
- Data Retention Periods for SDK Database Objects
- Troubleshooting
- Section XV. Portal Install and Upgrade (Windows)
- Installing the Portal on a Windows server
- Task 3: Installing Oracle application binaries (Windows)
- Upgrade NetBackup IT Analytics Portal on Windows
- Upgrade and migrate to a new server
- Installing the Portal on a Windows server
- Section XVI. Portal Install and Upgrade (Linux)
- Install the NetBackup IT Analytics Portal on a Linux server
- Installer-based deployment
- Upgrade NetBackup IT Analytics Portal on Linux
- Upgrade NetBackup IT Analytics Portal
- Data Collector upgrades
- Oracle patches for the database server
- Upgrade and Migrate to a new server
- Upgrade and migrate to a new server
- Upgrade and migrate to a new server
- Appendix C. X Virtual Frame Buffer
- Install the NetBackup IT Analytics Portal on a Linux server
- Section XVII. Licensing
- License installation and guidelines
- License overview
- Verify the current license configuration
- Storage suite
- Protection suite
- Backup Manager
- Backup Manager
- Complete suite
- Managing licenses
- Configure the Data Collector policy to exclude the object
- License management from the command line
- Troubleshooting
- License installation and guidelines
- Section XVIII. Inventory reports and operations
Install the Oracle patch
- As a root user, copy the Oracle patch file from
/tmp
to/opt/aptare/oracle
folder using the following command:mv p34773489_190000_Linux-x86-64.zip /opt/aptare/oracle
- Run the command su - aptare
- Navigate to
/opt/aptare/oracle
folder and unzip the file.cd /opt/aptare/oracle unzip p34773489_190000_Linux-x86-64.zip
The above command will create a
34773489
folder in/opt/aptare/oracle
folder.If the below message is displayed while you unzip the file, enter y in its response.
replace PatchSearch.xml? [y]es, [n]o, [A]ll, [N]one, [r]ename: is displayed, enter y.
- Set permission on patch folder
34773489
.chown -R aptare:dba 34773489
Note:
If the Oracle patch is not Veritas provided and have already installed Oracle patch, skip the following steps from 5 through 11.
- As a root user, copy the two jar files from
/tmp
to/opt/aptare/oracle/sqldeveloper/sqldeveloper/lib
folder.mv xdb6.jar /opt/aptare/oracle/sqldeveloper/sqldeveloper/lib mv xmlparserv2-sans-jaxp-services.jar /opt/aptare/oracle/sqldeveloper/sqldeveloper/lib
- Change the permissions on the
jar
files and the perl.cd /opt/aptare/oracle/sqldeveloper/sqldeveloper/lib chown -R aptare:dba xdb6.jar chown -R aptare:dba xmlparserv2-sans-jaxp-services.jar cd /opt/aptare/oracle chown -R aptare:dba perl chmod -R 775 perl
- Check if
oraInventory
folder is available under/opt/
. If the folder is not available, thencd /opt/aptare/upgrade cp oraInventory.zip /opt/ unzip oraInventory
- Check permission on
/opt/oraInventory
folder if it is aptare:dba else change the permission.cd /opt/ chown -R aptare:dba oraInventory
- su - aptare
- Run following command to attach the Oracle home
$ORACLE_HOME/oui/bin/runInstaller -silent -ignoreSysPrereqs -invPtrLoc "/opt/aptare/oracle/oraInst.loc" -attachHome ORACLE_HOME="/opt/aptare/oracle" ORACLE_HOME_NAME="OraDB19c_home" INVENTORY_LOCATION="/opt/oraInventory"
If the oracle home is already attached, the message 'Oracle Home already exists at this location. Select another location' will be displayed. Ignore the message.
- Follow the steps to make changes for fuser if you see the fuser error 'Missing command :fuser'.
cd /opt/aptare/oracle/bin/ touch fuser Chmod 755 fuser
- Set PATH. Make sure you set all the paths else patch application might fail.
export PATH=$PATH:/opt/aptare/oracle/OPatch export PATH=$PATH:/usr/ccs/bin PATH=$PATH:/opt/aptare/oracle/sqldeveloper/sqldeveloper/lib
- Check for any OPatch conflicts. This step will verify for any conflicts on both the database RU patch and OJVM patches.
cd /opt/aptare/oracle/34773489 /opt/aptare/oracle/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
- If no conflicts are detected, run the following commands to apply database RU patch from
/opt/aptare/oracle/34773489/34765931
folder.cd /opt/aptare/oracle/34773489/34765931 /opt/aptare/oracle/OPatch/opatch apply Verifying environment and performing prerequisite checks... OPatch continues with these patches: 34765931 Do you want to proceed? [y|n] y Is the local system ready for patching? [y|n] y Patching component oracle.jdk, 1.8.0.201.0... Patch 34765931 successfully applied. Sub-set patch [34419443] has become inactive due to the application of a super-set patch [34765931]. Please refer to Doc ID 2161861.1 for any possible further required actions. Log file location: /opt/aptare/oracle/cfgtoollogs/opatch/ opatch2023-02-06_15-44-28PM_1.log OPatch completed with warnings.
Note:
Ignore the warning message if it is related to rollback of patch 30565805. The message is displayed when no prior Oracle security patches were applied.
- Run the following commands to apply OJVM patch from
/opt/aptare/oracle/34773489/34786990
folder.cd /opt/aptare/oracle/34773489/34786990 /opt/aptare/oracle/OPatch/opatch apply Verifying environment and performing prerequisite checks... OPatch continues with these patches: 34786990 Do you want to proceed? [y|n] y Is the local system ready for patching? [y|n] y Patching component oracle.javavm.server, 19.0.0.0.0... Patching component oracle.javavm.server.core, 19.0.0.0.0... . . Patch 34786990 successfully applied. Log file location: /opt/aptare/oracle/cfgtoollogs/opatch/ opatch2023-02-06_15-50-55PM_1.log OPatch succeeded.
- Verify OPatch succeeded with the following command:
Note:
The commands will display the OPatch application of both the database and OJVM patches.
cd /opt/aptare/oracle/34773489 /opt/aptare/oracle/OPatch/opatch lsinventory -detail
- Connect to sqlplus using the following command:
-bash-4.2$ sqlplus /nolog SQL*Plus: Release 19.0.0.0.0 - Production on Mon Feb 6 15:56:17 2023 Version 19.18.0.0.0 Copyright (c) 1982, 2022, Oracle. All rights reserved
- Connect as sysdba.
SQL> connect / as sysdba Connected to an idle instance
- Start the database.
SQL> startup ORACLE instance started. : : Database mounted. Database opened.
- Open all pluggable database.
SQL> alter pluggable database all open; Pluggable database altered.
- Exit from SQL prompt.
SQL> quit
- Run the database patch to complete the post-install SQL deployment for the patch being installed.
Run the following commands to apply the patch to the pluggable database (this may take few minutes).
/opt/aptare/oracle/OPatch/datapatch -verbose Patch installation complete. Total patches installed: 9 Validating logfiles...done Patch 34411846 rollback (pdb CDB$ROOT): SUCCESS logfile: /opt/aptare/cfgtoollogs/sqlpatch/34411846 /24917919/34411846_rollback_SCDBCNTR_CDBROOT_2023Feb06_15_58_27.log (no errors) Patch 34765931 apply (pdb CDB$ROOT): SUCCESS logfile: /opt/aptare/cfgtoollogs/sqlpatch/34765931 /25098466/34765931_apply_SCDBCNTR_CDBROOT_2023Feb06_15_58_27.log (no errors) Patch 34786990 apply (pdb CDB$ROOT): SUCCESS logfile: /opt/aptare/cfgtoollogs/sqlpatch/34786990 /25032666/34786990_apply_SCDBCNTR_CDBROOT_2023Feb06_15_58_27.log (no errors) Patch 34411846 rollback (pdb PDB$SEED): SUCCESS logfile: /opt/aptare/cfgtoollogs/sqlpatch/34411846 /24917919/34411846_rollback_SCDBCNTR_PDBSEED_2023Feb06_15_58_56.log (no errors) Patch 34765931 apply (pdb PDB$SEED): SUCCESS logfile: /opt/aptare/cfgtoollogs/sqlpatch/34765931 /25098466/34765931_apply_SCDBCNTR_PDBSEED_2023Feb06_15_58_56.log (no errors) Patch 34786990 apply (pdb PDB$SEED): SUCCESS logfile: /opt/aptare/cfgtoollogs/sqlpatch/34786990 /25032666/34786990_apply_SCDBCNTR_PDBSEED_2023Feb06_15_58_56.log (no errors) Patch 34411846 rollback (pdb SCDB): SUCCESS logfile: /opt/aptare/cfgtoollogs/sqlpatch/34411846 /24917919/34411846_rollback_SCDBCNTR_SCDB_2023Feb06_15_58_56.log (no errors) Patch 34765931 apply (pdb SCDB): SUCCESS logfile: /opt/aptare/cfgtoollogs/sqlpatch/34765931 /25098466/34765931_apply_SCDBCNTR_SCDB_2023Feb06_15_58_56.log (no errors) Patch 34786990 apply (pdb SCDB): SUCCESS logfile: /opt/aptare/cfgtoollogs/sqlpatch/34786990 /25032666/34786990_apply_SCDBCNTR_SCDB_2023Feb06_15_58_56.log (no errors) . . SQL Patching tool complete on Mon Feb 6 15:59:32 2023
- Check the log file in
/opt/aptare/cfgtoollogs/sqlpatch/
for errors.The log file name includes the current timestamp:
Example:
/opt/aptare/cfgtoollogs/sqlpatch/sqlpatch_
32228_2023_02_06_15_57_52/sqlpatch_invocation.log
- Start all the services as a root user.
/opt/aptare/bin/aptare start