Backing Up Oracle Database for Upgrading

Use this procedure to back up your existing Oracle Database before you attempt an upgrade.


Before you make any changes to the Oracle software, Oracle recommends that you create a backup of the Oracle software and databases. For Oracle software running on Windows operating systems, you must also take a backup of the Windows registry. Without a registry backup, you cannot restore the Oracle software to a working state if the upgrade,fails, and you want to revert to the previous software installation.

If you choose to use the manual Pre-Upgrade Information Tool, then run it before you cleanly shut down the database. To minimize downtime, you can perform an online backup or create a guaranteed restore point. Database Upgrade Assistant (DBUA) enables you to specify your backup and restore point.

  1. Sign on to Oracle RMAN:

    rman "target / nocatalog"
  2. Run the following RMAN commands:

        BACKUP DATABASE FORMAT 'some_backup_directory%U' TAG before_upgrade;
        BACKUP CURRENT CONTROLFILE FORMAT 'controlfile location and name';

See Also: