DIA-48322: Relation [INCIDENT] of ADR V[2] incompatible with V[2] tool

I got this issue while using ADRCI tool to maintain the logs. This is how I fixed it: [oracle@dbserver ~]$ adrci ADRCI: Release 11.2.0.3.0 – Production on Wed May 31 09:43:29 2017 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. ADR base = “/u01/app/oracle” adrci> show homes ADR Homes: diag/diagtool/user_oracle/host_3933716914_11 diag/clients/user_oracle/host_3933716914_11 diag/rdbms/dbinst/DBINST…

Database upgrade from 10.2.0.5.0 to 11.2.0.4

The following document is the best one you can start documenting yourself from: 11gr2-upgrade-bp-apr2012-1610082.pdf From the above document, I followed: Note 251.1: Database Upgrades from 10.2 to 11.2 On that note, on the PLAN tab, I followed: Complete Checklist for Manual Upgrades to 11gR2 (Doc ID 837570.1) In this document you’ll find a bunch of…

ORA-01203: wrong incarnation of this file – wrong creation SCN

Like in everyone else’s life, this kind of “happiness” is happening. This is what I got on one of my test STANDBY databases while I was trying to start the Recovery Manager: Managed Standby Recovery starting Real Time Apply Read of datafile ‘/u01/oradata/DB/filename.dbf’ (fno 113) header failed with ORA-01203 Rereading datafile 113 header failed with…