Hi everybody,
I have this problem in a production database, (11g release 2, 11.2.0.3) using Real Application Cluster, I disabled archivelog to make a window for a massive update of big tables, now I'm trying to enable archivelog mode again and I haven't been able to, because it displays the ORA-00265 error, I've search a lot of sites and Oracle support and the explanation is always the same "you shutdown abort or startup force the database, start it again and shutdown with immediate or normal option" but the thing is that I use srvctl with the immediate option, I did some reboots to the database and I read in the alert log that indeed when the database starts it does an Instance recovery.
Why does this happens? I have shutdown the two nodes at once, and one by one, started one by one with sqlplus, and I don't really what else to do, I hope you can help me.
oracle@sur01 # srvctl stop instance -d asaa -i asaa1 -o immediate
oracle@sur01 # . oraenv
ORACLE_SID = [oracle] ? asaa
The Oracle base has been set to /u01/app/oracle
oracle@sur01 # export ORACLE_SID=asaa1
oracle@sur01 # srvctl start database -d asaa -o mount
oracle@sur01 # sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sat Jan 24 15:48:16 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
Instancia Estado Modo Lectura Activa Actividad Blo Inicio en Archive? EstArch
---------------- ------------ -------------------- ----------------- --------- --- -------------- ------------ -------
asaa1 MOUNTED MOUNTED ACTIVE NORMAL NO 24-01-15 15:47 NOARCHIVELOG STOPPED
SYS@asaa1> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
Thanks in advance....
Giancarlo Giammaria.