dataguard 同步状态检查
【摘要】 检查命令：set linesize 1000;set pagesize 500select sequence#,FIRST_TIME,NEXT_TIME,applied from v$archived_log/显示结果： SEQUENCE# FIRST_TIME NEXT_TIME APPLIED---------- ------------------...
检查命令：
set linesize 1000;
set pagesize 500
select sequence#,FIRST_TIME,NEXT_TIME,applied from v$archived_log
/显示结果：
SEQUENCE# FIRST_TIME NEXT_TIME APPLIED
---------- ------------------- ------------------- ---------------------------
193113 2021-09-19 01:16:49 2021-09-19 02:19:55 YES
193143 2021-09-19 18:51:26 2021-09-19 19:30:51 YES
193144 2021-09-19 19:30:51 2021-09-19 20:36:27 NO
193131 2021-09-19 11:09:00 2021-09-19 11:40:57 YES
193130 2021-09-19 10:41:45 2021-09-19 11:09:00 YES
193132 2021-09-19 11:40:57 2021-09-19 12:31:34 YES
193133 2021-09-19 12:31:34 2021-09-19 13:41:07 YES
193136 2021-09-19 14:41:52 2021-09-19 15:17:34 YES
193138 2021-09-19 15:52:58 2021-09-19 16:27:01 YES
193135 2021-09-19 14:05:31 2021-09-19 14:41:52 YES
193137 2021-09-19 15:17:34 2021-09-19 15:52:58 YES
193139 2021-09-19 16:27:01 2021-09-19 17:02:20 YES
193140 2021-09-19 17:02:20 2021-09-19 17:40:59 YES
193142 2021-09-19 18:05:26 2021-09-19 18:51:26 YES
193141 2021-09-19 17:40:59 2021-09-19 18:05:26 YES
193134 2021-09-19 13:41:07 2021-09-19 14:05:31 YES
193145 2021-09-19 20:36:27 2021-09-19 20:42:18 NO
193110 2021-09-18 21:51:16 2021-09-19 00:14:04 YES
172635 2021-09-18 21:50:20 2021-09-19 01:15:53 YES
193112 2021-09-19 00:31:37 2021-09-19 01:16:49 YES
193111 2021-09-19 00:14:04 2021-09-19 00:31:37 YES
172636 2021-09-19 01:15:53 2021-09-19 02:04:59 YES
172637 2021-09-19 02:04:59 2021-09-19 02:18:56 YES
193146 2021-09-19 20:42:18 2021-09-19 20:51:24 NO
193114 2021-09-19 02:19:55 2021-09-19 06:08:26 YES
193126 2021-09-19 09:02:42 2021-09-19 09:28:27 YES
193128 2021-09-19 09:55:36 2021-09-19 10:19:42 YES
193118 2021-09-19 06:17:44 2021-09-19 06:19:11 YES
193124 2021-09-19 06:24:44 2021-09-19 08:13:42 YES
193127 2021-09-19 09:28:27 2021-09-19 09:55:36 YES
193125 2021-09-19 08:13:42 2021-09-19 09:02:42 YES
193129 2021-09-19 10:19:42 2021-09-19 10:41:45 YES
193116 2021-09-19 06:09:38 2021-09-19 06:14:41 YES
193115 2021-09-19 06:08:26 2021-09-19 06:09:38 YES
193119 2021-09-19 06:19:11 2021-09-19 06:20:23 YES
193121 2021-09-19 06:21:41 2021-09-19 06:22:56 YES
193122 2021-09-19 06:22:56 2021-09-19 06:23:50 YES
193120 2021-09-19 06:20:23 2021-09-19 06:21:41 YES
193117 2021-09-19 06:14:41 2021-09-19 06:17:44 YES
172638 2021-09-19 02:18:56 2021-09-19 03:11:42 YES
193123 2021-09-19 06:23:50 2021-09-19 06:24:44 YES
172639 2021-09-19 03:11:42 2021-09-19 06:13:48 YES
172640 2021-09-19 06:13:48 2021-09-19 06:19:30 YES
172641 2021-09-19 06:19:30 2021-09-19 06:22:57 YES
172642 2021-09-19 06:22:57 2021-09-19 09:01:48 YES
172643 2021-09-19 09:01:48 2021-09-19 10:02:36 YES
172644 2021-09-19 10:02:36 2021-09-19 10:53:43 YES
172645 2021-09-19 10:53:43 2021-09-19 11:46:07 YES
172646 2021-09-19 11:46:07 2021-09-19 13:19:55 YES
172647 2021-09-19 13:19:55 2021-09-19 14:39:52 YES
172648 2021-09-19 14:39:52 2021-09-19 15:52:04 YES
172649 2021-09-19 15:52:04 2021-09-19 16:57:32 YES
172650 2021-09-19 16:57:32 2021-09-19 18:04:32 YES
172651 2021-09-19 18:04:32 2021-09-19 19:29:56 IN-MEMORY
【声明】本内容来自华为云开发者社区博主，不代表华为云及华为云开发者社区的观点和立场。转载时必须标注文章的来源（华为云社区）、文章链接、文章作者等基本信息，否则作者和本社区有权追究责任。如果您发现本社区中有涉嫌抄袭的内容，欢迎发送邮件进行举报，并提供相关证据，一经查实，本社区将立刻删除涉嫌侵权内容，举报邮箱：
cloudbbs@huaweicloud.com
- 点赞
- 收藏
- 关注作者
评论（0）