Data Guard – Adamhuan's Data Center – 【逻辑驱动数据】

DG,备库端：ORA-00313 & ORA-00312 & ORA-27037 + REDO与STANDBY LOG的重建

今天在DG的备库端的数据库里看到了大量如题所示的错误，具体如下：[……]

发表于： 2018年12月21日 2018年12月21日
作者： Adamhuan
分类： Oracle Dataguard
标签： Additional information: 3, alert, Data Guard, DG, error, Linux, Linux-x86_64 Error: 2: No such file or directory, log, ORA-00312, ORA-00312: online log 8 thread 0: '/oracle/NIP/standbylog/stdby_logfile_4.log', ORA-00313, ORA-00313: open failed for members of log group 5 of thread 0, ORA-01156: recovery or flashback in progress may need access to files, ORA-01275: Operation DROP LOGFILE is not allowed if standby file management is automatic, ORA-27037, ORA-27037: unable to obtain file status, redo, STANDBY, 错误
发表评论: DG,备库端：ORA-00313 & ORA-00312 & ORA-27037 + REDO与STANDBY LOG的重建

Oracle 12c DG：FAL[client]: Failed to request gap sequence

我的测试环境中有个12c的DG出现了问题，主库端的ARCHIVE LOG一直无法传送到备库端。

主库端：

suse-1:~ # su - oracle
oracle@suse-1:~> sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue Dec 18 18:36:19 2018

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> set linesize 400
SQL> col member for a65
SQL> select * from v$log order by group#;

    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME     CON_ID
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ --------- ----------
         1          1         97  209715200        512          1 YES INACTIVE               7379778 18-DEC-18      7383387 18-DEC-18          0
         2          1         98  209715200        512          1 NO  CURRENT                7383387 18-DEC-18   1.8447E+19                    0
         3          1         96  209715200        512          1 YES INACTIVE               7379737 18-DEC-18      7379778 18-DEC-18          0

SQL> 
SQL> select * from v$logfile order by group#;

    GROUP# STATUS  TYPE    MEMBER                                                            IS_     CON_ID
---------- ------- ------- ----------------------------------------------------------------- --- ----------
         1         ONLINE  /oradata/orcl/redo01.log                                          NO           0
         2         ONLINE  /oradata/orcl/redo02.log                                          NO           0
         3         ONLINE  /oradata/orcl/redo03.log                                          NO           0
         4         STANDBY /oradata/orcl/stdby_logfile_1.log                                 NO           0
         5         STANDBY /oradata/orcl/stdby_logfile_2.log                                 NO           0
         6         STANDBY /oradata/orcl/stdby_logfile_3.log                                 NO           0

6 rows selected.

SQL> 
SQL> set linesize 400
SQL> col name for a65
SQL> select name,thread#,sequence#,to_char(first_time,'yyyy-mm-dd hh24:mi:ss') "First",to_char(next_time,'yyyy-mm-dd hh24:mi:ss') "Next",applied from v$archived_log order by sequence#;

NAME                                                                 THREAD#  SEQUENCE# First               Next                APPLIED
----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------
/oradata/log_archive_dest_1/1_2_992771642.dbf                              1          2 2018-11-21 10:05:10 2018-11-21 14:32:22 NO
/oradata/log_archive_dest_1/1_3_992771642.dbf                              1          3 2018-11-21 14:32:22 2018-11-21 14:47:31 NO
/oradata/log_archive_dest_1/1_4_992771642.dbf                              1          4 2018-11-21 14:47:31 2018-11-21 16:35:31 NO
/oradata/log_archive_dest_1/1_5_992771642.dbf                              1          5 2018-11-21 16:35:31 2018-11-21 16:35:36 NO
/oradata/log_archive_dest_1/1_6_992771642.dbf                              1          6 2018-11-21 16:35:36 2018-11-21 17:10:06 NO
orclstdby                                                                  1          6 2018-11-21 16:35:36 2018-11-21 17:10:06 YES
/oradata/log_archive_dest_1/1_7_992771642.dbf                              1          7 2018-11-21 17:10:06 2018-11-21 17:11:44 NO
orclstdby                                                                  1          7 2018-11-21 17:10:06 2018-11-21 17:11:44 YES
/oradata/log_archive_dest_1/1_8_992771642.dbf                              1          8 2018-11-21 17:11:44 2018-11-21 17:41:53 NO
orclstdby                                                                  1          8 2018-11-21 17:11:44 2018-11-21 17:41:53 YES
/oradata/log_archive_dest_1/1_9_992771642.dbf                              1          9 2018-11-21 17:41:53 2018-11-21 17:41:59 NO

NAME                                                                 THREAD#  SEQUENCE# First               Next                APPLIED
----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------
orclstdby                                                                  1          9 2018-11-21 17:41:53 2018-11-21 17:41:59 YES
/oradata/log_archive_dest_1/1_10_992771642.dbf                             1         10 2018-11-21 17:41:59 2018-11-21 17:42:03 NO
orclstdby                                                                  1         10 2018-11-21 17:41:59 2018-11-21 17:42:03 YES
/oradata/log_archive_dest_1/1_11_992771642.dbf                             1         11 2018-11-21 17:42:03 2018-11-21 17:50:20 NO
orclstdby                                                                  1         11 2018-11-21 17:42:03 2018-11-21 17:50:20 YES
/oradata/log_archive_dest_1/1_12_992771642.dbf                             1         12 2018-11-21 17:50:20 2018-11-21 17:56:24 NO
orclstdby                                                                  1         12 2018-11-21 17:50:20 2018-11-21 17:56:24 YES
/oradata/log_archive_dest_1/1_13_992771642.dbf                             1         13 2018-11-21 17:56:24 2018-11-21 17:56:26 NO
orclstdby                                                                  1         13 2018-11-21 17:56:24 2018-11-21 17:56:26 YES
orclstdby                                                                  1         14 2018-11-21 17:56:26 2018-11-21 17:56:32 YES
/oradata/log_archive_dest_1/1_14_992771642.dbf                             1         14 2018-11-21 17:56:26 2018-11-21 17:56:32 NO

