Home » RDBMS Server » Backup & Recovery » Upgrade Disaster Recovery Database to (Oracle Windows 2003)
Upgrade Disaster Recovery Database to [message #336082] Thu, 24 July 2008 13:22
Messages: 3
Registered: July 2008
Junior Member
We have a production RAC database at a remote site.
I made a local copy of the database for Disaster Recovery and left the database in recovery mode (Startup Mount).
Every 3 hours we FTP the Archive Log backup created by RMAN to our local database and update the database.

The steps we perform are:
- RMAN target sys/pw
- Shutdown
- Startup nomount
- Restore ControlFile from '<Latest Backup Control File>';
- Shutdown
- Startup mount
- Recover Database;

My question is how do I upgrade this database to
Part of the upgrade is applying a database script.
Can I apply the script while the database is never opened or am I forced to create a Full backup using RMAN,
after our production database is updated?

This database shares its oracle home with other instances, can I upgrade the Oracle home and upgrade
the other databases without it affecting the process to apply the Archive Log Backups to the Disaster Recovery database?

I hope I am asking the questions in the right forum.
Previous Topic: Nightly backups
Next Topic: RMAN Backup Strategy
Goto Forum:

Current Time: Mon Oct 24 13:51:58 CDT 2016

Total time taken to generate the page: 0.12477 seconds