NetBackup83_Adminguide_Oracle.pdf - Veritas NetBackup\u2122 for Oracle Administrator's Guide UNIX Windows and Linux Release 8.3 Veritas NetBackup\u2122 for

NetBackup83_Adminguide_Oracle.pdf - Veritas NetBackupu2122...

This preview shows page 1 out of 357 pages.

You've reached the end of your free preview.

Want to read all 357 pages?

Unformatted text preview: Veritas NetBackup™ for Oracle Administrator's Guide UNIX, Windows, and Linux Release: 8.3 Veritas NetBackup™ for Oracle Administrator's Guide Last updated: 2020-07-28 Legal Notice Copyright © 2020 Veritas Technologies LLC. All rights reserved. Veritas, the Veritas Logo, and NetBackup are trademarks or registered trademarks of Veritas Technologies LLC or its affiliates in the U.S. and other countries. Other names may be trademarks of their respective owners. This product may contain third-party software for which Veritas is required to provide attribution to the third party (“Third-party Programs”). Some of the Third-party Programs are available under open source or free software licenses. The License Agreement accompanying the Software does not alter any rights or obligations you may have under those open source or free software licenses. Refer to the Third-party Legal Notices document accompanying this Veritas product or available at: The product described in this document is distributed under licenses restricting its use, copying, distribution, and decompilation/reverse engineering. No part of this document may be reproduced in any form by any means without prior written authorization of Veritas Technologies LLC and its licensors, if any. THE DOCUMENTATION IS PROVIDED "AS IS" AND ALL EXPRESS OR IMPLIED CONDITIONS, REPRESENTATIONS AND WARRANTIES, INCLUDING ANY IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE OR NON-INFRINGEMENT, ARE DISCLAIMED, EXCEPT TO THE EXTENT THAT SUCH DISCLAIMERS ARE HELD TO BE LEGALLY INVALID. Veritas Technologies LLC SHALL NOT BE LIABLE FOR INCIDENTAL OR CONSEQUENTIAL DAMAGES IN CONNECTION WITH THE FURNISHING, PERFORMANCE, OR USE OF THIS DOCUMENTATION. THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS SUBJECT TO CHANGE WITHOUT NOTICE. The Licensed Software and Documentation are deemed to be commercial computer software as defined in FAR 12.212 and subject to restricted rights as defined in FAR Section 52.227-19 "Commercial Computer Software - Restricted Rights" and DFARS 227.7202, et seq. "Commercial Computer Software and Commercial Computer Software Documentation," as applicable, and any successor regulations, whether delivered by Veritas as on premises or hosted services. Any use, modification, reproduction release, performance, display or disclosure of the Licensed Software and Documentation by the U.S. Government shall be solely in accordance with the terms of this Agreement. Veritas Technologies LLC 2625 Augustine Drive Santa Clara, CA 95054 Technical Support Technical Support maintains support centers globally. All support services will be delivered in accordance with your support agreement and the then-current enterprise technical support policies. For information about our support offerings and how to contact Technical Support, visit our website: You can manage your Veritas account information at the following URL: If you have questions regarding an existing support agreement, please email the support agreement administration team for your region as follows: Worldwide (except Japan) [email protected] Japan [email protected] Documentation Make sure that you have the current version of the documentation. Each document displays the date of the last update on page 2. The latest documentation is available on the Veritas website: Documentation feedback Your feedback is important to us. Suggest improvements or report errors or omissions to the documentation. Include the document title, document version, chapter title, and section title of the text on which you are reporting. Send feedback to: [email protected] You can also see documentation information or ask a question on the Veritas community site: Veritas Services and Operations Readiness Tools (SORT) Veritas Services and Operations Readiness Tools (SORT) is a website that provides information and tools to automate and simplify certain time-consuming administrative tasks. Depending on the product, SORT helps you prepare for installations and upgrades, identify risks in your datacenters, and improve operational efficiency. To see what services and tools SORT provides for your product, see the data sheet: Contents Chapter 1 Introduction .......................................................................... 13 What’s new about NetBackup for Oracle ........................................... About NetBackup for Oracle ........................................................... NetBackup for Oracle features ........................................................ NetBackup for Oracle terminology .................................................... NetBackup for Oracle operation using the Oracle Intelligent Policy ........................................................................................... Logging the RMAN input and output on a client .................................. NetBackup for Oracle operation using a script- or template-based policy ........................................................................................... About Oracle RMAN ..................................................................... About the Oracle recovery catalog ................................................... Chapter 2 NetBackup for Oracle QuickStart Installing NetBackup for Oracle Oracle policy configuration 24 25 27 29 30 33 35 .................................... 39 Verifying the operating system and platform compatibility ...................... NetBackup server and client requirements ......................................... Requirements for using NetBackup for SAP MaxDB, SAP Oracle, and SAP HANA in a NetBackup cluster ............................................. About the license for NetBackup for Oracle ........................................ About linking Oracle RMAN with NetBackup for UNIX .......................... Verifying environment variables and shutting down Oracle .............. Linking Oracle RMAN with NetBackup on UNIX platforms ............... Chapter 4 22 23 ................................. 29 Installing NetBackup for Oracle ....................................................... Registering Oracle database instances ............................................. Creating an Oracle database instance group ...................................... Creating an Oracle policy ............................................................... Chapter 3 13 14 15 20 39 40 40 41 41 42 43 ............................................. 49 Preparing for NetBackup for Oracle configuration ................................ About Oracle policy configuration ............................................... Permissions for NetBackup for Oracle log directories ..................... NetBackup for Oracle backup policy types ................................... 49 50 51 52 Contents Configuring the Maximum jobs per client for NetBackup for Oracle ..................................................................................... 58 Instance management for an Oracle Intelligent Policy .......................... 59 About the NetBackup Discovery Service ..................................... 61 Viewing the Oracle database instance repository .......................... 62 Manually adding an Oracle database instance to the repository ..................................................................................... 63 Registering an Oracle database instance .................................... 66 About Oracle database instance groups ...................................... 69 Adding an instance to an instance group ..................................... 69 Automatic Registration of an instance group ................................ 70 About instance actions ............................................................ 72 About Oracle Intelligent Policies (OIP) .............................................. 73 Creating an Oracle Intelligent Policy (OIP) ................................... 75 Oracle database upgrade effect on Oracle Intelligent Policies ..................................................................................... 78 Configuring NetBackup for Oracle automatic backup schedules ..................................................................................... 79 About NetBackup for Oracle schedule properties using Oracle Intelligent Policy ............................................................... 80 Oracle Intelligent Policy - Storage and Retention ........................... 81 About Oracle Intelligent Policy master server behavior ................... 83 Instances and Databases tab .................................................... 83 Backup Selections tab ............................................................. 86 Oracle tab ............................................................................. 88 About using a NetBackup appliance share for Oracle backups (Copilot) ......................................................................... 91 Configuring an OIP using a share on the NetBackup appliance (Copilot) ......................................................................... 93 About script- or template-based Oracle policies .................................. 95 Adding a new script- or template-based Oracle policy .................... 96 About policy attributes ............................................................. 98 About backup schedules, templates, and scripts ........................... 98 About schedule properties ....................................................... 98 Script- or template-based policy - Storage and Retention .............. 100 Adding clients to a policy ........................................................ 102 About adding backup selections to an Oracle policy ..................... 103 About configuring the run-time environment ............................... 105 About creating templates and shell scripts ................................. 114 Configuring the logon account for the NetBackup Client Service for NetBackup for Oracle ............................................................ 122 Testing configuration settings for NetBackup for Oracle ...................... 123 5 Contents Chapter 5 Performing backups and restores of Oracle ............ 125 Overview of using NetBackup for Oracle .......................................... Maintaining the RMAN repository ................................................... Querying the RMAN repository ...................................................... About NetBackup for Oracle backups .............................................. Running NetBackup for Oracle templates .................................. Using bpdbsbora to run a backup template ................................ Running the NetBackup for Oracle shell script ............................ Running RMAN .................................................................... Browsing backups using the bplist command .................................... Managing expired backup images .................................................. About NetBackup for Oracle restores .............................................. Starting the recovery wizard .................................................... Using the recovery wizard ...................................................... Using bpdbsbora to run a recovery template ............................... About an Oracle recovery shell script on the client ....................... Running RMAN on the client ................................................... About Oracle multistream restore for proxy backup ...................... Redirecting a restore to a different client .................................... Using NetBackup for Oracle in a Microsoft Windows cluster environment ........................................................................ About backups of an Oracle clustered database on Windows .................................................................................... Bringing the database instance offline on Windows ...................... Bringing the database instance online on Windows ...................... User-directed backup or restore from the Windows client .............. Creating an instant recovery point from an Oracle Copilot image .......... Deleting an instant recovery point for Oracle Copilot instant recovery .......................................................................................... Cleaning up the Copilot share after point in time restore of database .......................................................................................... Single-step restore to ASM storage from a Copilot recovery point ......... About restoring from a data file copy to ASM storage using RMAN .......................................................................................... Chapter 6 Guided Recovery 125 126 130 131 132 133 134 135 135 136 138 139 139 141 141 142 142 144 148 148 149 150 150 151 154 155 161 165 ............................................................. 166 About Guided Recovery ............................................................... Setting up for Guided Recovery cloning ........................................... Guided Recovery cloning pre-operation checks ................................ Performing a Guided Recovery cloning operation .............................. Select a Master Server dialog ........................................................ Select Source Database panel ...................................................... 166 167 167 168 170 170 6 Contents Select Control File Backup panel ................................................... Destination host and login panel .................................................... Destination Parameters panel ....................................................... Selection summary panel ............................................................. Pre-clone check panel ................................................................. Job Details panel ........................................................................ Guided Recovery post-clone operations .......................................... Troubleshooting Guided Recovery ................................................. Troubleshooting files for metadata collection operations at the time of the backup .......................................................... Troubleshooting files for Guided Recovery validation operations .................................................................................... Troubleshooting files for Guided Recovery cloning operations .................................................................................... Chapter 7 NetBackup for Oracle with Snapshot Client 171 171 172 173 173 173 173 174 175 175 176 ............ 178 About NetBackup for Oracle with Snapshot Client ............................. Proxy copy .......................................................................... NetBackup for Oracle stream-based operations .......................... NetBackup for Oracle file-based operations ................................ How NetBackup for Oracle with Snapshot Client works ....................... About the NetBackup for Oracle backup and restore operations .................................................................................... Database objects supported by advanced backup methods ........... About NetBackup multistreaming ............................................. RMAN multiple channels ........................................................ Restoring data files to a new location ........................................ Redirecting a restore to a different client .................................... Symbolic links and raw data files (UNIX) .................................... Quick I/O data files (UNIX) ...................................................... RMAN incremental backups .................................................... Proxy backup examples ......................................................... About configuring Snapshot Client with NetBackup for Oracle .............. Configuration requirements for snapshot backups with NetBackup for Oracle ...................................................................... Configuring a snapshot policy for NetBackup for Oracle ................ Configuring a snapshot policy using a share on the NetBackup appliance (Copilot) .......................................................... Restoring NetBackup for Oracle from a snapshot backup .................... About restoring individual files from a NetBackup for Oracle snapshot backup ............................................................ 178 180 180 181 182 183 183 184 184 184 185 185 185 186 187 190 190 191 195 197 197 7 Contents About NetBackup for Oracle restores of volumes and file systems using snapshot rollback ................................................... About configuring NetBackup for Oracle block-level incremental backups on UNIX .................................................................. How BLI works with NetBackup for Oracle (UNIX) ....................... About the Storage Checkpoint facility and NetBackup for Oracle .................................................................................... Configuration requirements for BLI backups with NetBackup for Oracle .......................................................................... Configuring policies for BLI backups with NetBackup for Oracle .................................................................................... About Snapshot Client effects ....................................................... How Snapshot Client software affects backup types ..................... How Snapshot Client software affects schedule properties ............ How Snapshot Client software affects templates and scripts .......... NetBackup for Oracle with Snapshot Client environment variables .................................................................................... About Oracle support for Replication Director ................................... Configuring an Oracle Intelligent Policy using Replication Director .................................................................................... Configuring a script- or template-based Oracle policy ................... Chapter 8 198 200 201 202 203 203 205 205 205 206 207 208 209 215 Troubleshooting ................................................................ 221 About troubleshooting NetBackup for Oracle .................................... About NetBackup for Oracle troubleshooting steps ............................ NetBackup debug logs and reports ................................................. Enabling the debug logs manually (Windows) ................................... Enabling the debug logs manually (UNIX) ........................................ About the NetBackup for Oracle log files .......................................... Setting the debug level on a Windows client ..................................... Setting the debug level on a UNIX client .......................................... About RMAN utility logs ............................................................... Troubleshooting RMAN backup or restore errors ............................... Verifying the RMAN script on UNIX ........................................... Troubleshooting each stage of the backup or restore ................... Troubleshooting the UNIX browser interface and wizards .................... Troubleshooting NetBackup for Oracle with Snapshot Client ................ Minimizing timeout failures on large database restores ....................... Minimizing the loading and unloading of tapes for database backups .......................................................................................... Delays in backup job transfer and completion ................................... 222 222 224 225 226 228 230 230 231 231 231 232 234 235 236 237 237 8 Contents Appendix A Ap...
View Full Document

  • Spring '17
  • kevin croteu
  • Veritas NetBackup, Oracle Administrator

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture