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

时间线：Oracle

1970年6月：IBM 公司的研究员埃德加·考特（Edgar Frank Codd）在 Communications of ACM 上发表了那篇著名的《大型共享数据库数据的关系模型》（A Relational Model of Data for Large Shared Data Banks）的[……]

Posted on: 2021年8月6日 2021年8月6日
Author: Adamhuan
Categories: Oracle
Tags: -, ，, :, ", /, 1.3, 10, 10g, 11, 11g, 12, 16, 18, 2, 200, 2008, 2012, 2014, 2015, 2017, 2018, 2018年, 2021年8月6日, 21, 26, 3, 30, 3D, 4, 4.0, 5, 50, 6, 6.5, 7, 8, 80, 9, 96, 9i, ant, Apple, b, BE, cat, CD, CDB, CE, Cloud, Cluster, CM, Data, Data Guard, db, dd, df, extension, File, for, form, format, gem, history, http, IBM, if, Internet, iso, KB, Lab, Language, Life, Linux, man, Management, ML, MS, net, nic, OP, OpenWorld, Oracle, PC, PDB, PL/SQL, put, RAC, racle, rap, RDBMS, rm, s, sed, Server, Shared, Software, SQL, Tag, Tiger, timeline, tr, ui, VM, war, wiki, Windows, 不说, 中国, 中文, 主, 书, 事务, 云, 云计算, 互联网, 从, 代号, 代码, 优化, 传输, 位置, 使用, 信, 信息, 充分, 光, 全球, 共享, 内存, 冲突, 分析, 创建, 别, 力, 力量, 功能, 加载, 包含, 协议, 卡, 历史, 压缩, 参与, 发布, 可插拔, 可用, 命名, 商业, 图, 地区, 域, 境, 增, 增加, 增强, 处理, 备份, 大量, 失败, 女, 字典, 存储, 存储过程, 安全, 实例, 实验, 容器, 密码, 对象, 工具, 平台, 库, 应用, 建议, 开发, 引用, 得到, 微软, 心, 性能, 情, 成功, 执行, 扩展, 排名, 操作系统, 改, 改变, 数据, 数据库, 数据类型, 文件, 新, 新功能, 新增, 新特性, 方向, 早, 时间, 时间线, 明智, 智慧, 更新, 服务, 服务器, 未来, 本地, 极, 架构, 查, 查询, 标准, 比较, 测试, 浏览器, 源, 潜在的, 版本, 特性, 猫, 环境, 生活, 用户, 甲骨文, 电脑, 相关, 神, 程序, 空, 空间, 策略, 签, 管理, 系统, 组, 终, 统计, 编程, 编译, 缺少, 网络, 美, 美国, 群, 翻译, 自动, 自动化, 自己, 落, 表, 规则, 解救, 计划, 计算, 记录, 访问, 语, 语句, 语言, 说, 资源, 趋势, 软件, 过高, 连接, 选择, 道, 部署, 配置, 锁, 锁定, 错, 阅读, 阻止, 降低, 限制, 集群, 面对, 项目, 高可用
Leave a comment: 时间线：Oracle

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

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

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-63dea2ade65231[……]

Posted on: 2018年12月18日 2018年12月18日
Author: Adamhuan
Categories: Oracle Dataguard
Tags: alert, Data Guard, DG, error, FAL[client]: Failed to request gap sequence, GAP, RFS, 应用, 异常, 日志传输, 日志应用, 错误
Leave a comment: 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开始的文件的大小为[……]