NAME                                                                 THREAD#  SEQUENCE# First               Next                APPLIED
----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------
/oradata/log_archive_dest_1/1_15_992771642.dbf                             1         15 2018-11-21 17:56:32 2018-11-21 17:56:34 NO
orclstdby                                                                  1         15 2018-11-21 17:56:32 2018-11-21 17:56:34 YES
/oradata/log_archive_dest_1/1_16_992771642.dbf                             1         16 2018-11-21 17:56:34 2018-11-21 17:56:50 NO
orclstdby                                                                  1         16 2018-11-21 17:56:34 2018-11-21 17:56:50 YES
/oradata/log_archive_dest_1/1_17_992771642.dbf                             1         17 2018-11-21 17:56:50 2018-11-21 17:56:51 NO
orclstdby                                                                  1         17 2018-11-21 17:56:50 2018-11-21 17:56:51 YES
/oradata/log_archive_dest_1/1_18_992771642.dbf                             1         18 2018-11-21 17:56:51 2018-11-21 17:56:58 NO
orclstdby                                                                  1         18 2018-11-21 17:56:51 2018-11-21 17:56:58 YES
/oradata/log_archive_dest_1/1_19_992771642.dbf                             1         19 2018-11-21 17:56:58 2018-11-21 17:56:59 NO
orclstdby                                                                  1         19 2018-11-21 17:56:58 2018-11-21 17:56:59 YES
orclstdby                                                                  1         20 2018-11-21 17:56:59 2018-11-21 17:57:06 YES

NAME                                                                 THREAD#  SEQUENCE# First               Next                APPLIED
----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------
/oradata/log_archive_dest_1/1_20_992771642.dbf                             1         20 2018-11-21 17:56:59 2018-11-21 17:57:06 NO
orclstdby                                                                  1         21 2018-11-21 17:57:06 2018-11-21 17:57:09 YES
/oradata/log_archive_dest_1/1_21_992771642.dbf                             1         21 2018-11-21 17:57:06 2018-11-21 17:57:09 NO
orclstdby                                                                  1         22 2018-11-21 17:57:09 2018-11-21 23:38:50 YES
/oradata/log_archive_dest_1/1_22_992771642.dbf                             1         22 2018-11-21 17:57:09 2018-11-21 23:38:50 NO
orclstdby                                                                  1         23 2018-11-21 23:38:50 2018-11-22 22:00:37 YES
/oradata/log_archive_dest_1/1_23_992771642.dbf                             1         23 2018-11-21 23:38:50 2018-11-22 22:00:37 NO
orclstdby                                                                  1         24 2018-11-22 22:00:37 2018-11-23 07:32:26 YES
/oradata/log_archive_dest_1/1_24_992771642.dbf                             1         24 2018-11-22 22:00:37 2018-11-23 07:32:26 NO
orclstdby                                                                  1         25 2018-11-23 07:32:26 2018-11-24 00:48:01 YES
/oradata/log_archive_dest_1/1_25_992771642.dbf                             1         25 2018-11-23 07:32:26 2018-11-24 00:48:01 NO

NAME                                                                 THREAD#  SEQUENCE# First               Next                APPLIED
----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------
orclstdby                                                                  1         26 2018-11-24 00:48:01 2018-11-24 10:00:37 YES
/oradata/log_archive_dest_1/1_26_992771642.dbf                             1         26 2018-11-24 00:48:01 2018-11-24 10:00:37 NO
orclstdby                                                                  1         27 2018-11-24 10:00:37 2018-11-24 15:20:30 YES
/oradata/log_archive_dest_1/1_27_992771642.dbf                             1         27 2018-11-24 10:00:37 2018-11-24 15:20:30 NO
orclstdby                                                                  1         28 2018-11-24 15:20:30 2018-11-24 22:00:58 YES
/oradata/log_archive_dest_1/1_28_992771642.dbf                             1         28 2018-11-24 15:20:30 2018-11-24 22:00:58 NO
orclstdby                                                                  1         29 2018-11-24 22:00:58 2018-11-25 07:23:33 YES
/oradata/log_archive_dest_1/1_29_992771642.dbf                             1         29 2018-11-24 22:00:58 2018-11-25 07:23:33 NO
orclstdby                                                                  1         30 2018-11-25 07:23:33 2018-11-25 13:04:44 YES
/oradata/log_archive_dest_1/1_30_992771642.dbf                             1         30 2018-11-25 07:23:33 2018-11-25 13:04:44 NO
orclstdby                                                                  1         31 2018-11-25 13:04:44 2018-11-25 19:25:37 YES

NAME                                                                 THREAD#  SEQUENCE# First               Next                APPLIED
----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------
/oradata/log_archive_dest_1/1_31_992771642.dbf                             1         31 2018-11-25 13:04:44 2018-11-25 19:25:37 NO
/oradata/log_archive_dest_1/1_32_992771642.dbf                             1         32 2018-11-25 19:25:37 2018-11-26 01:06:30 NO
orclstdby                                                                  1         32 2018-11-25 19:25:37 2018-11-26 01:06:30 YES
/oradata/log_archive_dest_1/1_33_992771642.dbf                             1         33 2018-11-26 01:06:30 2018-11-26 23:10:21 NO
orclstdby                                                                  1         33 2018-11-26 01:06:30 2018-11-26 23:10:21 YES
/oradata/log_archive_dest_1/1_34_992771642.dbf                             1         34 2018-11-26 23:10:21 2018-11-27 18:05:50 NO
orclstdby                                                                  1         34 2018-11-26 23:10:21 2018-11-27 18:05:50 YES
/oradata/log_archive_dest_1/1_35_992771642.dbf                             1         35 2018-11-27 18:05:50 2018-11-28 03:00:48 NO
orclstdby                                                                  1         35 2018-11-27 18:05:50 2018-11-28 03:00:48 YES
/oradata/log_archive_dest_1/1_36_992771642.dbf                             1         36 2018-11-28 03:00:48 2018-11-28 23:15:46 NO
orclstdby                                                                  1         36 2018-11-28 03:00:48 2018-11-28 23:15:46 YES

NAME                                                                 THREAD#  SEQUENCE# First               Next                APPLIED
----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------
/oradata/log_archive_dest_1/1_37_992771642.dbf                             1         37 2018-11-28 23:15:46 2018-11-29 12:04:22 NO
orclstdby                                                                  1         37 2018-11-28 23:15:46 2018-11-29 12:04:22 YES
/oradata/log_archive_dest_1/1_38_992771642.dbf                             1         38 2018-11-29 12:04:22 2018-11-30 02:00:39 NO
orclstdby                                                                  1         38 2018-11-29 12:04:22 2018-11-30 02:00:39 YES
/oradata/log_archive_dest_1/1_39_992771642.dbf                             1         39 2018-11-30 02:00:39 2018-11-30 22:02:00 NO
orclstdby                                                                  1         39 2018-11-30 02:00:39 2018-11-30 22:02:00 YES
/oradata/log_archive_dest_1/1_40_992771642.dbf                             1         40 2018-11-30 22:02:00 2018-12-01 07:04:05 NO
orclstdby                                                                  1         40 2018-11-30 22:02:00 2018-12-01 07:04:05 YES
/oradata/log_archive_dest_1/1_41_992771642.dbf                             1         41 2018-12-01 07:04:05 2018-12-01 10:04:25 NO
orclstdby                                                                  1         41 2018-12-01 07:04:05 2018-12-01 10:04:25 YES
/oradata/log_archive_dest_1/1_42_992771642.dbf                             1         42 2018-12-01 10:04:25 2018-12-01 17:01:01 NO

