Re: Minimizing downtime for 9i to 10g upgrade
From: Palooka <nobody_at_nowhere.com>
Date: Mon, 22 Sep 2008 21:13:27 +0100
Message-ID: <G%SBk.61114$oR7.5751@newsfe28.ams2>
>
> We've done just that exercise recently on a largish (4tb) but low volume
> database. Used a standard backup plus archive recoveru to get a second
> copy of the 9i db, then threw a trigger on every table which created a
> queue of outstanding transactions whilst upgrading the copy to 10g.
>
> then applied the transaction queue to the 10g database until "switch
> over"...the original 9i database becomes a trivial failback database.
>
>
Just curious. What happened to the transactions between your first backup and creation of the triggers?
Date: Mon, 22 Sep 2008 21:13:27 +0100
Message-ID: <G%SBk.61114$oR7.5751@newsfe28.ams2>
Connor McDonald wrote:
> Chuck wrote:
>> DA Morgan wrote: >> >>> I am slightly embarrassed to say this but I don't know since I >>> haven't seen 9.2.0.6 in about 5 years. It might be that it is and >>> it might be that this was handled in 9.2.0.8 so check the docs. >> Hey I'm embarassed to be supporting versions that are so old! But a lot >> of times the version of the application dictates the version of the >> database, and other times the business is never willing to take down >> time to perform upgrades. In this case it's been a little of both.
>
> We've done just that exercise recently on a largish (4tb) but low volume
> database. Used a standard backup plus archive recoveru to get a second
> copy of the 9i db, then threw a trigger on every table which created a
> queue of outstanding transactions whilst upgrading the copy to 10g.
>
> then applied the transaction queue to the 10g database until "switch
> over"...the original 9i database becomes a trivial failback database.
>
>
Just curious. What happened to the transactions between your first backup and creation of the triggers?
Palooka Received on Mon Sep 22 2008 - 15:13:27 CDT