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 51
Image 51
3Com NSR-ORA V3.2 manual Manual Recovery, Offline recovery of an offline or full backup

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.