Re: Minimizing downtime for 9i to 10g upgrade

Palooka wrote:
>
> 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

I paraphrased. There was a few "shutdown" and "alter system suspends" etc to establish some points of data consistency during the process.

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------