3Com NSR-ORA V3.2 Database Backup, Archive Mode of the Database, Database files Control file

Page 7

Introduction

The Database Backup

 

 

 

 

database files

control file

redolog files

 

SYSTEM USER

TEMP

Tablespaces

 

Figure 2: Logical database structure

 

2.3The 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 and transferred to an external storage medium or created as a NAS snapshot. These copies depict a state that is not identical to the current one.

In the case of one or more database files being lost, the backup copies serve as the starting time for a required recovery. During any recovery, all redolog files accruing since the backup are reapplied, thus updating from the backup to the current status.

2.4Archive Mode of the Database

To ensure that all the redolog files accruing since the backup are available, the database must be operated in ARCHIVELOG mode, which makes sure that redolog files are not overwritten unless they have first been archived on a separate disk area (archive directory) by ORACLE’s archiving function (see figure 3).

System Administrator’s Guide

U42252-J-Z915-1-76

Image 7
Contents Edition October NSR-ORACopyright and Trademarks Conventions AudienceBoldface Update from Previous Releases What is New in ReleasePreface Introduction Logical Database Structure Physical Database StructureIntroduction Archive Mode of the Database Database BackupDatabase 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 commandLog in as root Set the Display variable Invoke the following commandRufen 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 groupAmon Parameters No compression is usedNow the amon parameters are queried Mirror Parameters with Expert Mode Recovery ParametersOPS 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 Configuration InstallationNSR-ORA in OPS clusters On HP-UX /opt/networker/oracle/bin/startamon.sh Backing Up an Oracle Database Version 8.0 or higher TroubleshootingNSR-ORA on Linux Recovery Component Selecting the Type of RecoveryRecovery Recovery Until Time with Logical ErrorsControl 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 notificationRecover until time orarecut Recovery with NSR-ORADebugging 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.