I have PROD + Physical Standby Oracle 188.8.131.52 Enterprise on Oracle Solaris 10
PROD is a separate Machine and works fine
Standby instance lives on the similar machine, but shares OS with development instances.
Once there was a delay in supplying logs to the standby for some time, and after that I restored some of them and applied them manually. During that process on the one of the archived logs I faced a crash of Standby Oracle Instance. It crashed and wrote to the alert.log that there were many damaged blocks in datafiles and started to write a "core" file with a dump of memory trying to save on disk 35G of something. Unfortunately there was not enough space, so the core writing was not completed.
The strange things began after that.
Now when I try to connect to standby instnace to make it somehow alive:
+> sqlplus / as sysdba+
it writes: SQLPlus: Release 184.108.40.206.0 Production on Wed May 8 16:13:39 2013 Copyright (c) 1982, 2010, Oracle. All rights reserved.
but after that hangs for some time.
During this I may see thet there are 2 server processes
consuming 35G of memory, sleeping, and one of them tries to create a core file on disk. PID USERNAME SIZE RSS STATE PRI NICE TIME CPU PROCESS/NLWP
*12943 oracle 35G 34G sleep 60 0 0:00:14 0.5% oracle/1*
*12942 oracle 35G 34G sleep 59 0 0:00:01 0.0% oracle/1*
and after that the client writes: ERROR: ORA-12547: TNS:lost contact Enter user-name:sys as sysdba Enter password: ERROR: ORA-12547: TNS:lost contact Enter user-name:sys Enter password: ERROR: ORA-12547: TNS:lost contact SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQLPlus
After all this I only have a core file and nothing written to the alert log or anywhere else.
I must also notice that during all this all other instances of Dev oracle environments continue to live normally.
I tried to remove pfile and spfile from the dbs directory in order to connect to the instance just as if it is all new, but the result was same error and core dump..
Please advise me how to reanimate and start that instance.