Last updated on JULY 06, 2017
Applies to:Oracle Database - Standard Edition - Version 126.96.36.199 to 188.8.131.52 [Release 11.2]
Oracle Database - Enterprise Edition - Version 184.108.40.206 to 10.2.0.1 [Release 9.0.1 to 10.2]
Microsoft Windows 2000Microsoft Windows Server 2003Microsoft Windows XPMicrosoft Windows (32-bit)Microsoft Windows Server 2003 (64-bit AMD64 and Intel EM64T)
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms