3Com NSR-ORA V3.2 manual Recovery Until Time with Logical Errors, Control file Database files

Page 45

Recovery

Selecting the Type of Recovery

Naturally, you can also restore the database “manually”, i.e. without using the automatic facilities of NSR-ORA.

DBMS

Control file

Database files

SYST. USER TEMP

Tablespaces

Oracle’s archiving process

Redolog files

Threshold value

Archive directory

Database interface NSR-ORA

 

Recovery

 

Archiving

 

 

component

 

monitor

 

 

 

 

 

NetWorker user interface

Volume management

Volume pool management

Multiplexing

Jukebox support

Tape library

Figure 6: The recovery component

5.1.2Recovery Until Time with Logical Errors

The recovery until time (with the command ora_recut) allows the database to be recovered for an optional point in time. Thus it is also possible to automatically recover logical errors in the database.

Changes made to the structure of the database can also be reversed, since ora_recut also recovers the saved control file for the relevant point in time.

i

The database must be physically sound (operable) because ora_recut needs to query the position of the control files (not for NetApp filers).

System Administrator’s Guide

U42252-J-Z915-1-76

Image 45
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 ComponentsArchive Individual ComponentsDatabase interface NSR-ORA Archiving Tape libraryExample 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 ConfigurationInstallation and Configuration InstallationInstallation then continues interactively Licensing NSR-ORAIs to be installed Installing NSR-ORA from CDKeylic command Unix Client is requiredInvoke 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 LinuxHow to Proceed for an Update from an Earlier Version ConfigurationInstallation is then with the command Unpack the NSR-ORA.tarfile from the CDPreparations Example Configuration tool is invoked with the commandFirst make sure of the following Establishing tablespace namesChecking the Oracle Administration Program Installation and ConfigurationConfiguring NSR-ORA Oracle Parameters Parameters for configurensroraOracle owner Directory where Oracle is installedOracle owner group NetWorker ParametersNo 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 Recover the remaining save sets again RecoveryPerforming a recoveryFor the recovery of an online backup only Open the database usingRecovery 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 Two groups for pure snapshot backups Scenario 1 Three Backups per DayScenario 2 Two Backups per Day Name Oraclesidndmp One group for pure snapshot backupsDefining the Ndmp Client Scenario 3 Seven Backups per DayName Oraclesidsnapinterval You should use /vol/vol0 as the save setGroups NetWorker ResourcesInterval attribute Clients For Ndmp backups NSR-ORA provides two new save setsNdmp attribute Ndmpoffline client has to be assigned toBackup methods Backup with NSR-ORAPools Amon ClientInformation and log files of the current backup process For online backups the binary control fileSavegrp completion notification Control file as an Ascii trace fileRecovery 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 Shell parameter BackupDatabase DefiningFor NetApp Configurensrora Shell parameter Config.sh OutputIndex For NetApp NetWorkerShell parameter Nsrndmpsave command Shell parameter No space left on device error MessageBackup component Components Installation Installing from CDShell parameter Orarecut command For NetApp Configuration Installation on Remarkable thingsRestore Redolog files OPS Nfssave System Administrator’s Guide U42252-J-Z915-1-76OPS 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.