NAME                                                                 THREAD#  SEQUENCE# First               Next                APPLIED
----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------
orclstdby                                                                  1         42 2018-12-01 10:04:25 2018-12-01 17:01:01 YES
/oradata/log_archive_dest_1/1_43_992771642.dbf                             1         43 2018-12-01 17:01:01 2018-12-02 00:00:03 NO
orclstdby                                                                  1         43 2018-12-01 17:01:01 2018-12-02 00:00:03 YES
/oradata/log_archive_dest_1/1_44_992771642.dbf                             1         44 2018-12-02 00:00:03 2018-12-02 08:10:24 NO
orclstdby                                                                  1         44 2018-12-02 00:00:03 2018-12-02 08:10:24 YES
/oradata/log_archive_dest_1/1_45_992771642.dbf                             1         45 2018-12-02 08:10:24 2018-12-02 12:07:49 NO
/oradata/log_archive_dest_1/1_46_992771642.dbf                             1         46 2018-12-02 12:07:49 2018-12-02 18:08:45 NO
/oradata/log_archive_dest_1/1_47_992771642.dbf                             1         47 2018-12-02 18:08:45 2018-12-03 01:43:45 NO
/oradata/log_archive_dest_1/1_48_992771642.dbf                             1         48 2018-12-03 01:43:45 2018-12-03 22:01:17 NO
/oradata/log_archive_dest_1/1_49_992771642.dbf                             1         49 2018-12-03 22:01:17 2018-12-04 08:12:01 NO
/oradata/log_archive_dest_1/1_50_992771642.dbf                             1         50 2018-12-04 08:12:01 2018-12-04 23:22:23 NO

NAME                                                                 THREAD#  SEQUENCE# First               Next                APPLIED
----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------
/oradata/log_archive_dest_1/1_51_992771642.dbf                             1         51 2018-12-04 23:22:23 2018-12-05 16:54:27 NO
/oradata/log_archive_dest_1/1_52_992771642.dbf                             1         52 2018-12-05 16:54:27 2018-12-06 04:00:15 NO
/oradata/log_archive_dest_1/1_53_992771642.dbf                             1         53 2018-12-06 04:00:15 2018-12-06 22:01:19 NO
/oradata/log_archive_dest_1/1_54_992771642.dbf                             1         54 2018-12-06 22:01:19 2018-12-07 09:00:34 NO
/oradata/log_archive_dest_1/1_55_992771642.dbf                             1         55 2018-12-07 09:00:34 2018-12-08 00:01:02 NO
/oradata/log_archive_dest_1/1_56_992771642.dbf                             1         56 2018-12-08 00:01:02 2018-12-08 08:24:10 NO
/oradata/log_archive_dest_1/1_57_992771642.dbf                             1         57 2018-12-08 08:24:10 2018-12-08 13:13:10 NO
/oradata/log_archive_dest_1/1_58_992771642.dbf                             1         58 2018-12-08 13:13:10 2018-12-08 20:00:40 NO
/oradata/log_archive_dest_1/1_59_992771642.dbf                             1         59 2018-12-08 20:00:40 2018-12-09 05:47:19 NO
/oradata/log_archive_dest_1/1_60_992771642.dbf                             1         60 2018-12-09 05:47:19 2018-12-09 08:34:31 NO
/oradata/log_archive_dest_1/1_61_992771642.dbf                             1         61 2018-12-09 08:34:31 2018-12-09 15:06:33 NO

NAME                                                                 THREAD#  SEQUENCE# First               Next                APPLIED
----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------
/oradata/log_archive_dest_1/1_62_992771642.dbf                             1         62 2018-12-09 15:06:33 2018-12-09 22:07:29 NO
/oradata/log_archive_dest_1/1_63_992771642.dbf                             1         63 2018-12-09 22:07:29 2018-12-10 11:00:35 NO
/oradata/log_archive_dest_1/1_64_992771642.dbf                             1         64 2018-12-10 11:00:35 2018-12-10 22:38:20 NO
/oradata/log_archive_dest_1/1_65_992771642.dbf                             1         65 2018-12-10 22:38:20 2018-12-11 13:21:00 NO
/oradata/log_archive_dest_1/1_66_992771642.dbf                             1         66 2018-12-11 13:21:00 2018-12-12 01:20:41 NO
/oradata/log_archive_dest_1/1_67_992771642.dbf                             1         67 2018-12-12 01:20:41 2018-12-12 22:01:35 NO
/oradata/log_archive_dest_1/1_68_992771642.dbf                             1         68 2018-12-12 22:01:35 2018-12-13 11:00:43 NO
/oradata/log_archive_dest_1/1_69_992771642.dbf                             1         69 2018-12-13 11:00:43 2018-12-13 17:22:00 NO
orclstdby                                                                  1         69 2018-12-13 11:00:43 2018-12-13 17:22:00 NO
/oradata/log_archive_dest_1/1_70_992771642.dbf                             1         70 2018-12-13 17:22:00 2018-12-13 17:32:57 NO
orclstdby                                                                  1         70 2018-12-13 17:22:00 2018-12-13 17:32:57 NO

