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.
