3Com NSR-ORA V3.2 - Manuals

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...

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...

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...

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...

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 ...

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...

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...

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...

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...

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_...

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...

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>...

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...

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...

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 ...

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 ...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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 ...

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...

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...

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...

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)...

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...

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...

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...

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...

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...

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 ...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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 ...

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...

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...

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...

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...

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...

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 (...

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...

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...

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 ...

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...

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...

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...