Performing OS Backups of an Oracle9i and 10g Database on MS Windows

(Doc ID 345069.1)

Last updated on JULY 06, 2017

Applies to:

Oracle Database - Standard Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Oracle Database - Enterprise Edition - Version 9.0.1.0 to 10.2.0.1 [Release 9.0.1 to 10.2]
Generic Windows
Microsoft Windows 2000Microsoft Windows Server 2003Microsoft Windows XPMicrosoft Windows (32-bit)Microsoft Windows Server 2003 (64-bit AMD64 and Intel EM64T)
.

Goal

This note will provide the steps for taking offline and hot backups of an Oracle 9i or 10g database on the MS Windows platforms. 

NOTE: Much of the information in this note is taken directly from Note.66405.1, 'Performing Operating System Backups of an Oracle8 database.'  Information has been changed and added to provide instructions for this same operation on an Oracle9i or 10g database.  This same information applies to Oracle8i but that version is not referenced as it is desupported.

There are two fundamentally different ways to backup an Oracle9i Release 2 and 10g database.
The first method is 'Operating system backups' and the second method is often referred to as 'Server Managed Recovery'.

Operating system backups are performed using operating system commands and/or utilities and can be written to disk or tape. This backup method is documented in this article.  It is the simpler of the two methods and is often most applicable where you have a simple environment, e.g. few servers and few databases.

'Server Managed Recovery' (SMR) the actual backing up of Oracle data to backup media is handled by a thread within the Oracle server executable, i.e. the database software itself writes the data from within the database to backup media. This backup method is controlled by the client tool called Oracle Recovery Manager (RMAN). This backup method is more complex to set up and administer and it is often more applicable to a more complex environment, e.g. many databases. This method is not covered in this article.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms