Skip to Content
Former Member
Jan 08, 2009 at 02:27 PM

upgrade standby to 10.2 from 9.2 (we use brarchive)



Oracle has a metalink note, and documentation about upgrading a standby database, as long as you use Data Guard.

Our standby database is maintained with BRARCHIVE - and I can not find any guidance from SAP on upgrading the standby, if you use BRARCHIVE.

Here is what I will attempt, if I do not get any guidance:

- sync the secondary and primary

- stop shipping logs

- upgrade the primary

- bring up the standby w/ the 10.2 binaries

- apply all of the logs, which I believe will upgrade the data dictionary

Has anyone done this? We have a very large database, and rebuilding it from scratch would require a lot of work.