Page 2 - Copyright and Trademarks
Copyright and Trademarks Copyright © Fujitsu Siemens Computers GmbH 2001. All rights reserved.Delivery subject to availability; right of technical modifications reserved. All hardware and software names used are trademarks of their respective manufacturers. This manual was produced bycognitas. Gesel...
Page 3 - System Administrator’s Guide; Preface; Audience; boldface; Cancel
System Administrator’s Guide U42252-J-Z915-1-76 1 Preface This guide provides information about how to install, configure and operate the “NetWorker Save and Restore for ORAcle (NSR-ORA)” V3.2 NetWorker com-ponent. 1.1 Audience The information in this guide is intended for system and database admini...
Page 4 - What is New in Release 3.2; SVRMGRL; Update from Previous Releases; “How to Proceed for an Update from an Earlier
System Administrator’s Guide U42252-J-Z915-1-76 Preface What is New in Release 3.2 1.3 What is New in Release 3.2 With release V3.2 a number of changes have been made to NSR-ORA, influen-cing this guide: ● NSR-ORA V3.2 does now suppor t Oracle 8.x or 9i ● Version 9 of the Oracle database does not in...
Page 5 - Introduction; “Recovery”
System Administrator’s Guide U42252-J-Z915-1-76 2 Introduction This guide to Backing up and Restoring a Database describes the functionality, installation, configuration and adminstration of the NetWorker component “Net-Worker Save and Restore for ORAcle (NSR-ORA)” V3.2. This software compo-nent all...
Page 6 - The Physical Database Structure; figure 1; The Logical Database Structure; figure 2
System Administrator’s Guide U42252-J-Z915-1-76 Introduction The Physical Database Structure 2.1 The Physical Database Structure The physical database (see figure 1 ) consists of at least one control file, one parameter file, at least two redolog files and at least one database file. Figure 1: The p...
Page 7 - The Database Backup; figure 3; database files
System Administrator’s Guide U42252-J-Z915-1-76 Introduction The Database Backup Figure 2: Logical database structure 2.3 The Database Backup Every recovery procedure depends on a correctly performed database backup, which consists of copies of the database files being made at operating system level...
Page 8 - amon
System Administrator’s Guide U42252-J-Z915-1-76 Introduction Archive Mode of the Database NSR-ORA checks that the database is in ARCHIVELOG mode, and will abort the backup of the database if this is not the case if an online backup is to be car-ried out. An offline backup can be performed even if th...
Page 9 - Function Scope; automatic
System Administrator’s Guide U42252-J-Z915-1-76 Introduction Function Scope these redolog files had already been saved on the backup medium by the archiving monitor and then automatically deleted, they will be read in again and reapplied until the database is up to date. The database is then opened ...
Page 10 - The individual Components; “Installation and Configuration”; The Archiving Monitor
System Administrator’s Guide U42252-J-Z915-1-76 3 The individual Components The individual components for backing up and recovering an ORACLE database in a NetWorker environment are described in the following section. Four different areas are dealt with: ● The archiving monitor ● The backup componen...
Page 11 - DBMS
System Administrator’s Guide U42252-J-Z915-1-76 The individual Components The Archiving Monitor Figure 4: The archiving monitor The archiving monitor amon has the task of permanently and regularly monitoring and backing up the offline redolog files, which accrue in the archive directory. Once the co...
Page 12 - Starting and Ending the Archiving Monitor; nsr
System Administrator’s Guide U42252-J-Z915-1-76 The individual Components The Archiving Monitor 3.1.1 Starting and Ending the Archiving Monitor A control program start_amon.sh is provided in the directory ${NSR_INST}/ora- cle/bin for coordinating the activities of the archiving monitor. This program...
Page 13 - A subsequent status enquiry generates the following output:
System Administrator’s Guide U42252-J-Z915-1-76 The individual Components The Archiving Monitor AMON_GROUP=amon_ora_psiAMON_MAX_LOGS=4AMON_INTERVALL=1800AMON_MIRROR_GROUP=amon2_ora_psiAMON_MIRROR_SERVER=psi With these prerequisites fulfilled, the user can star t the archiving monitor: sh> start_a...
Page 14 - Logging; Protocol file
System Administrator’s Guide U42252-J-Z915-1-76 The individual Components The Archiving Monitor 3.1.2 Logging While the archiving monitor is active, the occupancy level of the archive direc-tory and other important events are logged at regular intervals ( AMON_INTERVALL ) in the protocol file ${DBO_...
Page 15 - The Backup Component; figure 5
System Administrator’s Guide U42252-J-Z915-1-76 The individual Components The Backup Component ......00-05-08:16:52:01: DEBUG:oraarch1_54.dbf 01/21/00 13:13:15 s: 0 m: 000-05-08:16:52:01: DEBUG: Print of a save_cmd: /opt/networker/bin/save -i -l full -g amonorapsi -s psi00-05-08:16:52:01: oraarch1_4...
Page 16 - Offline Backup of the Database
System Administrator’s Guide U42252-J-Z915-1-76 The individual Components The Backup Component Figure 5: The backup component 3.2.1 Offline Backup of the Database configure_nsrora and configure_networker can be used, if required, to create a new client and a new group called OFFLINE<oracle_sid>...
Page 17 - system files or raw devices are involved.; all instances; are either offline or online!
System Administrator’s Guide U42252-J-Z915-1-76 The individual Components The Backup Component 1. The database is started up briefly to determine the database files allocated to a tablespace. Normally, several tablespaces are backed up during an archiving process. 2. The database is closed. 3. All t...
Page 18 - Online Backup of the Database; alter tablespace begin backup; Configuration and management
System Administrator’s Guide U42252-J-Z915-1-76 The individual Components The Backup Component 3.2.2 Online Backup of the Database An online backup of the database is performed whenever the database is open at the time of the backup. In contrast to offline backups, the following phases are carried o...
Page 19 - NoSave; Log files from local backups (not for NAS filers); tablespaces
System Administrator’s Guide U42252-J-Z915-1-76 The individual Components The Backup Component 3.2.4 Checking backups (troubleshooting) If an error occurs when backing up the database or if one of the backup pro-cesses does not end cleanly, the entire database backup is abor ted and all tablespaces ...
Page 20 - AMON Recordings; “Logging”; one; Backup Command
System Administrator’s Guide U42252-J-Z915-1-76 The individual Components The Backup Component The shell script saveinfo.sh in the directory $NSR_INST/oracle/bin evaluates the protocol files save*.prot in the subdirectory tablespaces and tells you the status, the start and end of a backup, the type ...
Page 21 - is not
System Administrator’s Guide U42252-J-Z915-1-76 The individual Components The Backup Component concurrency used by NSR-ORA when backing up tablespaces is one less than the concurrency of NetWorker when nsrora_save_cmd is not used, because NSR-ORA always uses one backup for internal purposes. The dat...
Page 22 - Installation and Configuration; Quick Start; “Installing NSR-ORA from CD”
System Administrator’s Guide U42252-J-Z915-1-76 4 Installation and Configuration The following chapter describes the installation and configuration of NSR-ORA. 4.1 Quick Start This section gives experienced users an short overview of all steps required to install and configure NSR-ORA. It is a synop...
Page 23 - Installation; NetWorker; keylic; root
System Administrator’s Guide U42252-J-Z915-1-76 Installation and Configuration Installation 9. Start the archiving monitor amon using the following command: start_amon.sh start $ORACLE_SID (refer also to section “Star ting and Ending the Archiving Monitor“ ) 10. Check the results of your first backu...
Page 24 - Installing NSR-ORA from CD
System Administrator’s Guide U42252-J-Z915-1-76 Installation and Configuration Installation # /opt/nsr/keylic -s <server> <server> is the name of the NetWorker server. ● For NetWorker servers from Fujitsu Siemens Computers prior to NetWorker Version V5.5A21 and Reliant UNIX clients or th...
Page 27 - Configuration; Clients
System Administrator’s Guide U42252-J-Z915-1-76 Installation and Configuration Configuration # cd /tmp/nsr-ora Ê Unpack the NSR-ORA.tar file from the CD: # tar xvf /cdrom/NSR-ORA.tar Ê The installation is then continued with the command: # swinstall -s /tmp/NSRORA_HP_PKG \NSR-ORA 4.3 Configuration 4...
Page 28 - Preparations; Establishing tablespace names
System Administrator’s Guide U42252-J-Z915-1-76 Installation and Configuration Configuration 4.3.2 Preparations First make sure of the following: If you have several database instances on one computer, the redolog files of the various instances must have been created each in their own separate direc...
Page 29 - Size; Checking the ORACLE Administration Program; sqldba
System Administrator’s Guide U42252-J-Z915-1-76 Installation and Configuration Configuration Size Tablespace File in [K] in [M]---------- --------------------------SYSTEM /oracle/7_0_16/dbs/system1.dbf 8,192 8 /oracle/7_0_16/dbs/system2.dbf 2,048 2********** ------- -----sum 10,240 10 TEMP_TS /oracl...
Page 31 - monday; Parameters for configure_nsrora; Oracle Parameters
System Administrator’s Guide U42252-J-Z915-1-76 Installation and Configuration Configuration In the configuration directory /nsr/oracle/${ORACLE_SID} on request a directory is created for each weekday ( monday , tuesday ,...), and the directory ${ORACLE_SID}_full_save is created for full backups. If...
Page 32 - PATH
System Administrator’s Guide U42252-J-Z915-1-76 Installation and Configuration Configuration ORACLE_SID Name of the ORACLE entity. If several ORACLE databases are installed on the same computer, NSR-ORA can distinguish them clearly by means of the ORACLE_SID . ORACLE_OWNER ORACLE owner. ORACLE_GROUP...
Page 33 - “Configuring NSR-ORA”; true; AMON Parameters; not
System Administrator’s Guide U42252-J-Z915-1-76 Installation and Configuration Configuration The next query depends on the usage of an NAS filer. When you are using such an NAS filer and so answer y to this question you have to input the information described in section “Configuring NSR-ORA” . BACKU...
Page 34 - MIRROR
System Administrator’s Guide U42252-J-Z915-1-76 Installation and Configuration Configuration This makes it possible to carry out a recovery more rapidly, or to carry out a point-in-time recovery without having to read in the redolog files, since the existing redolog files can be used. AMON_INTERVALL...
Page 35 - OPS; yes
System Administrator’s Guide U42252-J-Z915-1-76 Installation and Configuration Configuration OPS Parameters OPS = yes | no You use this parameter to specify whether or not NSR-ORA will be used under Oracle Parallel Server (OPS). OPS_INSTANCES If you are using NSR-ORA under OPS, this parameter contai...
Page 37 - GZIP; Example
System Administrator’s Guide U42252-J-Z915-1-76 Installation and Configuration Configuration ● GZIP is used with the default value 1. ● BZIP2 no level is given to, so the default value of the algorithm will be used (see the uasm(1) manpage for fur ther information). 4.3.5 Defining backup sets (save ...
Page 38 - “Automatic Recovery for an Optional Point in
System Administrator’s Guide U42252-J-Z915-1-76 Installation and Configuration Configuration /nsr/oracle/ora/wednesday:USER1_TS USER2_TS /nsr/oracle/ora/thursday:ROLLBACK_TSUSER1_TS /nsr/oracle/ora/friday:USER1_TS /nsr/oracle/ora/${ORACLE_SID}_full_save:SYSTEM /nsr/oracle/ora/${ORACLE_SID}_offline:S...
Page 39 - Configuring NetWorker; create; delete
System Administrator’s Guide U42252-J-Z915-1-76 Installation and Configuration Configuration This configuration helps fulfill the requirements for the NSR-ORA administrator to define a backup schedule within NetWorker. The steps necessary for this are explained in the following section. 4.3.6 Config...
Page 40 - You will find an example of the progress of
System Administrator’s Guide U42252-J-Z915-1-76 Installation and Configuration Configuration You will find an example of the progress of configure_networker below: root 68 # configure_networker create ORA2 *-----------------------------------------------------------------------------*| || This scrip...
Page 41 - NSR-ORA in OPS clusters; on all; the OPS nodes as described in the
System Administrator’s Guide U42252-J-Z915-1-76 Installation and Configuration NSR-ORA in OPS clusters They will be used to configure your NetWorker Server. Please press ENTER to continue created resource id 0.20.3.237.51.225.160.62.77.0.0.4(1)created resource id 0.21.3.237.51.225.160.62.77.0.0.4(1)...
Page 43 - Troubleshooting; Backing Up an Oracle Database Version 8.0 or higher
System Administrator’s Guide U42252-J-Z915-1-76 Installation and Configuration Troubleshooting 4.5 Troubleshooting Backing Up an Oracle Database Version 8.0 or higher There is an Oracle Error in Oracle 8.0 to 8.0.5 (Generic BUGID 673508 and 677804) which may lead to an inconsistent backup when perfo...
Page 44 - Recovery; Selecting the Type of Recovery; The Recovery Component; figure 6
System Administrator’s Guide U42252-J-Z915-1-76 5 Recovery This chapter describes the various ways in which you can carry out a recovery for an ORACLE database. We recommend you try out a recovery of your database on a test system. This will enable you to become familiar with the possible procedures...
Page 45 - Recovery Until Time with Logical Errors
System Administrator’s Guide U42252-J-Z915-1-76 Recovery Selecting the Type of Recovery Naturally, you can also restore the database “manually”, i.e. without using the automatic facilities of NSR-ORA. Figure 6: The recovery component 5.1.2 Recovery Until Time with Logical Errors The recovery until t...
Page 46 - shutdown abort
System Administrator’s Guide U42252-J-Z915-1-76 Recovery Selecting the Type of Recovery 5.1.3 Automatic Recovery (Crash Recovery) In the case of a fully-automatic recovery, NSR-ORA deals with the entire task of restoring the damaged tablespaces and redolog files without any further operator interven...
Page 47 - backup then it cannot be recreated automatically.; Manual recovery; Performing a recovery; , the second section describes an fully-automatic
System Administrator’s Guide U42252-J-Z915-1-76 Recovery Performing a recovery An automatic recovery is quite unsuitable if the fault in the database files is not a physical media failure but a logical error in the data of the database. The automatic recovery procedure has no way of detecting logica...
Page 48 - Automatic Recovery for an Optional Point in Time; time
System Administrator’s Guide U42252-J-Z915-1-76 Recovery Performing a recovery 5.2.1 Automatic Recovery for an Optional Point in Time This section documents the use of the ora_recut command with the aid of which you can automatically recover a specific database level (recovery until time). In order ...
Page 49 - database reset logfiles; Fully-automatic Recovery
System Administrator’s Guide U42252-J-Z915-1-76 Recovery Performing a recovery Please look for a solution or give up!!Sqldba> or ERROR: couldn’t get log_file < ....dbf > Please try to find it yourself$ You can enter optional commands after the prompts Sqldba> and $ in order to recover er...
Page 51 - Manual Recovery; Offline recovery of an offline or full backup; an offline recovery you can proceed as follows:
System Administrator’s Guide U42252-J-Z915-1-76 Recovery Performing a recovery 5.2.3 Manual Recovery This section describes how to completely restore a database (that is, to restore all the tablespaces) manually (i.e. without using NSR-ORA’s automatic facilities) and - if necessary - to a state whic...
Page 52 - alter database open NORESETLOGS
System Administrator’s Guide U42252-J-Z915-1-76 Recovery Performing a recovery This command gives you the names and the save set IDs of all the files saved in <ora_pool> in the period specified. 5. Remove the save set IDs of the following files from this output: – recover_info_last – bootstrap...
Page 53 - Recovery with ORACLE Parallel Server (OPS); recover access
System Administrator’s Guide U42252-J-Z915-1-76 Recovery Performing a recovery 5.2.4 Recovery with ORACLE Parallel Server (OPS) If OPS is being used, you must pay attention to some fur ther prerequisites: ● All OPS instances have to have been specified in the configuration of NSR-ORA. Instances that...
Page 54 - “Manual Recovery”; can only be run on the OPS node; No space left on device; xxx
System Administrator’s Guide U42252-J-Z915-1-76 Recovery Troubleshooting started. You are recommended to use the archive directory of the ”recovery instance“ for this purpose. You can determine which directory this is by issuing the following command: show parameter log_archive_dest In this case you...
Page 55 - nnnnn
System Administrator’s Guide U42252-J-Z915-1-76 Recovery Troubleshooting log belongs to wrong database archived log ends at change nnnnn , need later change mmmmm If you get this or a similar error message, then the reason is generally that you executed an open database resetlogs command after a rec...
Page 56 - Running NSR-ORA with NAS devices; NetApp Filers
System Administrator’s Guide U42252-J-Z915-1-76 6 Using NSR-ORA with NetApp Filers This chapter describes how to configure and use NSR-ORA with NetApp Filers 6.1 Running NSR-ORA with NAS devices NSR-ORA allows database files stored on a Network Attached Storage (NAS) you to be backed up or recover o...
Page 57 - Prerequisites; “Defining the NDMP Client”
System Administrator’s Guide U42252-J-Z915-1-76 NSR-ORA and NetApp Prerequisites ● The administrator may perform an offline backup within a few minutes. This is done by making NSR-ORA shut down the database automatically and restarting it after the backup process is completed (i. e. after the snapsh...
Page 58 - Recommendations; Amon; Configuring NSR-ORA with NetApp Filers
System Administrator’s Guide U42252-J-Z915-1-76 NSR-ORA and NetApp Recommendations 6.3 Recommendations This section provides recommendations for using NSR-ORA to backup data on high performance NAS devices. 1. For the Archivelog files backup ( Amon backups) and to save the backup infor- mation a sec...
Page 59 - the cycle when the backup
System Administrator’s Guide U42252-J-Z915-1-76 NSR-ORA and NetApp Configuring NSR-ORA NETAPP_SNAP_NR=[0-30]:[0-30]:[0-30] This parameter defines the type of and number of snapshot backups to be kept for a restore process. NetWorker uses three types of snapshots: snapshot-by-week (first value), snap...
Page 60 - snap list
System Administrator’s Guide U42252-J-Z915-1-76 NSR-ORA and NetApp Configuring NSR-ORA Using the snap list command the administrator can obtain information about the number and the dates of creation of the existing snapshots. Example: NETAPP_SNAP_NR=2:5:5 With this command, NetWorker will perform a ...
Page 61 - savegroup; This causes no
System Administrator’s Guide U42252-J-Z915-1-76 NSR-ORA and NetApp Configuring NSR-ORA database rarely change, it may be usefull to keep the snapshots for a few weeks. If the rate of change is high it may be suffient to keep only a few snapshots-by-hour. For a moderate rate of changes it may be usef...
Page 62 - “NetWorker Resources”
System Administrator’s Guide U42252-J-Z915-1-76 NSR-ORA and NetApp Configuring NSR-ORA The configure_nsrora script does not ask you to set up this parameter, so you may have to set it up manually by changing the dbo${ORACLE_SID}.init configuration file. With this parameter you choose the protocol NS...
Page 64 - Defining the NDMP Client
System Administrator’s Guide U42252-J-Z915-1-76 NSR-ORA and NetApp Configuring NSR-ORA Scenario 3: Seven Backups per Day In this scenario NetWorker performs seven backups per day: Every four hours a snapshot backup is performed. Additionally another snapshot with an additional tape backup is star te...
Page 65 - NetWorker Resources; Groups
System Administrator’s Guide U42252-J-Z915-1-76 NSR-ORA and NetApp Configuring NSR-ORA ● Password attribute For an NDMP backup the NDMP client needs the password of the NDMP user for the NetApp Filer. This password must be entered into the attribute Password . ● Backup command attribute Here the adm...
Page 67 - “Defining the; NDMP
System Administrator’s Guide U42252-J-Z915-1-76 NSR-ORA and NetApp Configuring NSR-ORA This parameter overwrites the backup level of the respective NetWorker client which is preset in the clients schedule. Thus you can reduce the configuration to the definition of a client. “Pure snapshot backups” a...
Page 69 - NSR-ORA needs two or three NetWorker pools for NDMP backups:; Amon Client; Backup methods; Backup level
System Administrator’s Guide U42252-J-Z915-1-76 NSR-ORA and NetApp Backup Pools NSR-ORA needs two or three NetWorker pools for NDMP backups: ● One pool is required for the backup of database tablespace files. This pool must be usable on the NDMP drive. These pools must also be available for normal (...
Page 70 - The savegrp completion notification; The
System Administrator’s Guide U42252-J-Z915-1-76 NSR-ORA and NetApp Backup If the level is set to a value between 1 and 9 then NSR-ORA simply creates a snapshot. ● Save Set : When the save set NDMP is used the current state of the database will be backed up. With the save set specified NSR-ORA perfor...
Page 71 - savegrp completion; Debugging; Recovery with NSR-ORA; Recover until time; or; Which saved Version do you want to use
System Administrator’s Guide U42252-J-Z915-1-76 NSR-ORA and NetApp Recovery The saveinfo.sh command is not relevant to the NDMP backup method, and it will not be started after the backup has completed. If the backup process has been performed successfully you will be informed by the savegrp completi...
Page 72 - “Recovery Until Time with Logical Errors”
System Administrator’s Guide U42252-J-Z915-1-76 NSR-ORA and NetApp Recovery Selecting a tape backup the database recovery process is the same as the one for a usual database recover performed by NSR-ORA (see also section “Recovery Until Time with Logical Errors” ). If you specify a recovery using a ...
Page 73 - snap restore; Example 1: Recovery based on the last snapshot
System Administrator’s Guide U42252-J-Z915-1-76 NSR-ORA and NetApp Recovery If you want NSR-ORA to copy the files (selection “ 1 ”) it will search for the directory with the most free space and will ask you whether the existing archivelog files should be copied to this filesystem. Additionally you m...
Page 74 - Please select one of the following SNAPSHOTS
System Administrator’s Guide U42252-J-Z915-1-76 NSR-ORA and NetApp Recovery Example 2: Recovery based on a specified snapshot Should I try to use a copy from the LAST SNAPSHOT or do you want to select a specific snapshot 1) last SNAPSHOT 2) select SNAPSHOT (default 1:) > 2 Please select one of th...
Page 75 - Index
System Administrator’s Guide U42252-J-Z915-1-76 Index ${ORACLE_SID}_full_save (directory) 37 A actual_saves_of_tablespaces (file) 18 amon 6, 9 daemon 10 display status of 11 figure 10 log file 13 on OPS systems 10 start 11 task of 10 threshold value of 10 AMON_GROUP shell parameter 34 AMON_INTERVALL...
