3Com NSR-ORA V3.2 manual Selecting the Type of Recovery, Recovery Component

Page 44

5 Recovery

This chapter describes the various ways in which you can carry out a recovery for an ORACLE database.

i

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, so that in a genuine emergency you will be in a position to decide which type of recovery is appropriate.

There are basically three ways of recreating a damaged ORACLE database:

●firstly, performing a complete fully-automatic recovery of the entire database with the nsrora_rec command

●secondly, performing a recovery until time with the ora_recut command for an optional point in time between the first full_save backup and the point in time the recent changes within the database have occured.

●thirdly, carrying out a manual recovery, in which the corrupted data is restored by hand.

5.1Selecting the Type of Recovery

Which type of recovery you choose (recover until time, automatic or manual) will depend entirely on the actual situation. There are advantages and disadvan- tages to all methods; you will have to weigh these up as appropriate for the specific circumstances. This section is intended to help you decide whether to perform an specific type of recovery.

5.1.1The Recovery Component

The NSR-ORA recovery component allows the automatic recovery of an ORACLE database saved with NSR-ORA if one or more database file(s) are lost or an logical error has occurred (see figure 6 following).

System Administrator’s Guide

U42252-J-Z915-1-76

Page 43 Page 45
Image 44
Page 43 Page 45
Contents NSR-ORA Edition OctoberCopyright and Trademarks Boldface AudienceConventions Preface What is New in ReleaseUpdate from Previous Releases Introduction Introduction Physical Database StructureLogical Database Structure Database files Control file Database BackupArchive Mode of the Database System Administrator’s Guide U42252-J-Z915-1-76 ArchivingFunction Scope Function ScopeIndividual Components Archiving MonitorIndividual Components ArchiveDatabase interface NSR-ORA Archiving Tape libraryStarting and Ending the Archiving Monitor ExampleSubsequent status enquiry generates the following output # startamon.sh status ora ORACLESIDs oraLogging Following is a representative sample from the log fileBackup Component Individual ComponentsThe Backup ComponentOffline Backup of the Database Database interface NSR-ORA Backup Archiving ComponentIndividual Components Online Backup of the Database Configuration and managementChecking backups troubleshooting Log files from local backups not for NAS filersAmon Recordings Individual Components Installation and Configuration Quick StartInstallation Installation and ConfigurationInstallation then continues interactively Licensing NSR-ORAInstalling NSR-ORA from CD Is to be installedKeylic command Unix Client is requiredRufen Sie folgendes Kommando auf Invoke the following commandLog in as root Set the Display variable Use the following command to uninstall NSR-ORA under Linux HP-UXConfiguration How to Proceed for an Update from an Earlier VersionInstallation is then with the command Unpack the NSR-ORA.tarfile from the CDExample Configuration tool is invoked with the command PreparationsFirst make sure of the following Establishing tablespace namesInstallation and Configuration Checking the Oracle Administration ProgramConfiguring NSR-ORA Parameters for configurensrora Oracle ParametersDirectory where Oracle is installed Oracle ownerOracle owner group NetWorker ParametersNow the amon parameters are queried No compression is usedAmon Parameters Mirror OPS Parameters Recovery ParametersParameters with Expert Mode Amonmirrorgroup Defining backup sets save sets It is also recommended generally to carry out a full backup Configuring NetWorker # configurenetworker createdelete OraclesidRoot 68 # configurenetworker create ORA2 NSR-ORA in OPS clusters InstallationConfiguration On HP-UX /opt/networker/oracle/bin/startamon.sh NSR-ORA on Linux TroubleshootingBacking Up an Oracle Database Version 8.0 or higher Selecting the Type of Recovery Recovery ComponentControl file Database files Recovery Until Time with Logical ErrorsRecovery Automatic Recovery Crash Recovery Performing a recovery Manual recoveryAutomatic Recovery for an Optional Point in Time Start orarecutFully-automatic Recovery New recovery attempt with orarecut can be madeRecovery Offline recovery of an offline or full backup RecoveryPerforming a recovery Recover the remaining save sets againFor the recovery of an online backup only Open the database usingRecovery with Oracle Parallel Server OPS Oracle No space left on deviceRecovery Using NSR-ORA with NetApp Filers Running NSR-ORA with NAS devicesPrerequisites NSR-ORA and NetAppConfiguring NSR-ORA with NetApp Filers RecommendationsNSR-ORA and NetApp NETAPPSNAPNR=255 Nfssave RSH Scenario 1 Three Backups per Day Name Oraclesidndmp Two groups for pure snapshot backupsScenario 2 Two Backups per Day Name Oraclesidndmp One group for pure snapshot backupsScenario 3 Seven Backups per Day Defining the Ndmp ClientName Oraclesidsnapinterval You should use /vol/vol0 as the save setNetWorker Resources GroupsInterval attribute For Ndmp backups NSR-ORA provides two new save sets ClientsNdmpoffline client has to be assigned to Ndmp attributeBackup with NSR-ORA Backup methodsPools Amon ClientFor online backups the binary control file Information and log files of the current backup processSavegrp completion notification Control file as an Ascii trace fileDebugging Recovery with NSR-ORARecover until time orarecut NSR-ORA and NetApp Crash Recovery nsrorarec Example 1 Recovery based on the last snapshotExample 2 Recovery based on a specified snapshot Backup Shell parameterDatabase DefiningShell parameter Config.sh Output For NetApp ConfigurensroraIndex For NetApp NetWorkerShell parameter No space left on device error Message Shell parameter Nsrndmpsave commandBackup component Components Installation Installing from CDConfiguration Installation on Remarkable things Shell parameter Orarecut command For NetAppRestore Redolog files OPS Nfssave System Administrator’s Guide U42252-J-Z915-1-76Update OPS

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