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.