Oracle Database Discussions

Sat Feb 24 00:34:19 2001 E: rebuildDg: The script rebuildDg will start:
[Sat Feb 24 00:34:19 CGP 2001] Into rebuildDg 2 N PRI P_STA WRITING APPLYING_LOG
[Sat Feb 24 00:34:19 CGP 2001] localToStandby

[Sat Feb 24 00:34:19 CGP 2001] dg_switchover_sqlplus from dbu_name_2 to dbu_name_1

[Sat Feb 24 00:34:19 CGP 2001] sys/oracle@dbu_name_2 as sysdba:
select switchover_status from v$database;
[Sat Feb 24 00:34:19 CGP 2001] switchover_status=SESSIONS ACTIVE
[Sat Feb 24 00:34:19 CGP 2001] sys/oracle@dbu_name_2 as sysdba:
alter database commit to switchover to physical standby with session shutdown;
alter database commit to switchover to physical standby with session shutdown
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 15957
Session ID: 388 Serial number: 67
!! Error 41 : primary Unable to 'alter database commit to switchover to physical standby with session shutdown;'

=====================================================================
oracle@omu2:~> ps -ef|grep ora
oracle 2911 1 0 15:16 ? 00:00:00 /opt/oracle/oradb/11g/bin/tnslsnr LSN_DG -inherit
root 11326 5288 0 Feb23 ? 00:00:00 sshd: oracle [priv]
oracle 11328 11326 0 Feb23 ? 00:00:00 sshd: oracle@pts/0
oracle 11329 11328 0 Feb23 pts/0 00:00:00 -bash
oracle 11470 11329 0 Feb23 pts/0 00:00:00 sqlplus as sysdba
*oracle 11483 11470 0 Feb23 ? 00:00:00 [oracle] <defunct>*
oracle 14491 6306 0 15:18 pts/1 00:00:00 su - oracle
oracle 14492 14491 0 15:18 pts/1 00:00:00 -bash
root 15193 13126 0 15:18 ? 00:00:00 /bin/bash /opt/HUAWEI/cgp/omu_mirror/workspace1/server/bin/rm/DG/monitor FIX dg 1 oinstall /home/oracle
root 15199 15193 0 15:18 ? 00:00:00 /bin/bash ./monitor.sh FIX dg 1 oinstall /home/oracle
root 15869 15199 0 15:18 ? 00:00:00 /opt/HUAWEI/cgp/omu_mirror/workspace1/server/bin/lmtruntime -20 ./activate ChkLock=N oracle oracle /home/oracle 255.255.0.0 255.255.255.255
root 15870 15869 0 15:18 ? 00:00:00 /bin/bash ./activate ChkLock=N oracle oracle /home/oracle 255.255.0.0 255.255.255.255
oracle 16201 15870 0 15:18 ? 00:00:00 su - oracle -c /opt/HUAWEI/cgp/omu_mirror/workspace1/server/bin/db/dbcmd "shutdown abort"
oracle 16202 16201 1 15:18 ? 00:00:00 /bin/bash /opt/HUAWEI/cgp/omu_mirror/workspace1/server/bin/db/dbcmd shutdown abort
oracle 16229 16202 0 15:18 ? 00:00:00 /bin/bash /opt/HUAWEI/cgp/omu_mirror/workspace1/server/bin/db/dbcmd shutdown abort
oracle 16231 16229 0 15:18 ? 00:00:00 /opt/oracle/oradb/11g/bin/sqlplus -s
oracle 16237 1 0 15:18 ? 00:00:00 oracleomu (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 16399 14492 0 15:18 pts/1 00:00:00 ps -ef
oracle 16400 14492 0 15:18 pts/1 00:00:00 grep ora
oracle 22364 1 0 15:12 ? 00:00:00 /opt/oracle/oradb/11g/bin/tnslsnr LSN_LOOP -inherit
oracle 27548 11470 0 Feb23 pts/0 00:00:00 /bin/bash
oracle 31214 31155 0 Feb23 pts/2 00:00:00 su - oracle
oracle 31215 31214 0 Feb23 pts/2 00:00:00 -bash
oracle 31396 31215 0 Feb23 pts/2 00:00:00 sqlplus as sysdba
oracle 32410 27548 0 00:01 pts/0 00:00:00 sqlplus as sysdba

Edited by: user10572119 on 2009-5-20 下午5:22

Edited by: user10572119 on 2009-5-20 下午5:23