NAME                                                                 THREAD#  SEQUENCE# First               Next                APPLIED
----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------
/oradata/log_archive_dest_1/1_71_992771642.dbf                             1         71 2018-12-13 17:32:57 2018-12-13 17:33:04 NO
/oradata/log_archive_dest_1/1_72_992771642.dbf                             1         72 2018-12-13 17:33:04 2018-12-13 17:33:06 NO
/oradata/log_archive_dest_1/1_73_992771642.dbf                             1         73 2018-12-13 17:33:06 2018-12-13 17:33:08 NO
/oradata/log_archive_dest_1/1_74_992771642.dbf                             1         74 2018-12-13 17:33:08 2018-12-13 17:33:36 NO
/oradata/log_archive_dest_1/1_75_992771642.dbf                             1         75 2018-12-13 17:33:36 2018-12-13 17:33:38 NO
/oradata/log_archive_dest_1/1_76_992771642.dbf                             1         76 2018-12-13 17:33:38 2018-12-13 17:33:39 NO
/oradata/log_archive_dest_1/1_77_992771642.dbf                             1         77 2018-12-13 17:33:39 2018-12-13 17:33:40 NO
/oradata/log_archive_dest_1/1_78_992771642.dbf                             1         78 2018-12-13 17:33:40 2018-12-13 17:33:41 NO
/oradata/log_archive_dest_1/1_79_992771642.dbf                             1         79 2018-12-13 17:33:41 2018-12-13 17:33:41 NO
/oradata/log_archive_dest_1/1_80_992771642.dbf                             1         80 2018-12-13 17:33:41 2018-12-13 17:33:42 NO
/oradata/log_archive_dest_1/1_81_992771642.dbf                             1         81 2018-12-13 17:33:42 2018-12-13 23:02:59 NO

NAME                                                                 THREAD#  SEQUENCE# First               Next                APPLIED
----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------
/oradata/log_archive_dest_1/1_82_992771642.dbf                             1         82 2018-12-13 23:02:59 2018-12-14 13:00:12 NO
/oradata/log_archive_dest_1/1_83_992771642.dbf                             1         83 2018-12-14 13:00:12 2018-12-14 23:05:45 NO
/oradata/log_archive_dest_1/1_84_992771642.dbf                             1         84 2018-12-14 23:05:45 2018-12-15 08:00:31 NO
/oradata/log_archive_dest_1/1_85_992771642.dbf                             1         85 2018-12-15 08:00:31 2018-12-15 13:57:25 NO
/oradata/log_archive_dest_1/1_86_992771642.dbf                             1         86 2018-12-15 13:57:25 2018-12-15 19:58:05 NO
/oradata/log_archive_dest_1/1_87_992771642.dbf                             1         87 2018-12-15 19:58:05 2018-12-15 22:28:50 NO
/oradata/log_archive_dest_1/1_88_992771642.dbf                             1         88 2018-12-15 22:28:50 2018-12-16 07:49:36 NO
/oradata/log_archive_dest_1/1_89_992771642.dbf                             1         89 2018-12-16 07:49:36 2018-12-16 14:10:36 NO
/oradata/log_archive_dest_1/1_90_992771642.dbf                             1         90 2018-12-16 14:10:36 2018-12-16 20:01:19 NO
/oradata/log_archive_dest_1/1_91_992771642.dbf                             1         91 2018-12-16 20:01:19 2018-12-16 23:01:44 NO
/oradata/log_archive_dest_1/1_92_992771642.dbf                             1         92 2018-12-16 23:01:44 2018-12-17 20:46:05 NO

NAME                                                                 THREAD#  SEQUENCE# First               Next                APPLIED
----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------
/oradata/log_archive_dest_1/1_93_992771642.dbf                             1         93 2018-12-17 20:46:05 2018-12-17 23:34:35 NO
/oradata/log_archive_dest_1/1_94_992771642.dbf                             1         94 2018-12-17 23:34:35 2018-12-18 17:10:47 NO
/oradata/log_archive_dest_1/1_95_992771642.dbf                             1         95 2018-12-18 17:10:47 2018-12-18 17:11:10 NO
/oradata/log_archive_dest_1/1_96_992771642.dbf                             1         96 2018-12-18 17:11:10 2018-12-18 17:11:30 NO
/oradata/log_archive_dest_1/1_97_992771642.dbf                             1         97 2018-12-18 17:11:30 2018-12-18 17:38:20 NO

137 rows selected.

SQL>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

suse-1:~ # su - oracle

oracle@suse-1:~> sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue Dec 18 18:36:19 2018

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> set linesize 400

SQL> col member for a65

SQL> select * from v$log order by group#;

GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME CON_ID

---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ --------- ----------

1 1 97 209715200 512 1 YES INACTIVE 7379778 18-DEC-18 7383387 18-DEC-18 0

2 1 98 209715200 512 1 NO CURRENT 7383387 18-DEC-18 1.8447E+19 0

3 1 96 209715200 512 1 YES INACTIVE 7379737 18-DEC-18 7379778 18-DEC-18 0

SQL>

SQL> select * from v$logfile order by group#;

GROUP# STATUS TYPE MEMBER IS_ CON_ID

---------- ------- ------- ----------------------------------------------------------------- --- ----------

1 ONLINE /oradata/orcl/redo01.log NO 0

2 ONLINE /oradata/orcl/redo02.log NO 0

3 ONLINE /oradata/orcl/redo03.log NO 0

4 STANDBY /oradata/orcl/stdby_logfile_1.log NO 0

5 STANDBY /oradata/orcl/stdby_logfile_2.log NO 0

6 STANDBY /oradata/orcl/stdby_logfile_3.log NO 0

6 rows selected.

SQL>

SQL> set linesize 400

SQL> col name for a65

SQL> select name,thread#,sequence#,to_char(first_time,'yyyy-mm-dd hh24:mi:ss') "First",to_char(next_time,'yyyy-mm-dd hh24:mi:ss') "Next",applied from v$archived_log order by sequence#;

NAME THREAD# SEQUENCE# First Next APPLIED

----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------

/oradata/log_archive_dest_1/1_2_992771642.dbf 1 2 2018-11-21 10:05:10 2018-11-21 14:32:22 NO

/oradata/log_archive_dest_1/1_3_992771642.dbf 1 3 2018-11-21 14:32:22 2018-11-21 14:47:31 NO

/oradata/log_archive_dest_1/1_4_992771642.dbf 1 4 2018-11-21 14:47:31 2018-11-21 16:35:31 NO

/oradata/log_archive_dest_1/1_5_992771642.dbf 1 5 2018-11-21 16:35:31 2018-11-21 16:35:36 NO

/oradata/log_archive_dest_1/1_6_992771642.dbf 1 6 2018-11-21 16:35:36 2018-11-21 17:10:06 NO

orclstdby 1 6 2018-11-21 16:35:36 2018-11-21 17:10:06 YES

/oradata/log_archive_dest_1/1_7_992771642.dbf 1 7 2018-11-21 17:10:06 2018-11-21 17:11:44 NO

orclstdby 1 7 2018-11-21 17:10:06 2018-11-21 17:11:44 YES

/oradata/log_archive_dest_1/1_8_992771642.dbf 1 8 2018-11-21 17:11:44 2018-11-21 17:41:53 NO

