3Com NSR-ORA V3.2 manual Manual Recovery, Offline recovery of an offline or full backup

Page 51

Recovery

Performing a recovery

5.2.3Manual 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 which it had at some earlier time. We shall assume that you are familiar with both NetWorker and ORACLE.

ORACLE gives you the option of carrying out a recovery either offline or online. When you perform an offline recovery the entire database has the status Mount; this means that the database cannot be used while the recovery is in progress. In the case of an online recovery, only those tablespaces and data files that are currently being restored are switched offline and you can continue working with the rest of the data. An offline recovery is generally recommended if the tablespaces are strongly interdependent (as is the case for e.g. R/3 applica- tions) - in this case the database will have the status Mount throughout the recovery process. A manual offline recovery is described in the following section.

Offline recovery of an offline or full backup

A manual offline recovery is only possible if the backup was also created offline or using the save set ${ORACLE_SID}_full_save (full backup). When you perform an offline recovery you can proceed as follows:

1. Stop the NSR-ORA archiving monitor:

#/opt/nsr/oracle/bin/start_amon.sh stop $ORACLE_SID

(on HP-UX: /opt/networker/oracle/bin/start_amon.sh stop $ORACLE_SID).

2.Shut down the database: shutdown

3.Make sure that NetWorker does not start any other backup jobs while the recovery is in progress, otherwise the recovery jobs and save jobs might compete for the backup devices and so delay the restoration of the tablespaces and redologs. For this reason you should set disabled for any save groups that are about due to start, until the recovery has been completed.

4.Determine all the save sets belonging to the desired full offline backup (must be a full backup), for instance as follows:

#mminfo -v -q ´pool=<ora_pool>, savetime>="mm/dd/yy hh:mm:ss",\ savetime<="mm/dd/yy hh:mm:ss"´ -r "name,ssid"

System Administrator’s Guide

U42252-J-Z915-1-76

Page 50 Page 52
Image 51
Page 50 Page 52
Contents Edition October NSR-ORACopyright and Trademarks Audience ConventionsBoldface What is New in Release Update from Previous ReleasesPreface Introduction Physical Database Structure Logical Database StructureIntroduction Database Backup Archive Mode of the DatabaseDatabase files Control file Archiving System Administrator’s Guide U42252-J-Z915-1-76Function Scope Function ScopeArchiving Monitor Individual ComponentsTape library Individual ComponentsArchive Database interface NSR-ORA ArchivingExample Starting and Ending the Archiving Monitor# startamon.sh status ora ORACLESIDs ora Subsequent status enquiry generates the following outputFollowing is a representative sample from the log file LoggingIndividual ComponentsThe Backup Component Backup ComponentDatabase interface NSR-ORA Backup Archiving Component Offline Backup of the DatabaseIndividual Components Configuration and management Online Backup of the DatabaseLog files from local backups not for NAS filers Checking backups troubleshootingAmon Recordings Individual Components Quick Start Installation and ConfigurationLicensing NSR-ORA InstallationInstallation and Configuration Installation then continues interactivelyUnix Client is required Installing NSR-ORA from CDIs to be installed Keylic commandInvoke the following command Log in as root Set the Display variableRufen Sie folgendes Kommando auf HP-UX Use the following command to uninstall NSR-ORA under LinuxUnpack the NSR-ORA.tarfile from the CD ConfigurationHow to Proceed for an Update from an Earlier Version Installation is then with the commandEstablishing tablespace names Example Configuration tool is invoked with the commandPreparations First make sure of the followingChecking the Oracle Administration Program Installation and ConfigurationConfiguring NSR-ORA Oracle Parameters Parameters for configurensroraNetWorker Parameters Directory where Oracle is installedOracle owner Oracle owner groupNo compression is used Amon ParametersNow the amon parameters are queried Mirror Recovery Parameters Parameters with Expert ModeOPS Parameters Amonmirrorgroup Defining backup sets save sets It is also recommended generally to carry out a full backup # configurenetworker createdelete Oraclesid Configuring NetWorkerRoot 68 # configurenetworker create ORA2 Installation ConfigurationNSR-ORA in OPS clusters On HP-UX /opt/networker/oracle/bin/startamon.sh Troubleshooting Backing Up an Oracle Database Version 8.0 or higherNSR-ORA on Linux Recovery Component Selecting the Type of RecoveryRecovery Until Time with Logical Errors RecoveryControl file Database files Automatic Recovery Crash Recovery Manual recovery Performing a recoveryStart orarecut Automatic Recovery for an Optional Point in TimeNew recovery attempt with orarecut can be made Fully-automatic RecoveryRecovery Offline recovery of an offline or full backup Open the database using RecoveryPerforming a recoveryRecover the remaining save sets again For the recovery of an online backup onlyRecovery with Oracle Parallel Server OPS No space left on device OracleRecovery Running NSR-ORA with NAS devices Using NSR-ORA with NetApp FilersNSR-ORA and NetApp PrerequisitesRecommendations Configuring NSR-ORA with NetApp FilersNSR-ORA and NetApp NETAPPSNAPNR=255 Nfssave RSH Name Oraclesidndmp One group for pure snapshot backups Scenario 1 Three Backups per DayName Oraclesidndmp Two groups for pure snapshot backups Scenario 2 Two Backups per DayYou should use /vol/vol0 as the save set Scenario 3 Seven Backups per DayDefining the Ndmp Client Name OraclesidsnapintervalGroups NetWorker ResourcesInterval attribute Clients For Ndmp backups NSR-ORA provides two new save setsNdmp attribute Ndmpoffline client has to be assigned toAmon Client Backup with NSR-ORABackup methods PoolsControl file as an Ascii trace file For online backups the binary control fileInformation and log files of the current backup process Savegrp completion notificationRecovery with NSR-ORA Recover until time orarecutDebugging NSR-ORA and NetApp Example 1 Recovery based on the last snapshot Crash Recovery nsrorarecExample 2 Recovery based on a specified snapshot Defining BackupShell parameter DatabaseFor NetApp NetWorker Shell parameter Config.sh OutputFor NetApp Configurensrora IndexInstallation Installing from CD Shell parameter No space left on device error MessageShell parameter Nsrndmpsave command Backup component ComponentsNfssave System Administrator’s Guide U42252-J-Z915-1-76 Configuration Installation on Remarkable thingsShell parameter Orarecut command For NetApp Restore Redolog files OPSOPS Update

