Fast… Faster… Fastest DB UpgradesPosted: December 18, 2007
Did you notice that maintenance windows are getting shorter?
Five years ago, when I still managed the apps team, DBAs could shut down the database for maintenance for an entire day. Three years ago four hours window every month were acceptable. Now we are down to two hours.
Upgrading a DB to the latest version was always time consuming. Just the installation can easily take an hour. Then there is the catalog upgrade, and recompiling. Apply few patches and your maintenance window is far over. And that is when everything went according to plan.
So, here is our latest take on fast upgrades:
- Install the new version of Oracle Software on a new server, with patches and all. Don’t create a DB.
- During maintenance window – stop the old DB.
- Use Netapp’s SnapMirror technology to copy all the DB files (data, redo, archive, control) to the new server. Make sure it “looks” exactly like it did in the old server – same mount names.
- Copy spfile to new server.
- startup upgrade
- run catalog upgrade
- Restart DB
- Start Listener
We did all this in less than an hour, with catalog upgrade taking about 30 minutes.