orclstdby 1 8 2018-11-21 17:11:44 2018-11-21 17:41:53 YES

/oradata/log_archive_dest_1/1_9_992771642.dbf 1 9 2018-11-21 17:41:53 2018-11-21 17:41:59 NO

NAME THREAD# SEQUENCE# First Next APPLIED

----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------

orclstdby 1 9 2018-11-21 17:41:53 2018-11-21 17:41:59 YES

/oradata/log_archive_dest_1/1_10_992771642.dbf 1 10 2018-11-21 17:41:59 2018-11-21 17:42:03 NO

orclstdby 1 10 2018-11-21 17:41:59 2018-11-21 17:42:03 YES

/oradata/log_archive_dest_1/1_11_992771642.dbf 1 11 2018-11-21 17:42:03 2018-11-21 17:50:20 NO

orclstdby 1 11 2018-11-21 17:42:03 2018-11-21 17:50:20 YES

/oradata/log_archive_dest_1/1_12_992771642.dbf 1 12 2018-11-21 17:50:20 2018-11-21 17:56:24 NO

orclstdby 1 12 2018-11-21 17:50:20 2018-11-21 17:56:24 YES

/oradata/log_archive_dest_1/1_13_992771642.dbf 1 13 2018-11-21 17:56:24 2018-11-21 17:56:26 NO

orclstdby 1 13 2018-11-21 17:56:24 2018-11-21 17:56:26 YES

orclstdby 1 14 2018-11-21 17:56:26 2018-11-21 17:56:32 YES

/oradata/log_archive_dest_1/1_14_992771642.dbf 1 14 2018-11-21 17:56:26 2018-11-21 17:56:32 NO

NAME THREAD# SEQUENCE# First Next APPLIED

----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------

/oradata/log_archive_dest_1/1_15_992771642.dbf 1 15 2018-11-21 17:56:32 2018-11-21 17:56:34 NO

orclstdby 1 15 2018-11-21 17:56:32 2018-11-21 17:56:34 YES

/oradata/log_archive_dest_1/1_16_992771642.dbf 1 16 2018-11-21 17:56:34 2018-11-21 17:56:50 NO

orclstdby 1 16 2018-11-21 17:56:34 2018-11-21 17:56:50 YES

/oradata/log_archive_dest_1/1_17_992771642.dbf 1 17 2018-11-21 17:56:50 2018-11-21 17:56:51 NO

orclstdby 1 17 2018-11-21 17:56:50 2018-11-21 17:56:51 YES

/oradata/log_archive_dest_1/1_18_992771642.dbf 1 18 2018-11-21 17:56:51 2018-11-21 17:56:58 NO

orclstdby 1 18 2018-11-21 17:56:51 2018-11-21 17:56:58 YES

/oradata/log_archive_dest_1/1_19_992771642.dbf 1 19 2018-11-21 17:56:58 2018-11-21 17:56:59 NO

orclstdby 1 19 2018-11-21 17:56:58 2018-11-21 17:56:59 YES

orclstdby 1 20 2018-11-21 17:56:59 2018-11-21 17:57:06 YES

NAME THREAD# SEQUENCE# First Next APPLIED

----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------

/oradata/log_archive_dest_1/1_20_992771642.dbf 1 20 2018-11-21 17:56:59 2018-11-21 17:57:06 NO

orclstdby 1 21 2018-11-21 17:57:06 2018-11-21 17:57:09 YES

/oradata/log_archive_dest_1/1_21_992771642.dbf 1 21 2018-11-21 17:57:06 2018-11-21 17:57:09 NO

orclstdby 1 22 2018-11-21 17:57:09 2018-11-21 23:38:50 YES

/oradata/log_archive_dest_1/1_22_992771642.dbf 1 22 2018-11-21 17:57:09 2018-11-21 23:38:50 NO

orclstdby 1 23 2018-11-21 23:38:50 2018-11-22 22:00:37 YES

/oradata/log_archive_dest_1/1_23_992771642.dbf 1 23 2018-11-21 23:38:50 2018-11-22 22:00:37 NO

orclstdby 1 24 2018-11-22 22:00:37 2018-11-23 07:32:26 YES

/oradata/log_archive_dest_1/1_24_992771642.dbf 1 24 2018-11-22 22:00:37 2018-11-23 07:32:26 NO

orclstdby 1 25 2018-11-23 07:32:26 2018-11-24 00:48:01 YES

/oradata/log_archive_dest_1/1_25_992771642.dbf 1 25 2018-11-23 07:32:26 2018-11-24 00:48:01 NO

NAME THREAD# SEQUENCE# First Next APPLIED

----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------

orclstdby 1 26 2018-11-24 00:48:01 2018-11-24 10:00:37 YES

/oradata/log_archive_dest_1/1_26_992771642.dbf 1 26 2018-11-24 00:48:01 2018-11-24 10:00:37 NO

orclstdby 1 27 2018-11-24 10:00:37 2018-11-24 15:20:30 YES

/oradata/log_archive_dest_1/1_27_992771642.dbf 1 27 2018-11-24 10:00:37 2018-11-24 15:20:30 NO

orclstdby 1 28 2018-11-24 15:20:30 2018-11-24 22:00:58 YES

/oradata/log_archive_dest_1/1_28_992771642.dbf 1 28 2018-11-24 15:20:30 2018-11-24 22:00:58 NO

orclstdby 1 29 2018-11-24 22:00:58 2018-11-25 07:23:33 YES

/oradata/log_archive_dest_1/1_29_992771642.dbf 1 29 2018-11-24 22:00:58 2018-11-25 07:23:33 NO

orclstdby 1 30 2018-11-25 07:23:33 2018-11-25 13:04:44 YES

/oradata/log_archive_dest_1/1_30_992771642.dbf 1 30 2018-11-25 07:23:33 2018-11-25 13:04:44 NO

orclstdby 1 31 2018-11-25 13:04:44 2018-11-25 19:25:37 YES

NAME THREAD# SEQUENCE# First Next APPLIED

----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------

/oradata/log_archive_dest_1/1_31_992771642.dbf 1 31 2018-11-25 13:04:44 2018-11-25 19:25:37 NO

/oradata/log_archive_dest_1/1_32_992771642.dbf 1 32 2018-11-25 19:25:37 2018-11-26 01:06:30 NO

orclstdby 1 32 2018-11-25 19:25:37 2018-11-26 01:06:30 YES

