Backup3G/DA-Oracle/User Guide
This page was last modified 01:24, 5 September 2007.From Documentation
Revision as of 04:32, 12 April 2006 Moff (Talk | contribs) (→For More Information) ← Previous diff |
Current revision Moff (Talk | contribs) (→Where to from here) |
||
Line 1: | Line 1: | ||
== Getting Started == | == Getting Started == | ||
- | DA-Oracle is the Oracle Backup module for [[COSbackup]]. DA-Oracle is a set of backup and restore procedures that lets you perform: | + | |
+ | DA-Oracle is the Oracle Backup module for [[backup3G]]. DA-Oracle is a set of backup and restore procedures that lets you perform: | ||
*offline backup of an Oracle instance | *offline backup of an Oracle instance | ||
*online backup of an Oracle instance or specified tablespaces | *online backup of an Oracle instance or specified tablespaces | ||
Line 9: | Line 10: | ||
DA-Oracle lets you quickly restore Oracle files in the event of a system failure. Once the files are restored from tape, database recovery should be done by a qualified Oracle DBA. | DA-Oracle lets you quickly restore Oracle files in the event of a system failure. Once the files are restored from tape, database recovery should be done by a qualified Oracle DBA. | ||
- | Scheduling and monitoring of Oracle backups is exactly the same as for any other backup job in [[COSbackup]]. | + | Scheduling and monitoring of Oracle backups is exactly the same as for any other backup job in [[backup3G]]. |
DA-Oracle supports Oracle 7.x, 8i, 9i and 10g. | DA-Oracle supports Oracle 7.x, 8i, 9i and 10g. | ||
<br> | <br> | ||
+ | === About this guide === | ||
- | == About this guide == | + | This manual is the primary reference for setting up and using DA-Oracle, and is designed to help users and administrators to use DA-Oracle and backup3G effectively. It describes: |
- | This manual is the primary reference for setting up and using DA-Oracle, and is designed to help users and administrators to use DA-Oracle and COSbackup effectively. It describes: | + | |
*how to install and configure the Oracle Backup module | *how to install and configure the Oracle Backup module | ||
*how to configure backup items for Oracle databases | *how to configure backup items for Oracle databases | ||
Line 22: | Line 23: | ||
*how to restore from an Oracle backup. | *how to restore from an Oracle backup. | ||
+ | <br> | ||
=== Who should use this guide === | === Who should use this guide === | ||
+ | |||
This guide is aimed at: | This guide is aimed at: | ||
- | *managers who need an overview of what DA-Oracle can do | + | *''managers'' who need an overview of what DA-Oracle can do |
- | *DBA staff who need to plan database backup strategies and design backup procedures | + | *''DBA staff'' who need to plan database backup strategies and design backup procedures |
- | *system administrators who need to configure backups and control access to [[COSbackup]] | + | *''system administrators'' who need to configure backups and control access to [[backup3G]] |
- | *operators who may need to run backups or restore files under direction from the DBA. | + | *''operators'' who may need to run backups or restore files under direction from the DBA. |
- | === For More Information === | + | <br> |
- | The [[COSmanager]] User Guide explains how to install [[COSmanager]] products, such as [[COSbackup]], and add-on modules, such as [[DA-Oracle]]. | + | |
- | The [[COSbackup]] User Guide describes how to configure [[COSbackup]], how to set up and maintain backups, how to manage backup media and drives, and how to back up and recover filesystems and directories. Scheduling and monitoring of Oracle backups is exactly the same as for any other backup job. These are described in detail in the [[COSbackup]] User Guide. [[COSmanager]] promotes a ‘policies and procedures’ approach to system management, including backup and media management. The guides, [[How to Implement Policy Based Management]] and a [[Sample Policy and Procedures Manual]], are available. Examples of backup-related policy and procedure statements are also included the [[COSbackup]] User Guide. | + | == For More Information == |
+ | |||
+ | The [[COSmanager]] User Guide explains how to install [[COSmanager]] products, such as [[backup3G]], and add-on modules, such as [[DA-Oracle]]. | ||
+ | |||
+ | The [[backup3G/User Guide|backup3g User Guide]] describes how to configure [[backup3G]], how to set up and maintain backups, how to manage backup media and drives, and how to back up and recover filesystems and directories. | ||
+ | |||
+ | Scheduling and monitoring of Oracle backups is exactly the same as for any other backup job. These are described in detail in the [[backup3G/User Guide|backup3G User Guide]]. | ||
+ | |||
+ | [[COSmanager]] promotes a ‘policies and procedures’ approach to system management, including backup and media management. The guides, [[How to Implement Policy Based Management]] and a [[Sample Policy and Procedures Manual]], are available. Examples of backup-related policy and procedure statements are also included the [[backup3G]] User Guide. | ||
+ | |||
+ | <br> | ||
== Where to from here == | == Where to from here == | ||
- | [[Installing and Configuring DA-Oracle]] | + | [[/Installing and Configuring|Installing and Configuring DA-Oracle]] |
- | [[Defining Oracle Backups ]] | + | [[/Defining Oracle Backups|Defining Oracle Backups]] |
- | [[Searching and Restoring Oracle Backups ]] | + | [[/Searching and Restoring Oracle Backups|Searching and Restoring Oracle Backups]] |
- | [[DA-Oracle_Commands|Commands used by DA-Oracle]] | + | [[Backup3G/DA-Oracle/Command_Reference|Command Reference]] |
- | [[Oracle TEMPORARY Tablespaces and TEMPFILES¹]] | + | [[Backup3G/DA-Oracle/Commands|Commands used by DA-Oracle]] |
+ | |||
+ | <br> | ||
+ | ---- | ||
+ | <div style="float:right;">August 2007</div>Copyright © 1990-{{CURRENTYEAR}} Functional Software. All rights reserved. |
Current revision
Contents |
Getting Started
DA-Oracle is the Oracle Backup module for backup3G. DA-Oracle is a set of backup and restore procedures that lets you perform:
- offline backup of an Oracle instance
- online backup of an Oracle instance or specified tablespaces
- export of an Oracle instance or specified tablespaces
- archive and backup of redo log files
- full or partial restore of backed-up Oracle objects.
DA-Oracle lets you quickly restore Oracle files in the event of a system failure. Once the files are restored from tape, database recovery should be done by a qualified Oracle DBA.
Scheduling and monitoring of Oracle backups is exactly the same as for any other backup job in backup3G.
DA-Oracle supports Oracle 7.x, 8i, 9i and 10g.
About this guide
This manual is the primary reference for setting up and using DA-Oracle, and is designed to help users and administrators to use DA-Oracle and backup3G effectively. It describes:
- how to install and configure the Oracle Backup module
- how to configure backup items for Oracle databases
- how to search for backups of particular Oracle objects
- how to restore from an Oracle backup.
Who should use this guide
This guide is aimed at:
- managers who need an overview of what DA-Oracle can do
- DBA staff who need to plan database backup strategies and design backup procedures
- system administrators who need to configure backups and control access to backup3G
- operators who may need to run backups or restore files under direction from the DBA.
For More Information
The COSmanager User Guide explains how to install COSmanager products, such as backup3G, and add-on modules, such as DA-Oracle.
The backup3g User Guide describes how to configure backup3G, how to set up and maintain backups, how to manage backup media and drives, and how to back up and recover filesystems and directories.
Scheduling and monitoring of Oracle backups is exactly the same as for any other backup job. These are described in detail in the backup3G User Guide.
COSmanager promotes a ‘policies and procedures’ approach to system management, including backup and media management. The guides, How to Implement Policy Based Management and a Sample Policy and Procedures Manual, are available. Examples of backup-related policy and procedure statements are also included the backup3G User Guide.
Where to from here
Installing and Configuring DA-Oracle
Searching and Restoring Oracle Backups