Greetings, Dear.
Sorry in advance for the inconvenience, I need your help. I have the following situation, last week asked me to update a database contingency, ie, a database PHYSICAL STANDBY.
I checked MOS documentation, which clearly indicate that in order to update a database PHYSICAL STANDBY, you must first perform the upgrade in primary databases, then perform switching the Standby as Primary to apply the patch.
Despite the recommendations, I was asked to perform the upgrade, as you know the standby database is open in Read Only mode, I tried to run the script @/oracle/u01/rdbms/admin/catupgrd.sql and I threw multiple errors, obviously because he could not perform any update on the Database.
From that moment, I could not open the database, throws me the following error:
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1459617792 bytes
Fixed Size 2096448 bytes
Variable Size 822084288 bytes
Database Buffers 620756992 bytes
Redo Buffers 14680064 bytes
Database mounted.
SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
The features of this platform is:
Operating system: AIX 5.3.10.3 TL10
Database: Oracle Database (10.2.0.5.0 only Software) because he could not do the upgrade on the database.
Please, any expert can help me with this problem, I need to know if you can open the database, before thinking about performing a restore.
Thanks in advance.