/oradata/log_archive_dest_1/1_33_992771642.dbf 1 33 2018-11-26 01:06:30 2018-11-26 23:10:21 NO

orclstdby 1 33 2018-11-26 01:06:30 2018-11-26 23:10:21 YES

/oradata/log_archive_dest_1/1_34_992771642.dbf 1 34 2018-11-26 23:10:21 2018-11-27 18:05:50 NO

orclstdby 1 34 2018-11-26 23:10:21 2018-11-27 18:05:50 YES

/oradata/log_archive_dest_1/1_35_992771642.dbf 1 35 2018-11-27 18:05:50 2018-11-28 03:00:48 NO

orclstdby 1 35 2018-11-27 18:05:50 2018-11-28 03:00:48 YES

/oradata/log_archive_dest_1/1_36_992771642.dbf 1 36 2018-11-28 03:00:48 2018-11-28 23:15:46 NO

orclstdby 1 36 2018-11-28 03:00:48 2018-11-28 23:15:46 YES

NAME THREAD# SEQUENCE# First Next APPLIED

----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------

/oradata/log_archive_dest_1/1_37_992771642.dbf 1 37 2018-11-28 23:15:46 2018-11-29 12:04:22 NO

orclstdby 1 37 2018-11-28 23:15:46 2018-11-29 12:04:22 YES

/oradata/log_archive_dest_1/1_38_992771642.dbf 1 38 2018-11-29 12:04:22 2018-11-30 02:00:39 NO

orclstdby 1 38 2018-11-29 12:04:22 2018-11-30 02:00:39 YES

/oradata/log_archive_dest_1/1_39_992771642.dbf 1 39 2018-11-30 02:00:39 2018-11-30 22:02:00 NO

orclstdby 1 39 2018-11-30 02:00:39 2018-11-30 22:02:00 YES

/oradata/log_archive_dest_1/1_40_992771642.dbf 1 40 2018-11-30 22:02:00 2018-12-01 07:04:05 NO

orclstdby 1 40 2018-11-30 22:02:00 2018-12-01 07:04:05 YES

/oradata/log_archive_dest_1/1_41_992771642.dbf 1 41 2018-12-01 07:04:05 2018-12-01 10:04:25 NO

orclstdby 1 41 2018-12-01 07:04:05 2018-12-01 10:04:25 YES

/oradata/log_archive_dest_1/1_42_992771642.dbf 1 42 2018-12-01 10:04:25 2018-12-01 17:01:01 NO

NAME THREAD# SEQUENCE# First Next APPLIED

----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------

orclstdby 1 42 2018-12-01 10:04:25 2018-12-01 17:01:01 YES

/oradata/log_archive_dest_1/1_43_992771642.dbf 1 43 2018-12-01 17:01:01 2018-12-02 00:00:03 NO

orclstdby 1 43 2018-12-01 17:01:01 2018-12-02 00:00:03 YES

/oradata/log_archive_dest_1/1_44_992771642.dbf 1 44 2018-12-02 00:00:03 2018-12-02 08:10:24 NO

orclstdby 1 44 2018-12-02 00:00:03 2018-12-02 08:10:24 YES

/oradata/log_archive_dest_1/1_45_992771642.dbf 1 45 2018-12-02 08:10:24 2018-12-02 12:07:49 NO

/oradata/log_archive_dest_1/1_46_992771642.dbf 1 46 2018-12-02 12:07:49 2018-12-02 18:08:45 NO

/oradata/log_archive_dest_1/1_47_992771642.dbf 1 47 2018-12-02 18:08:45 2018-12-03 01:43:45 NO

/oradata/log_archive_dest_1/1_48_992771642.dbf 1 48 2018-12-03 01:43:45 2018-12-03 22:01:17 NO

/oradata/log_archive_dest_1/1_49_992771642.dbf 1 49 2018-12-03 22:01:17 2018-12-04 08:12:01 NO

/oradata/log_archive_dest_1/1_50_992771642.dbf 1 50 2018-12-04 08:12:01 2018-12-04 23:22:23 NO

NAME THREAD# SEQUENCE# First Next APPLIED

----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------

/oradata/log_archive_dest_1/1_51_992771642.dbf 1 51 2018-12-04 23:22:23 2018-12-05 16:54:27 NO

/oradata/log_archive_dest_1/1_52_992771642.dbf 1 52 2018-12-05 16:54:27 2018-12-06 04:00:15 NO

/oradata/log_archive_dest_1/1_53_992771642.dbf 1 53 2018-12-06 04:00:15 2018-12-06 22:01:19 NO

/oradata/log_archive_dest_1/1_54_992771642.dbf 1 54 2018-12-06 22:01:19 2018-12-07 09:00:34 NO

/oradata/log_archive_dest_1/1_55_992771642.dbf 1 55 2018-12-07 09:00:34 2018-12-08 00:01:02 NO

/oradata/log_archive_dest_1/1_56_992771642.dbf 1 56 2018-12-08 00:01:02 2018-12-08 08:24:10 NO

/oradata/log_archive_dest_1/1_57_992771642.dbf 1 57 2018-12-08 08:24:10 2018-12-08 13:13:10 NO

/oradata/log_archive_dest_1/1_58_992771642.dbf 1 58 2018-12-08 13:13:10 2018-12-08 20:00:40 NO

/oradata/log_archive_dest_1/1_59_992771642.dbf 1 59 2018-12-08 20:00:40 2018-12-09 05:47:19 NO

/oradata/log_archive_dest_1/1_60_992771642.dbf 1 60 2018-12-09 05:47:19 2018-12-09 08:34:31 NO

/oradata/log_archive_dest_1/1_61_992771642.dbf 1 61 2018-12-09 08:34:31 2018-12-09 15:06:33 NO

NAME THREAD# SEQUENCE# First Next APPLIED

----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------

/oradata/log_archive_dest_1/1_62_992771642.dbf 1 62 2018-12-09 15:06:33 2018-12-09 22:07:29 NO

/oradata/log_archive_dest_1/1_63_992771642.dbf 1 63 2018-12-09 22:07:29 2018-12-10 11:00:35 NO

/oradata/log_archive_dest_1/1_64_992771642.dbf 1 64 2018-12-10 11:00:35 2018-12-10 22:38:20 NO

/oradata/log_archive_dest_1/1_65_992771642.dbf 1 65 2018-12-10 22:38:20 2018-12-11 13:21:00 NO

/oradata/log_archive_dest_1/1_66_992771642.dbf 1 66 2018-12-11 13:21:00 2018-12-12 01:20:41 NO

