sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jul 16 19:18:24 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter database start logical standby apply immediate;
Database altered.
SQL> select * from v$logstdby_process;
SID SERIAL# LOGSTDBY_ID SPID TYPE
---------- ---------- ----------- ------------ ------------------------------
STATUS_CODE
-----------
STATUS
--------------------------------------------------------------------------------
HIGH_SCN
----------
472 75 -1 817 COORDINATOR
16116
ORA-16116: no work available
2223833318
SID SERIAL# LOGSTDBY_ID SPID TYPE
---------- ---------- ----------- ------------ ------------------------------
STATUS_CODE
-----------
STATUS
--------------------------------------------------------------------------------
HIGH_SCN
----------
502 534 0 819 READER
16127
ORA-16127: stalled waiting for additional transactions to be applied
2223478310
SID SERIAL# LOGSTDBY_ID SPID TYPE
---------- ---------- ----------- ------------ ------------------------------
STATUS_CODE
-----------
STATUS
--------------------------------------------------------------------------------
HIGH_SCN
----------
483 2612 1 821 BUILDER
16119
ORA-16119: building transaction at SCN 0x0000.84878cb1
2223475890
SID SERIAL# LOGSTDBY_ID SPID TYPE
---------- ---------- ----------- ------------ ------------------------------
STATUS_CODE
-----------
STATUS
--------------------------------------------------------------------------------
HIGH_SCN
----------
488 303 2 823 PREPARER
16117
ORA-16117: processing
2223475890
SID SERIAL# LOGSTDBY_ID SPID TYPE
---------- ---------- ----------- ------------ ------------------------------
STATUS_CODE
-----------
STATUS
--------------------------------------------------------------------------------
HIGH_SCN
----------
495 987 3 825 ANALYZER
16116
ORA-16116: no work available
2223475863
SID SERIAL# LOGSTDBY_ID SPID TYPE
---------- ---------- ----------- ------------ ------------------------------
STATUS_CODE
-----------
STATUS
--------------------------------------------------------------------------------
HIGH_SCN
----------
516 506 4 827 APPLIER
16116
ORA-16116: no work available
SID SERIAL# LOGSTDBY_ID SPID TYPE
---------- ---------- ----------- ------------ ------------------------------
STATUS_CODE
-----------
STATUS
--------------------------------------------------------------------------------
HIGH_SCN
----------
459 134 5 829 APPLIER
16116
ORA-16116: no work available
SID SERIAL# LOGSTDBY_ID SPID TYPE
---------- ---------- ----------- ------------ ------------------------------
STATUS_CODE
-----------
STATUS
--------------------------------------------------------------------------------
HIGH_SCN
----------
461 184 6 831 APPLIER
16116
ORA-16116: no work available
SID SERIAL# LOGSTDBY_ID SPID TYPE
---------- ---------- ----------- ------------ ------------------------------
STATUS_CODE
-----------
STATUS
--------------------------------------------------------------------------------
HIGH_SCN
----------
479 38 7 833 APPLIER
16116
ORA-16116: no work available
SID SERIAL# LOGSTDBY_ID SPID TYPE
---------- ---------- ----------- ------------ ------------------------------
STATUS_CODE
-----------
STATUS
--------------------------------------------------------------------------------
HIGH_SCN
----------
460 19 8 835 APPLIER
16116
ORA-16116: no work available
10 rows selected.
SQL>
阅读(765) | 评论(0) | 转发(0) |
