- 论坛徽章:
- 0
|
我的DG,是否正常:
主点:
SQL>select max(sequence#) from v$archived_log;
MAX(SEQUENCE#)
--------------
17396
SQL>select max(sequence#) from v$log;
MAX(SEQUENCE#)
--------------
17397
SQL>archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +DATA/newoa/arch
Oldest online log sequence 17393
Next log sequence to archive 17397
Current log sequence 17397
备点:
SQL>select max(sequence#) from v$archived_log;
MAX(SEQUENCE#)
--------------
17396
SQL>select max(sequence#) from v$log;
MAX(SEQUENCE#)
--------------
17380
SQL>archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 17376
Next log sequence to archive 0
Current log sequence 17380
SQL> select * from v$archive_gap;
no rows selected
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CLOSING 17260
ARCH CONNECTED 0
ARCH CLOSING 16950
ARCH CLOSING 17395
RFS IDLE 0
RFS IDLE 17396
RFS IDLE 0
RFS IDLE 0
RFS IDLE 16951
RFS IDLE 0
RFS IDLE 0
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
RFS IDLE 17261
RFS IDLE 0
MRP0 APPLYING_LOG 17396
14 rows selected.
这个DG是否正常学工作。谢谢!!
|
|