NSR-ORA V3.2 specifications

The 3Com NSR-ORA V3.2 is a versatile networking solution designed to enhance connectivity and streamline data management across various enterprise environments. With the rapid evolution of digital communication, 3Com recognized the need for a robust system that caters to the demanding requirements of today's businesses. The NSR-ORA V3.2 is specifically engineered to provide optimal performance, scalability, and reliability.

One of the standout features of the NSR-ORA V3.2 is its integrated network processing capabilities. This device employs advanced multi-layer switching technology that significantly boosts data throughput while maintaining low latency. This is particularly advantageous for organizations that rely on real-time data transmission for critical applications, such as VoIP and video conferencing. The ability to process large volumes of data efficiently ensures that businesses can operate seamlessly without disruptions.

Another key characteristic of the NSR-ORA V3.2 is its support for a wide range of networking protocols. The device is compatible with both IPv4 and IPv6, allowing businesses to transition smoothly to newer network architectures without the need for significant reconfiguration. This dual-stack capability not only enhances network flexibility but also future-proofs investments as organizations look to scale and adapt their digital infrastructure.

Security is at the forefront of the NSR-ORA V3.2's design. The device incorporates advanced security features such as firewall protection, intrusion detection, and secure VPN capabilities. These components work together to safeguard sensitive information and ensure that data integrity is maintained across the network. In addition to these features, the device offers comprehensive management tools, allowing network administrators to monitor performance and manage access controls more effectively.

The NSR-ORA V3.2 also excels in its interoperability with various devices and platforms, making it an ideal choice for enterprises that utilize a mix of legacy systems and modern technologies. Its compatibility with both wired and wireless networks provides businesses with the flexibility to design an infrastructure that meets their specific operational needs.

In summary, the 3Com NSR-ORA V3.2 is a powerful networking solution that combines advanced processing capabilities, robust security features, and a high degree of compatibility with diverse systems. Its emphasis on performance and scalability makes it a compelling choice for organizations seeking to enhance their network infrastructure in an ever-evolving digital landscape.
Top Page Image Contents