/oradata/log_archive_dest_1/1_67_992771642.dbf 1 67 2018-12-12 01:20:41 2018-12-12 22:01:35 NO

/oradata/log_archive_dest_1/1_68_992771642.dbf 1 68 2018-12-12 22:01:35 2018-12-13 11:00:43 NO

/oradata/log_archive_dest_1/1_69_992771642.dbf 1 69 2018-12-13 11:00:43 2018-12-13 17:22:00 NO

orclstdby 1 69 2018-12-13 11:00:43 2018-12-13 17:22:00 NO

/oradata/log_archive_dest_1/1_70_992771642.dbf 1 70 2018-12-13 17:22:00 2018-12-13 17:32:57 NO

orclstdby 1 70 2018-12-13 17:22:00 2018-12-13 17:32:57 NO

NAME THREAD# SEQUENCE# First Next APPLIED

----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------

/oradata/log_archive_dest_1/1_71_992771642.dbf 1 71 2018-12-13 17:32:57 2018-12-13 17:33:04 NO

/oradata/log_archive_dest_1/1_72_992771642.dbf 1 72 2018-12-13 17:33:04 2018-12-13 17:33:06 NO

/oradata/log_archive_dest_1/1_73_992771642.dbf 1 73 2018-12-13 17:33:06 2018-12-13 17:33:08 NO

/oradata/log_archive_dest_1/1_74_992771642.dbf 1 74 2018-12-13 17:33:08 2018-12-13 17:33:36 NO

/oradata/log_archive_dest_1/1_75_992771642.dbf 1 75 2018-12-13 17:33:36 2018-12-13 17:33:38 NO

/oradata/log_archive_dest_1/1_76_992771642.dbf 1 76 2018-12-13 17:33:38 2018-12-13 17:33:39 NO

/oradata/log_archive_dest_1/1_77_992771642.dbf 1 77 2018-12-13 17:33:39 2018-12-13 17:33:40 NO

/oradata/log_archive_dest_1/1_78_992771642.dbf 1 78 2018-12-13 17:33:40 2018-12-13 17:33:41 NO

/oradata/log_archive_dest_1/1_79_992771642.dbf 1 79 2018-12-13 17:33:41 2018-12-13 17:33:41 NO

/oradata/log_archive_dest_1/1_80_992771642.dbf 1 80 2018-12-13 17:33:41 2018-12-13 17:33:42 NO

/oradata/log_archive_dest_1/1_81_992771642.dbf 1 81 2018-12-13 17:33:42 2018-12-13 23:02:59 NO

NAME THREAD# SEQUENCE# First Next APPLIED

----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------

/oradata/log_archive_dest_1/1_82_992771642.dbf 1 82 2018-12-13 23:02:59 2018-12-14 13:00:12 NO

/oradata/log_archive_dest_1/1_83_992771642.dbf 1 83 2018-12-14 13:00:12 2018-12-14 23:05:45 NO

/oradata/log_archive_dest_1/1_84_992771642.dbf 1 84 2018-12-14 23:05:45 2018-12-15 08:00:31 NO

/oradata/log_archive_dest_1/1_85_992771642.dbf 1 85 2018-12-15 08:00:31 2018-12-15 13:57:25 NO

/oradata/log_archive_dest_1/1_86_992771642.dbf 1 86 2018-12-15 13:57:25 2018-12-15 19:58:05 NO

/oradata/log_archive_dest_1/1_87_992771642.dbf 1 87 2018-12-15 19:58:05 2018-12-15 22:28:50 NO

/oradata/log_archive_dest_1/1_88_992771642.dbf 1 88 2018-12-15 22:28:50 2018-12-16 07:49:36 NO

/oradata/log_archive_dest_1/1_89_992771642.dbf 1 89 2018-12-16 07:49:36 2018-12-16 14:10:36 NO

/oradata/log_archive_dest_1/1_90_992771642.dbf 1 90 2018-12-16 14:10:36 2018-12-16 20:01:19 NO

/oradata/log_archive_dest_1/1_91_992771642.dbf 1 91 2018-12-16 20:01:19 2018-12-16 23:01:44 NO

/oradata/log_archive_dest_1/1_92_992771642.dbf 1 92 2018-12-16 23:01:44 2018-12-17 20:46:05 NO

NAME THREAD# SEQUENCE# First Next APPLIED

----------------------------------------------------------------- ---------- ---------- ------------------- ------------------- ---------

/oradata/log_archive_dest_1/1_93_992771642.dbf 1 93 2018-12-17 20:46:05 2018-12-17 23:34:35 NO

/oradata/log_archive_dest_1/1_94_992771642.dbf 1 94 2018-12-17 23:34:35 2018-12-18 17:10:47 NO

/oradata/log_archive_dest_1/1_95_992771642.dbf 1 95 2018-12-18 17:10:47 2018-12-18 17:11:10 NO

/oradata/log_archive_dest_1/1_96_992771642.dbf 1 96 2018-12-18 17:11:10 2018-12-18 17:11:30 NO

/oradata/log_archive_dest_1/1_97_992771642.dbf 1 97 2018-12-18 17:11:30 2018-12-18 17:38:20 NO

137 rows selected.

SQL>

可以看到，主库端的SEQUENCE已经97了。

