9
Backing Up and Recovering an Oracle Parallel Server Database

This chapter is intended as an add-on to Chapter 13, "Backup and Recovering Database Files", of the Oracle8 Enterprise Edition Getting Stared, which describes how to back up and recover an Oracle8 Enterprise Edition database.

Specific topic covered in this chapter is:

• Backup and Recovery

Backup and Recovery

Backup and recovery of an Oracle Parallel Server database is performed from one node of the cluster using the NT Backup Manager and the NT Recovery Manager.

These applications operate in the same way for Oracle Parallel Server as Oracle8 Enterprise Edition, except where noted below:

• All instances in the cluster must be shut down before performing an off-line backup or recovery.
• 4mm and 8mm tapes are supported for Oracle Parallel Server
• The ORACLE_SID parameter must be set in the registry.

Additional Information:   See "Step 5: Add the ORACLE_SID Entry to the Registry" in Chapter 5, "Configuring Oracle Parallel Server".

   
• The NT Recovery Manager requires the INITSID.ORA to be located in the ORACLE_HOME\DATABASE directory. INITSID.ORA is placed in ORACLE_HOME\OPS by default. To use the NT Recovery Manager, copy INITSID.ORA to ORACLE_HOME\DATABASE.
• When performing an off-line backup, you must change the default file names to the symbolic link names, \\.\SYMBOLIC_LINK NAME.

For example, you would click Files from the Oracle Backup Manager dialog box:
 

The Database Files dialog box appears. Select each file type (Data Files, Log Files and Control Files), and enter the appropriate file name. File names should match the symbolic link names you used in the ORALINKx.TBL file(s):
 

Additional Information:   See "Step 2: Assign Symbolic Links to Each Logical Partition" in Chapter 5, "Configuring Oracle Parallel Server".

   

---