Ask the Expert

Backing up Oracle before installing a patch set

I am new to Oracle on Windows. What method or procedure would you use to back up Oracle prior to installing a patch set? My OS is Windows 2003.

    Requires Free Membership to View

To make things easy, I would perform a cold backup. I would shut down the database, and then use OS commands to copy the control files, online redo logs and database datafiles to a backup location. Just to be safe, I would back up the %ORACLE_HOME% directory and the HKEY_LOCAL_MACHINE\Software\Oracle hive in my registry as well. Then you can perform your upgrade. Should you have problems, you can restore the Oracle registry settings, Oracle software and the database.

This was first published in October 2005

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: