startup;
shutdown immediate;
startup mount;
alter database archivelog;
alter database open;
Best Regards,
Oleksandr Denysenko
03.12.2015 16:12, Stephens, Chris пишет:
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.