在看看备库端：
[crayon-5c42fa8aa09042[……]

发表于： 2018年12月18日 2018年12月18日
作者： Adamhuan
分类： Oracle Dataguard
标签： alert, Data Guard, DG, error, FAL[client]: Failed to request gap sequence, GAP, RFS, 应用, 异常, 日志传输, 日志应用, 错误
发表评论: Oracle 12c DG：FAL[client]: Failed to request gap sequence

Oracle database 12c DG – standby：ORA-00305: log 3 of thread 1 inconsistent; belongs to another database

在Oracle12c的DG环境中遇到了如题所示的错误。[……]

Oracle DG：备库：RMAN-06094: datafile 463 must be restored

在利用RMAN增量还原DG备库的差异数据的时候，我遇到了如题所示的问题，具体如下：

RMAN> recover database noredo;

Starting recover at 14-SEP-18
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/14/2018 11:05:41
RMAN-06094: datafile 463 must be restored

RMAN>

RMAN> recover database noredo;

Starting recover at 14-SEP-18

using channel ORA_DISK_1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 09/14/2018 11:05:41

RMAN-06094: datafile 463 must be restored

RMAN>

打开数据库，查看一下数据文件的状态：

SQL> set linesize 400
SQL> col name for a50
SQL> 
SQL> select file#,name,bytes/1024/1024/1024 from v$datafile where file#>426;

（过多的输出，... ）

     FILE# NAME                                               BYTES/1024/1024/1024
---------- -------------------------------------------------- --------------------
       460 /oracle/MY_INSTANCE/mydata14/zen_424/zen.424.data                           30
       461 /oracle/MY_INSTANCE/mydata14/zen_425/zen.425.data                           30
       462 /oracle/MY_INSTANCE/mydata14/zen_426/zen.426.data                           30
       463 /oracle/MY_INSTANCE/mydata10/zen_427/zen.427.data                            0
       464 /oracle/MY_INSTANCE/mydata10/zen_428/zen.428.data                            0
       465 /oracle/MY_INSTANCE/mydata11/zen_429/zen.429.data                            0

39 rows selected.

SQL>

SQL> set linesize 400

SQL> col name for a50

SQL>

SQL> select file#,name,bytes/1024/1024/1024 from v$datafile where file#>426;

（过多的输出，... ）

FILE# NAME BYTES/1024/1024/1024

---------- -------------------------------------------------- --------------------

460 /oracle/MY_INSTANCE/mydata14/zen_424/zen.424.data 30

461 /oracle/MY_INSTANCE/mydata14/zen_425/zen.425.data 30

462 /oracle/MY_INSTANCE/mydata14/zen_426/zen.426.data 30

463 /oracle/MY_INSTANCE/mydata10/zen_427/zen.427.data 0

464 /oracle/MY_INSTANCE/mydata10/zen_428/zen.428.data 0

465 /oracle/MY_INSTANCE/mydata11/zen_429/zen.429.data 0

39 rows selected.

SQL>

可以看到，463开始的文件的大小为[……]

Oracle Data Guard 10g 10205：RAC –> Standby

前提：
1. 主库：Oracle RAC 10g
2. 备库：Oracle DB 10g 10205

主库：

[root@rac2 ~]# su - grid
[grid@rac2 ~]$ 
[grid@rac2 ~]$ crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host        
----------------------------------------------------------------------
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    rac1        
ora....C1.lsnr application    0/5    0/0    ONLINE    ONLINE    rac1        
ora.rac1.gsd   application    0/5    0/0    ONLINE    ONLINE    rac1        
ora.rac1.ons   application    0/3    0/0    ONLINE    ONLINE    rac1        
ora.rac1.vip   application    0/0    0/0    ONLINE    ONLINE    rac1        
ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    rac2        
ora....C2.lsnr application    0/5    0/0    ONLINE    ONLINE    rac2        
ora.rac2.gsd   application    0/5    0/0    ONLINE    ONLINE    rac2        
ora.rac2.ons   application    0/3    0/0    ONLINE    ONLINE    rac2        
ora.rac2.vip   application    0/0    0/0    ONLINE    ONLINE    rac2        
ora.zona.db    application    0/1    0/1    ONLINE    ONLINE    rac2        
ora....a1.inst application    0/5    0/0    ONLINE    ONLINE    rac1        
ora....a2.inst application    0/5    0/0    ONLINE    ONLINE    rac2        
[grid@rac2 ~]$ 
[grid@rac2 ~]$ exit
logout
[root@rac2 ~]# su - oracle
[oracle@rac2 ~]$ 
[oracle@rac2 ~]$ ps -ef | grep pmon
oracle    3484     1  0 08:12 ?        00:00:00 asm_pmon_+ASM2
oracle   20559 20478  0 10:07 pts/4    00:00:00 grep pmon
oracle   26556     1  0 09:05 ?        00:00:00 ora_pmon_zona2
[oracle@rac2 ~]$ 
[oracle@rac2 ~]$ env | grep SID
ORACLE_SID=zona2
[oracle@rac2 ~]$ 
[oracle@rac2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Tue Jul 3 10:07:52 2018

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> select instance_name,status from v$instance;

INSTANCE_NAME    STATUS
---------------- ------------
zona2            OPEN

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
[oracle@rac2 ~]$

[root@rac2 ~]# su - grid

[grid@rac2 ~]$

[grid@rac2 ~]$ crs_stat -t -v

Name Type R/RA F/FT Target State Host

----------------------------------------------------------------------

ora....SM1.asm application 0/5 0/0 ONLINE ONLINE rac1

ora....C1.lsnr application 0/5 0/0 ONLINE ONLINE rac1

ora.rac1.gsd application 0/5 0/0 ONLINE ONLINE rac1

ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1

ora.rac1.vip application 0/0 0/0 ONLINE ONLINE rac1

ora....SM2.asm application 0/5 0/0 ONLINE ONLINE rac2

ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2

ora.rac2.gsd application 0/5 0/0 ONLINE ONLINE rac2

ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2

ora.rac2.vip application 0/0 0/0 ONLINE ONLINE rac2

ora.zona.db application 0/1 0/1 ONLINE ONLINE rac2

ora....a1.inst application 0/5 0/0 ONLINE ONLINE rac1

ora....a2.inst application 0/5 0/0 ONLINE ONLINE rac2

[grid@rac2 ~]$

[grid@rac2 ~]$ exit

logout

[root@rac2 ~]# su - oracle

[oracle@rac2 ~]$

[oracle@rac2 ~]$ ps -ef | grep pmon

oracle 3484 1 0 08:12 ? 00:00:00 asm_pmon_+ASM2

oracle 20559 20478 0 10:07 pts/4 00:00:00 grep pmon

oracle 26556 1 0 09:05 ? 00:00:00 ora_pmon_zona2

[oracle@rac2 ~]$

[oracle@rac2 ~]$ env | grep SID

ORACLE_SID=zona2

[oracle@rac2 ~]$

[oracle@rac2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Tue Jul 3 10:07:52 2018

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

SQL> select instance_name,status from v$instance;

INSTANCE_NAME STATUS

---------------- ------------

zona2 OPEN

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

[oracle@rac2 ~]$

备库：

[oracle@standby-rac ~]$ sqlplus -V

SQL*Plus: Release 10.2.0.5.0 - Production

[oracle@standby-rac ~]$

[oracle@standby-rac ~]$ sqlplus -V

SQL*Plus: Release 10.2.0.5.0 - Production

[oracle@standby-rac ~]$

一、基础配置检查：[……]

发表于： 2018年7月5日 2018年7月5日
作者： Adamhuan
分类： Oracle Dataguard, Real Application Cluster
标签： Data Guard, DG, Linux, Oracle, RAC, spfile, 集群
发表评论: Oracle Data Guard 10g 10205：RAC –> Standby