EMC® NetWorker® Module for Databases and Applications Version 9.1 Administratio

EMC® NetWorker® Module for Databases and Applications Version 9.1 Administration Guide 302-003-080 REV 01 Copyright © 2009-2016 Dell Inc. or its subsidiaries. All rights reserved. Published December 2016 Dell believes the information in this publication is accurate as of its publication date. The information is subject to change without notice. THE INFORMATION IN THIS PUBLICATION IS PROVIDED “AS-IS.“ DELL MAKES NO REPRESENTATIONS OR WARRANTIES OF ANY KIND WITH RESPECT TO THE INFORMATION IN THIS PUBLICATION, AND SPECIFICALLY DISCLAIMS IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. USE, COPYING, AND DISTRIBUTION OF ANY DELL SOFTWARE DESCRIBED IN THIS PUBLICATION REQUIRES AN APPLICABLE SOFTWARE LICENSE. Dell, EMC, and other trademarks are trademarks of Dell Inc. or its subsidiaries. Other trademarks may be the property of their respective owners. Published in the USA. EMC Corporation Hopkinton, Massachusetts 01748-9103 1-508-435-1000 In North America 1-866-464-7381 www.EMC.com 2 EMC NetWorker Module for Databases and Applications 9.1 Administration Guide 13 15 17 Overview of NMDA Features 21 Road map for NMDA operations.................................................................22 Terminology that is used in this guide.........................................................23 Importance of backups............................................................................... 24 NMDA features for all supported applications............................................ 24 Basic backup and recovery features.............................................. 25 Scheduled backups versus manual backups...................................25 Client Direct feature...................................................................... 26 Deduplication backups and restores with Data Domain.................. 27 Backups and restores with CloudBoost..........................................28 Snapshot backups and restores.....................................................28 Virtualization support.................................................................... 29 Cluster and high-availability system operations............................. 30 Configuration wizards....................................................................30 Internationalization (I18N)..............................................................31 IPv6 support for backups and restores...........................................31 Multiple database or application installations on the same host......31 Simplified scheduled backup configuration of multiple databases or applications.................................................................................... 31 NMDA features specific to DB2..................................................................32 DB2 full, incremental, and delta backups....................................... 32 DB2 transaction log backups......................................................... 32 DB2 history pruning.......................................................................33 DB2 10.5 features.......................................................................... 33 NMDA DB2 recovery wizard.......................................................... 34 Restores of Fujitsu NetWorker Module for DB2 backups...............34 DB2 data recovery with the HPU utility.........................................35 DB2 load command with the copy yes option................................ 35 NMDA features specific to Informix........................................................... 36 Informix terminology......................................................................36 Informix full and incremental backups............................................36 Logical log backups........................................................................36 Restores of Fujitsu NetWorker Module for Informix backups.........36 Informix 12.10 features...................................................................37 NMDA features specific to Lotus................................................................37 Files that are backed up during Lotus backups...............................37 Lotus full and incremental backups................................................38 Lotus transaction log backups....................................................... 38 Lotus DAOS backups and restores.................................................39 Restartable scheduled backups..................................................... 39 Tables Figures Preface Chapter 1 CONTENTS EMC NetWorker Module for Databases and Applications 9.1 Administration Guide 3 Types of Lotus restores.................................................................40 NetWorker User for Lotus program............................................... 40 NMDA Lotus recovery wizard........................................................40 Partitioned Domino servers............................................................ 41 NMDA features specific to MySQL............................................................. 41 MySQL online and offline backups................................................. 41 MySQL full and incremental backups.............................................42 MySQL binary log backups............................................................ 42 MySQL backup granularity............................................................ 43 MySQL restore and recovery operations....................................... 44 MySQL validate operation............................................................. 46 MySQL 5.6 features...................................................................... 46 MySQL replicated slave server operations.....................................46 NMDA features specific to Oracle.............................................................. 47 Oracle full and incremental backups...............................................47 Backups of archived redo logs....................................................... 48 Oracle DBA and NetWorker backup administrator collaboration.... 48 Control file and server parameter file autobackups........................48 Automatic channel allocation.........................................................49 Backup and restore optimization................................................... 49 Backup copies............................................................................... 49 Backup and deletion of backup sets...............................................50 Oracle Data Guard support............................................................50 Oracle Exadata support................................................................. 50 Restartable backups.......................................................................51 Retention policies...........................................................................51 NMDA Oracle recovery wizard...................................................... 52 Restores of Fujitsu NetWorker Module for Oracle backups........... 53 Save set bundling.......................................................................... 54 Policy uniformity........................................................................... 56 Other Oracle features....................................................................57 NMDA features specific to Sybase.............................................................60 Sybase full, cumulative, and incremental backups......................... 60 Sybase restore parameters............................................................ 61 Restore of Sybase transaction logs only.........................................61 Sybase up-to-the-minute recovery................................................62 Password-protected database backups and restores.................... 63 Database consistency check..........................................................63 Database backup and restore verification......................................63 Exclusion of multiple user-defined temporary databases from backup...........................................................................................63 Sybase in-memory and relaxed durability databases......................63 Sybase ASE 15.7 features..............................................................64 NetWorker User for Sybase...........................................................65 NMDA Sybase recovery wizard..................................................... 65 NMDA components.................................................................................... 66 NMDA backup and restore processes.........................................................68 Regular scheduled backup processes............................................ 68 Regular restore processes............................................................. 69 Backup Configuration 71 Configuring NMDA backups........................................................................72 Configuring internationalization (I18N) support.......................................... 73 I18N support requirements.............................................................75 Configuring I18N support for Informix operations.......................... 75 Chapter 2 CONTENTS 4 EMC NetWorker Module for Databases and Applications 9.1 Administration Guide Configuring I18N support for Oracle operations.............................75 Configuring I18N support for Sybase operations............................ 77 Verifying the database or application server configuration..........................77 Verifying the basic NetWorker resource configurations..............................77 Verifying the NetWorker Server resource......................................77 Verifying the NetWorker User Group resource.............................. 78 Verifying the NetWorker Client resource........................................81 Verifying the NetWorker Device resource...................................... 81 Verifying the NetWorker Pool and Label Template resources.........81 Configuring the firewall support..................................................... 81 Configuring scheduled backups with the wizard..........................................81 Requirements for using the backup configuration wizard.............. 82 Configuring a scheduled backup with the wizard........................... 83 Configuring scheduled backups without the wizard....................................85 Configuring the NMDA parameters without the wizard................. 85 Configuring the data protection policy with NMC..........................87 Configuring the Client resource.....................................................88 Configuring the backup group....................................................... 94 Configuring the backup policy....................................................... 94 Configuring the backup workflow..................................................95 Configuring the backup action.......................................................95 Configuring manual backups.......................................................................97 Configuring Data Domain backups..............................................................99 Best practices for Data Domain backups to any device................. 99 Configuring DD Boost backups to use Client Direct..................... 100 Configuring DD Boost backups to use a storage node.................. 102 Configuring transaction log backups to traditional NetWorker devices.........................................................................................102 Configuring CloudBoost backups.............................................................. 103 Best practices for CloudBoost backups........................................103 Configuring CloudBoost backups to use Client Direct.................. 103 Configuring CloudBoost backups to use a storage node...............104 Configuring backups to AFTD storage.......................................................104 Configuring Client Direct backups to AFTD..................................104 Configuring storage node backups to AFTD................................. 105 Configuring probe-based backups.............................................................105 NMDA probe................................................................................ 106 User-defined probe...................................................................... 107 Configuring a probe-based backup...............................................107 Configuring parallel backups...................................................................... 113 Configuring DB2 parallel backups..................................................114 Configuring Informix parallel backups........................................... 115 Configuring Lotus parallel backups............................................... 115 Configuring Oracle parallel backups..............................................115 Configuring Sybase parallel (multistripe) backups........................ 115 DB2 backup considerations........................................................................116 Configuring automatic deletion of DB2 recovery objects.............. 116 Configuring automatic backups of DB2 transaction logs...............116 Informix backup considerations..................................................................117 Configuring automatic (continuous) backups of Informix logical logs ..................................................................................................... 117 Lotus backup considerations......................................................................118 Setting the environment for Lotus manual backups on Solaris or Linux............................................................................................. 118 Considerations for Lotus database or directory link backups........ 118 Considerations for Lotus transaction log backups.........................119 CONTENTS EMC NetWorker Module for Databases and Applications 9.1 Administration Guide 5 Lotus incremental backups with the comfort span option............ 120 Configuring partitioned Domino server backups........................... 120 Configuring Lotus DAOS backups................................................. 121 Configuring Lotus restartable scheduled backups........................ 125 MySQL backup considerations..................................................................125 Configuration parameter settings.................................................125 Considerations for MySQL whole and partial backups..................126 Considerations for MySQL incremental backups.......................... 127 Considerations for MySQL binary log backups............................. 127 MySQL backup privileges.............................................................128 Configuring MySQL 5.6 features..................................................128 Considerations for backups of MySQL replicated slave servers... 128 Oracle backup considerations................................................................... 129 RMAN scripts for manual backups............................................... 129 RMAN scripts for scheduled backups...........................................130 Configuring automatic channel allocation.....................................133 Creating Oracle backup copies.....................................................134 Configuring save set bundling for scheduled Oracle backups....... 136 Configuring policy uniformity for scheduled Oracle backups........ 137 Configuring operations in an Oracle Data Guard environment...... 138 Sybase backup considerations.................................................................. 138 Setting up Sybase roles and permissions......................................139 Specifying verification of Sybase database backups.................... 139 Specifying volume pools for Sybase incremental backups............140 Sybase transaction log backups in an emergency.........................140 Configuring a Sybase threshold procedure................................... 141 Setting the environment for Sybase backups on HP-UX.............. 143 Configuring Sybase ASE 15.7 backup features............................. 144 Backup Procedures 147 Performing scheduled backups................................................................. 148 Testing scheduled backups.......................................................... 148 Canceling scheduled backups.......................................................148 Restarting failed scheduled backups............................................ 149 Monitoring scheduled backups.....................................................150 Performing manual backups......................................................................150 Performing DB2 manual backups with the db2 backup command.... 151 Performing DB2 manual backups with the DB2 GUI......................151 Performing Informix manual backups with the onbar command....152 Performing Lotus manual backups with the nsrdasv command.... 153 Performing Lotus manual backups with NetWorker User for Lotus... 153 Performing MySQL manual backups with the nsrdasv command. 155 Performing Oracle manual backups with the rman command....... 156 Performing Oracle manual backups with Oracle Enterprise Manager .....................................................................................................156 Performing Sybase database consistency checks before backups.... 157 Performing Sybase manual backups with the nsrdasv command..158 Performing Sybase manual backups with NetWorker User for Sybase......................................................................................... 158 Canceling manual backups........................................................... 160 Monitoring manual backups.......................................................... 161 Verifying backup information in NetWorker indexes.................................. 161 Chapter 3 CONTENTS 6 EMC NetWorker Module for Databases and Applications 9.1 Administration Guide Verifying Data Domain backup information in NetWorker indexes.... 162 Lotus restartable backup information in NetWorker indexes........ 163 MySQL backup information in NetWorker indexes....................... 163 Synchronizing backup catalogs and deleting backups............................... 164 Deleting DB2 backups.................................................................. 165 Deleting Informix backups............................................................ 166 Cross-checking and deleting Oracle backups............................... 167 Data Restore and Recovery 169 Data restore and recovery terminology..................................................... 170 NetWorker indexes and policies that are used for restores...........170 Performing NMDA data restore and recovery............................................171 Performing DB2 data restore and recovery............................................... 173 Determining how many restore devices and sessions to use.........174 Performing DB2 data restores with the db2 restore command.....175 Performing DB2 data recovery..................................................... 179 Performing DB2 data restore and recovery with the NMDA DB2 recovery wizard............................................................................182 Performing DB2 data restore and recovery with the DB2 GUI......183 Performing DB2 data recovery with the DB2 HPU utility..............184 Performing DB2 rollforward recovery after a load with copy yes option...........................................................................................185 Performing Informix data restore and recovery.........................................186 Determining the Informix restore mode........................................186 Performing Informix data restores with the onbar command........187 Performing Lotus data restore and recovery.............................................189 Performing Lotus database recovery with the nsrnotesrc command .....................................................................................................190 Performing Lotus database restore and recovery with the NMDA Lotus recovery wizard..................................................................194 Performing Lotus database recovery with NetWorker User for Lotus............................................................................................195 Performing recovery uploads/Finance/ ndma-admin-guide.pdf

  • 10
  • 0
  • 0
Afficher les détails des licences
Licence et utilisation
Gratuit pour un usage personnel Attribution requise
Partager
  • Détails
  • Publié le Aoû 13, 2021
  • Catégorie Business / Finance
  • Langue French
  • Taille du fichier 2.2595MB