Try just opening the database first, then shutting it down (normal or
immediate) and then mounting to reactivate ARCHIVELOG mode?
On 12/3/15 7:12, Stephens, Chris wrote:
Already tried that.
*From:*oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Oleksandr Denysenko
*Sent:* Thursday, December 03, 2015 8:06 AM
*To:* oracle-l@xxxxxxxxxxxxx
*Subject:* Re: unable to put database in archivelog mode
Hi Chris,
could you RECOVER DATABASE before ALTER DATABASE ARCHIVELOG;
?
Best Regards,
Oleksandr Denysenko
03.12.2015 15:53, Stephens, Chris пишет:
11.2.0.4 2 node RAC database on Oracle Linux 6.
We have a database environment refresh process that is taking too
long. That process exports a subset of data from production
database, drops existing dev schema, imports production export. To speed things up I want to take the database out of archivelog
mode prior to dropping the schema and placing it back into
archivelog mode after import completes. After the refresh
completes, we need to create a restore point to enable the
developers to rerun tests with the database as it is immediately
after refresh. That requires archivelog mode.
I’m currently testing the addition of the commands to take the
database into and out of archivelog mode in the script that
automates all of this. I’ve had several instances where I get
“ORA-00265: instance recovery required, cannot set ARCHIVELOG
mode” that is usually remedied by opening the database and
shutting it down again in NORMAL mode. However, as of right now,
no matter what I do, I can’t get the database back into archivelog
mode.
I’ve restarted the database multiple times. Recovered the
database through RMAN. Checked to see if any transactions are
rolling back (nothing). Confirmed no instances are up after
shutdown. Left the database alone overnight in case that
magically fixes something. Nothing seems to work. However, the
database opens just fine.
Has anyone seen this before?
My last attempt to fix this was simply:
“Srvctl stop database –d xxx –o normal”
Confirm no pmon for instances on either server.
“srvctl start instance –d xxx –I xxx1 –o mount”
SQL>alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
Confidentiality Notice:
This message may contain confidential or privileged information,
or information that is otherwise exempt from disclosure. If you
are not the intended recipient, you should promptly delete it and
should not disclose, copy or distribute it to others.
Confidentiality Notice:
This message may contain confidential or privileged information, or information that is otherwise exempt from disclosure. If you are not the intended recipient, you should promptly delete it and should not disclose, copy or distribute it to others.
