一、背景需求
生产库中有一个业务视图被误修改，需要单独恢复到修改前版本。
如下先在生产库确认本次对象信息，最后修改时间：
set lines 200 pages 100
col owner for a20
col object_name for a40
col object_type for a15
col last_ddl_time for a20
col status for a10
select owner,
object_name,
object_type,
to_char(last_ddl_time,'yyyy-mm-dd hh24:mi:ss') last_ddl_time,
status
from dba_objects
where owner = 'WMPROD'
and object_name = 'V_YN_GSP_NBR'
and object_type = 'VIEW';
查询结果：
OWNER OBJECT_NAME OBJECT_TYPE LAST_DDL_TIME STATUS
-------------------- ---------------------------------------- --------------- -------------------- ----------
WMPROD V_YN_GSP_NBR VIEW 2026-05-21 14:48:47 VALID
SQL>
恢复目标：只恢复 WMPROD.V_YN_GSP_NBR 这个视图定义，不回退生产库数据，不影响其他业务对象，恢复到 2026-05-21 14:48:47 修改之前
二、恢复思路
恢复方法如下表格：
| 方法 | 是否推荐 | 适用条件 | 风险 |
|---|---|---|---|
| 从代码库/发布脚本找旧视图定义 | 最推荐 | 有版本管理或上线脚本 | 最低 |
| 用 RMAN 克隆辅助库到修改前时间点，再导出视图 DDL | 推荐 | 有 RMAN 备份 + 归档完整 | 低，不影响生产 |
| 生产库 Flashback Database 回退 | 不推荐 | 需要整库回退 | 高，会影响所有业务 |
| RMAN 直接恢复单个视图 | 不支持 | 视图不是物理段对象 | 不可行 |
| LogMiner 查归档 | 可辅助定位 | 想确认谁改的、改了什么 | 不一定能还原旧定义 |
Oracle 的视图本质上是数据字典里的元数据对象，不像表数据文件那样可以直接通过 RMAN 单独恢复一个对象。
所以本次采用的思路是：
生产库保持不动
↓
使用 RMAN Duplicate 克隆一个辅助库 WMSAUX
↓
辅助库恢复到视图被修改之前的时间点
↓
从辅助库导出旧版视图 DDL
↓
在生产库执行 CREATE OR REPLACE VIEW 覆盖错误定义
↓
编译、验证、清理辅助库
为什么不直接做生产库时间点恢复？
| 方案 | 是否采用 | 原因 |
|---|---|---|
| 生产库 PITR | 否 | 会把整个生产库回退，影响所有业务数据 |
| Flashback Database | 否 | 同样是整库级别回退，风险过高 |
| LogMiner 找 DDL | 仅辅助 | 能定位修改 SQL，但不一定能拿到旧定义 |
| RMAN Duplicate 辅助库 | 是 | 不影响生产库，能准确拿到修改前数据字典状态 |
三、环境信息确认
生产库基本信息：
set lines 200 pages 100
col name for a20
col open_mode for a20
col database_role for a20
select name, dbid, open_mode, database_role
from v$database;
select instance_name, host_name, version, status
from v$instance;
查询结果：
NAME DBID OPEN_MODE DATABASE_ROLE
-------------------- ---------- -------------------- --------------------
WMPROD 3080983586 READ WRITE PRIMARY
INSTANCE_NAME HOST_NAME VERSION STATUS
---------------- -------------- ----------------- --------
wmprod wmsdb2019 18.0.0.0.0 OPEN
生产库数据文件和 redo 文件都在文件系统路径：
SQL> set lines 300 pages 100
col file_name for a120
select file_id, file_name
from dba_data_files
where rownum <= 20
order by file_id;SQL> SQL> SQL> 2 3 4
FILE_ID FILE_NAME
---------- ------------------------------------------------------------------------------------------------------------------------
1 /u01/app/oracle/oradata/WMPROD/system01.dbf
2 /u01/app/oracle/oradata/WMPROD/sysaux01.dbf
3 /u01/app/oracle/oradata/WMPROD/undotbs01.dbf
4 /u01/app/oracle/oradata/WMPROD/users01.dbf
5 /u01/app/oracle/oradata/WMPROD/APPT_TXN_DT_TBS.dbf
6 /u01/app/oracle/oradata/WMPROD/APPT_TXN_IDX_TBS.dbf
7 /u01/app/oracle/oradata/WMPROD/CBO_TXN_DT_TBS01.dbf
8 /u01/app/oracle/oradata/WMPROD/CBO_TXN_IDX_TBS01.dbf
9 /u01/app/oracle/oradata/WMPROD/CM_BST4K_DT_TBS01.dbf
10 /u01/app/oracle/oradata/WMPROD/CM_BST4K_IDX_TBS01.dbf
11 /u01/app/oracle/oradata/WMPROD/LEMA_LGTXN_DT_TBS01.dbf
12 /u01/app/oracle/oradata/WMPROD/LEMA_STAT_DT_TBS01.dbf
27 /u01/app/oracle/oradata/WMPROD/LEMA_STAT_DT_TBS02.dbf
28 /u01/app/oracle/oradata/WMPROD/LEMA_STAT_DT_TBS03.dbf
29 /u01/app/oracle/oradata/WMPROD/LEMA_STAT_DT_TBS04.dbf
30 /u01/app/oracle/oradata/WMPROD/LEMA_LGTXN_DT_TBS02.dbf
31 /u01/app/oracle/oradata/WMPROD/LEMA_LGTXN_DT_TBS03.dbf
39 /u01/app/oracle/oradata/WMPROD/LEMA_LGTXN_DT_TBS04.dbf
42 /u01/app/oracle/oradata/WMPROD/LEMA_LGTXN_DT_TBS05.dbf
43 /u01/app/oracle/oradata/WMPROD/LEMA_LGTXN_DT_TBS06.dbf
20 rows selected.
SQL> set lines 300 pages 100
col member for a120
select group#, member
from v$logfile
order by group#;SQL> SQL> SQL> 2 3
GROUP# MEMBER
---------- ------------------------------------------------------------------------------------------------------------------------
1 /u01/app/oracle/oradata/WMPROD/redo01.log
2 /u01/app/oracle/oradata/WMPROD/redo02.log
3 /u01/app/oracle/oradata/WMPROD/redo03.log
4 /u01/app/oracle/oradata/WMPROD/redo4.log
5 /u01/app/oracle/oradata/WMPROD/redo5.log
6 /u01/app/oracle/oradata/WMPROD/redo6.log
7 /u01/app/oracle/oradata/WMPROD/standby7.log
8 /u01/app/oracle/oradata/WMPROD/standby8.log
9 /u01/app/oracle/oradata/WMPROD/standby9.log
10 /u01/app/oracle/oradata/WMPROD/standby10.log
11 /u01/app/oracle/oradata/WMPROD/standby11.log
12 /u01/app/oracle/oradata/WMPROD/standby12.log
12 rows selected.
SQL>
因此辅助库规划为：
| 辅助库 | 名称 |
|---|---|
| SID | WMSAUX |
| 数据文件目录 | /u01/app/oracle/oradata/WMSAUX |
| FRA 目录 | /u01/app/oracle/fast_recovery_area/WMSAUX |
| 审计目录 | /u01/app/oracle/admin/WMSAUX/adump |
四、查看 RMAN 备份情况
进入 RMAN：
export ORACLE_SID=wmprod
rman target /
查看备份摘要：
[oracle@wmsdb2019 backup]$ rman target /
Recovery Manager: Release 18.0.0.0.0 - Production on Fri May 22 15:09:25 2026
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
connected to target database: WMPROD (DBID=3080983586)
RMAN> LIST BACKUP SUMMARY;
using target database control file instead of recovery catalog
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- ------------------- ------- ------- ---------- ---
46003 B 0 A SBT_TAPE 2026-05-07 06:33:35 1 1 NO HOT_DB_BK_LEVEL0
46004 B 0 A SBT_TAPE 2026-05-07 06:33:42 1 1 NO HOT_DB_BK_LEVEL0
46005 B 0 A SBT_TAPE 2026-05-07 06:33:44 1 1 NO HOT_DB_BK_LEVEL0
46006 B 0 A SBT_TAPE 2026-05-07 06:33:51 1 1 NO HOT_DB_BK_LEVEL0
46007 B F A SBT_TAPE 2026-05-07 06:34:01 1 1 NO TAG20260507T063353
46008 B A A SBT_TAPE 2026-05-07 06:35:05 1 1 NO TAG20260507T063410
46009 B A A SBT_TAPE 2026-05-07 06:35:16 1 1 NO TAG20260507T063410
46010 B A A SBT_TAPE 2026-05-07 06:36:19 1 1 NO TAG20260507T063410
46011 B A A SBT_TAPE 2026-05-07 06:36:28 1 1 NO TAG20260507T063410
46012 B A A SBT_TAPE 2026-05-07 06:37:23 1 1 NO TAG20260507T063410
46013 B A A SBT_TAPE 2026-05-07 06:37:36 1 1 NO TAG20260507T063410
46014 B F A SBT_TAPE 2026-05-07 06:37:50 1 1 NO TAG20260507T063743
46015 B F A SBT_TAPE 2026-05-07 06:38:07 1 1 NO TAG20260507T063759
46016 B F A SBT_TAPE 2026-05-07 06:38:23 1 1 NO TAG20260507T063816
46017 B 0 A SBT_TAPE 2026-05-08 02:17:59 1 1 NO HOT_DB_BK_LEVEL0
46018 B 0 A SBT_TAPE 2026-05-08 02:18:27 1 1 NO HOT_DB_BK_LEVEL0
46019 B 0 A SBT_TAPE 2026-05-08 02:45:36 1 1 NO HOT_DB_BK_LEVEL0
46020 B 0 A SBT_TAPE 2026-05-08 02:45:54 1 1 NO HOT_DB_BK_LEVEL0
46021 B 0 A SBT_TAPE 2026-05-08 03:25:48 1 1 NO HOT_DB_BK_LEVEL0
46022 B 0 A SBT_TAPE 2026-05-08 03:26:07 1 1 NO HOT_DB_BK_LEVEL0
46023 B 0 A SBT_TAPE 2026-05-08 04:03:28 1 1 NO HOT_DB_BK_LEVEL0
46024 B 0 A SBT_TAPE 2026-05-08 04:08:44 1 1 NO HOT_DB_BK_LEVEL0
46025 B 0 A SBT_TAPE 2026-05-08 04:53:05 1 1 NO HOT_DB_BK_LEVEL0
46026 B 0 A SBT_TAPE 2026-05-08 04:56:32 1 1 NO HOT_DB_BK_LEVEL0
46027 B 0 A SBT_TAPE 2026-05-08 05:13:31 1 1 NO HOT_DB_BK_LEVEL0
46028 B 0 A SBT_TAPE 2026-05-08 05:16:23 1 1 NO HOT_DB_BK_LEVEL0
46029 B 0 A SBT_TAPE 2026-05-08 05:32:07 1 1 NO HOT_DB_BK_LEVEL0
46030 B 0 A SBT_TAPE 2026-05-08 05:34:00 1 1 NO HOT_DB_BK_LEVEL0
46031 B 0 A SBT_TAPE 2026-05-08 05:38:00 1 1 NO HOT_DB_BK_LEVEL0
46032 B 0 A SBT_TAPE 2026-05-08 05:51:21 1 1 NO HOT_DB_BK_LEVEL0
46033 B 0 A SBT_TAPE 2026-05-08 05:54:10 1 1 NO HOT_DB_BK_LEVEL0
46034 B 0 A SBT_TAPE 2026-05-08 05:54:50 1 1 NO HOT_DB_BK_LEVEL0
46035 B 0 A SBT_TAPE 2026-05-08 05:57:04 1 1 NO HOT_DB_BK_LEVEL0
46036 B 0 A SBT_TAPE 2026-05-08 06:10:11 1 1 NO HOT_DB_BK_LEVEL0
46037 B 0 A SBT_TAPE 2026-05-08 06:10:18 1 1 NO HOT_DB_BK_LEVEL0
46038 B 0 A SBT_TAPE 2026-05-08 06:16:17 1 1 NO HOT_DB_BK_LEVEL0
46039 B 0 A SBT_TAPE 2026-05-08 06:21:53 1 1 NO HOT_DB_BK_LEVEL0
46040 B 0 A SBT_TAPE 2026-05-08 06:23:08 1 1 NO HOT_DB_BK_LEVEL0
46041 B 0 A SBT_TAPE 2026-05-08 06:24:15 1 1 NO HOT_DB_BK_LEVEL0
46042 B 0 A SBT_TAPE 2026-05-08 06:25:31 1 1 NO HOT_DB_BK_LEVEL0
46043 B 0 A SBT_TAPE 2026-05-08 06:26:22 1 1 NO HOT_DB_BK_LEVEL0
46044 B 0 A SBT_TAPE 2026-05-08 06:30:01 1 1 NO HOT_DB_BK_LEVEL0
46045 B 0 A SBT_TAPE 2026-05-08 06:30:13 1 1 NO HOT_DB_BK_LEVEL0
46046 B 0 A SBT_TAPE 2026-05-08 06:32:04 1 1 NO HOT_DB_BK_LEVEL0
46047 B 0 A SBT_TAPE 2026-05-08 06:32:38 1 1 NO HOT_DB_BK_LEVEL0
46048 B 0 A SBT_TAPE 2026-05-08 06:33:51 1 1 NO HOT_DB_BK_LEVEL0
46049 B 0 A SBT_TAPE 2026-05-08 06:34:03 1 1 NO HOT_DB_BK_LEVEL0
46050 B 0 A SBT_TAPE 2026-05-08 06:34:50 1 1 NO HOT_DB_BK_LEVEL0
46051 B 0 A SBT_TAPE 2026-05-08 06:34:59 1 1 NO HOT_DB_BK_LEVEL0
46052 B 0 A SBT_TAPE 2026-05-08 06:35:29 1 1 NO HOT_DB_BK_LEVEL0
46053 B 0 A SBT_TAPE 2026-05-08 06:35:34 1 1 NO HOT_DB_BK_LEVEL0
46054 B 0 A SBT_TAPE 2026-05-08 06:35:44 1 1 NO HOT_DB_BK_LEVEL0
46055 B 0 A SBT_TAPE 2026-05-08 06:35:45 1 1 NO HOT_DB_BK_LEVEL0
46056 B 0 A SBT_TAPE 2026-05-08 06:35:51 1 1 NO HOT_DB_BK_LEVEL0
46057 B 0 A SBT_TAPE 2026-05-08 06:35:52 1 1 NO HOT_DB_BK_LEVEL0
46058 B 0 A SBT_TAPE 2026-05-08 06:36:00 1 1 NO HOT_DB_BK_LEVEL0
46059 B 0 A SBT_TAPE 2026-05-08 06:36:03 1 1 NO HOT_DB_BK_LEVEL0
46060 B 0 A SBT_TAPE 2026-05-08 06:36:09 1 1 NO HOT_DB_BK_LEVEL0
46061 B 0 A SBT_TAPE 2026-05-08 06:36:11 1 1 NO HOT_DB_BK_LEVEL0
46062 B F A SBT_TAPE 2026-05-08 06:36:27 1 1 NO TAG20260508T063620
46063 B A A SBT_TAPE 2026-05-08 06:37:44 1 1 NO TAG20260508T063637
46064 B A A SBT_TAPE 2026-05-08 06:37:49 1 1 NO TAG20260508T063637
46065 B A A SBT_TAPE 2026-05-08 06:39:07 1 1 NO TAG20260508T063637
46066 B A A SBT_TAPE 2026-05-08 06:39:10 1 1 NO TAG20260508T063637
46067 B A A SBT_TAPE 2026-05-08 06:40:22 1 1 NO TAG20260508T063637
46068 B F A SBT_TAPE 2026-05-08 06:40:32 1 1 NO TAG20260508T064026
46069 B F A SBT_TAPE 2026-05-08 06:40:49 1 1 NO TAG20260508T064042
46070 B F A SBT_TAPE 2026-05-08 06:40:56 1 1 NO TAG20260508T064050
46071 B 0 A SBT_TAPE 2026-05-09 02:23:31 1 1 NO HOT_DB_BK_LEVEL0
46072 B 0 A SBT_TAPE 2026-05-09 02:23:47 1 1 NO HOT_DB_BK_LEVEL0
46073 B 0 A SBT_TAPE 2026-05-09 03:02:03 1 1 NO HOT_DB_BK_LEVEL0
46074 B 0 A SBT_TAPE 2026-05-09 03:02:08 1 1 NO HOT_DB_BK_LEVEL0
46075 B 0 A SBT_TAPE 2026-05-09 03:52:29 1 1 NO HOT_DB_BK_LEVEL0
46076 B 0 A SBT_TAPE 2026-05-09 03:56:33 1 1 NO HOT_DB_BK_LEVEL0
46077 B 0 A SBT_TAPE 2026-05-09 04:58:41 1 1 NO HOT_DB_BK_LEVEL0
46078 B 0 A SBT_TAPE 2026-05-09 05:03:30 1 1 NO HOT_DB_BK_LEVEL0
46079 B 0 A SBT_TAPE 2026-05-09 05:41:20 1 1 NO HOT_DB_BK_LEVEL0
46080 B 0 A SBT_TAPE 2026-05-09 05:41:48 1 1 NO HOT_DB_BK_LEVEL0
46081 B 0 A SBT_TAPE 2026-05-09 06:03:33 1 1 NO HOT_DB_BK_LEVEL0
46082 B 0 A SBT_TAPE 2026-05-09 06:03:50 1 1 NO HOT_DB_BK_LEVEL0
46083 B 0 A SBT_TAPE 2026-05-09 06:24:54 1 1 NO HOT_DB_BK_LEVEL0
46084 B 0 A SBT_TAPE 2026-05-09 06:25:01 1 1 NO HOT_DB_BK_LEVEL0
46085 B 0 A SBT_TAPE 2026-05-09 06:31:45 1 1 NO HOT_DB_BK_LEVEL0
46086 B 0 A SBT_TAPE 2026-05-09 06:44:38 1 1 NO HOT_DB_BK_LEVEL0
46087 B 0 A SBT_TAPE 2026-05-09 06:47:54 1 1 NO HOT_DB_BK_LEVEL0
46088 B 0 A SBT_TAPE 2026-05-09 06:50:40 1 1 NO HOT_DB_BK_LEVEL0
46089 B 0 A SBT_TAPE 2026-05-09 06:51:25 1 1 NO HOT_DB_BK_LEVEL0
46090 B 0 A SBT_TAPE 2026-05-09 07:07:08 1 1 NO HOT_DB_BK_LEVEL0
46091 B 0 A SBT_TAPE 2026-05-09 07:07:35 1 1 NO HOT_DB_BK_LEVEL0
46092 B 0 A SBT_TAPE 2026-05-09 07:14:12 1 1 NO HOT_DB_BK_LEVEL0
46093 B 0 A SBT_TAPE 2026-05-09 07:20:51 1 1 NO HOT_DB_BK_LEVEL0
46094 B 0 A SBT_TAPE 2026-05-09 07:21:47 1 1 NO HOT_DB_BK_LEVEL0
46095 B 0 A SBT_TAPE 2026-05-09 07:23:28 1 1 NO HOT_DB_BK_LEVEL0
46096 B 0 A SBT_TAPE 2026-05-09 07:24:56 1 1 NO HOT_DB_BK_LEVEL0
46097 B 0 A SBT_TAPE 2026-05-09 07:26:12 1 1 NO HOT_DB_BK_LEVEL0
46098 B 0 A SBT_TAPE 2026-05-09 07:30:33 1 1 NO HOT_DB_BK_LEVEL0
46099 B 0 A SBT_TAPE 2026-05-09 07:30:37 1 1 NO HOT_DB_BK_LEVEL0
46100 B 0 A SBT_TAPE 2026-05-09 07:32:58 1 1 NO HOT_DB_BK_LEVEL0
46101 B 0 A SBT_TAPE 2026-05-09 07:33:02 1 1 NO HOT_DB_BK_LEVEL0
46102 B 0 A SBT_TAPE 2026-05-09 07:34:12 1 1 NO HOT_DB_BK_LEVEL0
46103 B 0 A SBT_TAPE 2026-05-09 07:35:09 1 1 NO HOT_DB_BK_LEVEL0
46104 B 0 A SBT_TAPE 2026-05-09 07:35:10 1 1 NO HOT_DB_BK_LEVEL0
46105 B 0 A SBT_TAPE 2026-05-09 07:35:56 1 1 NO HOT_DB_BK_LEVEL0
46106 B 0 A SBT_TAPE 2026-05-09 07:36:11 1 1 NO HOT_DB_BK_LEVEL0
46107 B 0 A SBT_TAPE 2026-05-09 07:36:19 1 1 NO HOT_DB_BK_LEVEL0
46108 B 0 A SBT_TAPE 2026-05-09 07:36:22 1 1 NO HOT_DB_BK_LEVEL0
46109 B 0 A SBT_TAPE 2026-05-09 07:36:38 1 1 NO HOT_DB_BK_LEVEL0
46110 B 0 A SBT_TAPE 2026-05-09 07:36:38 1 1 NO HOT_DB_BK_LEVEL0
46111 B 0 A SBT_TAPE 2026-05-09 07:36:52 1 1 NO HOT_DB_BK_LEVEL0
46112 B 0 A SBT_TAPE 2026-05-09 07:36:53 1 1 NO HOT_DB_BK_LEVEL0
46113 B 0 A SBT_TAPE 2026-05-09 07:37:07 1 1 NO HOT_DB_BK_LEVEL0
46114 B 0 A SBT_TAPE 2026-05-09 07:37:08 1 1 NO HOT_DB_BK_LEVEL0
46115 B 0 A SBT_TAPE 2026-05-09 07:37:22 1 1 NO HOT_DB_BK_LEVEL0
46116 B F A SBT_TAPE 2026-05-09 07:37:38 1 1 NO TAG20260509T073731
46117 B A A SBT_TAPE 2026-05-09 07:39:00 1 1 NO TAG20260509T073748
46118 B A A SBT_TAPE 2026-05-09 07:39:04 1 1 NO TAG20260509T073748
46119 B A A SBT_TAPE 2026-05-09 07:40:25 1 1 NO TAG20260509T073748
46120 B A A SBT_TAPE 2026-05-09 07:40:29 1 1 NO TAG20260509T073748
46121 B A A SBT_TAPE 2026-05-09 07:41:31 1 1 NO TAG20260509T073748
46122 B F A SBT_TAPE 2026-05-09 07:41:44 1 1 NO TAG20260509T074137
46123 B F A SBT_TAPE 2026-05-09 07:42:01 1 1 NO TAG20260509T074153
46124 B F A SBT_TAPE 2026-05-09 07:42:16 1 1 NO TAG20260509T074209
46125 B 0 A SBT_TAPE 2026-05-10 02:16:01 1 1 NO HOT_DB_BK_LEVEL0
46126 B 0 A SBT_TAPE 2026-05-10 02:16:33 1 1 NO HOT_DB_BK_LEVEL0
46127 B 0 A SBT_TAPE 2026-05-10 02:43:03 1 1 NO HOT_DB_BK_LEVEL0
46128 B 0 A SBT_TAPE 2026-05-10 02:43:36 1 1 NO HOT_DB_BK_LEVEL0
46129 B 0 A SBT_TAPE 2026-05-10 03:16:00 1 1 NO HOT_DB_BK_LEVEL0
46130 B 0 A SBT_TAPE 2026-05-10 03:16:22 1 1 NO HOT_DB_BK_LEVEL0
46131 B 0 A SBT_TAPE 2026-05-10 03:49:31 1 1 NO HOT_DB_BK_LEVEL0
46132 B 0 A SBT_TAPE 2026-05-10 03:50:11 1 1 NO HOT_DB_BK_LEVEL0
46133 B 0 A SBT_TAPE 2026-05-10 04:33:42 1 1 NO HOT_DB_BK_LEVEL0
46134 B 0 A SBT_TAPE 2026-05-10 04:36:09 1 1 NO HOT_DB_BK_LEVEL0
46135 B 0 A SBT_TAPE 2026-05-10 05:08:38 1 1 NO HOT_DB_BK_LEVEL0
46136 B 0 A SBT_TAPE 2026-05-10 05:12:34 1 1 NO HOT_DB_BK_LEVEL0
46137 B 0 A SBT_TAPE 2026-05-10 05:31:13 1 1 NO HOT_DB_BK_LEVEL0
46138 B 0 A SBT_TAPE 2026-05-10 05:33:27 1 1 NO HOT_DB_BK_LEVEL0
46139 B 0 A SBT_TAPE 2026-05-10 05:36:48 1 1 NO HOT_DB_BK_LEVEL0
46140 B 0 A SBT_TAPE 2026-05-10 05:50:17 1 1 NO HOT_DB_BK_LEVEL0
46141 B 0 A SBT_TAPE 2026-05-10 05:53:34 1 1 NO HOT_DB_BK_LEVEL0
46142 B 0 A SBT_TAPE 2026-05-10 05:53:40 1 1 NO HOT_DB_BK_LEVEL0
46143 B 0 A SBT_TAPE 2026-05-10 05:57:13 1 1 NO HOT_DB_BK_LEVEL0
46144 B 0 A SBT_TAPE 2026-05-10 06:08:08 1 1 NO HOT_DB_BK_LEVEL0
46145 B 0 A SBT_TAPE 2026-05-10 06:11:11 1 1 NO HOT_DB_BK_LEVEL0
46146 B 0 A SBT_TAPE 2026-05-10 06:17:17 1 1 NO HOT_DB_BK_LEVEL0
46147 B 0 A SBT_TAPE 2026-05-10 06:21:22 1 1 NO HOT_DB_BK_LEVEL0
46148 B 0 A SBT_TAPE 2026-05-10 06:22:58 1 1 NO HOT_DB_BK_LEVEL0
46149 B 0 A SBT_TAPE 2026-05-10 06:24:26 1 1 NO HOT_DB_BK_LEVEL0
46150 B 0 A SBT_TAPE 2026-05-10 06:25:45 1 1 NO HOT_DB_BK_LEVEL0
46151 B 0 A SBT_TAPE 2026-05-10 06:26:37 1 1 NO HOT_DB_BK_LEVEL0
46152 B 0 A SBT_TAPE 2026-05-10 06:30:36 1 1 NO HOT_DB_BK_LEVEL0
46153 B 0 A SBT_TAPE 2026-05-10 06:31:04 1 1 NO HOT_DB_BK_LEVEL0
46154 B 0 A SBT_TAPE 2026-05-10 06:33:02 1 1 NO HOT_DB_BK_LEVEL0
46155 B 0 A SBT_TAPE 2026-05-10 06:33:14 1 1 NO HOT_DB_BK_LEVEL0
46156 B 0 A SBT_TAPE 2026-05-10 06:34:28 1 1 NO HOT_DB_BK_LEVEL0
46157 B 0 A SBT_TAPE 2026-05-10 06:35:06 1 1 NO HOT_DB_BK_LEVEL0
46158 B 0 A SBT_TAPE 2026-05-10 06:35:30 1 1 NO HOT_DB_BK_LEVEL0
46159 B 0 A SBT_TAPE 2026-05-10 06:35:53 1 1 NO HOT_DB_BK_LEVEL0
46160 B 0 A SBT_TAPE 2026-05-10 06:36:05 1 1 NO HOT_DB_BK_LEVEL0
46161 B 0 A SBT_TAPE 2026-05-10 06:36:16 1 1 NO HOT_DB_BK_LEVEL0
46162 B 0 A SBT_TAPE 2026-05-10 06:36:30 1 1 NO HOT_DB_BK_LEVEL0
46163 B 0 A SBT_TAPE 2026-05-10 06:36:31 1 1 NO HOT_DB_BK_LEVEL0
46164 B 0 A SBT_TAPE 2026-05-10 06:36:38 1 1 NO HOT_DB_BK_LEVEL0
46165 B 0 A SBT_TAPE 2026-05-10 06:36:42 1 1 NO HOT_DB_BK_LEVEL0
46166 B 0 A SBT_TAPE 2026-05-10 06:36:49 1 1 NO HOT_DB_BK_LEVEL0
46167 B 0 A SBT_TAPE 2026-05-10 06:36:52 1 1 NO HOT_DB_BK_LEVEL0
46168 B 0 A SBT_TAPE 2026-05-10 06:36:59 1 1 NO HOT_DB_BK_LEVEL0
46169 B 0 A SBT_TAPE 2026-05-10 06:37:02 1 1 NO HOT_DB_BK_LEVEL0
46170 B F A SBT_TAPE 2026-05-10 06:37:17 1 1 NO TAG20260510T063711
46171 B A A SBT_TAPE 2026-05-10 06:38:22 1 1 NO TAG20260510T063728
46172 B A A SBT_TAPE 2026-05-10 06:38:24 1 1 NO TAG20260510T063728
46173 B A A SBT_TAPE 2026-05-10 06:39:33 1 1 NO TAG20260510T063728
46174 B A A SBT_TAPE 2026-05-10 06:39:41 1 1 NO TAG20260510T063728
46175 B A A SBT_TAPE 2026-05-10 06:40:45 1 1 NO TAG20260510T063728
46176 B A A SBT_TAPE 2026-05-10 06:40:45 1 1 NO TAG20260510T063728
46177 B F A SBT_TAPE 2026-05-10 06:41:00 1 1 NO TAG20260510T064054
46178 B F A SBT_TAPE 2026-05-10 06:41:10 1 1 NO TAG20260510T064102
46179 B F A SBT_TAPE 2026-05-10 06:41:24 1 1 NO TAG20260510T064118
46180 B 0 A SBT_TAPE 2026-05-11 02:17:02 1 1 NO HOT_DB_BK_LEVEL0
46181 B 0 A SBT_TAPE 2026-05-11 02:17:38 1 1 NO HOT_DB_BK_LEVEL0
46182 B 0 A SBT_TAPE 2026-05-11 02:43:36 1 1 NO HOT_DB_BK_LEVEL0
46183 B 0 A SBT_TAPE 2026-05-11 02:44:31 1 1 NO HOT_DB_BK_LEVEL0
46184 B 0 A SBT_TAPE 2026-05-11 03:19:46 1 1 NO HOT_DB_BK_LEVEL0
46185 B 0 A SBT_TAPE 2026-05-11 03:21:15 1 1 NO HOT_DB_BK_LEVEL0
46186 B 0 A SBT_TAPE 2026-05-11 03:57:15 1 1 NO HOT_DB_BK_LEVEL0
46187 B 0 A SBT_TAPE 2026-05-11 03:58:57 1 1 NO HOT_DB_BK_LEVEL0
46188 B 0 A SBT_TAPE 2026-05-11 04:46:47 1 1 NO HOT_DB_BK_LEVEL0
46189 B 0 A SBT_TAPE 2026-05-11 04:48:09 1 1 NO HOT_DB_BK_LEVEL0
46190 B 0 A SBT_TAPE 2026-05-11 05:13:26 1 1 NO HOT_DB_BK_LEVEL0
46191 B 0 A SBT_TAPE 2026-05-11 05:14:56 1 1 NO HOT_DB_BK_LEVEL0
46192 B 0 A SBT_TAPE 2026-05-11 05:32:11 1 1 NO HOT_DB_BK_LEVEL0
46193 B 0 A SBT_TAPE 2026-05-11 05:33:56 1 1 NO HOT_DB_BK_LEVEL0
46194 B 0 A SBT_TAPE 2026-05-11 05:38:10 1 1 NO HOT_DB_BK_LEVEL0
46195 B 0 A SBT_TAPE 2026-05-11 05:51:28 1 1 NO HOT_DB_BK_LEVEL0
46196 B 0 A SBT_TAPE 2026-05-11 05:54:57 1 1 NO HOT_DB_BK_LEVEL0
46197 B 0 A SBT_TAPE 2026-05-11 05:55:13 1 1 NO HOT_DB_BK_LEVEL0
46198 B 0 A SBT_TAPE 2026-05-11 05:58:48 1 1 NO HOT_DB_BK_LEVEL0
46199 B 0 A SBT_TAPE 2026-05-11 06:10:28 1 1 NO HOT_DB_BK_LEVEL0
46200 B 0 A SBT_TAPE 2026-05-11 06:12:29 1 1 NO HOT_DB_BK_LEVEL0
46201 B 0 A SBT_TAPE 2026-05-11 06:17:48 1 1 NO HOT_DB_BK_LEVEL0
46202 B 0 A SBT_TAPE 2026-05-11 06:23:21 1 1 NO HOT_DB_BK_LEVEL0
46203 B 0 A SBT_TAPE 2026-05-11 06:23:48 1 1 NO HOT_DB_BK_LEVEL0
46204 B 0 A SBT_TAPE 2026-05-11 06:25:02 1 1 NO HOT_DB_BK_LEVEL0
46205 B 0 A SBT_TAPE 2026-05-11 06:26:31 1 1 NO HOT_DB_BK_LEVEL0
46206 B 0 A SBT_TAPE 2026-05-11 06:28:12 1 1 NO HOT_DB_BK_LEVEL0
46207 B 0 A SBT_TAPE 2026-05-11 06:31:32 1 1 NO HOT_DB_BK_LEVEL0
46208 B 0 A SBT_TAPE 2026-05-11 06:32:01 1 1 NO HOT_DB_BK_LEVEL0
46209 B 0 A SBT_TAPE 2026-05-11 06:33:58 1 1 NO HOT_DB_BK_LEVEL0
46210 B 0 A SBT_TAPE 2026-05-11 06:34:21 1 1 NO HOT_DB_BK_LEVEL0
46211 B 0 A SBT_TAPE 2026-05-11 06:35:34 1 1 NO HOT_DB_BK_LEVEL0
46212 B 0 A SBT_TAPE 2026-05-11 06:35:41 1 1 NO HOT_DB_BK_LEVEL0
46213 B 0 A SBT_TAPE 2026-05-11 06:36:27 1 1 NO HOT_DB_BK_LEVEL0
46214 B 0 A SBT_TAPE 2026-05-11 06:36:28 1 1 NO HOT_DB_BK_LEVEL0
46215 B 0 A SBT_TAPE 2026-05-11 06:37:01 1 1 NO HOT_DB_BK_LEVEL0
46216 B 0 A SBT_TAPE 2026-05-11 06:37:06 1 1 NO HOT_DB_BK_LEVEL0
46217 B 0 A SBT_TAPE 2026-05-11 06:37:12 1 1 NO HOT_DB_BK_LEVEL0
46218 B 0 A SBT_TAPE 2026-05-11 06:37:19 1 1 NO HOT_DB_BK_LEVEL0
46219 B 0 A SBT_TAPE 2026-05-11 06:37:22 1 1 NO HOT_DB_BK_LEVEL0
46220 B 0 A SBT_TAPE 2026-05-11 06:37:31 1 1 NO HOT_DB_BK_LEVEL0
46221 B 0 A SBT_TAPE 2026-05-11 06:37:33 1 1 NO HOT_DB_BK_LEVEL0
46222 B 0 A SBT_TAPE 2026-05-11 06:37:48 1 1 NO HOT_DB_BK_LEVEL0
46223 B 0 A SBT_TAPE 2026-05-11 06:37:48 1 1 NO HOT_DB_BK_LEVEL0
46224 B 0 A SBT_TAPE 2026-05-11 06:38:02 1 1 NO HOT_DB_BK_LEVEL0
46225 B F A SBT_TAPE 2026-05-11 06:38:11 1 1 NO TAG20260511T063804
46226 B A A SBT_TAPE 2026-05-11 06:39:21 1 1 NO TAG20260511T063821
46227 B A A SBT_TAPE 2026-05-11 06:39:28 1 1 NO TAG20260511T063821
46228 B A A SBT_TAPE 2026-05-11 06:40:31 1 1 NO TAG20260511T063821
46229 B F A SBT_TAPE 2026-05-11 06:40:49 1 1 NO TAG20260511T064043
46230 B F A SBT_TAPE 2026-05-11 06:41:07 1 1 NO TAG20260511T064059
46231 B F A SBT_TAPE 2026-05-11 06:41:23 1 1 NO TAG20260511T064115
46232 B 0 A SBT_TAPE 2026-05-12 02:17:25 1 1 NO HOT_DB_BK_LEVEL0
46233 B 0 A SBT_TAPE 2026-05-12 02:18:49 1 1 NO HOT_DB_BK_LEVEL0
46234 B 0 A SBT_TAPE 2026-05-12 02:45:28 1 1 NO HOT_DB_BK_LEVEL0
46235 B 0 A SBT_TAPE 2026-05-12 02:46:43 1 1 NO HOT_DB_BK_LEVEL0
46236 B 0 A SBT_TAPE 2026-05-12 03:22:01 1 1 NO HOT_DB_BK_LEVEL0
46237 B 0 A SBT_TAPE 2026-05-12 03:30:48 1 1 NO HOT_DB_BK_LEVEL0
46238 B 0 A SBT_TAPE 2026-05-12 04:06:18 1 1 NO HOT_DB_BK_LEVEL0
46239 B 0 A SBT_TAPE 2026-05-12 04:10:42 1 1 NO HOT_DB_BK_LEVEL0
46240 B 0 A SBT_TAPE 2026-05-12 04:53:28 1 1 NO HOT_DB_BK_LEVEL0
46241 B 0 A SBT_TAPE 2026-05-12 04:53:30 1 1 NO HOT_DB_BK_LEVEL0
46242 B 0 A SBT_TAPE 2026-05-12 05:15:01 1 1 NO HOT_DB_BK_LEVEL0
46243 B 0 A SBT_TAPE 2026-05-12 05:14:59 1 1 NO HOT_DB_BK_LEVEL0
46244 B 0 A SBT_TAPE 2026-05-12 05:33:24 1 1 NO HOT_DB_BK_LEVEL0
46245 B 0 A SBT_TAPE 2026-05-12 05:33:34 1 1 NO HOT_DB_BK_LEVEL0
46246 B 0 A SBT_TAPE 2026-05-12 05:40:11 1 1 NO HOT_DB_BK_LEVEL0
46247 B 0 A SBT_TAPE 2026-05-12 05:49:58 1 1 NO HOT_DB_BK_LEVEL0
46248 B 0 A SBT_TAPE 2026-05-12 05:53:30 1 1 NO HOT_DB_BK_LEVEL0
46249 B 0 A SBT_TAPE 2026-05-12 05:57:38 1 1 NO HOT_DB_BK_LEVEL0
46250 B 0 A SBT_TAPE 2026-05-12 05:58:17 1 1 NO HOT_DB_BK_LEVEL0
46251 B 0 A SBT_TAPE 2026-05-12 06:12:24 1 1 NO HOT_DB_BK_LEVEL0
46252 B 0 A SBT_TAPE 2026-05-12 06:12:49 1 1 NO HOT_DB_BK_LEVEL0
46253 B 0 A SBT_TAPE 2026-05-12 06:19:05 1 1 NO HOT_DB_BK_LEVEL0
46254 B 0 A SBT_TAPE 2026-05-12 06:24:16 1 1 NO HOT_DB_BK_LEVEL0
46255 B 0 A SBT_TAPE 2026-05-12 06:24:49 1 1 NO HOT_DB_BK_LEVEL0
46256 B 0 A SBT_TAPE 2026-05-12 06:26:40 1 1 NO HOT_DB_BK_LEVEL0
46257 B 0 A SBT_TAPE 2026-05-12 06:27:54 1 1 NO HOT_DB_BK_LEVEL0
46258 B 0 A SBT_TAPE 2026-05-12 06:29:07 1 1 NO HOT_DB_BK_LEVEL0
46259 B 0 A SBT_TAPE 2026-05-12 06:33:04 1 1 NO HOT_DB_BK_LEVEL0
46260 B 0 A SBT_TAPE 2026-05-12 06:33:09 1 1 NO HOT_DB_BK_LEVEL0
46261 B 0 A SBT_TAPE 2026-05-12 06:35:13 1 1 NO HOT_DB_BK_LEVEL0
46262 B 0 A SBT_TAPE 2026-05-12 06:35:47 1 1 NO HOT_DB_BK_LEVEL0
46263 B 0 A SBT_TAPE 2026-05-12 06:36:55 1 1 NO HOT_DB_BK_LEVEL0
46264 B 0 A SBT_TAPE 2026-05-12 06:37:22 1 1 NO HOT_DB_BK_LEVEL0
46265 B 0 A SBT_TAPE 2026-05-12 06:37:48 1 1 NO HOT_DB_BK_LEVEL0
46266 B 0 A SBT_TAPE 2026-05-12 06:38:13 1 1 NO HOT_DB_BK_LEVEL0
46267 B 0 A SBT_TAPE 2026-05-12 06:38:44 1 1 NO HOT_DB_BK_LEVEL0
46268 B 0 A SBT_TAPE 2026-05-12 06:38:44 1 1 NO HOT_DB_BK_LEVEL0
46269 B 0 A SBT_TAPE 2026-05-12 06:38:53 1 1 NO HOT_DB_BK_LEVEL0
46270 B 0 A SBT_TAPE 2026-05-12 06:38:55 1 1 NO HOT_DB_BK_LEVEL0
46271 B 0 A SBT_TAPE 2026-05-12 06:39:10 1 1 NO HOT_DB_BK_LEVEL0
46272 B 0 A SBT_TAPE 2026-05-12 06:39:11 1 1 NO HOT_DB_BK_LEVEL0
46273 B 0 A SBT_TAPE 2026-05-12 06:39:26 1 1 NO HOT_DB_BK_LEVEL0
46274 B 0 A SBT_TAPE 2026-05-12 06:39:25 1 1 NO HOT_DB_BK_LEVEL0
46275 B 0 A SBT_TAPE 2026-05-12 06:39:40 1 1 NO HOT_DB_BK_LEVEL0
46276 B 0 A SBT_TAPE 2026-05-12 06:39:41 1 1 NO HOT_DB_BK_LEVEL0
46277 B F A SBT_TAPE 2026-05-12 06:39:57 1 1 NO TAG20260512T063950
46278 B A A SBT_TAPE 2026-05-12 06:40:59 1 1 NO TAG20260512T064007
46279 B A A SBT_TAPE 2026-05-12 06:41:01 1 1 NO TAG20260512T064007
46280 B A A SBT_TAPE 2026-05-12 06:41:57 1 1 NO TAG20260512T064007
46281 B A A SBT_TAPE 2026-05-12 06:41:57 1 1 NO TAG20260512T064007
46282 B A A SBT_TAPE 2026-05-12 06:42:55 1 1 NO TAG20260512T064007
46283 B A A SBT_TAPE 2026-05-12 06:43:02 1 1 NO TAG20260512T064007
46284 B F A SBT_TAPE 2026-05-12 06:43:20 1 1 NO TAG20260512T064309
46285 B F A SBT_TAPE 2026-05-12 06:43:32 1 1 NO TAG20260512T064325
46286 B F A SBT_TAPE 2026-05-12 06:43:48 1 1 NO TAG20260512T064342
46287 B 0 A SBT_TAPE 2026-05-13 02:16:33 1 1 NO HOT_DB_BK_LEVEL0
46288 B 0 A SBT_TAPE 2026-05-13 02:16:50 1 1 NO HOT_DB_BK_LEVEL0
46289 B 0 A SBT_TAPE 2026-05-13 02:43:42 1 1 NO HOT_DB_BK_LEVEL0
46290 B 0 A SBT_TAPE 2026-05-13 02:44:25 1 1 NO HOT_DB_BK_LEVEL0
46291 B 0 A SBT_TAPE 2026-05-13 03:20:22 1 1 NO HOT_DB_BK_LEVEL0
46292 B 0 A SBT_TAPE 2026-05-13 03:22:20 1 1 NO HOT_DB_BK_LEVEL0
46293 B 0 A SBT_TAPE 2026-05-13 04:00:12 1 1 NO HOT_DB_BK_LEVEL0
46294 B 0 A SBT_TAPE 2026-05-13 04:04:07 1 1 NO HOT_DB_BK_LEVEL0
46295 B 0 A SBT_TAPE 2026-05-13 04:45:21 1 1 NO HOT_DB_BK_LEVEL0
46296 B 0 A SBT_TAPE 2026-05-13 04:52:43 1 1 NO HOT_DB_BK_LEVEL0
46297 B 0 A SBT_TAPE 2026-05-13 05:10:23 1 1 NO HOT_DB_BK_LEVEL0
46298 B 0 A SBT_TAPE 2026-05-13 05:13:31 1 1 NO HOT_DB_BK_LEVEL0
46299 B 0 A SBT_TAPE 2026-05-13 05:29:48 1 1 NO HOT_DB_BK_LEVEL0
46300 B 0 A SBT_TAPE 2026-05-13 05:32:08 1 1 NO HOT_DB_BK_LEVEL0
46301 B 0 A SBT_TAPE 2026-05-13 05:35:39 1 1 NO HOT_DB_BK_LEVEL0
46302 B 0 A SBT_TAPE 2026-05-13 05:49:33 1 1 NO HOT_DB_BK_LEVEL0
46303 B 0 A SBT_TAPE 2026-05-13 05:52:40 1 1 NO HOT_DB_BK_LEVEL0
46304 B 0 A SBT_TAPE 2026-05-13 05:53:27 1 1 NO HOT_DB_BK_LEVEL0
46305 B 0 A SBT_TAPE 2026-05-13 05:57:00 1 1 NO HOT_DB_BK_LEVEL0
46306 B 0 A SBT_TAPE 2026-05-13 06:08:18 1 1 NO HOT_DB_BK_LEVEL0
46307 B 0 A SBT_TAPE 2026-05-13 06:10:52 1 1 NO HOT_DB_BK_LEVEL0
46308 B 0 A SBT_TAPE 2026-05-13 06:17:10 1 1 NO HOT_DB_BK_LEVEL0
46309 B 0 A SBT_TAPE 2026-05-13 06:21:08 1 1 NO HOT_DB_BK_LEVEL0
46310 B 0 A SBT_TAPE 2026-05-13 06:22:59 1 1 NO HOT_DB_BK_LEVEL0
46311 B 0 A SBT_TAPE 2026-05-13 06:24:34 1 1 NO HOT_DB_BK_LEVEL0
46312 B 0 A SBT_TAPE 2026-05-13 06:26:19 1 1 NO HOT_DB_BK_LEVEL0
46313 B 0 A SBT_TAPE 2026-05-13 06:26:24 1 1 NO HOT_DB_BK_LEVEL0
46314 B 0 A SBT_TAPE 2026-05-13 06:29:57 1 1 NO HOT_DB_BK_LEVEL0
46315 B 0 A SBT_TAPE 2026-05-13 06:31:06 1 1 NO HOT_DB_BK_LEVEL0
46316 B 0 A SBT_TAPE 2026-05-13 06:32:15 1 1 NO HOT_DB_BK_LEVEL0
46317 B 0 A SBT_TAPE 2026-05-13 06:33:14 1 1 NO HOT_DB_BK_LEVEL0
46318 B 0 A SBT_TAPE 2026-05-13 06:34:19 1 1 NO HOT_DB_BK_LEVEL0
46319 B 0 A SBT_TAPE 2026-05-13 06:34:22 1 1 NO HOT_DB_BK_LEVEL0
46320 B 0 A SBT_TAPE 2026-05-13 06:35:12 1 1 NO HOT_DB_BK_LEVEL0
46321 B 0 A SBT_TAPE 2026-05-13 06:35:15 1 1 NO HOT_DB_BK_LEVEL0
46322 B 0 A SBT_TAPE 2026-05-13 06:35:48 1 1 NO HOT_DB_BK_LEVEL0
46323 B 0 A SBT_TAPE 2026-05-13 06:35:58 1 1 NO HOT_DB_BK_LEVEL0
46324 B 0 A SBT_TAPE 2026-05-13 06:36:03 1 1 NO HOT_DB_BK_LEVEL0
46325 B 0 A SBT_TAPE 2026-05-13 06:36:10 1 1 NO HOT_DB_BK_LEVEL0
46326 B 0 A SBT_TAPE 2026-05-13 06:36:14 1 1 NO HOT_DB_BK_LEVEL0
46327 B 0 A SBT_TAPE 2026-05-13 06:36:21 1 1 NO HOT_DB_BK_LEVEL0
46328 B 0 A SBT_TAPE 2026-05-13 06:36:24 1 1 NO HOT_DB_BK_LEVEL0
46329 B 0 A SBT_TAPE 2026-05-13 06:36:37 1 1 NO HOT_DB_BK_LEVEL0
46330 B 0 A SBT_TAPE 2026-05-13 06:36:37 1 1 NO HOT_DB_BK_LEVEL0
46331 B 0 A SBT_TAPE 2026-05-13 06:36:44 1 1 NO HOT_DB_BK_LEVEL0
46332 B F A SBT_TAPE 2026-05-13 06:36:56 1 1 NO TAG20260513T063646
46333 B A A SBT_TAPE 2026-05-13 06:38:07 1 1 NO TAG20260513T063703
46334 B A A SBT_TAPE 2026-05-13 06:38:18 1 1 NO TAG20260513T063703
46335 B A A SBT_TAPE 2026-05-13 06:39:29 1 1 NO TAG20260513T063703
46336 B A A SBT_TAPE 2026-05-13 06:39:31 1 1 NO TAG20260513T063703
46337 B A A SBT_TAPE 2026-05-13 06:40:21 1 1 NO TAG20260513T063703
46338 B F A SBT_TAPE 2026-05-13 06:40:31 1 1 NO TAG20260513T064025
46339 B F A SBT_TAPE 2026-05-13 06:40:49 1 1 NO TAG20260513T064041
46340 B F A SBT_TAPE 2026-05-13 06:41:03 1 1 NO TAG20260513T064057
46341 B F A DISK 2026-05-13 15:31:46 1 1 NO TAG20260513T153146
46342 B F A DISK 2026-05-13 16:41:55 1 1 NO TAG20260513T164155
46343 B F A DISK 2026-05-13 22:12:41 1 1 NO TAG20260513T221241
46344 B F A DISK 2026-05-13 22:32:42 1 1 NO TAG20260513T223242
46345 B 0 A SBT_TAPE 2026-05-14 02:16:14 1 1 NO HOT_DB_BK_LEVEL0
46346 B 0 A SBT_TAPE 2026-05-14 02:17:01 1 1 NO HOT_DB_BK_LEVEL0
46347 B 0 A SBT_TAPE 2026-05-14 02:43:39 1 1 NO HOT_DB_BK_LEVEL0
46348 B 0 A SBT_TAPE 2026-05-14 02:43:49 1 1 NO HOT_DB_BK_LEVEL0
46349 B 0 A SBT_TAPE 2026-05-14 03:19:33 1 1 NO HOT_DB_BK_LEVEL0
46350 B 0 A SBT_TAPE 2026-05-14 03:20:12 1 1 NO HOT_DB_BK_LEVEL0
46351 B 0 A SBT_TAPE 2026-05-14 03:58:40 1 1 NO HOT_DB_BK_LEVEL0
46352 B 0 A SBT_TAPE 2026-05-14 03:58:47 1 1 NO HOT_DB_BK_LEVEL0
46353 B 0 A SBT_TAPE 2026-05-14 04:45:44 1 1 NO HOT_DB_BK_LEVEL0
46354 B 0 A SBT_TAPE 2026-05-14 04:48:28 1 1 NO HOT_DB_BK_LEVEL0
46355 B 0 A SBT_TAPE 2026-05-14 05:12:08 1 1 NO HOT_DB_BK_LEVEL0
46356 B 0 A SBT_TAPE 2026-05-14 05:12:40 1 1 NO HOT_DB_BK_LEVEL0
46357 B 0 A SBT_TAPE 2026-05-14 05:31:12 1 1 NO HOT_DB_BK_LEVEL0
46358 B 0 A SBT_TAPE 2026-05-14 05:31:53 1 1 NO HOT_DB_BK_LEVEL0
46359 B 0 A SBT_TAPE 2026-05-14 05:37:35 1 1 NO HOT_DB_BK_LEVEL0
46360 B 0 A SBT_TAPE 2026-05-14 05:49:12 1 1 NO HOT_DB_BK_LEVEL0
46361 B 0 A SBT_TAPE 2026-05-14 05:53:33 1 1 NO HOT_DB_BK_LEVEL0
46362 B 0 A SBT_TAPE 2026-05-14 05:55:17 1 1 NO HOT_DB_BK_LEVEL0
46363 B 0 A SBT_TAPE 2026-05-14 05:58:09 1 1 NO HOT_DB_BK_LEVEL0
46364 B 0 A SBT_TAPE 2026-05-14 06:10:12 1 1 NO HOT_DB_BK_LEVEL0
46365 B 0 A SBT_TAPE 2026-05-14 06:12:20 1 1 NO HOT_DB_BK_LEVEL0
46366 B 0 A SBT_TAPE 2026-05-14 06:18:31 1 1 NO HOT_DB_BK_LEVEL0
46367 B 0 A SBT_TAPE 2026-05-14 06:23:29 1 1 NO HOT_DB_BK_LEVEL0
46368 B 0 A SBT_TAPE 2026-05-14 06:24:18 1 1 NO HOT_DB_BK_LEVEL0
46369 B 0 A SBT_TAPE 2026-05-14 06:26:10 1 1 NO HOT_DB_BK_LEVEL0
46370 B 0 A SBT_TAPE 2026-05-14 06:27:27 1 1 NO HOT_DB_BK_LEVEL0
46371 B 0 A SBT_TAPE 2026-05-14 06:27:39 1 1 NO HOT_DB_BK_LEVEL0
46372 B 0 A SBT_TAPE 2026-05-14 06:31:23 1 1 NO HOT_DB_BK_LEVEL0
46373 B 0 A SBT_TAPE 2026-05-14 06:32:49 1 1 NO HOT_DB_BK_LEVEL0
46374 B 0 A SBT_TAPE 2026-05-14 06:33:45 1 1 NO HOT_DB_BK_LEVEL0
46375 B 0 A SBT_TAPE 2026-05-14 06:34:59 1 1 NO HOT_DB_BK_LEVEL0
46376 B 0 A SBT_TAPE 2026-05-14 06:36:00 1 1 NO HOT_DB_BK_LEVEL0
46377 B 0 A SBT_TAPE 2026-05-14 06:36:04 1 1 NO HOT_DB_BK_LEVEL0
46378 B 0 A SBT_TAPE 2026-05-14 06:36:42 1 1 NO HOT_DB_BK_LEVEL0
46379 B 0 A SBT_TAPE 2026-05-14 06:36:46 1 1 NO HOT_DB_BK_LEVEL0
46380 B 0 A SBT_TAPE 2026-05-14 06:37:16 1 1 NO HOT_DB_BK_LEVEL0
46381 B 0 A SBT_TAPE 2026-05-14 06:37:22 1 1 NO HOT_DB_BK_LEVEL0
46382 B 0 A SBT_TAPE 2026-05-14 06:37:25 1 1 NO HOT_DB_BK_LEVEL0
46383 B 0 A SBT_TAPE 2026-05-14 06:37:33 1 1 NO HOT_DB_BK_LEVEL0
46384 B 0 A SBT_TAPE 2026-05-14 06:37:35 1 1 NO HOT_DB_BK_LEVEL0
46385 B 0 A SBT_TAPE 2026-05-14 06:37:42 1 1 NO HOT_DB_BK_LEVEL0
46386 B 0 A SBT_TAPE 2026-05-14 06:37:45 1 1 NO HOT_DB_BK_LEVEL0
46387 B 0 A SBT_TAPE 2026-05-14 06:37:54 1 1 NO HOT_DB_BK_LEVEL0
46388 B 0 A SBT_TAPE 2026-05-14 06:37:55 1 1 NO HOT_DB_BK_LEVEL0
46389 B 0 A SBT_TAPE 2026-05-14 06:38:03 1 1 NO HOT_DB_BK_LEVEL0
46390 B F A SBT_TAPE 2026-05-14 06:38:23 1 1 NO TAG20260514T063812
46391 B A A SBT_TAPE 2026-05-14 06:39:33 1 1 NO TAG20260514T063829
46392 B A A SBT_TAPE 2026-05-14 06:39:36 1 1 NO TAG20260514T063829
46393 B A A SBT_TAPE 2026-05-14 06:40:49 1 1 NO TAG20260514T063829
46394 B A A SBT_TAPE 2026-05-14 06:40:54 1 1 NO TAG20260514T063829
46395 B A A SBT_TAPE 2026-05-14 06:41:48 1 1 NO TAG20260514T063829
46396 B A A SBT_TAPE 2026-05-14 06:41:53 1 1 NO TAG20260514T063829
46397 B F A SBT_TAPE 2026-05-14 06:42:04 1 1 NO TAG20260514T064158
46398 B F A SBT_TAPE 2026-05-14 06:42:23 1 1 NO TAG20260514T064215
46399 B F A SBT_TAPE 2026-05-14 06:42:38 1 1 NO TAG20260514T064231
46400 B 0 A SBT_TAPE 2026-05-15 02:16:29 1 1 NO HOT_DB_BK_LEVEL0
46401 B 0 A SBT_TAPE 2026-05-15 02:16:38 1 1 NO HOT_DB_BK_LEVEL0
46402 B 0 A SBT_TAPE 2026-05-15 02:44:06 1 1 NO HOT_DB_BK_LEVEL0
46403 B 0 A SBT_TAPE 2026-05-15 02:44:48 1 1 NO HOT_DB_BK_LEVEL0
46404 B 0 A SBT_TAPE 2026-05-15 03:22:24 1 1 NO HOT_DB_BK_LEVEL0
46405 B 0 A SBT_TAPE 2026-05-15 03:23:00 1 1 NO HOT_DB_BK_LEVEL0
46406 B 0 A SBT_TAPE 2026-05-15 03:59:58 1 1 NO HOT_DB_BK_LEVEL0
46407 B 0 A SBT_TAPE 2026-05-15 04:01:57 1 1 NO HOT_DB_BK_LEVEL0
46408 B 0 A SBT_TAPE 2026-05-15 04:47:30 1 1 NO HOT_DB_BK_LEVEL0
46409 B 0 A SBT_TAPE 2026-05-15 04:50:08 1 1 NO HOT_DB_BK_LEVEL0
46410 B 0 A SBT_TAPE 2026-05-15 05:13:54 1 1 NO HOT_DB_BK_LEVEL0
46411 B 0 A SBT_TAPE 2026-05-15 05:13:54 1 1 NO HOT_DB_BK_LEVEL0
46412 B 0 A SBT_TAPE 2026-05-15 05:32:19 1 1 NO HOT_DB_BK_LEVEL0
46413 B 0 A SBT_TAPE 2026-05-15 05:32:36 1 1 NO HOT_DB_BK_LEVEL0
46414 B 0 A SBT_TAPE 2026-05-15 05:38:32 1 1 NO HOT_DB_BK_LEVEL0
46415 B 0 A SBT_TAPE 2026-05-15 05:49:57 1 1 NO HOT_DB_BK_LEVEL0
46416 B 0 A SBT_TAPE 2026-05-15 05:53:55 1 1 NO HOT_DB_BK_LEVEL0
46417 B 0 A SBT_TAPE 2026-05-15 05:56:20 1 1 NO HOT_DB_BK_LEVEL0
46418 B 0 A SBT_TAPE 2026-05-15 05:58:21 1 1 NO HOT_DB_BK_LEVEL0
46419 B 0 A SBT_TAPE 2026-05-15 06:11:18 1 1 NO HOT_DB_BK_LEVEL0
46420 B 0 A SBT_TAPE 2026-05-15 06:12:21 1 1 NO HOT_DB_BK_LEVEL0
46421 B 0 A SBT_TAPE 2026-05-15 06:18:15 1 1 NO HOT_DB_BK_LEVEL0
46422 B 0 A SBT_TAPE 2026-05-15 06:23:01 1 1 NO HOT_DB_BK_LEVEL0
46423 B 0 A SBT_TAPE 2026-05-15 06:24:51 1 1 NO HOT_DB_BK_LEVEL0
46424 B 0 A SBT_TAPE 2026-05-15 06:26:48 1 1 NO HOT_DB_BK_LEVEL0
46425 B 0 A SBT_TAPE 2026-05-15 06:28:09 1 1 NO HOT_DB_BK_LEVEL0
46426 B 0 A SBT_TAPE 2026-05-15 06:28:31 1 1 NO HOT_DB_BK_LEVEL0
46427 B 0 A SBT_TAPE 2026-05-15 06:32:34 1 1 NO HOT_DB_BK_LEVEL0
46428 B 0 A SBT_TAPE 2026-05-15 06:32:36 1 1 NO HOT_DB_BK_LEVEL0
46429 B 0 A SBT_TAPE 2026-05-15 06:34:45 1 1 NO HOT_DB_BK_LEVEL0
46430 B 0 A SBT_TAPE 2026-05-15 06:34:55 1 1 NO HOT_DB_BK_LEVEL0
46431 B 0 A SBT_TAPE 2026-05-15 06:36:13 1 1 NO HOT_DB_BK_LEVEL0
46432 B 0 A SBT_TAPE 2026-05-15 06:36:36 1 1 NO HOT_DB_BK_LEVEL0
46433 B 0 A SBT_TAPE 2026-05-15 06:37:15 1 1 NO HOT_DB_BK_LEVEL0
46434 B 0 A SBT_TAPE 2026-05-15 06:37:28 1 1 NO HOT_DB_BK_LEVEL0
46435 B 0 A SBT_TAPE 2026-05-15 06:38:02 1 1 NO HOT_DB_BK_LEVEL0
46436 B 0 A SBT_TAPE 2026-05-15 06:38:04 1 1 NO HOT_DB_BK_LEVEL0
46437 B 0 A SBT_TAPE 2026-05-15 06:38:17 1 1 NO HOT_DB_BK_LEVEL0
46438 B 0 A SBT_TAPE 2026-05-15 06:38:18 1 1 NO HOT_DB_BK_LEVEL0
46439 B 0 A SBT_TAPE 2026-05-15 06:38:26 1 1 NO HOT_DB_BK_LEVEL0
46440 B 0 A SBT_TAPE 2026-05-15 06:38:28 1 1 NO HOT_DB_BK_LEVEL0
46441 B 0 A SBT_TAPE 2026-05-15 06:38:36 1 1 NO HOT_DB_BK_LEVEL0
46442 B 0 A SBT_TAPE 2026-05-15 06:38:40 1 1 NO HOT_DB_BK_LEVEL0
46443 B 0 A SBT_TAPE 2026-05-15 06:38:52 1 1 NO HOT_DB_BK_LEVEL0
46444 B 0 A SBT_TAPE 2026-05-15 06:38:53 1 1 NO HOT_DB_BK_LEVEL0
46445 B F A SBT_TAPE 2026-05-15 06:39:11 1 1 NO TAG20260515T063902
46446 B A A SBT_TAPE 2026-05-15 06:40:29 1 1 NO TAG20260515T063919
46447 B A A SBT_TAPE 2026-05-15 06:40:34 1 1 NO TAG20260515T063919
46448 B A A SBT_TAPE 2026-05-15 06:41:37 1 1 NO TAG20260515T063919
46449 B A A SBT_TAPE 2026-05-15 06:41:43 1 1 NO TAG20260515T063919
46450 B A A SBT_TAPE 2026-05-15 06:42:43 1 1 NO TAG20260515T063919
46451 B A A SBT_TAPE 2026-05-15 06:42:53 1 1 NO TAG20260515T063919
46452 B A A SBT_TAPE 2026-05-15 06:43:53 1 1 NO TAG20260515T063919
46453 B A A SBT_TAPE 2026-05-15 06:43:52 1 1 NO TAG20260515T063919
46454 B F A SBT_TAPE 2026-05-15 06:44:16 1 1 NO TAG20260515T064408
46455 B F A SBT_TAPE 2026-05-15 06:44:31 1 1 NO TAG20260515T064425
46456 B F A SBT_TAPE 2026-05-15 06:44:48 1 1 NO TAG20260515T064441
46457 B F A DISK 2026-05-15 10:29:12 1 1 NO TAG20260515T102912
46458 B 0 A SBT_TAPE 2026-05-16 02:22:12 1 1 NO HOT_DB_BK_LEVEL0
46459 B 0 A SBT_TAPE 2026-05-16 02:23:12 1 1 NO HOT_DB_BK_LEVEL0
46460 B 0 A SBT_TAPE 2026-05-16 03:00:17 1 1 NO HOT_DB_BK_LEVEL0
46461 B 0 A SBT_TAPE 2026-05-16 03:01:45 1 1 NO HOT_DB_BK_LEVEL0
46462 B 0 A SBT_TAPE 2026-05-16 04:00:47 1 1 NO HOT_DB_BK_LEVEL0
46463 B 0 A SBT_TAPE 2026-05-16 04:16:30 1 1 NO HOT_DB_BK_LEVEL0
46464 B 0 A SBT_TAPE 2026-05-16 05:08:27 1 1 NO HOT_DB_BK_LEVEL0
46465 B 0 A SBT_TAPE 2026-05-16 05:08:47 1 1 NO HOT_DB_BK_LEVEL0
46466 B 0 A SBT_TAPE 2026-05-16 05:39:31 1 1 NO HOT_DB_BK_LEVEL0
46467 B 0 A SBT_TAPE 2026-05-16 05:39:54 1 1 NO HOT_DB_BK_LEVEL0
46468 B 0 A SBT_TAPE 2026-05-16 06:01:12 1 1 NO HOT_DB_BK_LEVEL0
46469 B 0 A SBT_TAPE 2026-05-16 06:02:11 1 1 NO HOT_DB_BK_LEVEL0
46470 B 0 A SBT_TAPE 2026-05-16 06:22:25 1 1 NO HOT_DB_BK_LEVEL0
46471 B 0 A SBT_TAPE 2026-05-16 06:23:41 1 1 NO HOT_DB_BK_LEVEL0
46472 B 0 A SBT_TAPE 2026-05-16 06:29:34 1 1 NO HOT_DB_BK_LEVEL0
46473 B 0 A SBT_TAPE 2026-05-16 06:43:11 1 1 NO HOT_DB_BK_LEVEL0
46474 B 0 A SBT_TAPE 2026-05-16 06:47:48 1 1 NO HOT_DB_BK_LEVEL0
46475 B 0 A SBT_TAPE 2026-05-16 06:49:17 1 1 NO HOT_DB_BK_LEVEL0
46476 B 0 A SBT_TAPE 2026-05-16 06:52:59 1 1 NO HOT_DB_BK_LEVEL0
46477 B 0 A SBT_TAPE 2026-05-16 07:05:57 1 1 NO HOT_DB_BK_LEVEL0
46478 B 0 A SBT_TAPE 2026-05-16 07:08:57 1 1 NO HOT_DB_BK_LEVEL0
46479 B 0 A SBT_TAPE 2026-05-16 07:15:40 1 1 NO HOT_DB_BK_LEVEL0
46480 B 0 A SBT_TAPE 2026-05-16 07:20:42 1 1 NO HOT_DB_BK_LEVEL0
46481 B 0 A SBT_TAPE 2026-05-16 07:21:58 1 1 NO HOT_DB_BK_LEVEL0
46482 B 0 A SBT_TAPE 2026-05-16 07:24:19 1 1 NO HOT_DB_BK_LEVEL0
46483 B 0 A SBT_TAPE 2026-05-16 07:26:32 1 1 NO HOT_DB_BK_LEVEL0
46484 B 0 A SBT_TAPE 2026-05-16 07:26:36 1 1 NO HOT_DB_BK_LEVEL0
46485 B 0 A SBT_TAPE 2026-05-16 07:30:50 1 1 NO HOT_DB_BK_LEVEL0
46486 B 0 A SBT_TAPE 2026-05-16 07:31:58 1 1 NO HOT_DB_BK_LEVEL0
46487 B 0 A SBT_TAPE 2026-05-16 07:33:32 1 1 NO HOT_DB_BK_LEVEL0
46488 B 0 A SBT_TAPE 2026-05-16 07:34:36 1 1 NO HOT_DB_BK_LEVEL0
46489 B 0 A SBT_TAPE 2026-05-16 07:35:50 1 1 NO HOT_DB_BK_LEVEL0
46490 B 0 A SBT_TAPE 2026-05-16 07:35:52 1 1 NO HOT_DB_BK_LEVEL0
46491 B 0 A SBT_TAPE 2026-05-16 07:36:55 1 1 NO HOT_DB_BK_LEVEL0
46492 B 0 A SBT_TAPE 2026-05-16 07:36:54 1 1 NO HOT_DB_BK_LEVEL0
46493 B 0 A SBT_TAPE 2026-05-16 07:37:25 1 1 NO HOT_DB_BK_LEVEL0
46494 B 0 A SBT_TAPE 2026-05-16 07:37:42 1 1 NO HOT_DB_BK_LEVEL0
46495 B 0 A SBT_TAPE 2026-05-16 07:37:46 1 1 NO HOT_DB_BK_LEVEL0
46496 B 0 A SBT_TAPE 2026-05-16 07:37:58 1 1 NO HOT_DB_BK_LEVEL0
46497 B 0 A SBT_TAPE 2026-05-16 07:37:59 1 1 NO HOT_DB_BK_LEVEL0
46498 B 0 A SBT_TAPE 2026-05-16 07:38:14 1 1 NO HOT_DB_BK_LEVEL0
46499 B 0 A SBT_TAPE 2026-05-16 07:38:14 1 1 NO HOT_DB_BK_LEVEL0
46500 B 0 A SBT_TAPE 2026-05-16 07:38:28 1 1 NO HOT_DB_BK_LEVEL0
46501 B 0 A SBT_TAPE 2026-05-16 07:38:29 1 1 NO HOT_DB_BK_LEVEL0
46502 B 0 A SBT_TAPE 2026-05-16 07:38:43 1 1 NO HOT_DB_BK_LEVEL0
46503 B F A SBT_TAPE 2026-05-16 07:38:59 1 1 NO TAG20260516T073852
46504 B A A SBT_TAPE 2026-05-16 07:40:21 1 1 NO TAG20260516T073909
46505 B A A SBT_TAPE 2026-05-16 07:40:24 1 1 NO TAG20260516T073909
46506 B A A SBT_TAPE 2026-05-16 07:41:44 1 1 NO TAG20260516T073909
46507 B A A SBT_TAPE 2026-05-16 07:41:50 1 1 NO TAG20260516T073909
46508 B A A SBT_TAPE 2026-05-16 07:43:05 1 1 NO TAG20260516T073909
46509 B A A SBT_TAPE 2026-05-16 07:43:07 1 1 NO TAG20260516T073909
46510 B A A SBT_TAPE 2026-05-16 07:43:56 1 1 NO TAG20260516T073909
46511 B F A SBT_TAPE 2026-05-16 07:44:14 1 1 NO TAG20260516T074407
46512 B F A SBT_TAPE 2026-05-16 07:44:31 1 1 NO TAG20260516T074423
46513 B F A SBT_TAPE 2026-05-16 07:44:46 1 1 NO TAG20260516T074439
46514 B 0 A SBT_TAPE 2026-05-17 02:16:45 1 1 NO HOT_DB_BK_LEVEL0
46515 B 0 A SBT_TAPE 2026-05-17 02:17:40 1 1 NO HOT_DB_BK_LEVEL0
46516 B 0 A SBT_TAPE 2026-05-17 02:44:18 1 1 NO HOT_DB_BK_LEVEL0
46517 B 0 A SBT_TAPE 2026-05-17 02:45:49 1 1 NO HOT_DB_BK_LEVEL0
46518 B 0 A SBT_TAPE 2026-05-17 03:21:33 1 1 NO HOT_DB_BK_LEVEL0
46519 B 0 A SBT_TAPE 2026-05-17 03:22:03 1 1 NO HOT_DB_BK_LEVEL0
46520 B 0 A SBT_TAPE 2026-05-17 03:58:11 1 1 NO HOT_DB_BK_LEVEL0
46521 B 0 A SBT_TAPE 2026-05-17 03:58:33 1 1 NO HOT_DB_BK_LEVEL0
46522 B 0 A SBT_TAPE 2026-05-17 04:46:14 1 1 NO HOT_DB_BK_LEVEL0
46523 B 0 A SBT_TAPE 2026-05-17 04:47:22 1 1 NO HOT_DB_BK_LEVEL0
46524 B 0 A SBT_TAPE 2026-05-17 05:12:25 1 1 NO HOT_DB_BK_LEVEL0
46525 B 0 A SBT_TAPE 2026-05-17 05:12:36 1 1 NO HOT_DB_BK_LEVEL0
46526 B 0 A SBT_TAPE 2026-05-17 05:31:00 1 1 NO HOT_DB_BK_LEVEL0
46527 B 0 A SBT_TAPE 2026-05-17 05:31:08 1 1 NO HOT_DB_BK_LEVEL0
46528 B 0 A SBT_TAPE 2026-05-17 05:37:05 1 1 NO HOT_DB_BK_LEVEL0
46529 B 0 A SBT_TAPE 2026-05-17 05:48:35 1 1 NO HOT_DB_BK_LEVEL0
46530 B 0 A SBT_TAPE 2026-05-17 05:52:59 1 1 NO HOT_DB_BK_LEVEL0
46531 B 0 A SBT_TAPE 2026-05-17 05:54:15 1 1 NO HOT_DB_BK_LEVEL0
46532 B 0 A SBT_TAPE 2026-05-17 05:57:37 1 1 NO HOT_DB_BK_LEVEL0
46533 B 0 A SBT_TAPE 2026-05-17 06:09:49 1 1 NO HOT_DB_BK_LEVEL0
46534 B 0 A SBT_TAPE 2026-05-17 06:11:33 1 1 NO HOT_DB_BK_LEVEL0
46535 B 0 A SBT_TAPE 2026-05-17 06:16:51 1 1 NO HOT_DB_BK_LEVEL0
46536 B 0 A SBT_TAPE 2026-05-17 06:23:01 1 1 NO HOT_DB_BK_LEVEL0
46537 B 0 A SBT_TAPE 2026-05-17 06:23:00 1 1 NO HOT_DB_BK_LEVEL0
46538 B 0 A SBT_TAPE 2026-05-17 06:25:06 1 1 NO HOT_DB_BK_LEVEL0
46539 B 0 A SBT_TAPE 2026-05-17 06:27:10 1 1 NO HOT_DB_BK_LEVEL0
46540 B 0 A SBT_TAPE 2026-05-17 06:27:39 1 1 NO HOT_DB_BK_LEVEL0
46541 B 0 A SBT_TAPE 2026-05-17 06:31:43 1 1 NO HOT_DB_BK_LEVEL0
46542 B 0 A SBT_TAPE 2026-05-17 06:32:04 1 1 NO HOT_DB_BK_LEVEL0
46543 B 0 A SBT_TAPE 2026-05-17 06:34:05 1 1 NO HOT_DB_BK_LEVEL0
46544 B 0 A SBT_TAPE 2026-05-17 06:34:06 1 1 NO HOT_DB_BK_LEVEL0
46545 B 0 A SBT_TAPE 2026-05-17 06:35:10 1 1 NO HOT_DB_BK_LEVEL0
46546 B 0 A SBT_TAPE 2026-05-17 06:36:05 1 1 NO HOT_DB_BK_LEVEL0
46547 B 0 A SBT_TAPE 2026-05-17 06:36:16 1 1 NO HOT_DB_BK_LEVEL0
46548 B 0 A SBT_TAPE 2026-05-17 06:36:58 1 1 NO HOT_DB_BK_LEVEL0
46549 B 0 A SBT_TAPE 2026-05-17 06:36:59 1 1 NO HOT_DB_BK_LEVEL0
46550 B 0 A SBT_TAPE 2026-05-17 06:37:12 1 1 NO HOT_DB_BK_LEVEL0
46551 B 0 A SBT_TAPE 2026-05-17 06:37:27 1 1 NO HOT_DB_BK_LEVEL0
46552 B 0 A SBT_TAPE 2026-05-17 06:37:29 1 1 NO HOT_DB_BK_LEVEL0
46553 B 0 A SBT_TAPE 2026-05-17 06:37:41 1 1 NO HOT_DB_BK_LEVEL0
46554 B 0 A SBT_TAPE 2026-05-17 06:37:43 1 1 NO HOT_DB_BK_LEVEL0
46555 B 0 A SBT_TAPE 2026-05-17 06:37:57 1 1 NO HOT_DB_BK_LEVEL0
46556 B 0 A SBT_TAPE 2026-05-17 06:37:58 1 1 NO HOT_DB_BK_LEVEL0
46557 B 0 A SBT_TAPE 2026-05-17 06:38:12 1 1 NO HOT_DB_BK_LEVEL0
46558 B 0 A SBT_TAPE 2026-05-17 06:38:11 1 1 NO HOT_DB_BK_LEVEL0
46559 B F A SBT_TAPE 2026-05-17 06:38:28 1 1 NO TAG20260517T063821
46560 B A A SBT_TAPE 2026-05-17 06:39:32 1 1 NO TAG20260517T063838
46561 B A A SBT_TAPE 2026-05-17 06:39:35 1 1 NO TAG20260517T063838
46562 B A A SBT_TAPE 2026-05-17 06:40:38 1 1 NO TAG20260517T063838
46563 B A A SBT_TAPE 2026-05-17 06:40:40 1 1 NO TAG20260517T063838
46564 B F A SBT_TAPE 2026-05-17 06:40:57 1 1 NO TAG20260517T064051
46565 B F A SBT_TAPE 2026-05-17 06:41:07 1 1 NO TAG20260517T064059
46566 B F A SBT_TAPE 2026-05-17 06:41:22 1 1 NO TAG20260517T064115
46567 B 0 A SBT_TAPE 2026-05-18 02:17:54 1 1 NO HOT_DB_BK_LEVEL0
46568 B 0 A SBT_TAPE 2026-05-18 02:18:10 1 1 NO HOT_DB_BK_LEVEL0
46569 B 0 A SBT_TAPE 2026-05-18 02:45:59 1 1 NO HOT_DB_BK_LEVEL0
46570 B 0 A SBT_TAPE 2026-05-18 02:46:20 1 1 NO HOT_DB_BK_LEVEL0
46571 B 0 A SBT_TAPE 2026-05-18 03:22:00 1 1 NO HOT_DB_BK_LEVEL0
46572 B 0 A SBT_TAPE 2026-05-18 03:23:33 1 1 NO HOT_DB_BK_LEVEL0
46573 B 0 A SBT_TAPE 2026-05-18 04:03:24 1 1 NO HOT_DB_BK_LEVEL0
46574 B 0 A SBT_TAPE 2026-05-18 04:03:39 1 1 NO HOT_DB_BK_LEVEL0
46575 B 0 A SBT_TAPE 2026-05-18 04:48:49 1 1 NO HOT_DB_BK_LEVEL0
46576 B 0 A SBT_TAPE 2026-05-18 04:48:49 1 1 NO HOT_DB_BK_LEVEL0
46577 B 0 A SBT_TAPE 2026-05-18 05:12:55 1 1 NO HOT_DB_BK_LEVEL0
46578 B 0 A SBT_TAPE 2026-05-18 05:12:59 1 1 NO HOT_DB_BK_LEVEL0
46579 B 0 A SBT_TAPE 2026-05-18 05:31:52 1 1 NO HOT_DB_BK_LEVEL0
46580 B 0 A SBT_TAPE 2026-05-18 05:31:54 1 1 NO HOT_DB_BK_LEVEL0
46581 B 0 A SBT_TAPE 2026-05-18 05:38:21 1 1 NO HOT_DB_BK_LEVEL0
46582 B 0 A SBT_TAPE 2026-05-18 05:49:14 1 1 NO HOT_DB_BK_LEVEL0
46583 B 0 A SBT_TAPE 2026-05-18 05:53:19 1 1 NO HOT_DB_BK_LEVEL0
46584 B 0 A SBT_TAPE 2026-05-18 05:55:29 1 1 NO HOT_DB_BK_LEVEL0
46585 B 0 A SBT_TAPE 2026-05-18 05:58:11 1 1 NO HOT_DB_BK_LEVEL0
46586 B 0 A SBT_TAPE 2026-05-18 06:11:09 1 1 NO HOT_DB_BK_LEVEL0
46587 B 0 A SBT_TAPE 2026-05-18 06:11:26 1 1 NO HOT_DB_BK_LEVEL0
46588 B 0 A SBT_TAPE 2026-05-18 06:17:51 1 1 NO HOT_DB_BK_LEVEL0
46589 B 0 A SBT_TAPE 2026-05-18 06:23:45 1 1 NO HOT_DB_BK_LEVEL0
46590 B 0 A SBT_TAPE 2026-05-18 06:24:11 1 1 NO HOT_DB_BK_LEVEL0
46591 B 0 A SBT_TAPE 2026-05-18 06:26:03 1 1 NO HOT_DB_BK_LEVEL0
46592 B 0 A SBT_TAPE 2026-05-18 06:28:03 1 1 NO HOT_DB_BK_LEVEL0
46593 B 0 A SBT_TAPE 2026-05-18 06:29:04 1 1 NO HOT_DB_BK_LEVEL0
46594 B 0 A SBT_TAPE 2026-05-18 06:31:51 1 1 NO HOT_DB_BK_LEVEL0
46595 B 0 A SBT_TAPE 2026-05-18 06:33:05 1 1 NO HOT_DB_BK_LEVEL0
46596 B 0 A SBT_TAPE 2026-05-18 06:34:13 1 1 NO HOT_DB_BK_LEVEL0
46597 B 0 A SBT_TAPE 2026-05-18 06:35:24 1 1 NO HOT_DB_BK_LEVEL0
46598 B 0 A SBT_TAPE 2026-05-18 06:36:20 1 1 NO HOT_DB_BK_LEVEL0
46599 B 0 A SBT_TAPE 2026-05-18 06:36:42 1 1 NO HOT_DB_BK_LEVEL0
46600 B 0 A SBT_TAPE 2026-05-18 06:37:22 1 1 NO HOT_DB_BK_LEVEL0
46601 B 0 A SBT_TAPE 2026-05-18 06:37:36 1 1 NO HOT_DB_BK_LEVEL0
46602 B 0 A SBT_TAPE 2026-05-18 06:37:57 1 1 NO HOT_DB_BK_LEVEL0
46603 B 0 A SBT_TAPE 2026-05-18 06:38:06 1 1 NO HOT_DB_BK_LEVEL0
46604 B 0 A SBT_TAPE 2026-05-18 06:38:14 1 1 NO HOT_DB_BK_LEVEL0
46605 B 0 A SBT_TAPE 2026-05-18 06:38:26 1 1 NO HOT_DB_BK_LEVEL0
46606 B 0 A SBT_TAPE 2026-05-18 06:38:27 1 1 NO HOT_DB_BK_LEVEL0
46607 B 0 A SBT_TAPE 2026-05-18 06:38:41 1 1 NO HOT_DB_BK_LEVEL0
46608 B 0 A SBT_TAPE 2026-05-18 06:38:42 1 1 NO HOT_DB_BK_LEVEL0
46609 B 0 A SBT_TAPE 2026-05-18 06:38:56 1 1 NO HOT_DB_BK_LEVEL0
46610 B 0 A SBT_TAPE 2026-05-18 06:38:56 1 1 NO HOT_DB_BK_LEVEL0
46611 B 0 A SBT_TAPE 2026-05-18 06:39:03 1 1 NO HOT_DB_BK_LEVEL0
46612 B F A SBT_TAPE 2026-05-18 06:39:11 1 1 NO TAG20260518T063904
46613 B A A SBT_TAPE 2026-05-18 06:40:08 1 1 NO TAG20260518T063921
46614 B A A SBT_TAPE 2026-05-18 06:40:12 1 1 NO TAG20260518T063921
46615 B A A SBT_TAPE 2026-05-18 06:41:05 1 1 NO TAG20260518T063921
46616 B F A SBT_TAPE 2026-05-18 06:41:21 1 1 NO TAG20260518T064114
46617 B F A SBT_TAPE 2026-05-18 06:41:37 1 1 NO TAG20260518T064130
46618 B F A SBT_TAPE 2026-05-18 06:41:53 1 1 NO TAG20260518T064146
46619 B 0 A SBT_TAPE 2026-05-19 02:16:19 1 1 NO HOT_DB_BK_LEVEL0
46620 B 0 A SBT_TAPE 2026-05-19 02:17:04 1 1 NO HOT_DB_BK_LEVEL0
46621 B 0 A SBT_TAPE 2026-05-19 02:43:28 1 1 NO HOT_DB_BK_LEVEL0
46622 B 0 A SBT_TAPE 2026-05-19 02:45:06 1 1 NO HOT_DB_BK_LEVEL0
46623 B 0 A SBT_TAPE 2026-05-19 03:19:11 1 1 NO HOT_DB_BK_LEVEL0
46624 B 0 A SBT_TAPE 2026-05-19 03:21:14 1 1 NO HOT_DB_BK_LEVEL0
46625 B 0 A SBT_TAPE 2026-05-19 03:58:53 1 1 NO HOT_DB_BK_LEVEL0
46626 B 0 A SBT_TAPE 2026-05-19 04:02:32 1 1 NO HOT_DB_BK_LEVEL0
46627 B 0 A SBT_TAPE 2026-05-19 04:48:47 1 1 NO HOT_DB_BK_LEVEL0
46628 B 0 A SBT_TAPE 2026-05-19 04:49:56 1 1 NO HOT_DB_BK_LEVEL0
46629 B 0 A SBT_TAPE 2026-05-19 05:13:48 1 1 NO HOT_DB_BK_LEVEL0
46630 B 0 A SBT_TAPE 2026-05-19 05:14:05 1 1 NO HOT_DB_BK_LEVEL0
46631 B 0 A SBT_TAPE 2026-05-19 05:32:16 1 1 NO HOT_DB_BK_LEVEL0
46632 B 0 A SBT_TAPE 2026-05-19 05:33:09 1 1 NO HOT_DB_BK_LEVEL0
46633 B 0 A SBT_TAPE 2026-05-19 05:38:47 1 1 NO HOT_DB_BK_LEVEL0
46634 B 0 A SBT_TAPE 2026-05-19 05:50:41 1 1 NO HOT_DB_BK_LEVEL0
46635 B 0 A SBT_TAPE 2026-05-19 05:54:36 1 1 NO HOT_DB_BK_LEVEL0
46636 B 0 A SBT_TAPE 2026-05-19 05:55:59 1 1 NO HOT_DB_BK_LEVEL0
46637 B 0 A SBT_TAPE 2026-05-19 05:59:25 1 1 NO HOT_DB_BK_LEVEL0
46638 B 0 A SBT_TAPE 2026-05-19 06:11:31 1 1 NO HOT_DB_BK_LEVEL0
46639 B 0 A SBT_TAPE 2026-05-19 06:12:46 1 1 NO HOT_DB_BK_LEVEL0
46640 B 0 A SBT_TAPE 2026-05-19 06:18:35 1 1 NO HOT_DB_BK_LEVEL0
46641 B 0 A SBT_TAPE 2026-05-19 06:24:26 1 1 NO HOT_DB_BK_LEVEL0
46642 B 0 A SBT_TAPE 2026-05-19 06:25:10 1 1 NO HOT_DB_BK_LEVEL0
46643 B 0 A SBT_TAPE 2026-05-19 06:27:20 1 1 NO HOT_DB_BK_LEVEL0
46644 B 0 A SBT_TAPE 2026-05-19 06:29:28 1 1 NO HOT_DB_BK_LEVEL0
46645 B 0 A SBT_TAPE 2026-05-19 06:29:31 1 1 NO HOT_DB_BK_LEVEL0
46646 B 0 A SBT_TAPE 2026-05-19 06:33:47 1 1 NO HOT_DB_BK_LEVEL0
46647 B 0 A SBT_TAPE 2026-05-19 06:34:38 1 1 NO HOT_DB_BK_LEVEL0
46648 B 0 A SBT_TAPE 2026-05-19 06:35:22 1 1 NO HOT_DB_BK_LEVEL0
46649 B 0 A SBT_TAPE 2026-05-19 06:36:44 1 1 NO HOT_DB_BK_LEVEL0
46650 B 0 A SBT_TAPE 2026-05-19 06:37:38 1 1 NO HOT_DB_BK_LEVEL0
46651 B 0 A SBT_TAPE 2026-05-19 06:37:57 1 1 NO HOT_DB_BK_LEVEL0
46652 B 0 A SBT_TAPE 2026-05-19 06:38:34 1 1 NO HOT_DB_BK_LEVEL0
46653 B 0 A SBT_TAPE 2026-05-19 06:38:54 1 1 NO HOT_DB_BK_LEVEL0
46654 B 0 A SBT_TAPE 2026-05-19 06:39:19 1 1 NO HOT_DB_BK_LEVEL0
46655 B 0 A SBT_TAPE 2026-05-19 06:39:33 1 1 NO HOT_DB_BK_LEVEL0
46656 B 0 A SBT_TAPE 2026-05-19 06:39:39 1 1 NO HOT_DB_BK_LEVEL0
46657 B 0 A SBT_TAPE 2026-05-19 06:39:42 1 1 NO HOT_DB_BK_LEVEL0
46658 B 0 A SBT_TAPE 2026-05-19 06:39:49 1 1 NO HOT_DB_BK_LEVEL0
46659 B 0 A SBT_TAPE 2026-05-19 06:39:53 1 1 NO HOT_DB_BK_LEVEL0
46660 B 0 A SBT_TAPE 2026-05-19 06:40:00 1 1 NO HOT_DB_BK_LEVEL0
46661 B 0 A SBT_TAPE 2026-05-19 06:40:06 1 1 NO HOT_DB_BK_LEVEL0
46662 B 0 A SBT_TAPE 2026-05-19 06:40:15 1 1 NO HOT_DB_BK_LEVEL0
46663 B 0 A SBT_TAPE 2026-05-19 06:40:15 1 1 NO HOT_DB_BK_LEVEL0
46664 B F A SBT_TAPE 2026-05-19 06:40:29 1 1 NO TAG20260519T064023
46665 B A A SBT_TAPE 2026-05-19 06:41:32 1 1 NO TAG20260519T064040
46666 B A A SBT_TAPE 2026-05-19 06:41:36 1 1 NO TAG20260519T064040
46667 B A A SBT_TAPE 2026-05-19 06:42:27 1 1 NO TAG20260519T064040
46668 B A A SBT_TAPE 2026-05-19 06:42:39 1 1 NO TAG20260519T064040
46669 B A A SBT_TAPE 2026-05-19 06:43:31 1 1 NO TAG20260519T064040
46670 B A A SBT_TAPE 2026-05-19 06:43:43 1 1 NO TAG20260519T064040
46671 B F A SBT_TAPE 2026-05-19 06:43:55 1 1 NO TAG20260519T064348
46672 B F A SBT_TAPE 2026-05-19 06:44:12 1 1 NO TAG20260519T064404
46673 B F A SBT_TAPE 2026-05-19 06:44:26 1 1 NO TAG20260519T064420
46674 B 0 A SBT_TAPE 2026-05-20 02:16:14 1 1 NO HOT_DB_BK_LEVEL0
46675 B 0 A SBT_TAPE 2026-05-20 02:16:31 1 1 NO HOT_DB_BK_LEVEL0
46676 B 0 A SBT_TAPE 2026-05-20 02:43:57 1 1 NO HOT_DB_BK_LEVEL0
46677 B 0 A SBT_TAPE 2026-05-20 02:44:38 1 1 NO HOT_DB_BK_LEVEL0
46678 B 0 A SBT_TAPE 2026-05-20 03:21:05 1 1 NO HOT_DB_BK_LEVEL0
46679 B 0 A SBT_TAPE 2026-05-20 03:21:47 1 1 NO HOT_DB_BK_LEVEL0
46680 B 0 A SBT_TAPE 2026-05-20 03:58:09 1 1 NO HOT_DB_BK_LEVEL0
46681 B 0 A SBT_TAPE 2026-05-20 04:05:55 1 1 NO HOT_DB_BK_LEVEL0
46682 B 0 A SBT_TAPE 2026-05-20 04:49:01 1 1 NO HOT_DB_BK_LEVEL0
46683 B 0 A SBT_TAPE 2026-05-20 04:54:41 1 1 NO HOT_DB_BK_LEVEL0
46684 B 0 A SBT_TAPE 2026-05-20 05:12:35 1 1 NO HOT_DB_BK_LEVEL0
46685 B 0 A SBT_TAPE 2026-05-20 05:15:55 1 1 NO HOT_DB_BK_LEVEL0
46686 B 0 A SBT_TAPE 2026-05-20 05:30:38 1 1 NO HOT_DB_BK_LEVEL0
46687 B 0 A SBT_TAPE 2026-05-20 05:34:52 1 1 NO HOT_DB_BK_LEVEL0
46688 B 0 A SBT_TAPE 2026-05-20 05:37:20 1 1 NO HOT_DB_BK_LEVEL0
46689 B 0 A SBT_TAPE 2026-05-20 05:52:15 1 1 NO HOT_DB_BK_LEVEL0
46690 B 0 A SBT_TAPE 2026-05-20 05:54:38 1 1 NO HOT_DB_BK_LEVEL0
46691 B 0 A SBT_TAPE 2026-05-20 05:56:16 1 1 NO HOT_DB_BK_LEVEL0
46692 B 0 A SBT_TAPE 2026-05-20 05:59:40 1 1 NO HOT_DB_BK_LEVEL0
46693 B 0 A SBT_TAPE 2026-05-20 06:11:42 1 1 NO HOT_DB_BK_LEVEL0
46694 B 0 A SBT_TAPE 2026-05-20 06:13:48 1 1 NO HOT_DB_BK_LEVEL0
46695 B 0 A SBT_TAPE 2026-05-20 06:19:39 1 1 NO HOT_DB_BK_LEVEL0
46696 B 0 A SBT_TAPE 2026-05-20 06:24:56 1 1 NO HOT_DB_BK_LEVEL0
46697 B 0 A SBT_TAPE 2026-05-20 06:25:32 1 1 NO HOT_DB_BK_LEVEL0
46698 B 0 A SBT_TAPE 2026-05-20 06:27:54 1 1 NO HOT_DB_BK_LEVEL0
46699 B 0 A SBT_TAPE 2026-05-20 06:29:58 1 1 NO HOT_DB_BK_LEVEL0
46700 B 0 A SBT_TAPE 2026-05-20 06:30:00 1 1 NO HOT_DB_BK_LEVEL0
46701 B 0 A SBT_TAPE 2026-05-20 06:33:36 1 1 NO HOT_DB_BK_LEVEL0
46702 B 0 A SBT_TAPE 2026-05-20 06:34:27 1 1 NO HOT_DB_BK_LEVEL0
46703 B 0 A SBT_TAPE 2026-05-20 06:35:57 1 1 NO HOT_DB_BK_LEVEL0
46704 B 0 A SBT_TAPE 2026-05-20 06:36:39 1 1 NO HOT_DB_BK_LEVEL0
46705 B 0 A SBT_TAPE 2026-05-20 06:37:56 1 1 NO HOT_DB_BK_LEVEL0
46706 B 0 A SBT_TAPE 2026-05-20 06:37:54 1 1 NO HOT_DB_BK_LEVEL0
46707 B 0 A SBT_TAPE 2026-05-20 06:38:52 1 1 NO HOT_DB_BK_LEVEL0
46708 B 0 A SBT_TAPE 2026-05-20 06:38:54 1 1 NO HOT_DB_BK_LEVEL0
46709 B 0 A SBT_TAPE 2026-05-20 06:39:17 1 1 NO HOT_DB_BK_LEVEL0
46710 B 0 A SBT_TAPE 2026-05-20 06:39:21 1 1 NO HOT_DB_BK_LEVEL0
46711 B 0 A SBT_TAPE 2026-05-20 06:39:27 1 1 NO HOT_DB_BK_LEVEL0
46712 B 0 A SBT_TAPE 2026-05-20 06:39:31 1 1 NO HOT_DB_BK_LEVEL0
46713 B 0 A SBT_TAPE 2026-05-20 06:39:38 1 1 NO HOT_DB_BK_LEVEL0
46714 B 0 A SBT_TAPE 2026-05-20 06:39:39 1 1 NO HOT_DB_BK_LEVEL0
46715 B 0 A SBT_TAPE 2026-05-20 06:39:56 1 1 NO HOT_DB_BK_LEVEL0
46716 B 0 A SBT_TAPE 2026-05-20 06:39:54 1 1 NO HOT_DB_BK_LEVEL0
46717 B 0 A SBT_TAPE 2026-05-20 06:40:09 1 1 NO HOT_DB_BK_LEVEL0
46718 B 0 A SBT_TAPE 2026-05-20 06:40:10 1 1 NO HOT_DB_BK_LEVEL0
46719 B F A SBT_TAPE 2026-05-20 06:40:26 1 1 NO TAG20260520T064019
46720 B A A SBT_TAPE 2026-05-20 06:41:39 1 1 NO TAG20260520T064036
46721 B A A SBT_TAPE 2026-05-20 06:41:41 1 1 NO TAG20260520T064036
46722 B A A SBT_TAPE 2026-05-20 06:42:56 1 1 NO TAG20260520T064036
46723 B A A SBT_TAPE 2026-05-20 06:42:57 1 1 NO TAG20260520T064036
46724 B A A SBT_TAPE 2026-05-20 06:43:54 1 1 NO TAG20260520T064036
46725 B A A SBT_TAPE 2026-05-20 06:44:11 1 1 NO TAG20260520T064036
46726 B F A SBT_TAPE 2026-05-20 06:44:22 1 1 NO TAG20260520T064415
46727 B F A SBT_TAPE 2026-05-20 06:44:38 1 1 NO TAG20260520T064432
46728 B F A SBT_TAPE 2026-05-20 06:44:55 1 1 NO TAG20260520T064448
46729 B 0 A SBT_TAPE 2026-05-21 02:17:30 1 1 NO HOT_DB_BK_LEVEL0
46730 B 0 A SBT_TAPE 2026-05-21 02:17:36 1 1 NO HOT_DB_BK_LEVEL0
46731 B 0 A SBT_TAPE 2026-05-21 02:44:47 1 1 NO HOT_DB_BK_LEVEL0
46732 B 0 A SBT_TAPE 2026-05-21 02:44:59 1 1 NO HOT_DB_BK_LEVEL0
46733 B 0 A SBT_TAPE 2026-05-21 03:21:49 1 1 NO HOT_DB_BK_LEVEL0
46734 B 0 A SBT_TAPE 2026-05-21 03:22:01 1 1 NO HOT_DB_BK_LEVEL0
46735 B 0 A SBT_TAPE 2026-05-21 03:57:22 1 1 NO HOT_DB_BK_LEVEL0
46736 B 0 A SBT_TAPE 2026-05-21 03:59:02 1 1 NO HOT_DB_BK_LEVEL0
46737 B 0 A SBT_TAPE 2026-05-21 04:49:53 1 1 NO HOT_DB_BK_LEVEL0
46738 B 0 A SBT_TAPE 2026-05-21 04:50:39 1 1 NO HOT_DB_BK_LEVEL0
46739 B 0 A SBT_TAPE 2026-05-21 05:12:10 1 1 NO HOT_DB_BK_LEVEL0
46740 B 0 A SBT_TAPE 2026-05-21 05:12:38 1 1 NO HOT_DB_BK_LEVEL0
46741 B 0 A SBT_TAPE 2026-05-21 05:31:28 1 1 NO HOT_DB_BK_LEVEL0
46742 B 0 A SBT_TAPE 2026-05-21 05:31:30 1 1 NO HOT_DB_BK_LEVEL0
46743 B 0 A SBT_TAPE 2026-05-21 05:38:21 1 1 NO HOT_DB_BK_LEVEL0
46744 B 0 A SBT_TAPE 2026-05-21 05:49:09 1 1 NO HOT_DB_BK_LEVEL0
46745 B 0 A SBT_TAPE 2026-05-21 05:53:16 1 1 NO HOT_DB_BK_LEVEL0
46746 B 0 A SBT_TAPE 2026-05-21 05:55:46 1 1 NO HOT_DB_BK_LEVEL0
46747 B 0 A SBT_TAPE 2026-05-21 05:57:40 1 1 NO HOT_DB_BK_LEVEL0
46748 B 0 A SBT_TAPE 2026-05-21 06:10:38 1 1 NO HOT_DB_BK_LEVEL0
46749 B 0 A SBT_TAPE 2026-05-21 06:11:38 1 1 NO HOT_DB_BK_LEVEL0
46750 B 0 A SBT_TAPE 2026-05-21 06:17:30 1 1 NO HOT_DB_BK_LEVEL0
46751 B 0 A SBT_TAPE 2026-05-21 06:22:44 1 1 NO HOT_DB_BK_LEVEL0
46752 B 0 A SBT_TAPE 2026-05-21 06:23:52 1 1 NO HOT_DB_BK_LEVEL0
46753 B 0 A SBT_TAPE 2026-05-21 06:26:14 1 1 NO HOT_DB_BK_LEVEL0
46754 B 0 A SBT_TAPE 2026-05-21 06:27:57 1 1 NO HOT_DB_BK_LEVEL0
46755 B 0 A SBT_TAPE 2026-05-21 06:28:22 1 1 NO HOT_DB_BK_LEVEL0
46756 B 0 A SBT_TAPE 2026-05-21 06:32:13 1 1 NO HOT_DB_BK_LEVEL0
46757 B 0 A SBT_TAPE 2026-05-21 06:32:48 1 1 NO HOT_DB_BK_LEVEL0
46758 B 0 A SBT_TAPE 2026-05-21 06:34:39 1 1 NO HOT_DB_BK_LEVEL0
46759 B 0 A SBT_TAPE 2026-05-21 06:34:49 1 1 NO HOT_DB_BK_LEVEL0
46760 B 0 A SBT_TAPE 2026-05-21 06:36:03 1 1 NO HOT_DB_BK_LEVEL0
46761 B 0 A SBT_TAPE 2026-05-21 06:36:47 1 1 NO HOT_DB_BK_LEVEL0
46762 B 0 A SBT_TAPE 2026-05-21 06:37:04 1 1 NO HOT_DB_BK_LEVEL0
46763 B 0 A SBT_TAPE 2026-05-21 06:37:47 1 1 NO HOT_DB_BK_LEVEL0
46764 B 0 A SBT_TAPE 2026-05-21 06:37:46 1 1 NO HOT_DB_BK_LEVEL0
46765 B 0 A SBT_TAPE 2026-05-21 06:37:59 1 1 NO HOT_DB_BK_LEVEL0
46766 B 0 A SBT_TAPE 2026-05-21 06:38:10 1 1 NO HOT_DB_BK_LEVEL0
46767 B 0 A SBT_TAPE 2026-05-21 06:38:14 1 1 NO HOT_DB_BK_LEVEL0
46768 B 0 A SBT_TAPE 2026-05-21 06:38:21 1 1 NO HOT_DB_BK_LEVEL0
46769 B 0 A SBT_TAPE 2026-05-21 06:38:24 1 1 NO HOT_DB_BK_LEVEL0
46770 B 0 A SBT_TAPE 2026-05-21 06:38:31 1 1 NO HOT_DB_BK_LEVEL0
46771 B 0 A SBT_TAPE 2026-05-21 06:38:39 1 1 NO HOT_DB_BK_LEVEL0
46772 B 0 A SBT_TAPE 2026-05-21 06:38:42 1 1 NO HOT_DB_BK_LEVEL0
46773 B 0 A SBT_TAPE 2026-05-21 06:38:56 1 1 NO HOT_DB_BK_LEVEL0
46774 B F A SBT_TAPE 2026-05-21 06:39:12 1 1 NO TAG20260521T063905
46775 B A A SBT_TAPE 2026-05-21 06:40:30 1 1 NO TAG20260521T063922
46776 B A A SBT_TAPE 2026-05-21 06:40:29 1 1 NO TAG20260521T063922
46777 B A A SBT_TAPE 2026-05-21 06:41:46 1 1 NO TAG20260521T063922
46778 B A A SBT_TAPE 2026-05-21 06:41:53 1 1 NO TAG20260521T063922
46779 B A A SBT_TAPE 2026-05-21 06:42:54 1 1 NO TAG20260521T063922
46780 B A A SBT_TAPE 2026-05-21 06:43:02 1 1 NO TAG20260521T063922
46781 B F A SBT_TAPE 2026-05-21 06:43:21 1 1 NO TAG20260521T064315
46782 B F A SBT_TAPE 2026-05-21 06:43:40 1 1 NO TAG20260521T064331
46783 B F A SBT_TAPE 2026-05-21 06:43:54 1 1 NO TAG20260521T064347
46784 B 0 A SBT_TAPE 2026-05-22 02:16:13 1 1 NO HOT_DB_BK_LEVEL0
46785 B 0 A SBT_TAPE 2026-05-22 02:17:20 1 1 NO HOT_DB_BK_LEVEL0
46786 B 0 A SBT_TAPE 2026-05-22 02:44:25 1 1 NO HOT_DB_BK_LEVEL0
46787 B 0 A SBT_TAPE 2026-05-22 02:44:23 1 1 NO HOT_DB_BK_LEVEL0
46788 B 0 A SBT_TAPE 2026-05-22 03:19:49 1 1 NO HOT_DB_BK_LEVEL0
46789 B 0 A SBT_TAPE 2026-05-22 03:20:17 1 1 NO HOT_DB_BK_LEVEL0
46790 B 0 A SBT_TAPE 2026-05-22 03:59:10 1 1 NO HOT_DB_BK_LEVEL0
46791 B 0 A SBT_TAPE 2026-05-22 04:04:21 1 1 NO HOT_DB_BK_LEVEL0
46792 B 0 A SBT_TAPE 2026-05-22 04:48:43 1 1 NO HOT_DB_BK_LEVEL0
46793 B 0 A SBT_TAPE 2026-05-22 04:52:06 1 1 NO HOT_DB_BK_LEVEL0
46794 B 0 A SBT_TAPE 2026-05-22 05:13:36 1 1 NO HOT_DB_BK_LEVEL0
46795 B 0 A SBT_TAPE 2026-05-22 05:14:57 1 1 NO HOT_DB_BK_LEVEL0
46796 B 0 A SBT_TAPE 2026-05-22 05:31:50 1 1 NO HOT_DB_BK_LEVEL0
46797 B 0 A SBT_TAPE 2026-05-22 05:33:58 1 1 NO HOT_DB_BK_LEVEL0
46798 B 0 A SBT_TAPE 2026-05-22 05:38:34 1 1 NO HOT_DB_BK_LEVEL0
46799 B 0 A SBT_TAPE 2026-05-22 05:51:18 1 1 NO HOT_DB_BK_LEVEL0
46800 B 0 A SBT_TAPE 2026-05-22 05:55:36 1 1 NO HOT_DB_BK_LEVEL0
46801 B 0 A SBT_TAPE 2026-05-22 05:55:46 1 1 NO HOT_DB_BK_LEVEL0
46802 B 0 A SBT_TAPE 2026-05-22 06:00:11 1 1 NO HOT_DB_BK_LEVEL0
46803 B 0 A SBT_TAPE 2026-05-22 06:11:03 1 1 NO HOT_DB_BK_LEVEL0
46804 B 0 A SBT_TAPE 2026-05-22 06:13:35 1 1 NO HOT_DB_BK_LEVEL0
46805 B 0 A SBT_TAPE 2026-05-22 06:19:59 1 1 NO HOT_DB_BK_LEVEL0
46806 B 0 A SBT_TAPE 2026-05-22 06:24:06 1 1 NO HOT_DB_BK_LEVEL0
46807 B 0 A SBT_TAPE 2026-05-22 06:25:51 1 1 NO HOT_DB_BK_LEVEL0
46808 B 0 A SBT_TAPE 2026-05-22 06:28:18 1 1 NO HOT_DB_BK_LEVEL0
46809 B 0 A SBT_TAPE 2026-05-22 06:29:02 1 1 NO HOT_DB_BK_LEVEL0
46810 B 0 A SBT_TAPE 2026-05-22 06:30:06 1 1 NO HOT_DB_BK_LEVEL0
46811 B 0 A SBT_TAPE 2026-05-22 06:33:48 1 1 NO HOT_DB_BK_LEVEL0
46812 B 0 A SBT_TAPE 2026-05-22 06:34:13 1 1 NO HOT_DB_BK_LEVEL0
46813 B 0 A SBT_TAPE 2026-05-22 06:35:55 1 1 NO HOT_DB_BK_LEVEL0
46814 B 0 A SBT_TAPE 2026-05-22 06:36:31 1 1 NO HOT_DB_BK_LEVEL0
46815 B 0 A SBT_TAPE 2026-05-22 06:37:37 1 1 NO HOT_DB_BK_LEVEL0
46816 B 0 A SBT_TAPE 2026-05-22 06:38:04 1 1 NO HOT_DB_BK_LEVEL0
46817 B 0 A SBT_TAPE 2026-05-22 06:38:22 1 1 NO HOT_DB_BK_LEVEL0
46818 B 0 A SBT_TAPE 2026-05-22 06:38:43 1 1 NO HOT_DB_BK_LEVEL0
46819 B 0 A SBT_TAPE 2026-05-22 06:39:13 1 1 NO HOT_DB_BK_LEVEL0
46820 B 0 A SBT_TAPE 2026-05-22 06:39:14 1 1 NO HOT_DB_BK_LEVEL0
46821 B 0 A SBT_TAPE 2026-05-22 06:39:28 1 1 NO HOT_DB_BK_LEVEL0
46822 B 0 A SBT_TAPE 2026-05-22 06:39:29 1 1 NO HOT_DB_BK_LEVEL0
46823 B 0 A SBT_TAPE 2026-05-22 06:39:37 1 1 NO HOT_DB_BK_LEVEL0
46824 B 0 A SBT_TAPE 2026-05-22 06:39:39 1 1 NO HOT_DB_BK_LEVEL0
46825 B 0 A SBT_TAPE 2026-05-22 06:39:47 1 1 NO HOT_DB_BK_LEVEL0
46826 B 0 A SBT_TAPE 2026-05-22 06:39:50 1 1 NO HOT_DB_BK_LEVEL0
46827 B 0 A SBT_TAPE 2026-05-22 06:39:57 1 1 NO HOT_DB_BK_LEVEL0
46828 B 0 A SBT_TAPE 2026-05-22 06:39:58 1 1 NO HOT_DB_BK_LEVEL0
46829 B F A SBT_TAPE 2026-05-22 06:40:13 1 1 NO TAG20260522T064006
46830 B A A SBT_TAPE 2026-05-22 06:41:15 1 1 NO TAG20260522T064023
46831 B A A SBT_TAPE 2026-05-22 06:41:21 1 1 NO TAG20260522T064023
46832 B A A SBT_TAPE 2026-05-22 06:42:36 1 1 NO TAG20260522T064023
46833 B A A SBT_TAPE 2026-05-22 06:42:39 1 1 NO TAG20260522T064023
46834 B A A SBT_TAPE 2026-05-22 06:43:41 1 1 NO TAG20260522T064023
46835 B A A SBT_TAPE 2026-05-22 06:43:43 1 1 NO TAG20260522T064023
46836 B F A SBT_TAPE 2026-05-22 06:44:01 1 1 NO TAG20260522T064354
46837 B F A SBT_TAPE 2026-05-22 06:44:18 1 1 NO TAG20260522T064410
46838 B F A SBT_TAPE 2026-05-22 06:44:34 1 1 NO TAG20260522T064426
RMAN>
从备份信息看，本库备份设备类型主要是：
Device Type = SBT_TAPE
也就是通过 NetBackup 介质管理器进行备份，不是普通磁盘备份。备份摘要中可以看到大量 SBT_TAPE 备份集，并且近期备份状态为 AVAILABLE。
继续查看指定时间段归档：
RMAN> LIST BACKUP OF ARCHIVELOG FROM TIME "TO_DATE('2026-05-21 00:00:00','YYYY-MM-DD HH24:MI:SS')"
UNTIL TIME "TO_DATE('2026-05-21 15:00:00','YYYY-MM-DD HH24:MI:SS')";2>
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
46778 1.79G SBT_TAPE 00:01:15 2026-05-21 06:41:53
BP Key: 46778 Status: AVAILABLE Compressed: NO Tag: TAG20260521T063922
Handle: al_46789_1_1233816038 Media: @aaaab
List of Archived Logs in backup set 46778
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 73535 24508901526942 2026-05-20 23:34:01 24508901818144 2026-05-21 00:10:49
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
46779 1.44G SBT_TAPE 00:00:55 2026-05-21 06:42:54
BP Key: 46779 Status: AVAILABLE Compressed: NO Tag: TAG20260521T063922
Handle: al_46791_1_1233816119 Media: @aaaab
List of Archived Logs in backup set 46779
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 73536 24508901818144 2026-05-21 00:10:49 24508901827779 2026-05-21 00:10:58
1 73537 24508901827779 2026-05-21 00:10:58 24508901877269 2026-05-21 00:20:55
1 73538 24508901877269 2026-05-21 00:20:55 24508902122304 2026-05-21 01:10:49
1 73539 24508902122304 2026-05-21 01:10:49 24508902764591 2026-05-21 02:53:13
1 73540 24508902764591 2026-05-21 02:53:13 24508903028376 2026-05-21 03:35:13
1 73541 24508903028376 2026-05-21 03:35:13 24508903028514 2026-05-21 03:35:25
1 73542 24508903028514 2026-05-21 03:35:25 24508903028671 2026-05-21 03:35:40
1 73543 24508903028671 2026-05-21 03:35:40 24508903499100 2026-05-21 05:00:49
1 73544 24508903499100 2026-05-21 05:00:49 24508903779784 2026-05-21 05:31:19
1 73545 24508903779784 2026-05-21 05:31:19 24508903853890 2026-05-21 05:40:49
1 73546 24508903853890 2026-05-21 05:40:49 24508904184632 2026-05-21 05:55:58
1 73547 24508904184632 2026-05-21 05:55:58 24508904396323 2026-05-21 06:25:07
1 73548 24508904396323 2026-05-21 06:25:07 24508904398777 2026-05-21 06:25:10
1 73549 24508904398777 2026-05-21 06:25:10 24508904401249 2026-05-21 06:25:13
1 73550 24508904401249 2026-05-21 06:25:13 24508904477477 2026-05-21 06:39:21
1 73551 24508904477477 2026-05-21 06:39:21 24508904477522 2026-05-21 06:39:22
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
46830 1.76G SBT_TAPE 00:00:51 2026-05-22 06:41:15
BP Key: 46830 Status: AVAILABLE Compressed: NO Tag: TAG20260522T064023
Handle: al_46842_1_1233902424 Media: @aaaab
List of Archived Logs in backup set 46830
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 73571 24508908130311 2026-05-21 11:00:05 24508908169379 2026-05-21 11:02:08
1 73572 24508908169379 2026-05-21 11:02:08 24508908229487 2026-05-21 11:05:38
1 73573 24508908229487 2026-05-21 11:05:38 24508908276823 2026-05-21 11:07:47
1 73574 24508908276823 2026-05-21 11:07:47 24508908314865 2026-05-21 11:10:23
1 73575 24508908314865 2026-05-21 11:10:23 24508908393936 2026-05-21 11:13:41
1 73576 24508908393936 2026-05-21 11:13:41 24508908453938 2026-05-21 11:18:02
1 73577 24508908453938 2026-05-21 11:18:02 24508908511409 2026-05-21 11:22:02
1 73578 24508908511409 2026-05-21 11:22:02 24508908592655 2026-05-21 11:26:17
1 73579 24508908592655 2026-05-21 11:26:17 24508908878337 2026-05-21 11:33:47
1 73580 24508908878337 2026-05-21 11:33:47 24508909630923 2026-05-21 11:49:14
1 73581 24508909630923 2026-05-21 11:49:14 24508911067083 2026-05-21 12:10:05
1 73582 24508911067083 2026-05-21 12:10:05 24508911324881 2026-05-21 12:49:08
1 73583 24508911324881 2026-05-21 12:49:08 24508911618585 2026-05-21 13:00:05
1 73584 24508911618585 2026-05-21 13:00:05 24508911746737 2026-05-21 13:05:26
1 73585 24508911746737 2026-05-21 13:05:26 24508911805442 2026-05-21 13:10:08
1 73586 24508911805442 2026-05-21 13:10:08 24508911863994 2026-05-21 13:13:41
1 73587 24508911863994 2026-05-21 13:13:41 24508911937944 2026-05-21 13:18:05
1 73588 24508911937944 2026-05-21 13:18:05 24508911996002 2026-05-21 13:21:53
1 73589 24508911996002 2026-05-21 13:21:53 24508912058065 2026-05-21 13:26:23
1 73590 24508912058065 2026-05-21 13:26:23 24508912136291 2026-05-21 13:38:11
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
46833 1.70G SBT_TAPE 00:01:10 2026-05-22 06:42:39
BP Key: 46833 Status: AVAILABLE Compressed: NO Tag: TAG20260522T064023
Handle: al_46844_1_1233902489 Media: @aaaab
List of Archived Logs in backup set 46833
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 73552 24508904477522 2026-05-21 06:39:22 24508905242162 2026-05-21 08:24:01
1 73553 24508905242162 2026-05-21 08:24:01 24508905550289 2026-05-21 08:41:07
1 73554 24508905550289 2026-05-21 08:41:07 24508905815984 2026-05-21 08:56:10
1 73555 24508905815984 2026-05-21 08:56:10 24508905849310 2026-05-21 09:00:07
1 73556 24508905849310 2026-05-21 09:00:07 24508905977458 2026-05-21 09:05:04
1 73557 24508905977458 2026-05-21 09:05:04 24508906035024 2026-05-21 09:08:53
1 73558 24508906035024 2026-05-21 09:08:53 24508906107065 2026-05-21 09:12:35
1 73559 24508906107065 2026-05-21 09:12:35 24508906170735 2026-05-21 09:17:14
1 73560 24508906170735 2026-05-21 09:17:14 24508906230231 2026-05-21 09:21:23
1 73561 24508906230231 2026-05-21 09:21:23 24508906308019 2026-05-21 09:25:59
1 73562 24508906308019 2026-05-21 09:25:59 24508906390587 2026-05-21 09:33:05
1 73563 24508906390587 2026-05-21 09:33:05 24508906553555 2026-05-21 09:42:47
1 73564 24508906553555 2026-05-21 09:42:47 24508907061821 2026-05-21 09:54:59
1 73565 24508907061821 2026-05-21 09:54:59 24508907158574 2026-05-21 10:03:56
1 73566 24508907158574 2026-05-21 10:03:56 24508907265742 2026-05-21 10:16:23
1 73567 24508907265742 2026-05-21 10:16:23 24508907630532 2026-05-21 10:29:56
1 73568 24508907630532 2026-05-21 10:29:56 24508907828480 2026-05-21 10:40:56
1 73569 24508907828480 2026-05-21 10:40:56 24508908040703 2026-05-21 10:52:08
1 73570 24508908040703 2026-05-21 10:52:08 24508908130311 2026-05-21 11:00:05
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
46835 1.70G SBT_TAPE 00:00:58 2026-05-22 06:43:43
BP Key: 46835 Status: AVAILABLE Compressed: NO Tag: TAG20260522T064023
Handle: al_46845_1_1233902565 Media: @aaaab
List of Archived Logs in backup set 46835
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 73591 24508912136291 2026-05-21 13:38:11 24508912431890 2026-05-21 13:47:05
1 73592 24508912431890 2026-05-21 13:47:05 24508912500490 2026-05-21 13:55:20
1 73593 24508912500490 2026-05-21 13:55:20 24508912593258 2026-05-21 14:02:53
1 73594 24508912593258 2026-05-21 14:02:53 24508912832247 2026-05-21 14:08:50
1 73595 24508912832247 2026-05-21 14:08:50 24508912924568 2026-05-21 14:17:29
1 73596 24508912924568 2026-05-21 14:17:29 24508913118341 2026-05-21 14:28:02
1 73597 24508913118341 2026-05-21 14:28:02 24508913591529 2026-05-21 14:41:20
1 73598 24508913591529 2026-05-21 14:41:20 24508913746380 2026-05-21 14:49:20
1 73599 24508913746380 2026-05-21 14:49:20 24508913935125 2026-05-21 15:00:02
RMAN> exit
Recovery Manager complete.
[oracle@wmsdb2019 backup]$
关键归档信息如下：
BS Key : 46835 Device : SBT_TAPE Status : AVAILABLE Handle : al_46845_1_1233902565 Thread Sequence Low Time Next Time ------ -------- ------------------- ------------------- 1 73591 2026-05-21 13:38:11 2026-05-21 13:47:05 1 73592 2026-05-21 13:47:05 2026-05-21 13:55:20 1 73593 2026-05-21 13:55:20 2026-05-21 14:02:53 1 73594 2026-05-21 14:02:53 2026-05-21 14:08:50 1 73595 2026-05-21 14:08:50 2026-05-21 14:17:29 1 73596 2026-05-21 14:17:29 2026-05-21 14:28:02 1 73597 2026-05-21 14:28:02 2026-05-21 14:41:20 1 73598 2026-05-21 14:41:20 2026-05-21 14:49:20 1 73599 2026-05-21 14:49:20 2026-05-21 15:00:02
视图修改时间是 2026-05-21 14:48:47，归档 sequence 73598 覆盖 14:41:20 到 14:49:20，因此归档链满足恢复到修改前时间点的要求。
五、恢复时间点选择
但本次只需要取视图定义，不关心 14:45 到 14:48 之间的数据变化，所以为了避开 DDL 边界时间，最终选择恢复到更早一点：
SET UNTIL TIME "to_date('2026-05-21 14:45:00','yyyy-mm-dd hh24:mi:ss')";
判断原则：
| 判断点 | 说明 |
|---|---|
| 必须早于误修改时间 | 避免恢复到错误 DDL 已提交之后 |
| 不必精确到秒 | 只是为了取旧视图定义 |
| 建议提前几分钟 | 避免时间精度、提交时刻、时区显示等边界问题 |
| 归档必须覆盖该时间点 | 本例 sequence 73598 覆盖目标时间 |
六、创建辅助库参数文件
确认空间：
[oracle@wmsdb2019 backup]$ df -h 文件系统 容量 已用 可用 已用% 挂载点 devtmpfs 126G 0 126G 0% /dev tmpfs 126G 0 126G 0% /dev/shm tmpfs 126G 290M 126G 1% /run tmpfs 126G 0 126G 0% /sys/fs/cgroup /dev/mapper/rhel-root 50G 20G 31G 39% / /dev/mapper/rhel-u01 2.5T 987G 1.5T 41% /u01 /dev/mapper/rhel-home 10G 8.0G 2.1G 80% /home /dev/sda1 497M 217M 280M 44% /boot /dev/mapper/vg_backup-lv_backup 800G 167G 634G 21% /backup tmpfs 26G 12K 26G 1% /run/user/42 tmpfs 26G 0 26G 0% /run/user/0 [oracle@wmsdb2019 backup]$
结论还有1.5T够辅助库恢复。
创建目录：
mkdir -p /u01/app/oracle/oradata/WMSAUX mkdir -p /u01/app/oracle/fast_recovery_area/WMSAUX mkdir -p /u01/app/oracle/admin/WMSAUX/adump [oracle@wmsdb2019 rman]$ mkdir -p /u01/app/oracle/oradata/WMSAUX [oracle@wmsdb2019 rman]$ mkdir -p /u01/app/oracle/fast_recovery_area/WMSAUX [oracle@wmsdb2019 rman]$ mkdir -p /u01/app/oracle/admin/WMSAUX/adump [oracle@wmsdb2019 rman]$
创建 pfile：
vi $ORACLE_HOME/dbs/initWMSAUX.ora
内容如下：
db_name='WMSAUX'
db_unique_name='WMSAUX'
memory_target=8G
control_files='/u01/app/oracle/oradata/WMSAUX/control01.ctl','/u01/app/oracle/oradata/WMSAUX/control02.ctl'
audit_file_dest='/u01/app/oracle/admin/WMSAUX/adump'
db_create_file_dest='/u01/app/oracle/oradata/WMSAUX'
db_recovery_file_dest='/u01/app/oracle/fast_recovery_area/WMSAUX'
db_recovery_file_dest_size=100G
db_file_name_convert='/u01/app/oracle/oradata/WMPROD','/u01/app/oracle/oradata/WMSAUX'
log_file_name_convert='/u01/app/oracle/oradata/WMPROD','/u01/app/oracle/oradata/WMSAUX'
compatible='18.0.0'
[oracle@wmsdb2019 rman]$ vi $ORACLE_HOME/dbs/initWMSAUX.ora
[oracle@wmsdb2019 rman]$ cat $ORACLE_HOME/dbs/initWMSAUX.ora
db_name='WMSAUX'
db_unique_name='WMSAUX'
memory_target=8G
control_files='/u01/app/oracle/oradata/WMSAUX/control01.ctl','/u01/app/oracle/oradata/WMSAUX/control02.ctl'
audit_file_dest='/u01/app/oracle/admin/WMSAUX/adump'
db_create_file_dest='/u01/app/oracle/oradata/WMSAUX'
db_recovery_file_dest='/u01/app/oracle/fast_recovery_area/WMSAUX'
db_recovery_file_dest_size=100G
db_file_name_convert='/u01/app/oracle/oradata/WMPROD','/u01/app/oracle/oradata/WMSAUX'
log_file_name_convert='/u01/app/oracle/oradata/WMPROD','/u01/app/oracle/oradata/WMSAUX'
compatible='18.0.0'
[oracle@wmsdb2019 rman]$
启动辅助实例到 NOMOUNT：
export ORACLE_SID=WMSAUX
sqlplus / as sysdba
startup nomount pfile='$ORACLE_HOME/dbs/initWMSAUX.ora';
exit
输出：
[oracle@wmsdb2019 rman]$ export ORACLE_SID=WMSAUX
[oracle@wmsdb2019 rman]$ sqlplus / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Fri May 22 15:20:34 2026
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile='$ORACLE_HOME/dbs/initWMSAUX.ora';
ORACLE instance started.
Total System Global Area 8589933416 bytes
Fixed Size 12217192 bytes
Variable Size 4882169856 bytes
Database Buffers 3657433088 bytes
Redo Buffers 38113280 bytes
SQL> exit
Disconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
[oracle@wmsdb2019 rman]$
七、执行 RMAN Duplicate
RMAN 连接到 target 指向生产库，auxiliary 指向辅助库
export ORACLE_SID=WMSAUX
rman target sys/****@wmprod auxiliary /
[oracle@wmsdb2019 ~]$ rman target sys/Sin0pharmYN@wmprod auxiliary /
Recovery Manager: Release 18.0.0.0.0 - Production on Fri May 22 15:55:25 2026
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
connected to target database: WMPROD (DBID=3080983586)
connected to auxiliary database: WMSAUX (not mounted)
RMAN>
由于备份走 NetBackup，因此需要分配 SBT_TAPE 辅助通道，并发送 NetBackup 参数。
实际执行脚本如下，密码已脱敏：
RUN {
SET UNTIL TIME "to_date('2026-05-21 14:45:00','yyyy-mm-dd hh24:mi:ss')";
ALLOCATE AUXILIARY CHANNEL aux00 TYPE 'SBT_TAPE';
ALLOCATE AUXILIARY CHANNEL aux01 TYPE 'SBT_TAPE';
SEND 'NB_ORA_SERV=nbu-master,NB_ORA_CLIENT=wmsdb2019';
DUPLICATE TARGET DATABASE TO WMSAUX
NOFILENAMECHECK;
RELEASE CHANNEL aux00;
RELEASE CHANNEL aux01;
}
恢复步骤结果：
[oracle@wmsdb2019 ~]$ rman target sys/******@wmprod auxiliary /
Recovery Manager: Release 18.0.0.0.0 - Production on Fri May 22 15:55:25 2026
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
connected to target database: WMPROD (DBID=3080983586)
connected to auxiliary database: WMSAUX (not mounted)
RMAN> RUN {
2> SET UNTIL TIME "to_date('2026-05-21 14:45:00','yyyy-mm-dd hh24:mi:ss')";
ALLOCATE AUXILIARY CHANNEL aux00 TYPE 'SBT_TAPE';
ALLOCATE AUXILIARY CHANNEL aux01 TYPE 'SBT_TAPE';
3>
4> SEND 'NB_ORA_SERV=nbu-master,NB_ORA_CLIENT=wmsdb2019';
DUPLICATE TARGET DATABASE TO WMSAUX
NOFILENAMECHECK;
5> 6> 7> 8> 9> 10> 11> 12> RELEASE CHANNEL aux00;
RELEASE CHANNEL aux01;
}13> 14>
executing command: SET until clause
using target database control file instead of recovery catalog
allocated channel: aux00
channel aux00: SID=977 device type=SBT_TAPE
channel aux00: Veritas NetBackup for Oracle - Release 8.0 (2016110921)
allocated channel: aux01
channel aux01: SID=4393 device type=SBT_TAPE
channel aux01: Veritas NetBackup for Oracle - Release 8.0 (2016110921)
sent command to channel: aux00
sent command to channel: aux01
Starting Duplicate Db at 2026-05-22 15:57:09
contents of Memory Script:
{
sql clone "create spfile from memory";
}
executing Memory Script
sql statement: create spfile from memory
contents of Memory Script:
{
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 8589933416 bytes
Fixed Size 12217192 bytes
Variable Size 4882169856 bytes
Database Buffers 3657433088 bytes
Redo Buffers 38113280 bytes
allocated channel: aux00
channel aux00: SID=5247 device type=SBT_TAPE
channel aux00: Veritas NetBackup for Oracle - Release 8.0 (2016110921)
allocated channel: aux01
channel aux01: SID=5369 device type=SBT_TAPE
channel aux01: Veritas NetBackup for Oracle - Release 8.0 (2016110921)
contents of Memory Script:
{
set until scn 24508913591529;
sql clone "alter system set db_name =
''WMPROD'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''WMSAUX'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone primary controlfile;
alter clone database mount;
}
executing Memory Script
executing command: SET until clause
sql statement: alter system set db_name = ''WMPROD'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''WMSAUX'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 8589933416 bytes
Fixed Size 12217192 bytes
Variable Size 4882169856 bytes
Database Buffers 3657433088 bytes
Redo Buffers 38113280 bytes
allocated channel: aux00
channel aux00: SID=5247 device type=SBT_TAPE
channel aux00: Veritas NetBackup for Oracle - Release 8.0 (2016110921)
allocated channel: aux01
channel aux01: SID=5369 device type=SBT_TAPE
channel aux01: Veritas NetBackup for Oracle - Release 8.0 (2016110921)
Starting restore at 2026-05-22 15:58:25
channel aux00: starting datafile backup set restore
channel aux00: restoring control file
channel aux00: reading from backup piece c-3080983586-20260521-02
channel aux00: piece handle=c-3080983586-20260521-02 tag=TAG20260521T064347
channel aux00: restored backup piece 1
channel aux00: restore complete, elapsed time: 00:00:15
output file name=/u01/app/oracle/oradata/WMSAUX/control01.ctl
output file name=/u01/app/oracle/oradata/WMSAUX/control02.ctl
Finished restore at 2026-05-22 15:58:42
database mounted
contents of Memory Script:
{
set until scn 24508913591529;
set newname for datafile 1 to
"/u01/app/oracle/oradata/WMSAUX/system01.dbf";
set newname for datafile 2 to
"/u01/app/oracle/oradata/WMSAUX/sysaux01.dbf";
set newname for datafile 3 to
"/u01/app/oracle/oradata/WMSAUX/undotbs01.dbf";
set newname for datafile 4 to
"/u01/app/oracle/oradata/WMSAUX/users01.dbf";
set newname for datafile 5 to
"/u01/app/oracle/oradata/WMSAUX/APPT_TXN_DT_TBS.dbf";
set newname for datafile 6 to
"/u01/app/oracle/oradata/WMSAUX/APPT_TXN_IDX_TBS.dbf";
set newname for datafile 7 to
"/u01/app/oracle/oradata/WMSAUX/CBO_TXN_DT_TBS01.dbf";
set newname for datafile 8 to
"/u01/app/oracle/oradata/WMSAUX/CBO_TXN_IDX_TBS01.dbf";
set newname for datafile 9 to
"/u01/app/oracle/oradata/WMSAUX/CM_BST4K_DT_TBS01.dbf";
set newname for datafile 10 to
"/u01/app/oracle/oradata/WMSAUX/CM_BST4K_IDX_TBS01.dbf";
set newname for datafile 11 to
"/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS01.dbf";
set newname for datafile 12 to
"/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS01.dbf";
set newname for datafile 13 to
"/u01/app/oracle/oradata/WMSAUX/LEMA_TXN_DT_TBS01.dbf";
set newname for datafile 14 to
"/u01/app/oracle/oradata/WMSAUX/LEMA_TXN_IDX_TBS01.dbf";
set newname for datafile 15 to
"/u01/app/oracle/oradata/WMSAUX/LLMDATA_TBS01.dbf";
set newname for datafile 16 to
"/u01/app/oracle/oradata/WMSAUX/LLMINDX_TBS01.dbf";
set newname for datafile 17 to
"/u01/app/oracle/oradata/WMSAUX/MLMDATA_TBS01.dbf";
set newname for datafile 18 to
"/u01/app/oracle/oradata/WMSAUX/MLMINDX_TBS01.dbf";
set newname for datafile 19 to
"/u01/app/oracle/oradata/WMSAUX/SLMDATA_TBS01.dbf";
set newname for datafile 20 to
"/u01/app/oracle/oradata/WMSAUX/SLMINDX_TBS01.dbf";
set newname for datafile 21 to
"/u01/app/oracle/oradata/WMSAUX/SLOT_DT_TBS.dbf";
set newname for datafile 22 to
"/u01/app/oracle/oradata/WMSAUX/SLOT_INDX_TBS.dbf";
set newname for datafile 23 to
"/u01/app/oracle/oradata/WMSAUX/TE_BST_DT_TBS01.dbf";
set newname for datafile 24 to
"/u01/app/oracle/oradata/WMSAUX/TE_BST_IDX_TBS01.dbf";
set newname for datafile 25 to
"/u01/app/oracle/oradata/WMSAUX/YMS_BST_DT_TBS01.dbf";
set newname for datafile 26 to
"/u01/app/oracle/oradata/WMSAUX/YMS_BST_IDX_TBS01.dbf";
set newname for datafile 27 to
"/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS02.dbf";
set newname for datafile 28 to
"/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS03.dbf";
set newname for datafile 29 to
"/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS04.dbf";
set newname for datafile 30 to
"/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS02.dbf";
set newname for datafile 31 to
"/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS03.dbf";
set newname for datafile 32 to
"/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS05.dbf";
set newname for datafile 33 to
"/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS06.dbf";
set newname for datafile 34 to
"/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS07.dbf";
set newname for datafile 35 to
"/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS08.dbf";
set newname for datafile 36 to
"/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS09.dbf";
set newname for datafile 37 to
"/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS10.dbf";
set newname for datafile 38 to
"/u01/app/oracle/oradata/WMSAUX/LLMINDX_TBS02.dbf";
set newname for datafile 39 to
"/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS04.dbf";
set newname for datafile 40 to
"/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS11.dbf";
set newname for datafile 41 to
"/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS12.dbf";
set newname for datafile 42 to
"/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS05.dbf";
set newname for datafile 43 to
"/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS06.dbf";
set newname for datafile 44 to
"/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS13.dbf";
set newname for datafile 45 to
"/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS14.dbf";
restore
clone database
;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 2026-05-22 15:58:46
channel aux00: starting datafile backup set restore
channel aux00: specifying datafile(s) to restore from backup set
channel aux00: restoring datafile 00029 to /u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS04.dbf
channel aux00: reading from backup piece bk_46741_1_1233798369
channel aux01: starting datafile backup set restore
channel aux01: specifying datafile(s) to restore from backup set
channel aux01: restoring datafile 00027 to /u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS02.dbf
channel aux01: reading from backup piece bk_46740_1_1233798369
channel aux01: piece handle=bk_46740_1_1233798369 tag=HOT_DB_BK_LEVEL0
channel aux01: restored backup piece 1
channel aux01: restore complete, elapsed time: 00:09:45
channel aux01: starting datafile backup set restore
channel aux01: specifying datafile(s) to restore from backup set
channel aux01: restoring datafile 00032 to /u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS05.dbf
channel aux01: reading from backup piece bk_46742_1_1233800254
channel aux00: piece handle=bk_46741_1_1233798369 tag=HOT_DB_BK_LEVEL0
channel aux00: restored backup piece 1
channel aux00: restore complete, elapsed time: 00:09:52
channel aux00: starting datafile backup set restore
channel aux00: specifying datafile(s) to restore from backup set
channel aux00: restoring datafile 00033 to /u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS06.dbf
channel aux00: reading from backup piece bk_46743_1_1233800262
channel aux01: piece handle=bk_46742_1_1233800254 tag=HOT_DB_BK_LEVEL0
channel aux01: restored backup piece 1
channel aux01: restore complete, elapsed time: 00:09:33
channel aux01: starting datafile backup set restore
channel aux01: specifying datafile(s) to restore from backup set
channel aux01: restoring datafile 00034 to /u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS07.dbf
channel aux01: reading from backup piece bk_46744_1_1233801897
channel aux00: piece handle=bk_46743_1_1233800262 tag=HOT_DB_BK_LEVEL0
channel aux00: restored backup piece 1
channel aux00: restore complete, elapsed time: 00:10:01
channel aux00: starting datafile backup set restore
channel aux00: specifying datafile(s) to restore from backup set
channel aux00: restoring datafile 00035 to /u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS08.dbf
channel aux00: reading from backup piece bk_46745_1_1233801904
channel aux01: piece handle=bk_46744_1_1233801897 tag=HOT_DB_BK_LEVEL0
channel aux01: restored backup piece 1
channel aux01: restore complete, elapsed time: 00:09:50
channel aux01: starting datafile backup set restore
channel aux01: specifying datafile(s) to restore from backup set
channel aux01: restoring datafile 00036 to /u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS09.dbf
channel aux01: reading from backup piece bk_46746_1_1233804120
channel aux00: piece handle=bk_46745_1_1233801904 tag=HOT_DB_BK_LEVEL0
channel aux00: restored backup piece 1
channel aux00: restore complete, elapsed time: 00:09:40
channel aux00: starting datafile backup set restore
channel aux00: specifying datafile(s) to restore from backup set
channel aux00: restoring datafile 00037 to /u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS10.dbf
channel aux00: reading from backup piece bk_46747_1_1233804127
channel aux01: piece handle=bk_46746_1_1233804120 tag=HOT_DB_BK_LEVEL0
channel aux01: restored backup piece 1
channel aux01: restore complete, elapsed time: 00:09:40
channel aux01: starting datafile backup set restore
channel aux01: specifying datafile(s) to restore from backup set
channel aux01: restoring datafile 00012 to /u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS01.dbf
channel aux01: reading from backup piece bk_46749_1_1233806347
channel aux00: piece handle=bk_46747_1_1233804127 tag=HOT_DB_BK_LEVEL0
channel aux00: restored backup piece 1
channel aux00: restore complete, elapsed time: 00:09:50
channel aux00: starting datafile backup set restore
channel aux00: specifying datafile(s) to restore from backup set
channel aux00: restoring datafile 00039 to /u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS04.dbf
channel aux00: reading from backup piece bk_46748_1_1233806252
channel aux01: piece handle=bk_46749_1_1233806347 tag=HOT_DB_BK_LEVEL0
channel aux01: restored backup piece 1
channel aux01: restore complete, elapsed time: 00:09:41
channel aux01: starting datafile backup set restore
channel aux01: specifying datafile(s) to restore from backup set
channel aux01: restoring datafile 00011 to /u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS01.dbf
channel aux01: reading from backup piece bk_46750_1_1233809403
channel aux00: piece handle=bk_46748_1_1233806252 tag=HOT_DB_BK_LEVEL0
channel aux00: restored backup piece 1
channel aux00: restore complete, elapsed time: 00:09:51
channel aux00: starting datafile backup set restore
channel aux00: specifying datafile(s) to restore from backup set
channel aux00: restoring datafile 00031 to /u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS03.dbf
channel aux00: reading from backup piece bk_46751_1_1233809448
channel aux01: piece handle=bk_46750_1_1233809403 tag=HOT_DB_BK_LEVEL0
channel aux01: restored backup piece 1
channel aux01: restore complete, elapsed time: 00:09:50
channel aux01: starting datafile backup set restore
channel aux01: specifying datafile(s) to restore from backup set
channel aux01: restoring datafile 00016 to /u01/app/oracle/oradata/WMSAUX/LLMINDX_TBS01.dbf
channel aux01: reading from backup piece bk_46753_1_1233810769
channel aux00: piece handle=bk_46751_1_1233809448 tag=HOT_DB_BK_LEVEL0
channel aux00: restored backup piece 1
channel aux00: restore complete, elapsed time: 00:09:40
channel aux00: starting datafile backup set restore
channel aux00: specifying datafile(s) to restore from backup set
channel aux00: restoring datafile 00030 to /u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS02.dbf
channel aux00: reading from backup piece bk_46752_1_1233810744
channel aux01: piece handle=bk_46753_1_1233810769 tag=HOT_DB_BK_LEVEL0
channel aux01: restored backup piece 1
channel aux01: restore complete, elapsed time: 00:09:40
channel aux01: starting datafile backup set restore
channel aux01: specifying datafile(s) to restore from backup set
channel aux01: restoring datafile 00038 to /u01/app/oracle/oradata/WMSAUX/LLMINDX_TBS02.dbf
channel aux01: reading from backup piece bk_46754_1_1233811904
channel aux00: piece handle=bk_46752_1_1233810744 tag=HOT_DB_BK_LEVEL0
channel aux00: restored backup piece 1
channel aux00: restore complete, elapsed time: 00:09:51
channel aux00: starting datafile backup set restore
channel aux00: specifying datafile(s) to restore from backup set
channel aux00: restoring datafile 00040 to /u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS11.dbf
channel aux00: reading from backup piece bk_46755_1_1233811904
channel aux01: piece handle=bk_46754_1_1233811904 tag=HOT_DB_BK_LEVEL0
channel aux01: restored backup piece 1
channel aux01: restore complete, elapsed time: 00:04:51
channel aux01: starting datafile backup set restore
channel aux01: specifying datafile(s) to restore from backup set
channel aux01: restoring datafile 00044 to /u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS13.dbf
channel aux01: reading from backup piece bk_46757_1_1233812955
channel aux00: piece handle=bk_46755_1_1233811904 tag=HOT_DB_BK_LEVEL0
channel aux00: restored backup piece 1
channel aux00: restore complete, elapsed time: 00:07:00
channel aux00: starting datafile backup set restore
channel aux00: specifying datafile(s) to restore from backup set
channel aux00: restoring datafile 00041 to /u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS12.dbf
channel aux00: reading from backup piece bk_46756_1_1233812309
channel aux01: piece handle=bk_46757_1_1233812955 tag=HOT_DB_BK_LEVEL0
channel aux01: restored backup piece 1
channel aux01: restore complete, elapsed time: 00:03:40
channel aux01: starting datafile backup set restore
channel aux01: specifying datafile(s) to restore from backup set
channel aux01: restoring datafile 00045 to /u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS14.dbf
channel aux01: reading from backup piece bk_46758_1_1233813200
channel aux01: piece handle=bk_46758_1_1233813200 tag=HOT_DB_BK_LEVEL0
channel aux01: restored backup piece 1
channel aux01: restore complete, elapsed time: 00:04:25
channel aux01: starting datafile backup set restore
channel aux01: specifying datafile(s) to restore from backup set
channel aux01: restoring datafile 00015 to /u01/app/oracle/oradata/WMSAUX/LLMDATA_TBS01.dbf
channel aux01: reading from backup piece bk_46759_1_1233813355
channel aux00: piece handle=bk_46756_1_1233812309 tag=HOT_DB_BK_LEVEL0
channel aux00: restored backup piece 1
channel aux00: restore complete, elapsed time: 00:06:05
channel aux00: starting datafile backup set restore
channel aux00: specifying datafile(s) to restore from backup set
channel aux00: restoring datafile 00019 to /u01/app/oracle/oradata/WMSAUX/SLMDATA_TBS01.dbf
channel aux00: reading from backup piece bk_46760_1_1233813470
channel aux00: piece handle=bk_46760_1_1233813470 tag=HOT_DB_BK_LEVEL0
channel aux00: restored backup piece 1
channel aux00: restore complete, elapsed time: 00:07:15
channel aux00: starting datafile backup set restore
channel aux00: specifying datafile(s) to restore from backup set
channel aux00: restoring datafile 00007 to /u01/app/oracle/oradata/WMSAUX/CBO_TXN_DT_TBS01.dbf
channel aux00: reading from backup piece bk_46762_1_1233814310
channel aux01: piece handle=bk_46759_1_1233813355 tag=HOT_DB_BK_LEVEL0
channel aux01: restored backup piece 1
channel aux01: restore complete, elapsed time: 00:08:11
channel aux01: starting datafile backup set restore
channel aux01: specifying datafile(s) to restore from backup set
channel aux01: restoring datafile 00008 to /u01/app/oracle/oradata/WMSAUX/CBO_TXN_IDX_TBS01.dbf
channel aux01: reading from backup piece bk_46763_1_1233814665
channel aux01: piece handle=bk_46763_1_1233814665 tag=HOT_DB_BK_LEVEL0
channel aux01: restored backup piece 1
channel aux01: restore complete, elapsed time: 00:03:06
channel aux01: starting datafile backup set restore
channel aux01: specifying datafile(s) to restore from backup set
channel aux01: restoring datafile 00002 to /u01/app/oracle/oradata/WMSAUX/sysaux01.dbf
channel aux01: reading from backup piece bk_46761_1_1233814255
channel aux00: piece handle=bk_46762_1_1233814310 tag=HOT_DB_BK_LEVEL0
channel aux00: restored backup piece 1
channel aux00: restore complete, elapsed time: 00:03:10
channel aux00: starting datafile backup set restore
channel aux00: specifying datafile(s) to restore from backup set
channel aux00: restoring datafile 00042 to /u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS05.dbf
channel aux00: reading from backup piece bk_46765_1_1233815046
channel aux00: piece handle=bk_46765_1_1233815046 tag=HOT_DB_BK_LEVEL0
channel aux00: restored backup piece 1
channel aux00: restore complete, elapsed time: 00:01:45
channel aux00: starting datafile backup set restore
channel aux00: specifying datafile(s) to restore from backup set
channel aux00: restoring datafile 00028 to /u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS03.dbf
channel aux00: reading from backup piece bk_46764_1_1233814971
channel aux00: piece handle=bk_46764_1_1233814971 tag=HOT_DB_BK_LEVEL0
channel aux00: restored backup piece 1
channel aux00: restore complete, elapsed time: 00:02:45
channel aux00: starting datafile backup set restore
channel aux00: specifying datafile(s) to restore from backup set
channel aux00: restoring datafile 00043 to /u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS06.dbf
channel aux00: reading from backup piece bk_46766_1_1233815181
channel aux01: piece handle=bk_46761_1_1233814255 tag=HOT_DB_BK_LEVEL0
channel aux01: restored backup piece 1
channel aux01: restore complete, elapsed time: 00:05:58
channel aux01: starting datafile backup set restore
channel aux01: specifying datafile(s) to restore from backup set
channel aux01: restoring datafile 00003 to /u01/app/oracle/oradata/WMSAUX/undotbs01.dbf
channel aux01: reading from backup piece bk_46768_1_1233815311
channel aux00: piece handle=bk_46766_1_1233815181 tag=HOT_DB_BK_LEVEL0
channel aux00: restored backup piece 1
channel aux00: restore complete, elapsed time: 00:01:50
channel aux00: starting datafile backup set restore
channel aux00: specifying datafile(s) to restore from backup set
channel aux00: restoring datafile 00020 to /u01/app/oracle/oradata/WMSAUX/SLMINDX_TBS01.dbf
channel aux00: reading from backup piece bk_46767_1_1233815286
channel aux01: piece handle=bk_46768_1_1233815311 tag=HOT_DB_BK_LEVEL0
channel aux01: restored backup piece 1
channel aux01: restore complete, elapsed time: 00:01:40
channel aux01: starting datafile backup set restore
channel aux01: specifying datafile(s) to restore from backup set
channel aux01: restoring datafile 00013 to /u01/app/oracle/oradata/WMSAUX/LEMA_TXN_DT_TBS01.dbf
channel aux01: reading from backup piece bk_46769_1_1233815546
channel aux00: piece handle=bk_46767_1_1233815286 tag=HOT_DB_BK_LEVEL0
channel aux00: restored backup piece 1
channel aux00: restore complete, elapsed time: 00:02:40
channel aux00: starting datafile backup set restore
channel aux00: specifying datafile(s) to restore from backup set
channel aux00: restoring datafile 00014 to /u01/app/oracle/oradata/WMSAUX/LEMA_TXN_IDX_TBS01.dbf
channel aux00: reading from backup piece bk_46770_1_1233815581
channel aux01: piece handle=bk_46769_1_1233815546 tag=HOT_DB_BK_LEVEL0
channel aux01: restored backup piece 1
channel aux01: restore complete, elapsed time: 00:01:25
channel aux01: starting datafile backup set restore
channel aux01: specifying datafile(s) to restore from backup set
channel aux01: restoring datafile 00023 to /u01/app/oracle/oradata/WMSAUX/TE_BST_DT_TBS01.dbf
channel aux01: reading from backup piece bk_46772_1_1233815702
channel aux01: piece handle=bk_46772_1_1233815702 tag=HOT_DB_BK_LEVEL0
channel aux01: restored backup piece 1
channel aux01: restore complete, elapsed time: 00:00:45
channel aux01: starting datafile backup set restore
channel aux01: specifying datafile(s) to restore from backup set
channel aux01: restoring datafile 00018 to /u01/app/oracle/oradata/WMSAUX/MLMINDX_TBS01.dbf
channel aux01: reading from backup piece bk_46771_1_1233815686
channel aux00: piece handle=bk_46770_1_1233815581 tag=HOT_DB_BK_LEVEL0
channel aux00: restored backup piece 1
channel aux00: restore complete, elapsed time: 00:01:00
channel aux00: starting datafile backup set restore
channel aux00: specifying datafile(s) to restore from backup set
channel aux00: restoring datafile 00001 to /u01/app/oracle/oradata/WMSAUX/system01.dbf
channel aux00: reading from backup piece bk_46773_1_1233815767
channel aux00: piece handle=bk_46773_1_1233815767 tag=HOT_DB_BK_LEVEL0
channel aux00: restored backup piece 1
channel aux00: restore complete, elapsed time: 00:00:35
channel aux00: starting datafile backup set restore
channel aux00: specifying datafile(s) to restore from backup set
channel aux00: restoring datafile 00017 to /u01/app/oracle/oradata/WMSAUX/MLMDATA_TBS01.dbf
channel aux00: reading from backup piece bk_46775_1_1233815827
channel aux01: piece handle=bk_46771_1_1233815686 tag=HOT_DB_BK_LEVEL0
channel aux01: restored backup piece 1
channel aux01: restore complete, elapsed time: 00:00:50
channel aux01: starting datafile backup set restore
channel aux01: specifying datafile(s) to restore from backup set
channel aux01: restoring datafile 00024 to /u01/app/oracle/oradata/WMSAUX/TE_BST_IDX_TBS01.dbf
channel aux01: reading from backup piece bk_46774_1_1233815812
channel aux00: piece handle=bk_46775_1_1233815827 tag=HOT_DB_BK_LEVEL0
channel aux00: restored backup piece 1
channel aux00: restore complete, elapsed time: 00:00:25
channel aux00: starting datafile backup set restore
channel aux00: specifying datafile(s) to restore from backup set
channel aux00: restoring datafile 00005 to /u01/app/oracle/oradata/WMSAUX/APPT_TXN_DT_TBS.dbf
channel aux00: reading from backup piece bk_46777_1_1233815872
channel aux01: piece handle=bk_46774_1_1233815812 tag=HOT_DB_BK_LEVEL0
channel aux01: restored backup piece 1
channel aux01: restore complete, elapsed time: 00:00:29
channel aux01: starting datafile backup set restore
channel aux01: specifying datafile(s) to restore from backup set
channel aux01: restoring datafile 00004 to /u01/app/oracle/oradata/WMSAUX/users01.dbf
channel aux01: reading from backup piece bk_46776_1_1233815872
channel aux00: piece handle=bk_46777_1_1233815872 tag=HOT_DB_BK_LEVEL0
channel aux00: restored backup piece 1
channel aux00: restore complete, elapsed time: 00:00:06
channel aux00: starting datafile backup set restore
channel aux00: specifying datafile(s) to restore from backup set
channel aux00: restoring datafile 00006 to /u01/app/oracle/oradata/WMSAUX/APPT_TXN_IDX_TBS.dbf
channel aux00: reading from backup piece bk_46778_1_1233815887
channel aux00: piece handle=bk_46778_1_1233815887 tag=HOT_DB_BK_LEVEL0
channel aux00: restored backup piece 1
channel aux00: restore complete, elapsed time: 00:00:07
channel aux00: starting datafile backup set restore
channel aux00: specifying datafile(s) to restore from backup set
channel aux00: restoring datafile 00009 to /u01/app/oracle/oradata/WMSAUX/CM_BST4K_DT_TBS01.dbf
channel aux00: reading from backup piece bk_46779_1_1233815894
channel aux01: piece handle=bk_46776_1_1233815872 tag=HOT_DB_BK_LEVEL0
channel aux01: restored backup piece 1
channel aux01: restore complete, elapsed time: 00:00:10
channel aux01: starting datafile backup set restore
channel aux01: specifying datafile(s) to restore from backup set
channel aux01: restoring datafile 00010 to /u01/app/oracle/oradata/WMSAUX/CM_BST4K_IDX_TBS01.dbf
channel aux01: reading from backup piece bk_46780_1_1233815897
channel aux00: piece handle=bk_46779_1_1233815894 tag=HOT_DB_BK_LEVEL0
channel aux00: restored backup piece 1
channel aux00: restore complete, elapsed time: 00:00:07
channel aux00: starting datafile backup set restore
channel aux00: specifying datafile(s) to restore from backup set
channel aux00: restoring datafile 00021 to /u01/app/oracle/oradata/WMSAUX/SLOT_DT_TBS.dbf
channel aux00: reading from backup piece bk_46781_1_1233815905
channel aux01: piece handle=bk_46780_1_1233815897 tag=HOT_DB_BK_LEVEL0
channel aux01: restored backup piece 1
channel aux01: restore complete, elapsed time: 00:00:07
channel aux01: starting datafile backup set restore
channel aux01: specifying datafile(s) to restore from backup set
channel aux01: restoring datafile 00022 to /u01/app/oracle/oradata/WMSAUX/SLOT_INDX_TBS.dbf
channel aux01: reading from backup piece bk_46782_1_1233815912
channel aux00: piece handle=bk_46781_1_1233815905 tag=HOT_DB_BK_LEVEL0
channel aux00: restored backup piece 1
channel aux00: restore complete, elapsed time: 00:00:07
channel aux00: starting datafile backup set restore
channel aux00: specifying datafile(s) to restore from backup set
channel aux00: restoring datafile 00025 to /u01/app/oracle/oradata/WMSAUX/YMS_BST_DT_TBS01.dbf
channel aux00: reading from backup piece bk_46783_1_1233815915
channel aux01: piece handle=bk_46782_1_1233815912 tag=HOT_DB_BK_LEVEL0
channel aux01: restored backup piece 1
channel aux01: restore complete, elapsed time: 00:00:07
channel aux01: starting datafile backup set restore
channel aux01: specifying datafile(s) to restore from backup set
channel aux01: restoring datafile 00026 to /u01/app/oracle/oradata/WMSAUX/YMS_BST_IDX_TBS01.dbf
channel aux01: reading from backup piece bk_46784_1_1233815930
channel aux00: piece handle=bk_46783_1_1233815915 tag=HOT_DB_BK_LEVEL0
channel aux00: restored backup piece 1
channel aux00: restore complete, elapsed time: 00:00:07
channel aux01: piece handle=bk_46784_1_1233815930 tag=HOT_DB_BK_LEVEL0
channel aux01: restored backup piece 1
channel aux01: restore complete, elapsed time: 00:00:07
Finished restore at 2026-05-22 17:42:44
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=46 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=47 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=48 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=49 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=50 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/APPT_TXN_DT_TBS.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=51 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/APPT_TXN_IDX_TBS.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=52 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/CBO_TXN_DT_TBS01.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=53 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/CBO_TXN_IDX_TBS01.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=54 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/CM_BST4K_DT_TBS01.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=55 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/CM_BST4K_IDX_TBS01.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=56 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS01.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=57 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS01.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=58 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_TXN_DT_TBS01.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=59 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_TXN_IDX_TBS01.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=60 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/LLMDATA_TBS01.dbf
datafile 16 switched to datafile copy
input datafile copy RECID=61 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/LLMINDX_TBS01.dbf
datafile 17 switched to datafile copy
input datafile copy RECID=62 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/MLMDATA_TBS01.dbf
datafile 18 switched to datafile copy
input datafile copy RECID=63 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/MLMINDX_TBS01.dbf
datafile 19 switched to datafile copy
input datafile copy RECID=64 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/SLMDATA_TBS01.dbf
datafile 20 switched to datafile copy
input datafile copy RECID=65 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/SLMINDX_TBS01.dbf
datafile 21 switched to datafile copy
input datafile copy RECID=66 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/SLOT_DT_TBS.dbf
datafile 22 switched to datafile copy
input datafile copy RECID=67 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/SLOT_INDX_TBS.dbf
datafile 23 switched to datafile copy
input datafile copy RECID=68 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/TE_BST_DT_TBS01.dbf
datafile 24 switched to datafile copy
input datafile copy RECID=69 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/TE_BST_IDX_TBS01.dbf
datafile 25 switched to datafile copy
input datafile copy RECID=70 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/YMS_BST_DT_TBS01.dbf
datafile 26 switched to datafile copy
input datafile copy RECID=71 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/YMS_BST_IDX_TBS01.dbf
datafile 27 switched to datafile copy
input datafile copy RECID=72 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS02.dbf
datafile 28 switched to datafile copy
input datafile copy RECID=73 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS03.dbf
datafile 29 switched to datafile copy
input datafile copy RECID=74 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS04.dbf
datafile 30 switched to datafile copy
input datafile copy RECID=75 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS02.dbf
datafile 31 switched to datafile copy
input datafile copy RECID=76 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS03.dbf
datafile 32 switched to datafile copy
input datafile copy RECID=77 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS05.dbf
datafile 33 switched to datafile copy
input datafile copy RECID=78 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS06.dbf
datafile 34 switched to datafile copy
input datafile copy RECID=79 STAMP=1233942164 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS07.dbf
datafile 35 switched to datafile copy
input datafile copy RECID=80 STAMP=1233942165 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS08.dbf
datafile 36 switched to datafile copy
input datafile copy RECID=81 STAMP=1233942165 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS09.dbf
datafile 37 switched to datafile copy
input datafile copy RECID=82 STAMP=1233942165 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS10.dbf
datafile 38 switched to datafile copy
input datafile copy RECID=83 STAMP=1233942165 file name=/u01/app/oracle/oradata/WMSAUX/LLMINDX_TBS02.dbf
datafile 39 switched to datafile copy
input datafile copy RECID=84 STAMP=1233942165 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS04.dbf
datafile 40 switched to datafile copy
input datafile copy RECID=85 STAMP=1233942165 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS11.dbf
datafile 41 switched to datafile copy
input datafile copy RECID=86 STAMP=1233942165 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS12.dbf
datafile 42 switched to datafile copy
input datafile copy RECID=87 STAMP=1233942165 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS05.dbf
datafile 43 switched to datafile copy
input datafile copy RECID=88 STAMP=1233942165 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS06.dbf
datafile 44 switched to datafile copy
input datafile copy RECID=89 STAMP=1233942165 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS13.dbf
datafile 45 switched to datafile copy
input datafile copy RECID=90 STAMP=1233942165 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS14.dbf
contents of Memory Script:
{
set until time "to_date('MAY 21 2026 14:45:00', 'MON DD YYYY HH24:MI:SS')";
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 2026-05-22 17:42:45
starting media recovery
channel aux00: starting archived log restore to default destination
channel aux00: restoring archived log
archived log thread=1 sequence=73539
channel aux00: restoring archived log
archived log thread=1 sequence=73540
channel aux00: restoring archived log
archived log thread=1 sequence=73541
channel aux00: restoring archived log
archived log thread=1 sequence=73542
channel aux00: restoring archived log
archived log thread=1 sequence=73543
channel aux00: restoring archived log
archived log thread=1 sequence=73544
channel aux00: restoring archived log
archived log thread=1 sequence=73545
channel aux00: restoring archived log
archived log thread=1 sequence=73546
channel aux00: restoring archived log
archived log thread=1 sequence=73547
channel aux00: restoring archived log
archived log thread=1 sequence=73548
channel aux00: restoring archived log
archived log thread=1 sequence=73549
channel aux00: restoring archived log
archived log thread=1 sequence=73550
channel aux00: restoring archived log
archived log thread=1 sequence=73551
channel aux00: reading from backup piece al_46791_1_1233816119
channel aux01: starting archived log restore to default destination
channel aux01: restoring archived log
archived log thread=1 sequence=73552
channel aux01: restoring archived log
archived log thread=1 sequence=73553
channel aux01: restoring archived log
archived log thread=1 sequence=73554
channel aux01: restoring archived log
archived log thread=1 sequence=73555
channel aux01: restoring archived log
archived log thread=1 sequence=73556
channel aux01: restoring archived log
archived log thread=1 sequence=73557
channel aux01: restoring archived log
archived log thread=1 sequence=73558
channel aux01: restoring archived log
archived log thread=1 sequence=73559
channel aux01: restoring archived log
archived log thread=1 sequence=73560
channel aux01: restoring archived log
archived log thread=1 sequence=73561
channel aux01: restoring archived log
archived log thread=1 sequence=73562
channel aux01: restoring archived log
archived log thread=1 sequence=73563
channel aux01: restoring archived log
archived log thread=1 sequence=73564
channel aux01: restoring archived log
archived log thread=1 sequence=73565
channel aux01: restoring archived log
archived log thread=1 sequence=73566
channel aux01: restoring archived log
archived log thread=1 sequence=73567
channel aux01: restoring archived log
archived log thread=1 sequence=73568
channel aux01: restoring archived log
archived log thread=1 sequence=73569
channel aux01: restoring archived log
archived log thread=1 sequence=73570
channel aux01: reading from backup piece al_46844_1_1233902489
channel aux00: piece handle=al_46791_1_1233816119 tag=TAG20260521T063922
channel aux00: restored backup piece 1
channel aux00: restore complete, elapsed time: 00:00:35
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73539_o1099dtn_.arc thread=1 sequence=73539
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73539_o1099dtn_.arc RECID=147053 STAMP=1233942200
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73540_o1098y54_.arc thread=1 sequence=73540
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73540_o1098y54_.arc RECID=147034 STAMP=1233942187
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73541_o1098y62_.arc thread=1 sequence=73541
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73541_o1098y62_.arc RECID=147033 STAMP=1233942186
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73542_o1098y4f_.arc thread=1 sequence=73542
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73542_o1098y4f_.arc RECID=147035 STAMP=1233942187
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73543_o1099c1w_.arc thread=1 sequence=73543
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73543_o1099c1w_.arc RECID=147050 STAMP=1233942199
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73544_o1099bsr_.arc thread=1 sequence=73544
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73544_o1099bsr_.arc RECID=147051 STAMP=1233942200
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73545_o1099cdz_.arc thread=1 sequence=73545
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73545_o1099cdz_.arc RECID=147049 STAMP=1233942199
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73546_o1099d5b_.arc thread=1 sequence=73546
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73546_o1099d5b_.arc RECID=147052 STAMP=1233942200
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73547_o1098y20_.arc thread=1 sequence=73547
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73547_o1098y20_.arc RECID=147045 STAMP=1233942192
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73548_o1098y3l_.arc thread=1 sequence=73548
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73548_o1098y3l_.arc RECID=147036 STAMP=1233942188
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73549_o1098y2x_.arc thread=1 sequence=73549
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73549_o1098y2x_.arc RECID=147037 STAMP=1233942188
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73550_o1099hgd_.arc thread=1 sequence=73550
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73550_o1099hgd_.arc RECID=147048 STAMP=1233942199
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73551_o1099job_.arc thread=1 sequence=73551
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73551_o1099job_.arc RECID=147046 STAMP=1233942192
channel aux00: starting archived log restore to default destination
channel aux00: restoring archived log
archived log thread=1 sequence=73571
channel aux00: restoring archived log
archived log thread=1 sequence=73572
channel aux00: restoring archived log
archived log thread=1 sequence=73573
channel aux00: restoring archived log
archived log thread=1 sequence=73574
channel aux00: restoring archived log
archived log thread=1 sequence=73575
channel aux00: restoring archived log
archived log thread=1 sequence=73576
channel aux00: restoring archived log
archived log thread=1 sequence=73577
channel aux00: restoring archived log
archived log thread=1 sequence=73578
channel aux00: restoring archived log
archived log thread=1 sequence=73579
channel aux00: restoring archived log
archived log thread=1 sequence=73580
channel aux00: restoring archived log
archived log thread=1 sequence=73581
channel aux00: restoring archived log
archived log thread=1 sequence=73582
channel aux00: restoring archived log
archived log thread=1 sequence=73583
channel aux00: restoring archived log
archived log thread=1 sequence=73584
channel aux00: restoring archived log
archived log thread=1 sequence=73585
channel aux00: restoring archived log
archived log thread=1 sequence=73586
channel aux00: restoring archived log
archived log thread=1 sequence=73587
channel aux00: restoring archived log
archived log thread=1 sequence=73588
channel aux00: restoring archived log
archived log thread=1 sequence=73589
channel aux00: restoring archived log
archived log thread=1 sequence=73590
channel aux00: reading from backup piece al_46842_1_1233902424
channel aux01: piece handle=al_46844_1_1233902489 tag=TAG20260522T064023
channel aux01: restored backup piece 1
channel aux01: restore complete, elapsed time: 00:00:47
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73552_o1099j8b_.arc thread=1 sequence=73552
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73552_o1099j8b_.arc RECID=147060 STAMP=1233942209
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73553_o1098z33_.arc thread=1 sequence=73553
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73553_o1098z33_.arc RECID=147044 STAMP=1233942192
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73554_o1098z43_.arc thread=1 sequence=73554
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73554_o1098z43_.arc RECID=147043 STAMP=1233942191
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73555_o1098z6b_.arc thread=1 sequence=73555
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73555_o1098z6b_.arc RECID=147042 STAMP=1233942191
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73556_o1099ntx_.arc thread=1 sequence=73556
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73556_o1099ntx_.arc RECID=147061 STAMP=1233942211
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73557_o1098z9c_.arc thread=1 sequence=73557
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73557_o1098z9c_.arc RECID=147040 STAMP=1233942190
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73558_o1099hy2_.arc thread=1 sequence=73558
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73558_o1099hy2_.arc RECID=147059 STAMP=1233942209
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73559_o1099wsc_.arc thread=1 sequence=73559
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73559_o1099wsc_.arc RECID=147062 STAMP=1233942214
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73560_o1099gq0_.arc thread=1 sequence=73560
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73560_o1099gq0_.arc RECID=147056 STAMP=1233942205
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73561_o1098z88_.arc thread=1 sequence=73561
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73561_o1098z88_.arc RECID=147039 STAMP=1233942190
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73562_o1099gwf_.arc thread=1 sequence=73562
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73562_o1099gwf_.arc RECID=147054 STAMP=1233942204
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73563_o1099hnr_.arc thread=1 sequence=73563
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73563_o1099hnr_.arc RECID=147058 STAMP=1233942206
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73564_o1098z57_.arc thread=1 sequence=73564
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73564_o1098z57_.arc RECID=147041 STAMP=1233942191
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73565_o1099x0w_.arc thread=1 sequence=73565
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73565_o1099x0w_.arc RECID=147063 STAMP=1233942214
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73566_o1099xhm_.arc thread=1 sequence=73566
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73566_o1099xhm_.arc RECID=147064 STAMP=1233942214
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73567_o1098z76_.arc thread=1 sequence=73567
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73567_o1098z76_.arc RECID=147038 STAMP=1233942190
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73568_o1099hh2_.arc thread=1 sequence=73568
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73568_o1099hh2_.arc RECID=147057 STAMP=1233942206
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73569_o1099gkh_.arc thread=1 sequence=73569
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73569_o1099gkh_.arc RECID=147055 STAMP=1233942205
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73570_o1098z1x_.arc thread=1 sequence=73570
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73570_o1098z1x_.arc RECID=147047 STAMP=1233942196
channel aux01: starting archived log restore to default destination
channel aux01: restoring archived log
archived log thread=1 sequence=73591
channel aux01: restoring archived log
archived log thread=1 sequence=73592
channel aux01: restoring archived log
archived log thread=1 sequence=73593
channel aux01: restoring archived log
archived log thread=1 sequence=73594
channel aux01: restoring archived log
archived log thread=1 sequence=73595
channel aux01: restoring archived log
archived log thread=1 sequence=73596
channel aux01: restoring archived log
archived log thread=1 sequence=73597
channel aux01: restoring archived log
archived log thread=1 sequence=73598
channel aux01: reading from backup piece al_46845_1_1233902565
channel aux00: piece handle=al_46842_1_1233902424 tag=TAG20260522T064023
channel aux00: restored backup piece 1
channel aux00: restore complete, elapsed time: 00:00:42
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73571_o109bgo3_.arc thread=1 sequence=73571
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73571_o109bgo3_.arc RECID=147068 STAMP=1233942236
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73572_o109bw46_.arc thread=1 sequence=73572
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73572_o109bw46_.arc RECID=147073 STAMP=1233942249
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73573_o109c9tk_.arc thread=1 sequence=73573
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73573_o109c9tk_.arc RECID=147082 STAMP=1233942258
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73574_o109bwby_.arc thread=1 sequence=73574
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73574_o109bwby_.arc RECID=147075 STAMP=1233942250
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73575_o109cb1r_.arc thread=1 sequence=73575
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73575_o109cb1r_.arc RECID=147083 STAMP=1233942258
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73576_o109bvpt_.arc thread=1 sequence=73576
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73576_o109bvpt_.arc RECID=147074 STAMP=1233942249
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73577_o109bgoy_.arc thread=1 sequence=73577
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73577_o109bgoy_.arc RECID=147066 STAMP=1233942235
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73578_o109bgn4_.arc thread=1 sequence=73578
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73578_o109bgn4_.arc RECID=147069 STAMP=1233942236
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73579_o109bgm4_.arc thread=1 sequence=73579
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73579_o109bgm4_.arc RECID=147070 STAMP=1233942236
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73580_o109c9o2_.arc thread=1 sequence=73580
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73580_o109c9o2_.arc RECID=147081 STAMP=1233942258
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73581_o109by3z_.arc thread=1 sequence=73581
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73581_o109by3z_.arc RECID=147080 STAMP=1233942251
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73582_o109cb77_.arc thread=1 sequence=73582
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73582_o109cb77_.arc RECID=147084 STAMP=1233942258
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73583_o109bgjv_.arc thread=1 sequence=73583
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73583_o109bgjv_.arc RECID=147072 STAMP=1233942238
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73584_o109bgqm_.arc thread=1 sequence=73584
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73584_o109bgqm_.arc RECID=147065 STAMP=1233942235
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73585_o109bgpr_.arc thread=1 sequence=73585
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73585_o109bgpr_.arc RECID=147067 STAMP=1233942236
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73586_o109bwl8_.arc thread=1 sequence=73586
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73586_o109bwl8_.arc RECID=147077 STAMP=1233942250
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73587_o109bvxt_.arc thread=1 sequence=73587
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73587_o109bvxt_.arc RECID=147076 STAMP=1233942250
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73588_o109bwvc_.arc thread=1 sequence=73588
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73588_o109bwvc_.arc RECID=147078 STAMP=1233942250
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73589_o109bgl3_.arc thread=1 sequence=73589
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73589_o109bgl3_.arc RECID=147071 STAMP=1233942237
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73590_o109bx3b_.arc thread=1 sequence=73590
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73590_o109bx3b_.arc RECID=147079 STAMP=1233942250
channel aux01: piece handle=al_46845_1_1233902565 tag=TAG20260522T064023
channel aux01: restored backup piece 1
channel aux01: restore complete, elapsed time: 00:00:38
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73591_o109cs6t_.arc thread=1 sequence=73591
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73591_o109cs6t_.arc RECID=147087 STAMP=1233942273
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73592_o109cs9h_.arc thread=1 sequence=73592
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73592_o109cs9h_.arc RECID=147086 STAMP=1233942272
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73593_o109d05m_.arc thread=1 sequence=73593
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73593_o109d05m_.arc RECID=147088 STAMP=1233942278
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73594_o109cs89_.arc thread=1 sequence=73594
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73594_o109cs89_.arc RECID=147085 STAMP=1233942272
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73595_o109d11r_.arc thread=1 sequence=73595
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73595_o109d11r_.arc RECID=147090 STAMP=1233942279
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73596_o109d0c3_.arc thread=1 sequence=73596
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73596_o109d0c3_.arc RECID=147089 STAMP=1233942279
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73597_o109d6sx_.arc thread=1 sequence=73597
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73597_o109d6sx_.arc RECID=147091 STAMP=1233942283
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73598_o109d702_.arc thread=1 sequence=73598
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/WMSAUX/WMSAUX/archivelog/2026_05_22/o1_mf_1_73598_o109d702_.arc RECID=147092 STAMP=1233942283
media recovery complete, elapsed time: 00:00:19
Finished recover at 2026-05-22 17:45:16
released channel: aux00
released channel: aux01
Oracle instance started
Total System Global Area 8589933416 bytes
Fixed Size 12217192 bytes
Variable Size 4898947072 bytes
Database Buffers 3640655872 bytes
Redo Buffers 38113280 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''WMSAUX'' comment=
''Reset to original value by RMAN'' scope=spfile";
sql clone "alter system reset db_unique_name scope=spfile";
}
executing Memory Script
sql statement: alter system set db_name = ''WMSAUX'' comment= ''Reset to original value by RMAN'' scope=spfile
sql statement: alter system reset db_unique_name scope=spfile
Oracle instance started
Total System Global Area 8589933416 bytes
Fixed Size 12217192 bytes
Variable Size 4882169856 bytes
Database Buffers 3657433088 bytes
Redo Buffers 38113280 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "WMSAUX" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 1168
LOGFILE
GROUP 1 ( '/u01/app/oracle/oradata/WMSAUX/redo01.log' ) SIZE 200 M REUSE,
GROUP 2 ( '/u01/app/oracle/oradata/WMSAUX/redo02.log' ) SIZE 200 M REUSE,
GROUP 3 ( '/u01/app/oracle/oradata/WMSAUX/redo03.log' ) SIZE 200 M REUSE,
GROUP 4 ( '/u01/app/oracle/oradata/WMSAUX/redo4.log' ) SIZE 200 M REUSE,
GROUP 5 ( '/u01/app/oracle/oradata/WMSAUX/redo5.log' ) SIZE 200 M REUSE,
GROUP 6 ( '/u01/app/oracle/oradata/WMSAUX/redo6.log' ) SIZE 200 M REUSE
DATAFILE
'/u01/app/oracle/oradata/WMSAUX/system01.dbf'
CHARACTER SET AL32UTF8
contents of Memory Script:
{
set newname for tempfile 1 to
"/u01/app/oracle/oradata/WMSAUX/temp01.dbf";
set newname for tempfile 2 to
"/u01/app/oracle/oradata/WMSAUX/temp02.dbf";
switch clone tempfile all;
catalog clone datafilecopy "/u01/app/oracle/oradata/WMSAUX/sysaux01.dbf",
"/u01/app/oracle/oradata/WMSAUX/undotbs01.dbf",
"/u01/app/oracle/oradata/WMSAUX/users01.dbf",
"/u01/app/oracle/oradata/WMSAUX/APPT_TXN_DT_TBS.dbf",
"/u01/app/oracle/oradata/WMSAUX/APPT_TXN_IDX_TBS.dbf",
"/u01/app/oracle/oradata/WMSAUX/CBO_TXN_DT_TBS01.dbf",
"/u01/app/oracle/oradata/WMSAUX/CBO_TXN_IDX_TBS01.dbf",
"/u01/app/oracle/oradata/WMSAUX/CM_BST4K_DT_TBS01.dbf",
"/u01/app/oracle/oradata/WMSAUX/CM_BST4K_IDX_TBS01.dbf",
"/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS01.dbf",
"/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS01.dbf",
"/u01/app/oracle/oradata/WMSAUX/LEMA_TXN_DT_TBS01.dbf",
"/u01/app/oracle/oradata/WMSAUX/LEMA_TXN_IDX_TBS01.dbf",
"/u01/app/oracle/oradata/WMSAUX/LLMDATA_TBS01.dbf",
"/u01/app/oracle/oradata/WMSAUX/LLMINDX_TBS01.dbf",
"/u01/app/oracle/oradata/WMSAUX/MLMDATA_TBS01.dbf",
"/u01/app/oracle/oradata/WMSAUX/MLMINDX_TBS01.dbf",
"/u01/app/oracle/oradata/WMSAUX/SLMDATA_TBS01.dbf",
"/u01/app/oracle/oradata/WMSAUX/SLMINDX_TBS01.dbf",
"/u01/app/oracle/oradata/WMSAUX/SLOT_DT_TBS.dbf",
"/u01/app/oracle/oradata/WMSAUX/SLOT_INDX_TBS.dbf",
"/u01/app/oracle/oradata/WMSAUX/TE_BST_DT_TBS01.dbf",
"/u01/app/oracle/oradata/WMSAUX/TE_BST_IDX_TBS01.dbf",
"/u01/app/oracle/oradata/WMSAUX/YMS_BST_DT_TBS01.dbf",
"/u01/app/oracle/oradata/WMSAUX/YMS_BST_IDX_TBS01.dbf",
"/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS02.dbf",
"/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS03.dbf",
"/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS04.dbf",
"/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS02.dbf",
"/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS03.dbf",
"/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS05.dbf",
"/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS06.dbf",
"/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS07.dbf",
"/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS08.dbf",
"/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS09.dbf",
"/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS10.dbf",
"/u01/app/oracle/oradata/WMSAUX/LLMINDX_TBS02.dbf",
"/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS04.dbf",
"/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS11.dbf",
"/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS12.dbf",
"/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS05.dbf",
"/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS06.dbf",
"/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS13.dbf",
"/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS14.dbf";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
renamed tempfile 1 to /u01/app/oracle/oradata/WMSAUX/temp01.dbf in control file
renamed tempfile 2 to /u01/app/oracle/oradata/WMSAUX/temp02.dbf in control file
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/sysaux01.dbf RECID=1 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/undotbs01.dbf RECID=2 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/users01.dbf RECID=3 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/APPT_TXN_DT_TBS.dbf RECID=4 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/APPT_TXN_IDX_TBS.dbf RECID=5 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/CBO_TXN_DT_TBS01.dbf RECID=6 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/CBO_TXN_IDX_TBS01.dbf RECID=7 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/CM_BST4K_DT_TBS01.dbf RECID=8 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/CM_BST4K_IDX_TBS01.dbf RECID=9 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS01.dbf RECID=10 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS01.dbf RECID=11 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/LEMA_TXN_DT_TBS01.dbf RECID=12 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/LEMA_TXN_IDX_TBS01.dbf RECID=13 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/LLMDATA_TBS01.dbf RECID=14 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/LLMINDX_TBS01.dbf RECID=15 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/MLMDATA_TBS01.dbf RECID=16 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/MLMINDX_TBS01.dbf RECID=17 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/SLMDATA_TBS01.dbf RECID=18 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/SLMINDX_TBS01.dbf RECID=19 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/SLOT_DT_TBS.dbf RECID=20 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/SLOT_INDX_TBS.dbf RECID=21 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/TE_BST_DT_TBS01.dbf RECID=22 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/TE_BST_IDX_TBS01.dbf RECID=23 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/YMS_BST_DT_TBS01.dbf RECID=24 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/YMS_BST_IDX_TBS01.dbf RECID=25 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS02.dbf RECID=26 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS03.dbf RECID=27 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS04.dbf RECID=28 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS02.dbf RECID=29 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS03.dbf RECID=30 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS05.dbf RECID=31 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS06.dbf RECID=32 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS07.dbf RECID=33 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS08.dbf RECID=34 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS09.dbf RECID=35 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS10.dbf RECID=36 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/LLMINDX_TBS02.dbf RECID=37 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS04.dbf RECID=38 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS11.dbf RECID=39 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS12.dbf RECID=40 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS05.dbf RECID=41 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS06.dbf RECID=42 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS13.dbf RECID=43 STAMP=1233942360
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS14.dbf RECID=44 STAMP=1233942360
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/APPT_TXN_DT_TBS.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/APPT_TXN_IDX_TBS.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/CBO_TXN_DT_TBS01.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=7 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/CBO_TXN_IDX_TBS01.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=8 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/CM_BST4K_DT_TBS01.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=9 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/CM_BST4K_IDX_TBS01.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=10 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS01.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=11 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS01.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=12 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_TXN_DT_TBS01.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=13 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_TXN_IDX_TBS01.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=14 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/LLMDATA_TBS01.dbf
datafile 16 switched to datafile copy
input datafile copy RECID=15 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/LLMINDX_TBS01.dbf
datafile 17 switched to datafile copy
input datafile copy RECID=16 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/MLMDATA_TBS01.dbf
datafile 18 switched to datafile copy
input datafile copy RECID=17 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/MLMINDX_TBS01.dbf
datafile 19 switched to datafile copy
input datafile copy RECID=18 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/SLMDATA_TBS01.dbf
datafile 20 switched to datafile copy
input datafile copy RECID=19 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/SLMINDX_TBS01.dbf
datafile 21 switched to datafile copy
input datafile copy RECID=20 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/SLOT_DT_TBS.dbf
datafile 22 switched to datafile copy
input datafile copy RECID=21 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/SLOT_INDX_TBS.dbf
datafile 23 switched to datafile copy
input datafile copy RECID=22 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/TE_BST_DT_TBS01.dbf
datafile 24 switched to datafile copy
input datafile copy RECID=23 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/TE_BST_IDX_TBS01.dbf
datafile 25 switched to datafile copy
input datafile copy RECID=24 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/YMS_BST_DT_TBS01.dbf
datafile 26 switched to datafile copy
input datafile copy RECID=25 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/YMS_BST_IDX_TBS01.dbf
datafile 27 switched to datafile copy
input datafile copy RECID=26 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS02.dbf
datafile 28 switched to datafile copy
input datafile copy RECID=27 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS03.dbf
datafile 29 switched to datafile copy
input datafile copy RECID=28 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS04.dbf
datafile 30 switched to datafile copy
input datafile copy RECID=29 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS02.dbf
datafile 31 switched to datafile copy
input datafile copy RECID=30 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS03.dbf
datafile 32 switched to datafile copy
input datafile copy RECID=31 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS05.dbf
datafile 33 switched to datafile copy
input datafile copy RECID=32 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS06.dbf
datafile 34 switched to datafile copy
input datafile copy RECID=33 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS07.dbf
datafile 35 switched to datafile copy
input datafile copy RECID=34 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS08.dbf
datafile 36 switched to datafile copy
input datafile copy RECID=35 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS09.dbf
datafile 37 switched to datafile copy
input datafile copy RECID=36 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS10.dbf
datafile 38 switched to datafile copy
input datafile copy RECID=37 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/LLMINDX_TBS02.dbf
datafile 39 switched to datafile copy
input datafile copy RECID=38 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS04.dbf
datafile 40 switched to datafile copy
input datafile copy RECID=39 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS11.dbf
datafile 41 switched to datafile copy
input datafile copy RECID=40 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_STAT_DT_TBS12.dbf
datafile 42 switched to datafile copy
input datafile copy RECID=41 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS05.dbf
datafile 43 switched to datafile copy
input datafile copy RECID=42 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS06.dbf
datafile 44 switched to datafile copy
input datafile copy RECID=43 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS13.dbf
datafile 45 switched to datafile copy
input datafile copy RECID=44 STAMP=1233942360 file name=/u01/app/oracle/oradata/WMSAUX/LEMA_LGTXN_DT_TBS14.dbf
Reenabling controlfile options for auxiliary database
Executing: alter database add supplemental log data
Executing: alter database force logging
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Cannot remove created server parameter file
Finished Duplicate Db at 2026-05-22 17:46:08
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of release command at 05/22/2026 17:46:08
RMAN-06012: channel: aux00 not allocated
RMAN>
RMAN 自动恢复控制文件：
channel aux00: restoring control file channel aux00: reading from backup piece c-3080983586-20260521-02 output file name=/u01/app/oracle/oradata/WMSAUX/control01.ctl output file name=/u01/app/oracle/oradata/WMSAUX/control02.ctl database mounted
并自动把生产库数据文件转换到辅助库目录，例如：
/u01/app/oracle/oradata/WMSAUX/system01.dbf /u01/app/oracle/oradata/WMSAUX/sysaux01.dbf /u01/app/oracle/oradata/WMSAUX/undotbs01.dbf ...
这些路径来自 db_file_name_convert 和 RMAN Duplicate 自动生成的 set newname。
RMAN 最后输出：
Alter clone database open resetlogs;
database opened
Finished Duplicate Db at 2026-05-22 17:46:08
说明辅助库已经成功打开。后面出现了：
RMAN-06012: channel: aux00 not allocated
这是释放通道时的报错，不影响 Duplicate 成功，因为数据库已经 open resetlogs 并且 RMAN 明确显示 Finished Duplicate Db。
判断 Duplicate 成功的关键不是看是否完全没有报错，而是看以下几项：
| 检查点 | 结果 |
|---|---|
| target 是否为 WMPROD | 是 |
| auxiliary 是否为 WMSAUX | 是 |
| 控制文件是否恢复到 WMSAUX 目录 | 是 |
| 数据文件是否恢复到 WMSAUX 目录 | 是 |
| 是否完成 recover clone database | 是 |
| 是否 open resetlogs | 是 |
| 是否出现 Finished Duplicate Db | 是 |
八、从辅助库导出旧版视图 DDL
进入辅助库：
export ORACLE_SID=WMSAUX
sqlplus / as sysdba
[oracle@wmsdb2019 ~]$ export ORACLE_SID=WMSAUX
[oracle@wmsdb2019 ~]$ sqlplus / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Fri May 22 21:36:08 2026
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
SQL>
建议使用下面这种方式导出，避免 SQL 文件里带 SQL> 提示符：
set long 1000000
set longchunksize 1000000
set pages 0
set lines 300
set trimspool on
set heading off
set feedback off
set echo off
set termout off
set sqlprompt ''
exec dbms_metadata.set_transform_param(dbms_metadata.session_transform,'SQLTERMINATOR',true);
exec dbms_metadata.set_transform_param(dbms_metadata.session_transform,'PRETTY',true);
exec dbms_metadata.set_transform_param(dbms_metadata.session_transform,'EMIT_SCHEMA',true);
spool /tmp/V_YN_GSP_NBR_old_20260521_144500.sql
select dbms_metadata.get_ddl('VIEW','V_YN_GSP_NBR','WMPROD')
from dual;
spool off
SQL> set long 1000000
set longchunksize 1000000
set pages 0
set lines 300
set trimspool on
set heading off
set feedback off
exec dbms_metadata.set_transform_param(dbms_metadata.session_transform,'SQLTERMINATOR',true);SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL>
SQL> exec dbms_metadata.set_transform_param(dbms_metadata.session_transform,'PRETTY',true);
SQL> exec dbms_metadata.set_transform_param(dbms_metadata.session_transform,'EMIT_SCHEMA',true);
SQL> spool /tmp/V_YN_GSP_NBR_old_20260521_144846.sql
SQL> select dbms_metadata.get_ddl('VIEW','V_YN_GSP_NBR','WMPROD')
from dual; 2
CREATE OR REPLACE FORCE EDITIONABLE VIEW "WMPROD"."V_YN_GSP_NBR" ("CREATE_DATETIME", "CREATE_DATE_TIME", "WHSE", "SEASON", "COMPANY_DESCRIPTION", "BILLNO_TYPE", "BILLNO_NAME", "I_O_FLAG", "I_O_FLAG_TYPE", "TC_LPN_ID", "CMS_BILLNO", "CMS_GRPNO", "WMS_BILLNO", "ITEM_ID", "SIZE_DESC", "DESCRIPTION",
"BATCH_NBR", "GSP_NBR", "UOM", "DNAME", "COMMODITY_LEVEL_DESC", "C_QSTD", "C_APPR_CODE", "BUSINESS_PARTNER_ID", "VENDOR_NAME", "STD_PACK_QTY", "USER_NAME") AS
select cgnt.create_date_time as create_datetime, -- 监管码时间
/*to_date(cgnt.create_date_time, 'yyyy-mm-dd hh24:mi:ss') as create_datetime, -- 监管码时间*/
to_char(a.created_dttm, 'yyyymmdd hh24:mi:ss') as create_date_time, -- 订单时间
cgnt.whse, -- 仓库代码
cgnt.season, -- 货主代码
(select company_description
from company
where parent_company_id = 1
and company_code = cgnt.season) company_description, --货主名称
a.asn_orgn_type as billno_type, -- 订单类型
(select sc.code_desc
from sys_code sc
where sc.code_type = '022'
and sc.code_id = a.asn_orgn_type) as billno_name,
l.inbound_outbound_indicator as i_o_flag, -- 出入库类型
decode(l.inbound_outbound_indicator, 'I', '入库', 'O', '出库') as i_o_flag_type, --入出库类型
l.tc_lpn_id, -- 货箱号
ad.ref_field_3 as cms_billno, -- cms订单号
a.manif_nbr as cms_grpno, -- cms订单组号
a.tc_asn_id as wms_billno, -- wms订单号
ad.sku_id as item_id, -- 商品id
cgnt.size_desc, --erp商品代码
ic.description, --品规
cgnt.batch_nbr, --批号
cgnt.gsp_nbr, -- 监管码
cgnt.uom, -- 单位
(select substr(bp.description, instr(bp.description, ' ') + 1)
from business_partner bp
where bp.business_partner_id = a.business_partner_id) as dname,
ic.commodity_level_desc, --生产企业
ic.c_qstd, --存储条件
ic.c_appr_code, --注册证号
a.business_partner_id as business_partner_id, -- 客商id
substr(bp.description, instr(bp.description, ' ') + 1) as vendor_name, --客商名称
ld.std_pack_qty, -- 包装数量
uu.user_last_name || uu.user_first_name as user_name --扫码人
from asn a
join asn_detail ad
on a.asn_id = ad.asn_id
join asn_detail_ref adr
on a.asn_id = adr.asn_id
join lpn l
on l.inbound_outbound_indicator = 'I'
and a.asn_id = l.asn_id
and a.tc_asn_id = l.tc_asn_id
join lpn_detail ld
on l.lpn_id = ld.lpn_id
and ad.sku_id = ld.item_id
and ad.batch_nbr = ld.batch_nbr
join c_gsp_nbr_trkg cgnt
on cgnt.i_o_flag = 'I'
and a.tc_asn_id = cgnt.rcvd_shpmt_nbr
and l.tc_lpn_id = cgnt.cntr_nbr
and ld.item_id = cgnt.sku_id
and ld.batch_nbr = cgnt.batch_nbr
join item_cbo ic
on cgnt.sku_id = ic.item_id
join ucl_user uu
--on cgnt.user_id = uu.user_name
on cgnt.scan_user_id = uu.user_name --20257/28 关联扫码人id
join business_partner bp
on bp.business_partner_id = ad.business_partner_id
where a.asn_status = 40
union all
select cgnt.create_date_time as create_datetime, -- 监管码时间
/* to_date(cgnt.create_date_time, 'yyyy-mm-dd hh24:mi:ss') as create_datetime, -- 监管码时间*/
to_char(o.created_dttm, 'yyyymmdd hh24:mi:ss') as create_date_time, -- 订单时间
cgnt.whse, -- 仓库代码
cgnt.season, -- 货主代码
(select company_description
from company
where parent_company_id = 1
and company_code = cgnt.season) company_description, --货主名称
o.ref_field_2 as billno_type, -- 订单类型
(select sc.code_desc
from sys_code sc
where sc.code_type = '022'
and sc.code_id = o.ref_field_2) as billno_name,
l.inbound_outbound_indicator as i_o_flag, -- 出入库类型
decode(l.inbound_outbound_indicator, 'I', '入库', 'O', '出库') as i_o_flag_type, --入出库类型
l.tc_lpn_id as tc_lpn_id, -- 货箱号
oli.delivery_reference_number as cms_billno, -- cms订单号
o.ref_field_3 as cms_grpno, --cms订单组号
o.tc_order_id as wms_billno, -- wms订单号
ld.item_id as item_id, -- 商品id
ic.item_size_desc as size_desc, --erp商品代码
ic.description, --品规
cgnt.batch_nbr, --批号
cgnt.gsp_nbr, -- 监管码
cgnt.uom, -- 单位
(select fa.facility_name
from facility_alias fa
where fa.facility_alias_id = o.d_facility_alias_id) as dname,
ic.commodity_level_desc, --生产企业
ic.c_qstd, --存储条件
ic.c_appr_code, --注册证号
o.d_facility_alias_id as business_partner_id, -- 客商id
case
when o.tc_company_id = 133 then
(select substr(c.company_name, instr(c.company_name, ' ', 1, 1) + 1)
from company c, orders o1
where o1.tc_company_id = 133
and c.company_code = o.ref_field_7
and o1.order_id = o.order_id)
else
o.d_facility_name
end vendor_name, --客商名称
ld.std_pack_qty, -- 包装数量
uu.user_last_name || uu.user_first_name as user_name --扫码人
from orders o
join order_line_item oli
on o.order_id = oli.order_id
join item_cbo ic on oli.item_name=ic.item_name
join lpn l
on l.inbound_outbound_indicator = 'O'
and o.order_id = l.order_id
and o.tc_order_id = l.tc_order_id
join lpn_detail ld
on l.lpn_id = ld.lpn_id
and oli.item_id = ld.item_id
and oli.batch_nbr = ld.batch_nbr
join c_gsp_nbr_trkg cgnt
on cgnt.i_o_flag = 'O'
and o.tc_order_id = cgnt.pkt_ctrl_nbr
and l.tc_lpn_id = cgnt.cntr_nbr
and ld.item_id = cgnt.sku_id
and ld.batch_nbr = cgnt.batch_nbr
join item_cbo ic
on cgnt.sku_id = ic.item_id
join ucl_user uu
--on cgnt.user_id = uu.user_name
on cgnt.scan_user_id = uu.user_name --20257/28 关联扫码人id
where o.do_status = 190
;
SQL> spool off
SQL>
本次实际导出的旧 DDL 文件为：
/tmp/V_YN_GSP_NBR_old_20260521_144846.sql
文件大小约 6.1K，导出的视图开头如下：
CREATE OR REPLACE FORCE EDITIONABLE VIEW "WMPROD"."V_YN_GSP_NBR" ("CREATE_DATETIME", "CREATE_DATE_TIME", "WHSE", "SEASON", "COMPANY_DESCRIPTION", "BILLNO_TYPE", "BILLNO_NAME", "I_O_FLAG", "I_O_FLAG_TYPE", "TC_LPN_ID", "CMS_BILLNO", "CMS_GRPNO", "WMS_BILLNO", "ITEM_ID", "SIZE_DESC", "DESCRIPTION",
"BATCH_NBR", "GSP_NBR", "UOM", "DNAME", "COMMODITY_LEVEL_DESC", "C_QSTD", "C_APPR_CODE", "BUSINESS_PARTNER_ID", "VENDOR_NAME", "STD_PACK_QTY", "USER_NAME") AS
select cgnt.create_date_time as create_datetime, -- 监管码时间
/*to_date(cgnt.create_date_time, 'yyyy-mm-dd hh24:mi:ss') as create_datetime, -- 监管码时间*/
to_char(a.created_dttm, 'yyyymmdd hh24:mi:ss') as create_date_time, -- 订单时间
cgnt.whse, -- 仓库代码
cgnt.season, -- 货主代码
(select company_description
from company
where parent_company_id = 1
and company_code = cgnt.season) company_description, --货主名称
a.asn_orgn_type as billno_type, -- 订单类型
(select sc.code_desc
from sys_code sc
where sc.code_type = '022'
and sc.code_id = a.asn_orgn_type) as billno_name,
l.inbound_outbound_indicator as i_o_flag, -- 出入库类型
decode(l.inbound_outbound_indicator, 'I', '入库', 'O', '出库') as i_o_flag_type, --入出库类型
l.tc_lpn_id, -- 货箱号
ad.ref_field_3 as cms_billno, -- cms订单号
a.manif_nbr as cms_grpno, -- cms订单组号
a.tc_asn_id as wms_billno, -- wms订单号
ad.sku_id as item_id, -- 商品id
cgnt.size_desc, --erp商品代码
ic.description, --品规
cgnt.batch_nbr, --批号
cgnt.gsp_nbr, -- 监管码
cgnt.uom, -- 单位
(select substr(bp.description, instr(bp.description, ' ') + 1)
from business_partner bp
where bp.business_partner_id = a.business_partner_id) as dname,
ic.commodity_level_desc, --生产企业
ic.c_qstd, --存储条件
ic.c_appr_code, --注册证号
a.business_partner_id as business_partner_id, -- 客商id
substr(bp.description, instr(bp.description, ' ') + 1) as vendor_name, --客商名称
ld.std_pack_qty, -- 包装数量
uu.user_last_name || uu.user_first_name as user_name --扫码人
from asn a
join asn_detail ad
on a.asn_id = ad.asn_id
join asn_detail_ref adr
on a.asn_id = adr.asn_id
join lpn l
on l.inbound_outbound_indicator = 'I'
and a.asn_id = l.asn_id
and a.tc_asn_id = l.tc_asn_id
join lpn_detail ld
on l.lpn_id = ld.lpn_id
and ad.sku_id = ld.item_id
and ad.batch_nbr = ld.batch_nbr
join c_gsp_nbr_trkg cgnt
on cgnt.i_o_flag = 'I'
and a.tc_asn_id = cgnt.rcvd_shpmt_nbr
and l.tc_lpn_id = cgnt.cntr_nbr
and ld.item_id = cgnt.sku_id
and ld.batch_nbr = cgnt.batch_nbr
join item_cbo ic
on cgnt.sku_id = ic.item_id
join ucl_user uu
--on cgnt.user_id = uu.user_name
on cgnt.scan_user_id = uu.user_name --20257/28 关联扫码人id
join business_partner bp
on bp.business_partner_id = ad.business_partner_id
where a.asn_status = 40
union all
select cgnt.create_date_time as create_datetime, -- 监管码时间
/* to_date(cgnt.create_date_time, 'yyyy-mm-dd hh24:mi:ss') as create_datetime, -- 监管码时间*/
to_char(o.created_dttm, 'yyyymmdd hh24:mi:ss') as create_date_time, -- 订单时间
cgnt.whse, -- 仓库代码
cgnt.season, -- 货主代码
(select company_description
from company
where parent_company_id = 1
and company_code = cgnt.season) company_description, --货主名称
o.ref_field_2 as billno_type, -- 订单类型
(select sc.code_desc
from sys_code sc
where sc.code_type = '022'
and sc.code_id = o.ref_field_2) as billno_name,
l.inbound_outbound_indicator as i_o_flag, -- 出入库类型
decode(l.inbound_outbound_indicator, 'I', '入库', 'O', '出库') as i_o_flag_type, --入出库类型
l.tc_lpn_id as tc_lpn_id, -- 货箱号
oli.delivery_reference_number as cms_billno, -- cms订单号
o.ref_field_3 as cms_grpno, --cms订单组号
o.tc_order_id as wms_billno, -- wms订单号
ld.item_id as item_id, -- 商品id
ic.item_size_desc as size_desc, --erp商品代码
ic.description, --品规
cgnt.batch_nbr, --批号
cgnt.gsp_nbr, -- 监管码
cgnt.uom, -- 单位
(select fa.facility_name
from facility_alias fa
where fa.facility_alias_id = o.d_facility_alias_id) as dname,
ic.commodity_level_desc, --生产企业
ic.c_qstd, --存储条件
ic.c_appr_code, --注册证号
o.d_facility_alias_id as business_partner_id, -- 客商id
case
when o.tc_company_id = 133 then
(select substr(c.company_name, instr(c.company_name, ' ', 1, 1) + 1)
from company c, orders o1
where o1.tc_company_id = 133
and c.company_code = o.ref_field_7
and o1.order_id = o.order_id)
else
o.d_facility_name
end vendor_name, --客商名称
ld.std_pack_qty, -- 包装数量
uu.user_last_name || uu.user_first_name as user_name --扫码人
from orders o
join order_line_item oli
on o.order_id = oli.order_id
join item_cbo ic on oli.item_name=ic.item_name
join lpn l
on l.inbound_outbound_indicator = 'O'
and o.order_id = l.order_id
and o.tc_order_id = l.tc_order_id
join lpn_detail ld
on l.lpn_id = ld.lpn_id
and oli.item_id = ld.item_id
and oli.batch_nbr = ld.batch_nbr
join c_gsp_nbr_trkg cgnt
on cgnt.i_o_flag = 'O'
and o.tc_order_id = cgnt.pkt_ctrl_nbr
and l.tc_lpn_id = cgnt.cntr_nbr
and ld.item_id = cgnt.sku_id
and ld.batch_nbr = cgnt.batch_nbr
join item_cbo ic
on cgnt.sku_id = ic.item_id
join ucl_user uu
--on cgnt.user_id = uu.user_name
on cgnt.scan_user_id = uu.user_name --20257/28 关联扫码人id
where o.do_status = 190
;
这说明辅助库中已经拿到了修改前的旧版长视图定义。
九、备份当前错误版本视图定义
在生产库上先把当前错误版本导出保存，方便回退或审计。
export ORACLE_SID=wmprod
sqlplus / as sysdba
set long 1000000
set longchunksize 1000000
set pages 0
set lines 300
set trimspool on
set heading off
set feedback off
exec dbms_metadata.set_transform_param(dbms_metadata.session_transform,'SQLTERMINATOR',true);
exec dbms_metadata.set_transform_param(dbms_metadata.session_transform,'PRETTY',true);
spool /tmp/V_YN_GSP_NBR_current_wrong.sql
select dbms_metadata.get_ddl('VIEW','V_YN_GSP_NBR','WMPROD')
from dual;
spool off
[oracle@wmsdb2019 ~]$ export ORACLE_SID=wmprod
[oracle@wmsdb2019 ~]$ sqlplus / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Fri May 22 21:40:32 2026
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
SQL> set long 1000000
set longchunksize 1000000
set pages 0
set lines 300
set trimspool on
set heading off
set feedback offSQL> SQL> SQL> SQL> SQL> SQL>
SQL> exec dbms_metadata.set_transform_param(dbms_metadata.session_transform,'SQLTERMINATOR',true);
SQL> exec dbms_metadata.set_transform_param(dbms_metadata.session_transform,'PRETTY',true);
SQL> spool /tmp/V_YN_GSP_NBR_current_wrong.sql
SQL> select dbms_metadata.get_ddl('VIEW','V_YN_GSP_NBR','WMPROD')
from dual; 2
CREATE OR REPLACE FORCE EDITIONABLE VIEW "WMPROD"."V_YN_GSP_NBR" ("CNTR_NBR", "SIZE_DESC", "GSP_NBR", "RCVD_SHPMT_NBR", "PKT_CTRL_NBR") AS
select cntr_nbr,size_desc,gsp_nbr,rcvd_shpmt_nbr,pkt_ctrl_nbr from c_gsp_nbr_trkg where whse='YN2'
union all
select cntr_nbr,size_desc,brcd as gsp_nbr,rcvd_shpmt_nbr,pkt_ctrl_nbr from c_udi_trkg t where whse='YN2'
;
SQL> spool off
SQL>
得到的错误版本文件：
/tmp/V_YN_GSP_NBR_current_wrong.sql
十、在生产库恢复视图定义
先清洗文件文件中的 SQL>、spool off ：
sed -e '/^SQL>/d' \
-e '/^[[:space:]]*[0-9][[:space:]]/d' \
/tmp/V_YN_GSP_NBR_old_20260521_144846.sql \
> /tmp/V_YN_GSP_NBR_old_clean.sql
[oracle@wmsdb2019 tmp]$ sed -e '/^SQL>/d' \
> -e '/^[[:space:]]*[0-9][[:space:]]/d' \
> /tmp/V_YN_GSP_NBR_old_20260521_144846.sql \
> > /tmp/V_YN_GSP_NBR_old_clean.sql
[oracle@wmsdb2019 tmp]$
然后执行：
@/tmp/V_YN_GSP_NBR_old_clean.sql SQL> @/tmp/V_YN_GSP_NBR_old_clean.sql SQL>
执行后编译视图：
alter view WMPROD.V_YN_GSP_NBR compile;
SQL> alter view WMPROD.V_YN_GSP_NBR compile;
SQL>
十一、恢复结果验证
11.1 检查对象状态
set lines 200 pages 100
col owner for a20
col object_name for a40
col object_type for a15
col last_ddl_time for a20
col status for a10
select owner,
object_name,
object_type,
to_char(last_ddl_time,'yyyy-mm-dd hh24:mi:ss') last_ddl_time,
status
from dba_objects
where owner = 'WMPROD'
and object_name = 'V_YN_GSP_NBR'
and object_type = 'VIEW';
查询结果：
OWNER OBJECT_NAME OBJECT_TYPE LAST_DDL_TIME STATUS
------ -------------- ----------- ------------------- ------
WMPROD V_YN_GSP_NBR VIEW 2026-05-22 21:41:34 VALID
说明视图已经重新创建并编译成功。
11.2 检查当前视图定义
set long 1000000
set longchunksize 1000000
set pages 0
set lines 300
set trimspool on
set heading off
set feedback off
set echo off
select dbms_metadata.get_ddl('VIEW','V_YN_GSP_NBR','WMPROD')
from dual;
SQL> set long 1000000
set longchunksize 1000000
set pages 0
set lines 300
set trimspool on
set heading off
set feedback off
set echo off
select dbms_metadata.get_ddl('VIEW','V_YN_GSP_NBR','WMPROD')
from dual;SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 2
CREATE OR REPLACE FORCE EDITIONABLE VIEW "WMPROD"."V_YN_GSP_NBR" ("CREATE_DATETIME", "CREATE_DATE_TIME", "WHSE", "SEASON", "COMPANY_DESCRIPTION", "BILLNO_TYPE", "BILLNO_NAME", "I_O_FLAG", "I_O_FLAG_TYPE", "TC_LPN_ID", "CMS_BILLNO", "CMS_GRPNO", "WMS_BILLNO", "ITEM_ID", "SIZE_DESC", "DESCRIPTION",
"BATCH_NBR", "GSP_NBR", "UOM", "DNAME", "COMMODITY_LEVEL_DESC", "C_QSTD", "C_APPR_CODE", "BUSINESS_PARTNER_ID", "VENDOR_NAME", "STD_PACK_QTY", "USER_NAME") AS
select cgnt.create_date_time as create_datetime, -- 监管码时间
/*to_date(cgnt.create_date_time, 'yyyy-mm-dd hh24:mi:ss') as create_datetime, -- 监管码时间*/
to_char(a.created_dttm, 'yyyymmdd hh24:mi:ss') as create_date_time, -- 订单时间
cgnt.whse, -- 仓库代码
cgnt.season, -- 货主代码
(select company_description
from company
where parent_company_id = 1
and company_code = cgnt.season) company_description, --货主名称
a.asn_orgn_type as billno_type, -- 订单类型
(select sc.code_desc
from sys_code sc
where sc.code_type = '022'
and sc.code_id = a.asn_orgn_type) as billno_name,
l.inbound_outbound_indicator as i_o_flag, -- 出入库类型
decode(l.inbound_outbound_indicator, 'I', '入库', 'O', '出库') as i_o_flag_type, --入出库类型
l.tc_lpn_id, -- 货箱号
ad.ref_field_3 as cms_billno, -- cms订单号
a.manif_nbr as cms_grpno, -- cms订单组号
a.tc_asn_id as wms_billno, -- wms订单号
ad.sku_id as item_id, -- 商品id
cgnt.size_desc, --erp商品代码
ic.description, --品规
cgnt.batch_nbr, --批号
cgnt.gsp_nbr, -- 监管码
cgnt.uom, -- 单位
(select substr(bp.description, instr(bp.description, ' ') + 1)
from business_partner bp
where bp.business_partner_id = a.business_partner_id) as dname,
ic.commodity_level_desc, --生产企业
ic.c_qstd, --存储条件
ic.c_appr_code, --注册证号
a.business_partner_id as business_partner_id, -- 客商id
substr(bp.description, instr(bp.description, ' ') + 1) as vendor_name, --客商名称
ld.std_pack_qty, -- 包装数量
uu.user_last_name || uu.user_first_name as user_name --扫码人
from asn a
join asn_detail ad
on a.asn_id = ad.asn_id
join asn_detail_ref adr
on a.asn_id = adr.asn_id
join lpn l
on l.inbound_outbound_indicator = 'I'
and a.asn_id = l.asn_id
and a.tc_asn_id = l.tc_asn_id
join lpn_detail ld
on l.lpn_id = ld.lpn_id
and ad.sku_id = ld.item_id
and ad.batch_nbr = ld.batch_nbr
join c_gsp_nbr_trkg cgnt
on cgnt.i_o_flag = 'I'
and a.tc_asn_id = cgnt.rcvd_shpmt_nbr
and l.tc_lpn_id = cgnt.cntr_nbr
and ld.item_id = cgnt.sku_id
and ld.batch_nbr = cgnt.batch_nbr
join item_cbo ic
on cgnt.sku_id = ic.item_id
join ucl_user uu
--on cgnt.user_id = uu.user_name
on cgnt.scan_user_id = uu.user_name --20257/28 关联扫码人id
join business_partner bp
on bp.business_partner_id = ad.business_partner_id
where a.asn_status = 40
union all
select cgnt.create_date_time as create_datetime, -- 监管码时间
/* to_date(cgnt.create_date_time, 'yyyy-mm-dd hh24:mi:ss') as create_datetime, -- 监管码时间*/
to_char(o.created_dttm, 'yyyymmdd hh24:mi:ss') as create_date_time, -- 订单时间
cgnt.whse, -- 仓库代码
cgnt.season, -- 货主代码
(select company_description
from company
where parent_company_id = 1
and company_code = cgnt.season) company_description, --货主名称
o.ref_field_2 as billno_type, -- 订单类型
(select sc.code_desc
from sys_code sc
where sc.code_type = '022'
and sc.code_id = o.ref_field_2) as billno_name,
l.inbound_outbound_indicator as i_o_flag, -- 出入库类型
decode(l.inbound_outbound_indicator, 'I', '入库', 'O', '出库') as i_o_flag_type, --入出库类型
l.tc_lpn_id as tc_lpn_id, -- 货箱号
oli.delivery_reference_number as cms_billno, -- cms订单号
o.ref_field_3 as cms_grpno, --cms订单组号
o.tc_order_id as wms_billno, -- wms订单号
ld.item_id as item_id, -- 商品id
ic.item_size_desc as size_desc, --erp商品代码
ic.description, --品规
cgnt.batch_nbr, --批号
cgnt.gsp_nbr, -- 监管码
cgnt.uom, -- 单位
(select fa.facility_name
from facility_alias fa
where fa.facility_alias_id = o.d_facility_alias_id) as dname,
ic.commodity_level_desc, --生产企业
ic.c_qstd, --存储条件
ic.c_appr_code, --注册证号
o.d_facility_alias_id as business_partner_id, -- 客商id
case
when o.tc_company_id = 133 then
(select substr(c.company_name, instr(c.company_name, ' ', 1, 1) + 1)
from company c, orders o1
where o1.tc_company_id = 133
and c.company_code = o.ref_field_7
and o1.order_id = o.order_id)
else
o.d_facility_name
end vendor_name, --客商名称
ld.std_pack_qty, -- 包装数量
uu.user_last_name || uu.user_first_name as user_name --扫码人
from orders o
join order_line_item oli
on o.order_id = oli.order_id
join item_cbo ic on oli.item_name=ic.item_name
join lpn l
on l.inbound_outbound_indicator = 'O'
and o.order_id = l.order_id
and o.tc_order_id = l.tc_order_id
join lpn_detail ld
on l.lpn_id = ld.lpn_id
and oli.item_id = ld.item_id
and oli.batch_nbr = ld.batch_nbr
join c_gsp_nbr_trkg cgnt
on cgnt.i_o_flag = 'O'
and o.tc_order_id = cgnt.pkt_ctrl_nbr
and l.tc_lpn_id = cgnt.cntr_nbr
and ld.item_id = cgnt.sku_id
and ld.batch_nbr = cgnt.batch_nbr
join item_cbo ic
on cgnt.sku_id = ic.item_id
join ucl_user uu
--on cgnt.user_id = uu.user_name
on cgnt.scan_user_id = uu.user_name --20257/28 关联扫码人id
where o.do_status = 190
SQL>
结果显示生产库当前视图已经恢复为旧版长字段定义
[oracle@wmsdb2019 tmp]$ cat /tmp/V_YN_GSP_NBR_current_wrong.sql
SQL> select dbms_metadata.get_ddl('VIEW','V_YN_GSP_NBR','WMPROD')
2 from dual;
CREATE OR REPLACE FORCE EDITIONABLE VIEW "WMPROD"."V_YN_GSP_NBR" ("CNTR_NBR", "SIZE_DESC", "GSP_NBR", "RCVD_SHPMT_NBR", "PKT_CTRL_NBR") AS
select cntr_nbr,size_desc,gsp_nbr,rcvd_shpmt_nbr,pkt_ctrl_nbr from c_gsp_nbr_trkg where whse='YN2'
union all
select cntr_nbr,size_desc,brcd as gsp_nbr,rcvd_shpmt_nbr,pkt_ctrl_nbr from c_udi_trkg t where whse='YN2'
;
SQL> spool off
[oracle@wmsdb2019 tmp]$
这说明生产库当前定义不再是上面错误V_YN_GSP_NBR_current_wrong.sql的 5 字段短版本。
11.3 实际查询验证
select count(*)
from WMPROD.V_YN_GSP_NBR
where rownum <= 1;
返回：
1
说明视图不仅对象状态为 VALID，实际解析和查询也能正常执行。
十二、检查并重编译无效对象
恢复视图后检查 schema 下无效对象：
set lines 200 pages 100
col owner for a20
col object_name for a40
col object_type for a20
col status for a10
select owner,
object_name,
object_type,
status
from dba_objects
where owner = 'WMPROD'
and status <> 'VALID'
order by object_type, object_name;
如存在较多无效对象，可以执行：
exec utl_recomp.recomp_serial('WMPROD');
如果重编译后仍有 INVALID 对象，再查询具体错误：
set lines 200 pages 200
col name for a40
col type for a20
col text for a120
select name,
type,
line,
position,
text
from dba_errors
where owner = 'WMPROD'
order by name, type, sequence;
十三、清理辅助库
确认生产视图恢复完成、业务验证通过后，关闭辅助库：
export ORACLE_SID=WMSAUX
sqlplus / as sysdba
shutdown immediate;
exit
[oracle@wmsdb2019 ~]$ export ORACLE_SID=WMSAUX
[oracle@wmsdb2019 ~]$ sqlplus / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Fri May 22 21:43:02 2026
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
[oracle@wmsdb2019 ~]$
删除辅助库目录：
rm -rf /u01/app/oracle/oradata/WMSAUX rm -rf /u01/app/oracle/fast_recovery_area/WMSAUX rm -rf /u01/app/oracle/admin/WMSAUX [oracle@wmsdb2019 ~]$ rm -rf /u01/app/oracle/oradata/WMSAUX [oracle@wmsdb2019 ~]$ rm -rf /u01/app/oracle/fast_recovery_area/WMSAUX [oracle@wmsdb2019 ~]$ rm -rf /u01/app/oracle/admin/WMSAUX [oracle@wmsdb2019 ~]$
本次实际操作中，WMSAUX 已经正常关闭，并清理了上述目录。
十四、恢复总结
本次故障的核心是生产库中 WMPROD.V_YN_GSP_NBR 视图被误修改，导致原有复杂视图定义被替换成了错误的短版本。由于视图属于数据库字典中的逻辑对象，RMAN 不能像恢复数据文件或表空间一样直接恢复单个视图对象，因此不能在生产库上直接做对象级 RMAN 恢复。
在不影响生产业务的前提下，最终选择使用 RMAN Duplicate 创建辅助库 的方式进行恢复。通过将辅助库 WMSAUX 恢复到误修改时间 2026-05-21 14:48:47 之前的时间点，再从辅助库中导出旧版视图 DDL，最后回到生产库执行 CREATE OR REPLACE VIEW 覆盖错误定义，实现了单个视图的精准恢复。
本次恢复过程中有几个关键判断点：
- 生产库不能直接回退。
如果使用 PITR 或 Flashback Database，会导致整个生产库回退，影响范围过大，不适合只恢复单个视图的场景。 - RMAN 备份和归档必须完整。
通过检查备份摘要和归档日志，确认目标时间点被归档序列覆盖，具备恢复到误修改前时间点的条件。 - 辅助库恢复时间要早于误操作时间。
本次选择恢复到2026-05-21 14:45:00，避开了14:48:47的 DDL 修改边界，保证导出的视图定义是修改前版本。 - RMAN Duplicate 连接方式必须正确。
必须确认target连接生产库WMPROD，auxiliary连接辅助库WMSAUX。如果两边都连到生产库，存在严重误操作风险。 - 恢复后必须做多层验证。
不能只看视图状态是否VALID，还要通过DBMS_METADATA.GET_DDL确认视图定义已经恢复为旧版本，并执行简单查询验证视图可以正常解析和访问。
最终，生产库 WMPROD.V_YN_GSP_NBR 已恢复为误修改前的长版本定义，对象状态为 VALID，实际查询返回正常，说明本次视图恢复成功。
本案例说明：当生产库中视图、存储过程、函数、包等逻辑对象被误修改，而又没有代码版本或发布脚本可回退时，通过 RMAN Duplicate 恢复辅助库，再从辅助库提取旧对象 DDL，是一种安全、可靠、对生产影响最小的恢复方式。
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
