Oracle8i Administrator's Guide Release 2 (8.1.6) for Windows NT A73008-01 |
|
This chapter provides information on backing up and recovering your database.
Specific topics discussed are:
Backing up and recovering your Oracle8i database is one of the most critical operations that a database administrator (DBA) performs. For this reason, it is extremely important to choose the correct tools. The table below describes available backup and recovery tools and makes recommendations on which tool to use with your Oracle8i database:
Tool | Description | Analysis of Tool | To Use this Tool, See... |
---|---|---|---|
Oracle Enterprise Manager Backup Management tools |
The Oracle Enterprise Manager DBA Management Pack includes the Backup Wizard for backing up and the Recovery Wizard for recovering your Oracle8i database. The Backup Wizard enables users to:
The wizards provide a graphical user interface (GUI) to Recovery Manager. |
Highly recommended for backing up and recovering your Oracle8i database because of capabilities and ease of use. Works in conjunction with Recovery Manager (RMAN). Backing up to tape requires an optional media management layer (MML) from a third-party vendor, such as Legato Storage Manager (LSM). LSM is included on your CD-ROM. |
|
Recovery Manager (RMAN) in command line mode1 |
Recovery Manager in command line mode is an Oracle8i tool that manages the process of backing up, restoring, and recovering files. Recovery Manager is automatically installed with Oracle Utilities. Recovery Manager uses a special PL/SQL interface to the server for invoking backup functions. The user is unaware of this interface and instead interfaces only with a command line. |
Command line usage only. Must clearly understand the command line syntax described in Oracle8i Recovery Manager User's Guide and Reference before using. Backing up to tape requires an optional MML from a third-party vendor. |
Chapter 2, "Database Tools Overview" for instructions on accessing this tool and Oracle8i Recovery Manager User's Guide and Reference for instructions on using this tool. |
Third-party vendor products |
Third-party vendors such as Legato provide tape backup software that works with Backup Wizard and RMAN. |
If using Legato MML, can back up to tape only if you are using RMAN and only if the tape device and the target database are on the same physical device. Contact your third-party vendors for additional information. |
Legato Storage Manager Administrator's Guide and other third-party vendor documentation. |
OCOPY |
OCOPY is needed when performing a hot backup manually (that is, backing up a tablespace that is in offline backup mode). |
Command line usage only. Can back up only to disk. Can only perform local backups. |
"Backing Up Files with OCOPY" and "Recovering Files with OCOPY" in this chapter. |
1
On Windows NT, starting with version 8.1.6, additional transformations are added to file names entered by the user. If you use Recovery Manager, existing file names stored in the recovery catalog must be normalized. To normalize file names, see Chapter 8, "After Migrating or Upgrading the Database" in the Oracle8i Migration guide. |
Use OCOPY for both hot and raw database file backups of the following file types:
File | Description |
---|---|
File Allocation Table (FAT) or NT File System (NTFS) files |
File allocation table (FAT) or NT file system (NTFS) files you want to back up. |
|
A logical drive (accessed with the direct I/O) identified by the name: |
|
|
Note: For more information on logical drives, see Appendix D, "Storing Tablespaces on Raw Partitions" |
where x: is the logical drive designator. |
Physical raw files |
A physical hard drive (accessed with direct I/O) identified by a device name of the form: |
|
|
|
where N is 0, 1, 2, and so on, representing each of the physical drives in the system. |
This table describes the two copy modes in which to use OCOPY:
This table describes the syntax to use when backing up all file types to hard disk or multiple diskettes:
The table below describes the syntax to use when recovering all file types from hard disk or multiple diskettes.
Restore From... | File Type to Restore | Syntax |
---|---|---|
Hard Disk1 |
FAT or NTFS files |
Use the Windows NT COPY command. |
|
Logical raw |
|
|
Physical raw |
|
Multiple diskettes2 |
FAT or NTFS files |
Note: First insert the diskette containing the initial part of the backed up file. |
|
Logical raw |
|
|
Physical raw |
|
1
These are files originally backed up without the /B option. 2 These are files originally backed up with the /B option. |
When running backups to tape drivers using Legato Storage Manager (LSM), you must add LSM's BIN directory to the PATH. The default location of the directory is C:\WIN32APP\NSR\BIN.
To add this directory to the PATH:
The System Properties dialog box appears.
The Environment view appears.
If you use LSM, and have more than one tape device on your system (LSM supports a maximum of 4), ensure that the following settings are made in the LSM Administrator GUI:
In the Japanese version of Legato Storage Manager 5.5, the following log files are written in UTF8 format:
C:\WIN32APP\NSR\APPLOGS\DMO.MESSAGES C:\WIN32APP\NSR\LOGS\DAEMON.LOG C:\WIN32APP\NSR\LOGS\MESSAGES
On a Japanese version of Windows NT running Japanese Legato Storage Manager 5.5, you must run the following command at the command prompt to read one of these UTF8 log files:
C:\> NSRCAT -N < FILE_NAME
where FILE_NAME is the appropriate path name for the specific log file, such as:
C:\WIN32APP\NSR\APPLOGS\DMO.MESSAGES
|
![]() Copyright © 2000 Oracle Corporation. All Rights Reserved. |
|