当前位置：首页 > news >正文

南京做网站开发待遇/网络营销运营方案

news 文章来源：https://blog.csdn.net/weixin_44377973/article/details/142502724 2025/3/13 23:59:55

南京做网站开发待遇,网络营销运营方案,泰安房产最新出售信息,网站建设颜色注意事项从 Oracle 集群到单节点环境（详细记录一次数据迁移过程）之三：在目标服务器上恢复数据目录从 Oracle 集群到单节点环境（详细记录一次数据迁移过程）之三：在目标服务器上恢复数据一、修改参数文件的内容二、…

从 Oracle 集群到单节点环境（详细记录一次数据迁移过程）之三：在目标服务器上恢复数据

从 Oracle 集群到单节点环境（详细记录一次数据迁移过程）之三：在目标服务器上恢复数据
- 一、修改参数文件的内容
- 二、创建参数文件中涉及到的所有目录
- 三、使用修改后的参数文件启动数据库到 nomount
- 四、生成 spfile 文件，关闭数据库，然后重新启动到 nomount
- 五、启动 rman，恢复控制文件，启动数据库到 mount
- 六、查看控制文件中的数据文件与临时文件信息
- 七、在目标服务器上开始恢复数据库
- - - 1、核对备份文件
    - 2、删除失效的备份文件
    - 3、重新核对备份文件
    - 4、更新备份文件
    - 5、查看备份集信息
    - 6、恢复数据库
- 八、恢复完成后的设置
- - - 1、修改日志文件
    - 2、启动数据库
    - 3、查看 redo log 信息，删除无效日志组（删除节点2的日志）
    - 4、查看 undo 表空间，并删除节点2的 undo 表空间
    - 5、创建临时表空间
    - 6、重启数据库

在目标服务器上恢复数据，执行如下操作：

一、修改参数文件的内容

参数文件的位置如下：

[oracle@node1 ~]$ pwd
/home/oracle
[oracle@node1 ~]$ ll
总用量 4
-rw-r--r--  1 oracle oinstall 2030 9月  24 12:33 pfile0921.ora
drwxr-xr-x. 3 oracle oinstall  114 9月  22 20:32 soft

修改参数文件的内容如下：

*.audit_file_dest='/usr/local/oracle/admin/hisdb/adump'
*.compatible='11.2.0.4.0'
*.control_files='/usr/local/oracle/controlfile/control01.ctl','/usr/local/oracle/data/controlfile/control02.ctl'
*.db_block_size=8192
*.db_name='hisdb'
*.db_recovery_file_dest='/usr/local/oracle/data/flash_recovery_area'
*.db_recovery_file_dest_size=536870912000
*.diagnostic_dest='/usr/local/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=hisdbXDB)'
*.log_archive_dest_1='location=/usr/local/oracle/data/arch'
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.processes=1500
*.remote_login_passwordfile='exclusive'
*.undo_tablespace='UNDOTBS1'
*.log_file_name_convert=('+DATA/hisdb/onlinelog','/usr/local/oracle/data/oradata')
*.db_file_name_convert=('+DATA/hisdb/datafile','/usr/local/oracle/data/oradata')
*.db_file_name_convert=('+DATA/hisdb/tempfile','/usr/local/oracle/data/oradata')

二、创建参数文件中涉及到的所有目录

切换到 oracle 用户，执行如下命令：

mkdir -p /usr/local/oracle/admin/hisdb/adump
mkdir -p /usr/local/oracle/controlfile
mkdir -p /usr/local/oracle/data/controlfile/
mkdir -p /usr/local/oracle/data/flash_recovery_area
mkdir -p /usr/local/oracle/data/arch
mkdir -p /usr/local/oracle/data/oradata

三、使用修改后的参数文件启动数据库到 nomount

SQL> startup nomount pfile='/home/oracle/pfile0921.ora';
ORACLE instance started.Total System Global Area  476061696 bytes
Fixed Size		    2254264 bytes
Variable Size		  398461512 bytes
Database Buffers	   67108864 bytes
Redo Buffers		    8237056 bytes

四、生成 spfile 文件，关闭数据库，然后重新启动到 nomount

-- 生成 spfile 文件
--===========================================================================================================
SQL> create spfile from pfile='/home/oracle/pfile0921.ora';File created.-- 关闭数据库
--===========================================================================================================
SQL> shutdown immediate;
ORA-01507: database not mountedORACLE instance shut down.-- 重新启动到 nomount
--===========================================================================================================
SQL> startup nomount;
ORACLE instance started.Total System Global Area  476061696 bytes
Fixed Size		    2254264 bytes
Variable Size		  398461512 bytes
Database Buffers	   67108864 bytes
Redo Buffers		    8237056 bytes

五、启动 rman，恢复控制文件，启动数据库到 mount

查看备份的控制文件信息：

#  备份的控制文件的地址：/usr/local/oracle/bak0921/bak
[root@node1 bak]# pwd
/usr/local/oracle/bak0921/bak
[root@node1 bak]# mv control_bak_1094.bak ../# 把控制文件复制到 /usr/local/oracle/bak0921/
[root@node1 bak]# cd ..
[root@node1 bak0921]# pwd
/usr/local/oracle/bak0921
[root@node1 bak0921]# ll
总用量 85512
drwxr-xr-x 2 oracle oinstall    20480 9月  24 13:32 bak
-rw-r----- 1 oracle oinstall 87523328 9月  24 12:55 control_bak_1094.bak
drwxrwxr-x 2 oracle oinstall    16384 9月  22 21:51 lost+found
drwxr-xr-x 3 oracle oinstall     4096 9月  23 21:31 usr

恢复控制文件：

-- 启动rman
[oracle@node1 ~]$ rman target /Recovery Manager: Release 11.2.0.4.0 - Production on Sun Sep 22 23:11:20 2024Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.connected to target database: HISDB (not mounted)--恢复控制文件
RMAN> restore controlfile from '/usr/local/oracle/bak0921/control_bak_1094.bak';Starting restore at 24-SEP-24
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=996 device type=DISKchannel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/usr/local/oracle/controlfile/control01.ctl
output file name=/usr/local/oracle/data/controlfile/control02.ctl
Finished restore at 24-SEP-24

启动数据库到 mount：

SQL> alter database mount;Database altered.

六、查看控制文件中的数据文件与临时文件信息

RMAN> report schema;
--======================================================================================================released channel: ORA_DISK_1
Starting implicit crosscheck backup at 24-SEP-24
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=996 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=1138 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=1280 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=1422 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=1563 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=1706 device type=DISK
Crosschecked 27 objects
Finished implicit crosscheck backup at 24-SEP-24Starting implicit crosscheck copy at 24-SEP-24
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
Crosschecked 2 objects
Finished implicit crosscheck copy at 24-SEP-24searching for all files in the recovery area
cataloging files...
no files catalogedRMAN-06139: WARNING: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name HISDBList of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    0        SYSTEM               ***     +DATA/hisdb/datafile/system.413.1109379227
2    0        UNDOTBS1             ***     +DATA/hisdb/datafile/undotbs1.345.1109379195
3    0        SYSAUX               ***     +DATA/hisdb/datafile/sysaux.412.1109379225
4    0        USERS                ***     +DATA/hisdb/datafile/users.423.1109379259
5    0        SYSTEM               ***     +DATA/hisdb/datafile/system.369.1109379199
6    0        SYSAUX               ***     +DATA/hisdb/datafile/sysaux.419.1109379239
7    0        USERS                ***     +DATA/hisdb/datafile/users.347.1109379195
8    0        DATA_USER            ***     +DATA/hisdb/datafile/data_user.407.1109379221
9    0        DATA_COM             ***     +DATA/hisdb/datafile/data_com.386.1109379201
10   0        DATA_FIN             ***     +DATA/hisdb/datafile/data_fin.318.1109379187
11   0        DATA_MET             ***     +DATA/hisdb/datafile/data_met.313.1109379185
12   0        DATA_LOG             ***     +DATA/hisdb/datafile/data_log.418.1109379233
13   0        DATA_GOA             ***     +DATA/hisdb/datafile/data_goa.422.1109379259
14   0        DATA_AQU             ***     +DATA/hisdb/datafile/data_aqu.420.1109379239
15   0        DATA_SEM             ***     +DATA/hisdb/datafile/data_sem.400.1109379213
16   0        DATA_EMR             ***     +DATA/hisdb/datafile/data_emr.416.1109379229
17   0        DATA_LIS             ***     +DATA/hisdb/datafile/data_lis.409.1109379223
18   0        DATA_CAS             ***     +DATA/hisdb/datafile/data_cas.408.1109379221
19   0        DATA_AIS             ***     +DATA/hisdb/datafile/data_ais.410.1109379223
20   0        DATA_OTHER           ***     +DATA/hisdb/datafile/data_other.406.1109379217
21   0        DATA_PHA             ***     +DATA/hisdb/datafile/data_pha.292.1109379173
22   0        DATA_ITEMLIST        ***     +DATA/hisdb/datafile/data_itemlist.281.1109379159
23   0        DATA_MEDICINELIST    ***     +DATA/hisdb/datafile/data_medicinelist.282.1109379161
24   0        DATA_FEEINFO         ***     +DATA/hisdb/datafile/data_feeinfo.291.1109379171
25   0        DATA_FEEDETAIL       ***     +DATA/hisdb/datafile/data_feedetail.354.1109379197
26   0        DATA_APPLYOUT        ***     +DATA/hisdb/datafile/data_applyout.275.1109379159
27   0        DATA_OUTPUT          ***     +DATA/hisdb/datafile/data_output.286.1109379169
28   0        DATA_RECORD          ***     +DATA/hisdb/datafile/data_record.293.1109379173
29   0        DATA_EXECDRUG        ***     +DATA/hisdb/datafile/data_execdrug.272.1109379159
30   0        DATA_EXECUNDRUG      ***     +DATA/hisdb/datafile/data_execundrug.314.1109379185
31   0        DATA_ORDER           ***     +DATA/hisdb/datafile/data_order.274.1109379159
32   0        DATA_RECIPEDETAIL    ***     +DATA/hisdb/datafile/data_recipedetail.389.1109379203
33   0        INDEX_USER           ***     +DATA/hisdb/datafile/index_user.404.1109379215
34   0        INDEX_COM            ***     +DATA/hisdb/datafile/index_com.392.1109379203
35   0        INDEX_FIN            ***     +DATA/hisdb/datafile/index_fin.312.1109379183
36   0        INDEX_PHA            ***     +DATA/hisdb/datafile/index_pha.288.1109379171
37   0        INDEX_MET            ***     +DATA/hisdb/datafile/index_met.311.1109379181
38   0        INDEX_LOG            ***     +DATA/hisdb/datafile/index_log.394.1109379203
39   0        INDEX_GOA            ***     +DATA/hisdb/datafile/index_goa.398.1109379211
40   0        INDEX_AQU            ***     +DATA/hisdb/datafile/index_aqu.405.1109379217
41   0        INDEX_SEM            ***     +DATA/hisdb/datafile/index_sem.414.1109379227
42   0        INDEX_EMR            ***     +DATA/hisdb/datafile/index_emr.395.1109379203
43   0        INDEX_LIS            ***     +DATA/hisdb/datafile/index_lis.399.1109379213
44   0        INDEX_CAS            ***     +DATA/hisdb/datafile/index_cas.393.1109379203
45   0        INDEX_AIS            ***     +DATA/hisdb/datafile/index_ais.421.1109379243
46   0        INDEX_OTHER          ***     +DATA/hisdb/datafile/index_other.396.1109379209
47   0        INDEX_ITEMLIST       ***     +DATA/hisdb/datafile/index_itemlist.271.1109379159
48   0        INDEX_MEDICINELIST   ***     +DATA/hisdb/datafile/index_medicinelist.279.1109379159
49   0        INDEX_FEEINFO        ***     +DATA/hisdb/datafile/index_feeinfo.273.1109379159
50   0        INDEX_FEEDETAIL      ***     +DATA/hisdb/datafile/index_feedetail.320.1109379187
51   0        INDEX_APPLYOUT       ***     +DATA/hisdb/datafile/index_applyout.284.1109379161
52   0        INDEX_OUTPUT         ***     +DATA/hisdb/datafile/index_output.298.1109379173
53   0        INDEX_RECORD         ***     +DATA/hisdb/datafile/index_record.391.1109379203
54   0        INDEX_EXECDRUG       ***     +DATA/hisdb/datafile/index_execdrug.343.1109379195
55   0        INDEX_EXECUNDRUG     ***     +DATA/hisdb/datafile/index_execundrug.351.1109379197
56   0        INDEX_ORDER          ***     +DATA/hisdb/datafile/index_order.325.1109379189
57   0        INDEX_RECIPEDETAIL   ***     +DATA/hisdb/datafile/index_recipedetail.397.1109379209
58   0        DATA_USER            ***     +DATA/hisdb/datafile/data_user.401.1109379215
59   0        DATA_COM             ***     +DATA/hisdb/datafile/data_com.350.1109379197
60   0        DATA_FIN             ***     +DATA/hisdb/datafile/data_fin.339.1109379193
61   0        DATA_MET             ***     +DATA/hisdb/datafile/data_met.340.1109379193
62   0        DATA_LOG             ***     +DATA/hisdb/datafile/data_log.349.1109379197
63   0        DATA_GOA             ***     +DATA/hisdb/datafile/data_goa.352.1109379197
64   0        DATA_AQU             ***     +DATA/hisdb/datafile/data_aqu.348.1109379195
65   0        DATA_SEM             ***     +DATA/hisdb/datafile/data_sem.355.1109379197
66   0        DATA_EMR             ***     +DATA/hisdb/datafile/data_emr.358.1109379197
67   0        DATA_LIS             ***     +DATA/hisdb/datafile/data_lis.368.1109379199
68   0        DATA_CAS             ***     +DATA/hisdb/datafile/data_cas.342.1109379193
69   0        DATA_AIS             ***     +DATA/hisdb/datafile/data_ais.361.1109379199
70   0        DATA_OTHER           ***     +DATA/hisdb/datafile/data_other.356.1109379197
71   0        DATA_PHA             ***     +DATA/hisdb/datafile/data_pha.336.1109379193
72   0        DATA_ITEMLIST        ***     +DATA/hisdb/datafile/data_itemlist.278.1109379159
73   0        DATA_MEDICINELIST    ***     +DATA/hisdb/datafile/data_medicinelist.294.1109379173
74   0        DATA_FEEINFO         ***     +DATA/hisdb/datafile/data_feeinfo.321.1109379187
75   0        DATA_FEEDETAIL       ***     +DATA/hisdb/datafile/data_feedetail.364.1109379199
76   0        DATA_APPLYOUT        ***     +DATA/hisdb/datafile/data_applyout.295.1109379173
77   0        DATA_OUTPUT          ***     +DATA/hisdb/datafile/data_output.299.1109379177
78   0        DATA_RECORD          ***     +DATA/hisdb/datafile/data_record.297.1109379173
79   0        DATA_EXECDRUG        ***     +DATA/hisdb/datafile/data_execdrug.289.1109379171
80   0        DATA_EXECUNDRUG      ***     +DATA/hisdb/datafile/data_execundrug.327.1109379189
81   0        DATA_ORDER           ***     +DATA/hisdb/datafile/data_order.307.1109379181
82   0        DATA_RECIPEDETAIL    ***     +DATA/hisdb/datafile/data_recipedetail.387.1109379203
83   0        INDEX_USER           ***     +DATA/hisdb/datafile/index_user.417.1109379231
84   0        INDEX_COM            ***     +DATA/hisdb/datafile/index_com.402.1109379215
85   0        INDEX_FIN            ***     +DATA/hisdb/datafile/index_fin.331.1109379191
86   0        INDEX_PHA            ***     +DATA/hisdb/datafile/index_pha.330.1109379191
87   0        INDEX_MET            ***     +DATA/hisdb/datafile/index_met.328.1109379189
88   0        INDEX_LOG            ***     +DATA/hisdb/datafile/index_log.334.1109379193
89   0        INDEX_GOA            ***     +DATA/hisdb/datafile/index_goa.366.1109379199
90   0        INDEX_AQU            ***     +DATA/hisdb/datafile/index_aqu.363.1109379199
91   0        INDEX_SEM            ***     +DATA/hisdb/datafile/index_sem.365.1109379199
92   0        INDEX_EMR            ***     +DATA/hisdb/datafile/index_emr.360.1109379197
93   0        INDEX_LIS            ***     +DATA/hisdb/datafile/index_lis.359.1109379197
94   0        INDEX_CAS            ***     +DATA/hisdb/datafile/index_cas.367.1109379199
95   0        INDEX_AIS            ***     +DATA/hisdb/datafile/index_ais.371.1109379199
96   0        INDEX_OTHER          ***     +DATA/hisdb/datafile/index_other.332.1109379193
97   0        INDEX_ITEMLIST       ***     +DATA/hisdb/datafile/index_itemlist.280.1109379159
98   0        INDEX_MEDICINELIST   ***     +DATA/hisdb/datafile/index_medicinelist.310.1109379181
99   0        INDEX_FEEINFO        ***     +DATA/hisdb/datafile/index_feeinfo.362.1109379199
100  0        INDEX_FEEDETAIL      ***     +DATA/hisdb/datafile/index_feedetail.376.1109379201
101  0        INDEX_APPLYOUT       ***     +DATA/hisdb/datafile/index_applyout.357.1109379197
102  0        INDEX_OUTPUT         ***     +DATA/hisdb/datafile/index_output.374.1109379201
103  0        INDEX_RECORD         ***     +DATA/hisdb/datafile/index_record.381.1109379201
104  0        INDEX_EXECDRUG       ***     +DATA/hisdb/datafile/index_execdrug.378.1109379201
105  0        INDEX_EXECUNDRUG     ***     +DATA/hisdb/datafile/index_execundrug.384.1109379201
106  0        INDEX_ORDER          ***     +DATA/hisdb/datafile/index_order.373.1109379199
107  0        INDEX_RECIPEDETAIL   ***     +DATA/hisdb/datafile/index_recipedetail.380.1109379201
108  0        INDEX_APPLYOUT       ***     +DATA/hisdb/datafile/index_applyout.301.1109379179
109  0        INDEX_FEEINFO        ***     +DATA/hisdb/datafile/index_feeinfo.296.1109379173
110  0        INDEX_FEEDETAIL      ***     +DATA/hisdb/datafile/index_feedetail.306.1109379181
111  0        DATA_PHA             ***     +DATA/hisdb/datafile/data_pha.323.1109379187
112  0        DATA_FEEINFO         ***     +DATA/hisdb/datafile/data_feeinfo.303.1109379179
113  0        DATA_FEEDETAIL       ***     +DATA/hisdb/datafile/data_feedetail.316.1109379187
114  0        INDEX_APPLYOUT       ***     +DATA/hisdb/datafile/index_applyout.300.1109379179
115  0        DATA_EXECDRUG        ***     +DATA/hisdb/datafile/data_execdrug.322.1109379187
116  0        DATA_EXECUNDRUG      ***     +DATA/hisdb/datafile/data_execundrug.338.1109379193
117  0        DATA_FIN             ***     +DATA/hisdb/datafile/data_fin.324.1109379187
118  0        INDEX_COM            ***     +DATA/hisdb/datafile/index_com.390.1109379203
119  0        INDEX_ORDER          ***     +DATA/hisdb/datafile/index_order.305.1109379181
120  0        INDEX_MET            ***     +DATA/hisdb/datafile/index_met.315.1109379185
121  0        DATA_MET             ***     +DATA/hisdb/datafile/data_met.302.1109379179
122  0        INDEX_PHA            ***     +DATA/hisdb/datafile/index_pha.319.1109379187
123  0        INDEX_MEDICINELIST   ***     +DATA/hisdb/datafile/index_medicinelist.304.1109379179
124  0        DATA_MEDICINELIST    ***     +DATA/hisdb/datafile/data_medicinelist.290.1109379171
125  0        DATA_ORDER           ***     +DATA/hisdb/datafile/data_order.308.1109379181
126  0        DATA_APPLYOUT        ***     +DATA/hisdb/datafile/data_applyout.287.1109379169
127  0        INDEX_FIN            ***     +DATA/hisdb/datafile/index_fin.329.1109379191
128  0        INDEX_EXECDRUG       ***     +DATA/hisdb/datafile/index_execdrug.326.1109379189
129  0        INDEX_FEEINFO        ***     +DATA/hisdb/datafile/index_feeinfo.337.1109379193
130  0        INDEX_OUTPUT         ***     +DATA/hisdb/datafile/index_output.309.1109379181
131  0        DATA_EXECDRUG        ***     +DATA/hisdb/datafile/data_execdrug.317.1109379187
132  0        DATA_EXECUNDRUG      ***     +DATA/hisdb/datafile/data_execundrug.335.1109379193
133  0        DATA_FEEINFO         ***     +DATA/hisdb/datafile/data_feeinfo.382.1109379201
134  0        DATA_FEEDETAIL       ***     +DATA/hisdb/datafile/data_feedetail.377.1109379201
135  0        DATA_ITEMLIST        ***     +DATA/hisdb/datafile/data_itemlist.379.1109379201
136  0        DATA_MEDICINELIST    ***     +DATA/hisdb/datafile/data_medicinelist.372.1109379199
137  0        DATA_OUTPUT          ***     +DATA/hisdb/datafile/data_output.370.1109379199
138  0        DATA_PHA             ***     +DATA/hisdb/datafile/data_pha.411.1109379225
139  0        DATA_RECIPEDETAIL    ***     +DATA/hisdb/datafile/data_recipedetail.283.1109379161
140  0        DATA_RECORD          ***     +DATA/hisdb/datafile/data_record.383.1109379201
141  0        INDEX_APPLYOUT       ***     +DATA/hisdb/datafile/index_applyout.341.1109379193
142  0        INDEX_EXECUNDRUG     ***     +DATA/hisdb/datafile/index_execundrug.333.1109379193
143  0        INDEX_FEEINFO        ***     +DATA/hisdb/datafile/index_feeinfo.385.1109379201
144  0        INDEX_ITEMLIST       ***     +DATA/hisdb/datafile/index_itemlist.346.1109379195
145  0        INDEX_MEDICINELIST   ***     +DATA/hisdb/datafile/index_medicinelist.344.1109379195
146  0        INDEX_OUTPUT         ***     +DATA/hisdb/datafile/index_output.375.1109379201
147  0        DATA_FIN             ***     +DATA/hisdb/datafile/data_fin.388.1109379203
148  0        DATA_OUTPUT          ***     +DATA/hisdb/datafile/data_output.353.1109379197
149  0        DATA_USER            ***     +DATA/hisdb/datafile/data_user.415.1109379229
150  0        DATA_ORDER           ***     +DATA/hisdb/datafile/data_order.285.1109379161
151  0        EMR5                 ***     +DATA/hisdb/datafile/emr5.403.1109379215
152  0        DATA_ORDER           ***     +DATA/hisdb/datafile/data_order.277.1109379159
153  0        DATA_ORDER           ***     +DATA/hisdb/datafile/data_order.270.1109379159
154  0        DATA_USER            ***     +DATA/hisdb/datafile/data_user.276.1109379159
155  0        UNDOTBS2             ***     +DATA/hisdb/datafile/undotbs2.429.1109386101
156  0        NFEMR                ***     +DATA/hisdb/datafile/nfemr.dbf
157  0        EMR52012             ***     +DATA/hisdb/datafile/emr52012.dbf
158  0        EMR52013             ***     +DATA/hisdb/datafile/emr52013.dbf
159  0        EMR52014             ***     +DATA/hisdb/datafile/emr52014.dbf
160  0        EMR52015             ***     +DATA/hisdb/datafile/emr52015.dbf
161  0        EMR52016             ***     +DATA/hisdb/datafile/emr52016.dbf
162  0        EMR52017             ***     +DATA/hisdb/datafile/emr52017.dbf
163  0        EMR52018             ***     +DATA/hisdb/datafile/emr52018.dbf
164  0        EMR52019             ***     +DATA/hisdb/datafile/mr52019.dbf
165  0        EMR52020             ***     +DATA/hisdb/datafile/emr52020.dbf
166  0        EMR52021             ***     +DATA/hisdb/datafile/emr52021.dbf
167  0        EMR52022             ***     +DATA/hisdb/datafile/emr52022.dbf
168  0        EMR5                 ***     +DATA/hisdb/datafile/emr5.403.1109379326.dbf
169  0        EMR52023             ***     +DATA/hisdb/datafile/emr5202301.dbf
170  0        EMR52023             ***     +DATA/hisdb/datafile/emr5202302.dbf
171  0        EMR52023             ***     +DATA/hisdb/datafile/emr5202303.dbf
172  0        NEUODTS              ***     +DATA/hisdb/datafile/neuodts.dbf
173  0        NEUCBUS              ***     +DATA/hisdb/datafile/neucbus.dbf
174  0        EMR52023             ***     +DATA/hisdb/datafile/emr5202305.dbf
175  0        EMR52024             ***     +DATA/hisdb/datafile/emr5202401.dbf
176  0        EMR52022             ***     +DATA/hisdb/datafile/emr52022_data41801.dbf
177  0        EMR52022             ***     +DATA/hisdb/datafile/emr52022_data41802.dbf
178  0        EMR52022             ***     +DATA/hisdb/datafile/emr52022_data41803.dbf
179  0        EMR52022             ***     +DATA/hisdb/datafile/emr52022_data41804.dbf
180  0        EMR52023             ***     +DATA/hisdb/datafile/emr52023_data41801.dbf
181  0        EMR52023             ***     +DATA/hisdb/datafile/emr52023_data41802.dbf
182  0        EMR52023             ***     +DATA/hisdb/datafile/emr52023_data41803.dbf
183  0        EMR52023             ***     +DATA/hisdb/datafile/emr52023_data41804.dbf
184  0        EMR52024             ***     +DATA/hisdb/datafile/emr52024_data41801.dbf
185  0        EMR52024             ***     +DATA/hisdb/datafile/emr52024_data41802.dbf
186  0        EMR52024             ***     +DATA/hisdb/datafile/emr52024_data41803.dbf
187  0        EMR52024             ***     +DATA/hisdb/datafile/emr52024_data41804.dbf
188  0        EMR52024             ***     +DATA/hisdb/datafile/emr52024_data01.dbf
189  0        EMR52024             ***     +DATA/hisdb/datafile/emr52024_data02.dbf
190  0        EMR52024             ***     +DATA/hisdb/datafile/emr52024_data03.dbf
191  0        EMR52024             ***     +DATA/hisdb/datafile/emr52024_data04.dbf
192  0        EMR52024             ***     +DATA/hisdb/datafile/emr52024_data05.dbf
193  0        EMR52024             ***     +DATA/hisdb/datafile/emr52024_data06.dbfList of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       +DATA/hisdb/tempfile/temp.425.1109379973
2    1024     TEMP                 4096        +DATA/hisdb/tempfile/temp.424.1109379973

七、在目标服务器上开始恢复数据库

1、核对备份文件

RMAN> crosscheck backup;--======================================================================================================
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/data_bak/HISDB_1726452655_610_1_20220706.BKP RECID=610 STAMP=1109378722
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/data_bak/HISDB_1726452655_611_1_20220706.BKP RECID=611 STAMP=1109378723
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/data_bak/HISDB_1726452655_612_1_20220706.BKP RECID=612 STAMP=1109378723
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/data_bak/HISDB_1726452655_613_1_20220706.BKP RECID=613 STAMP=1109378723
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/data_bak/HISDB_1726452655_614_1_20220706.BKP RECID=614 STAMP=1109378723
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/data_bak/HISDB_1726452655_615_1_20220706.BKP RECID=615 STAMP=1109378723
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/data_bak/HISDB_1726452655_616_1_20220706.BKP RECID=616 STAMP=1109378723
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/data_bak/HISDB_1726452655_617_1_20220706.BKP RECID=617 STAMP=1109378723
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/data_bak/HISDB_1726452655_618_1_20220706.BKP RECID=618 STAMP=1109378723
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/data_bak/HISDB_1726452655_619_1_20220706.BKP RECID=619 STAMP=1109378723
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/data_bak/HISDB_1726452655_620_1_20220706.BKP RECID=620 STAMP=1109378723
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/data_bak/HISDB_1726452655_621_1_20220706.BKP RECID=621 STAMP=1109378723
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/data_bak/HISDB_1726452655_622_1_20220706.BKP RECID=622 STAMP=1109378723
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/data_bak/HISDB_1726452655_623_1_20220706.BKP RECID=623 STAMP=1109378723
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/data_bak/HISDB_1726452655_624_1_20220706.BKP RECID=624 STAMP=1109378723
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/data_bak/HISDB_1726452655_625_1_20220706.BKP RECID=625 STAMP=1109378723
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/data_bak/HISDB_1726452655_626_1_20220706.BKP RECID=626 STAMP=1109378723
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/data_bak/HISDB_1726452655_627_1_20220706.BKP RECID=627 STAMP=1109378723
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/bak0921/control_bak_1085.bak RECID=628 STAMP=1180273157
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/bak0921/HISDB_1726452655_1089_1_20240921.bkp RECID=629 STAMP=1180273227
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/bak0921/HISDB_1726452655_1092_1_20240921.bkp RECID=630 STAMP=1180275114
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/bak0921/HISDB_1726452655_1093_1_20240921.bkp RECID=631 STAMP=1180275117
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/bak0921/HISDB_1726452655_1087_1_20240921.bkp RECID=632 STAMP=1180273226
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/bak0921/HISDB_1726452655_1091_1_20240921.bkp RECID=633 STAMP=1180273228
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/bak0921/HISDB_1726452655_1088_1_20240921.bkp RECID=634 STAMP=1180273226
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/bak0921/HISDB_1726452655_1090_1_20240921.bkp RECID=635 STAMP=1180273227
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/bak0921/HISDB_1726452655_1086_1_20240921.bkp RECID=636 STAMP=1180273226
Crosschecked 27 objects

2、删除失效的备份文件

RMAN> delete expired backup;--======================================================================================================
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
610     610     1   1   EXPIRED     DISK        /data_bak/HISDB_1726452655_610_1_20220706.BKP
611     611     1   1   EXPIRED     DISK        /data_bak/HISDB_1726452655_611_1_20220706.BKP
612     612     1   1   EXPIRED     DISK        /data_bak/HISDB_1726452655_612_1_20220706.BKP
613     613     1   1   EXPIRED     DISK        /data_bak/HISDB_1726452655_613_1_20220706.BKP
614     614     1   1   EXPIRED     DISK        /data_bak/HISDB_1726452655_614_1_20220706.BKP
615     615     1   1   EXPIRED     DISK        /data_bak/HISDB_1726452655_615_1_20220706.BKP
616     616     1   1   EXPIRED     DISK        /data_bak/HISDB_1726452655_616_1_20220706.BKP
617     617     1   1   EXPIRED     DISK        /data_bak/HISDB_1726452655_617_1_20220706.BKP
618     618     1   1   EXPIRED     DISK        /data_bak/HISDB_1726452655_618_1_20220706.BKP
619     619     1   1   EXPIRED     DISK        /data_bak/HISDB_1726452655_619_1_20220706.BKP
620     620     1   1   EXPIRED     DISK        /data_bak/HISDB_1726452655_620_1_20220706.BKP
621     621     1   1   EXPIRED     DISK        /data_bak/HISDB_1726452655_621_1_20220706.BKP
622     622     1   1   EXPIRED     DISK        /data_bak/HISDB_1726452655_622_1_20220706.BKP
623     623     1   1   EXPIRED     DISK        /data_bak/HISDB_1726452655_623_1_20220706.BKP
624     624     1   1   EXPIRED     DISK        /data_bak/HISDB_1726452655_624_1_20220706.BKP
625     625     1   1   EXPIRED     DISK        /data_bak/HISDB_1726452655_625_1_20220706.BKP
626     626     1   1   EXPIRED     DISK        /data_bak/HISDB_1726452655_626_1_20220706.BKP
627     627     1   1   EXPIRED     DISK        /data_bak/HISDB_1726452655_627_1_20220706.BKP
628     628     1   1   EXPIRED     DISK        /bak0921/control_bak_1085.bak
629     629     1   1   EXPIRED     DISK        /bak0921/HISDB_1726452655_1089_1_20240921.bkp
630     630     1   1   EXPIRED     DISK        /bak0921/HISDB_1726452655_1092_1_20240921.bkp
631     631     1   1   EXPIRED     DISK        /bak0921/HISDB_1726452655_1093_1_20240921.bkp
632     632     1   1   EXPIRED     DISK        /bak0921/HISDB_1726452655_1087_1_20240921.bkp
633     633     1   1   EXPIRED     DISK        /bak0921/HISDB_1726452655_1091_1_20240921.bkp
634     634     1   1   EXPIRED     DISK        /bak0921/HISDB_1726452655_1088_1_20240921.bkp
635     635     1   1   EXPIRED     DISK        /bak0921/HISDB_1726452655_1090_1_20240921.bkp
636     636     1   1   EXPIRED     DISK        /bak0921/HISDB_1726452655_1086_1_20240921.bkpDo you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/data_bak/HISDB_1726452655_610_1_20220706.BKP RECID=610 STAMP=1109378722
deleted backup piece
backup piece handle=/data_bak/HISDB_1726452655_611_1_20220706.BKP RECID=611 STAMP=1109378723
deleted backup piece
backup piece handle=/data_bak/HISDB_1726452655_612_1_20220706.BKP RECID=612 STAMP=1109378723
deleted backup piece
backup piece handle=/data_bak/HISDB_1726452655_613_1_20220706.BKP RECID=613 STAMP=1109378723
deleted backup piece
backup piece handle=/data_bak/HISDB_1726452655_614_1_20220706.BKP RECID=614 STAMP=1109378723
deleted backup piece
backup piece handle=/data_bak/HISDB_1726452655_615_1_20220706.BKP RECID=615 STAMP=1109378723
deleted backup piece
backup piece handle=/data_bak/HISDB_1726452655_616_1_20220706.BKP RECID=616 STAMP=1109378723
deleted backup piece
backup piece handle=/data_bak/HISDB_1726452655_617_1_20220706.BKP RECID=617 STAMP=1109378723
deleted backup piece
backup piece handle=/data_bak/HISDB_1726452655_618_1_20220706.BKP RECID=618 STAMP=1109378723
deleted backup piece
backup piece handle=/data_bak/HISDB_1726452655_619_1_20220706.BKP RECID=619 STAMP=1109378723
deleted backup piece
backup piece handle=/data_bak/HISDB_1726452655_620_1_20220706.BKP RECID=620 STAMP=1109378723
deleted backup piece
backup piece handle=/data_bak/HISDB_1726452655_621_1_20220706.BKP RECID=621 STAMP=1109378723
deleted backup piece
backup piece handle=/data_bak/HISDB_1726452655_622_1_20220706.BKP RECID=622 STAMP=1109378723
deleted backup piece
backup piece handle=/data_bak/HISDB_1726452655_623_1_20220706.BKP RECID=623 STAMP=1109378723
deleted backup piece
backup piece handle=/data_bak/HISDB_1726452655_624_1_20220706.BKP RECID=624 STAMP=1109378723
deleted backup piece
backup piece handle=/data_bak/HISDB_1726452655_625_1_20220706.BKP RECID=625 STAMP=1109378723
deleted backup piece
backup piece handle=/data_bak/HISDB_1726452655_626_1_20220706.BKP RECID=626 STAMP=1109378723
deleted backup piece
backup piece handle=/data_bak/HISDB_1726452655_627_1_20220706.BKP RECID=627 STAMP=1109378723
deleted backup piece
backup piece handle=/bak0921/control_bak_1085.bak RECID=628 STAMP=1180273157
deleted backup piece
backup piece handle=/bak0921/HISDB_1726452655_1089_1_20240921.bkp RECID=629 STAMP=1180273227
deleted backup piece
backup piece handle=/bak0921/HISDB_1726452655_1092_1_20240921.bkp RECID=630 STAMP=1180275114
deleted backup piece
backup piece handle=/bak0921/HISDB_1726452655_1093_1_20240921.bkp RECID=631 STAMP=1180275117
deleted backup piece
backup piece handle=/bak0921/HISDB_1726452655_1087_1_20240921.bkp RECID=632 STAMP=1180273226
deleted backup piece
backup piece handle=/bak0921/HISDB_1726452655_1091_1_20240921.bkp RECID=633 STAMP=1180273228
deleted backup piece
backup piece handle=/bak0921/HISDB_1726452655_1088_1_20240921.bkp RECID=634 STAMP=1180273226
deleted backup piece
backup piece handle=/bak0921/HISDB_1726452655_1090_1_20240921.bkp RECID=635 STAMP=1180273227
deleted backup piece
backup piece handle=/bak0921/HISDB_1726452655_1086_1_20240921.bkp RECID=636 STAMP=1180273226
Deleted 27 EXPIRED objectsRMAN-08591: WARNING: invalid archived log deletion policy

3、重新核对备份文件

RMAN> crosscheck backup;--======================================================================================================
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
specification does not match any backup in the repository

4、更新备份文件

RMAN> catalog start with '/usr/local/oracle/bak0921/bak';--======================================================================================================
searching for all files that match the pattern /usr/local/oracle/bak0921/bakList of Files Unknown to the Database
=====================================
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1340_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1184_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1106_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1280_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1345_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1159_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1130_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1344_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1250_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1255_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1248_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1113_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1133_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1217_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1180_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1263_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1331_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1251_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1231_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1138_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1147_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1234_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1312_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1143_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1135_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1172_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1313_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1215_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1318_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1201_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1199_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1283_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1285_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1267_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1166_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1160_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1317_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1294_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1240_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1239_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1178_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1336_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1307_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1276_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1226_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1188_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1173_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1324_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1112_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1241_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1136_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1192_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1281_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1305_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1258_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1235_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1140_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1314_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1323_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1308_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1227_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1155_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1221_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1165_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1211_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1282_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1189_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1126_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1095_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1260_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1152_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1303_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1146_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1325_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1247_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1219_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1191_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1237_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1208_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1100_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1225_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1291_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1333_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1310_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1213_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1153_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1266_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1195_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1278_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1123_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1243_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1302_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1316_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1186_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1209_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1274_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1220_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1144_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1139_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1343_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1290_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1301_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1207_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1148_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1212_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1115_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1292_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1181_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1163_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1107_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1156_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1326_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1315_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1099_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1330_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1131_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1268_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1196_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1264_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1216_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1205_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1321_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1262_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1194_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1270_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1233_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1119_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1183_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1319_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1279_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1170_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1198_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1311_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1168_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1116_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1287_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1137_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1273_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1124_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1342_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1337_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1309_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1335_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1118_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1110_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1232_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1117_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1244_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1249_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1254_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1151_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1096_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1120_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1108_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1338_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1190_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1102_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1275_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1167_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1149_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1210_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1229_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1269_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1265_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1288_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1114_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1332_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1222_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1236_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1296_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1098_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1176_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1105_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1142_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1145_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1329_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1150_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1164_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1272_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1193_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1334_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1257_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1252_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1182_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1253_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1161_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1141_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1261_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1202_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1179_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1341_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1320_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1158_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1277_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1322_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1242_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1297_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1271_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1230_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1177_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1218_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1304_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1103_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1289_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1125_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1256_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1104_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1246_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1259_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1134_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1111_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1171_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1284_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1204_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1299_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1097_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1122_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1200_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1109_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1328_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1245_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1129_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1223_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1206_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1197_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1293_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1224_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1132_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1327_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1187_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1174_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1300_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1185_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1121_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1175_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1101_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1238_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1286_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1157_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1295_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1128_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1339_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1214_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1127_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1162_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1228_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1306_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1169_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1203_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1154_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1298_1_20240924.bkpDo you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging doneList of Cataloged Files
=======================
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1340_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1184_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1106_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1280_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1345_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1159_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1130_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1344_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1250_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1255_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1248_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1113_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1133_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1217_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1180_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1263_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1331_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1251_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1231_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1138_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1147_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1234_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1312_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1143_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1135_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1172_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1313_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1215_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1318_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1201_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1199_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1283_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1285_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1267_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1166_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1160_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1317_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1294_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1240_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1239_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1178_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1336_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1307_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1276_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1226_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1188_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1173_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1324_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1112_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1241_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1136_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1192_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1281_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1305_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1258_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1235_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1140_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1314_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1323_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1308_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1227_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1155_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1221_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1165_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1211_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1282_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1189_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1126_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1095_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1260_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1152_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1303_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1146_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1325_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1247_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1219_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1191_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1237_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1208_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1100_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1225_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1291_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1333_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1310_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1213_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1153_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1266_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1195_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1278_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1123_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1243_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1302_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1316_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1186_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1209_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1274_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1220_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1144_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1139_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1343_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1290_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1301_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1207_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1148_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1212_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1115_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1292_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1181_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1163_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1107_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1156_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1326_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1315_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1099_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1330_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1131_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1268_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1196_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1264_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1216_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1205_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1321_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1262_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1194_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1270_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1233_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1119_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1183_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1319_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1279_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1170_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1198_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1311_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1168_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1116_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1287_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1137_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1273_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1124_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1342_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1337_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1309_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1335_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1118_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1110_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1232_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1117_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1244_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1249_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1254_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1151_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1096_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1120_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1108_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1338_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1190_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1102_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1275_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1167_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1149_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1210_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1229_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1269_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1265_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1288_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1114_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1332_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1222_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1236_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1296_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1098_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1176_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1105_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1142_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1145_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1329_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1150_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1164_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1272_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1193_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1334_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1257_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1252_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1182_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1253_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1161_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1141_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1261_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1202_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1179_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1341_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1320_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1158_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1277_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1322_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1242_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1297_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1271_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1230_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1177_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1218_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1304_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1103_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1289_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1125_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1256_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1104_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1246_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1259_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1134_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1111_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1171_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1284_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1204_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1299_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1097_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1122_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1200_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1109_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1328_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1245_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1129_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1223_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1206_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1197_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1293_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1224_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1132_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1327_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1187_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1174_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1300_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1185_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1121_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1175_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1101_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1238_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1286_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1157_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1295_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1128_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1339_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1214_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1127_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1162_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1228_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1306_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1169_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1203_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1154_1_20240924.bkp
File Name: /usr/local/oracle/bak0921/bak/arch_HISDB_1726452655_1298_1_20240924.bkpRMAN> catalog start with '/usr/local/oracle/bak0921/bak';
--===========================================================================================================
searching for all files that match the pattern /usr/local/oracle/bak0921/bak
no files found to be unknown to the database

5、查看备份集信息

list backup;                      ----备份集列表：归档日志文件、数据文件、spfile、control file
list backupset;                   ----备份集列表：归档日志文件、数据文件、spfile、control file
list backup of database;          --显示数据文件
list backup of controlfile;       ---显示控制文件
list backup of spfile;            ----显示spfile文件
list backup of archivelog all;    ---显示归档日志文件--===========================================================================================================
RMAN> list backup of database;
--===========================================================================================================List of Backup Sets
===================BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
705     Full    39.10G     DISK        00:00:00     24-SEP-24      BP Key: 705   Status: AVAILABLE  Compressed: YES  Tag: TAG20240924T101007Piece Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1095_1_20240924.bkpList of Datafiles in backup set 705File LV Type Ckp SCN    Ckp Time  Name---- -- ---- ---------- --------- ----10      Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/data_fin.318.110937918715      Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/data_sem.400.110937921325      Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/data_feedetail.354.110937919732      Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/data_recipedetail.389.110937920339      Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/index_goa.398.110937921145      Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/index_ais.421.110937924348      Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/index_medicinelist.279.110937915949      Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/index_feeinfo.273.110937915952      Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/index_output.298.110937917356      Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/index_order.325.110937918964      Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/data_aqu.348.110937919570      Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/data_other.356.110937919778      Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/data_record.297.110937917380      Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/data_execundrug.327.110937918990      Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/index_aqu.363.110937919999      Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/index_feeinfo.362.1109379199104     Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/index_execdrug.378.1109379201106     Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/index_order.373.1109379199110     Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/index_feedetail.306.1109379181113     Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/data_feedetail.316.1109379187136     Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/data_medicinelist.372.1109379199141     Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/index_applyout.341.1109379193149     Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/data_user.415.1109379229150     Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/data_order.285.1109379161154     Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/data_user.276.1109379159155     Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/undotbs2.429.1109386101161     Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/emr52016.dbf166     Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/emr52021.dbf169     Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/emr5202301.dbf177     Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/emr52022_data41802.dbf183     Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/emr52023_data41804.dbf191     Full 8200079404 24-SEP-24 +DATA/hisdb/datafile/emr52024_data04.dbfBS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
716     Full    18.07G     DISK        00:00:00     24-SEP-24      BP Key: 716   Status: AVAILABLE  Compressed: YES  Tag: TAG20240924T101007Piece Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1100_1_20240924.bkpList of Datafiles in backup set 716File LV Type Ckp SCN    Ckp Time  Name---- -- ---- ---------- --------- ----1       Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/system.413.11093792274       Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/users.423.11093792595       Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/system.369.110937919911      Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/data_met.313.110937918516      Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/data_emr.416.110937922918      Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/data_cas.408.110937922134      Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/index_com.392.110937920337      Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/index_met.311.110937918140      Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/index_aqu.405.110937921755      Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/index_execundrug.351.110937919766      Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/data_emr.358.110937919771      Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/data_pha.336.110937919372      Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/data_itemlist.278.110937915973      Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/data_medicinelist.294.110937917386      Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/index_pha.330.110937919192      Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/index_emr.360.110937919797      Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/index_itemlist.280.1109379159101     Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/index_applyout.357.1109379197114     Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/index_applyout.300.1109379179117     Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/data_fin.324.1109379187126     Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/data_applyout.287.1109379169131     Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/data_execdrug.317.1109379187132     Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/data_execundrug.335.1109379193140     Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/data_record.383.1109379201147     Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/data_fin.388.1109379203156     Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/nfemr.dbf162     Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/emr52017.dbf168     Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/emr5.403.1109379326.dbf172     Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/neuodts.dbf178     Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/emr52022_data41803.dbf192     Full 8200079430 24-SEP-24 +DATA/hisdb/datafile/emr52024_data05.dbfBS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
750     Full    28.82G     DISK        00:00:00     24-SEP-24      BP Key: 750   Status: AVAILABLE  Compressed: YES  Tag: TAG20240924T101007Piece Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1099_1_20240924.bkpList of Datafiles in backup set 750File LV Type Ckp SCN    Ckp Time  Name---- -- ---- ---------- --------- ----2       Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/undotbs1.345.11093791957       Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/users.347.110937919512      Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/data_log.418.110937923319      Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/data_ais.410.110937922327      Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/data_output.286.110937916928      Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/data_record.293.110937917330      Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/data_execundrug.314.110937918533      Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/index_user.404.110937921536      Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/index_pha.288.110937917142      Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/index_emr.395.110937920346      Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/index_other.396.110937920963      Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/data_goa.352.110937919775      Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/data_feedetail.364.110937919979      Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/data_execdrug.289.110937917181      Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/data_order.307.110937918184      Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/index_com.402.110937921585      Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/index_fin.331.110937919189      Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/index_goa.366.110937919995      Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/index_ais.371.1109379199105     Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/index_execundrug.384.1109379201115     Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/data_execdrug.322.1109379187118     Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/index_com.390.1109379203121     Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/data_met.302.1109379179135     Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/data_itemlist.379.1109379201142     Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/index_execundrug.333.1109379193148     Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/data_output.353.1109379197153     Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/data_order.270.1109379159158     Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/emr52013.dbf174     Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/emr5202305.dbf180     Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/emr52023_data41801.dbf184     Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/emr52024_data41801.dbf186     Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/emr52024_data41803.dbf188     Full 8200079411 24-SEP-24 +DATA/hisdb/datafile/emr52024_data01.dbfBS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
788     Full    46.35G     DISK        00:00:00     24-SEP-24      BP Key: 788   Status: AVAILABLE  Compressed: YES  Tag: TAG20240924T101007Piece Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1096_1_20240924.bkpList of Datafiles in backup set 788File LV Type Ckp SCN    Ckp Time  Name---- -- ---- ---------- --------- ----3       Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/sysaux.412.11093792259       Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/data_com.386.110937920114      Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/data_aqu.420.110937923926      Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/data_applyout.275.110937915929      Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/data_execdrug.272.110937915935      Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/index_fin.312.110937918338      Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/index_log.394.110937920344      Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/index_cas.393.110937920360      Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/data_fin.339.110937919367      Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/data_lis.368.110937919982      Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/data_recipedetail.387.110937920393      Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/index_lis.359.110937919796      Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/index_other.332.1109379193102     Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/index_output.374.1109379201107     Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/index_recipedetail.380.1109379201109     Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/index_feeinfo.296.1109379173111     Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/data_pha.323.1109379187116     Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/data_execundrug.338.1109379193125     Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/data_order.308.1109379181128     Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/index_execdrug.326.1109379189130     Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/index_output.309.1109379181134     Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/data_feedetail.377.1109379201138     Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/data_pha.411.1109379225144     Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/index_itemlist.346.1109379195152     Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/data_order.277.1109379159160     Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/emr52015.dbf165     Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/emr52020.dbf167     Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/emr52022.dbf170     Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/emr5202302.dbf176     Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/emr52022_data41801.dbf182     Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/emr52023_data41803.dbf190     Full 8200079405 24-SEP-24 +DATA/hisdb/datafile/emr52024_data03.dbfBS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
807     Full    34.15G     DISK        00:00:00     24-SEP-24      BP Key: 807   Status: AVAILABLE  Compressed: YES  Tag: TAG20240924T101007Piece Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1098_1_20240924.bkpList of Datafiles in backup set 807File LV Type Ckp SCN    Ckp Time  Name---- -- ---- ---------- --------- ----6       Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/sysaux.419.11093792398       Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/data_user.407.110937922117      Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/data_lis.409.110937922322      Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/data_itemlist.281.110937915923      Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/data_medicinelist.282.110937916131      Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/data_order.274.110937915941      Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/index_sem.414.110937922751      Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/index_applyout.284.110937916153      Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/index_record.391.110937920354      Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/index_execdrug.343.110937919558      Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/data_user.401.110937921562      Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/data_log.349.110937919768      Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/data_cas.342.110937919369      Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/data_ais.361.110937919974      Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/data_feeinfo.321.110937918777      Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/data_output.299.110937917788      Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/index_log.334.110937919394      Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/index_cas.367.110937919998      Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/index_medicinelist.310.1109379181103     Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/index_record.381.1109379201112     Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/data_feeinfo.303.1109379179119     Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/index_order.305.1109379181122     Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/index_pha.319.1109379187124     Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/data_medicinelist.290.1109379171129     Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/index_feeinfo.337.1109379193133     Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/data_feeinfo.382.1109379201143     Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/index_feeinfo.385.1109379201157     Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/emr52012.dbf163     Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/emr52018.dbf171     Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/emr5202303.dbf179     Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/emr52022_data41804.dbf193     Full 8200079410 24-SEP-24 +DATA/hisdb/datafile/emr52024_data06.dbfBS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
852     Full    46.21G     DISK        00:00:00     24-SEP-24      BP Key: 852   Status: AVAILABLE  Compressed: YES  Tag: TAG20240924T101007Piece Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1097_1_20240924.bkpList of Datafiles in backup set 852File LV Type Ckp SCN    Ckp Time  Name---- -- ---- ---------- --------- ----13      Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/data_goa.422.110937925920      Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/data_other.406.110937921721      Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/data_pha.292.110937917324      Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/data_feeinfo.291.110937917143      Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/index_lis.399.110937921347      Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/index_itemlist.271.110937915950      Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/index_feedetail.320.110937918757      Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/index_recipedetail.397.110937920959      Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/data_com.350.110937919761      Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/data_met.340.110937919365      Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/data_sem.355.110937919776      Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/data_applyout.295.110937917383      Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/index_user.417.110937923187      Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/index_met.328.110937918991      Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/index_sem.365.1109379199100     Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/index_feedetail.376.1109379201108     Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/index_applyout.301.1109379179120     Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/index_met.315.1109379185123     Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/index_medicinelist.304.1109379179127     Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/index_fin.329.1109379191137     Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/data_output.370.1109379199139     Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/data_recipedetail.283.1109379161145     Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/index_medicinelist.344.1109379195146     Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/index_output.375.1109379201151     Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/emr5.403.1109379215159     Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/emr52014.dbf164     Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/mr52019.dbf173     Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/neucbus.dbf175     Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/emr5202401.dbf181     Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/emr52023_data41802.dbf185     Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/emr52024_data41802.dbf187     Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/emr52024_data41804.dbf189     Full 8200079406 24-SEP-24 +DATA/hisdb/datafile/emr52024_data02.dbf

6、恢复数据库

run{
set newname for datafile  10  to  '/usr/local/oracle/data/oradata/data_fin.318.1109379187';
set newname for datafile  15  to  '/usr/local/oracle/data/oradata/data_sem.400.1109379213';
set newname for datafile  25  to  '/usr/local/oracle/data/oradata/data_feedetail.354.1109379197';
set newname for datafile  32  to  '/usr/local/oracle/data/oradata/data_recipedetail.389.1109379203';
set newname for datafile  39  to  '/usr/local/oracle/data/oradata/index_goa.398.1109379211';
set newname for datafile  45  to  '/usr/local/oracle/data/oradata/index_ais.421.1109379243';
set newname for datafile  48  to  '/usr/local/oracle/data/oradata/index_medicinelist.279.1109379159';
set newname for datafile  49  to  '/usr/local/oracle/data/oradata/index_feeinfo.273.1109379159';
set newname for datafile  52  to  '/usr/local/oracle/data/oradata/index_output.298.1109379173';
set newname for datafile  56  to  '/usr/local/oracle/data/oradata/index_order.325.1109379189';
set newname for datafile  64  to  '/usr/local/oracle/data/oradata/data_aqu.348.1109379195';
set newname for datafile  70  to  '/usr/local/oracle/data/oradata/data_other.356.1109379197';
set newname for datafile  78  to  '/usr/local/oracle/data/oradata/data_record.297.1109379173';
set newname for datafile  80  to  '/usr/local/oracle/data/oradata/data_execundrug.327.1109379189';
set newname for datafile  90  to  '/usr/local/oracle/data/oradata/index_aqu.363.1109379199';
set newname for datafile  99  to  '/usr/local/oracle/data/oradata/index_feeinfo.362.1109379199';
set newname for datafile  104  to  '/usr/local/oracle/data/oradata/index_execdrug.378.1109379201';
set newname for datafile  106  to  '/usr/local/oracle/data/oradata/index_order.373.1109379199';
set newname for datafile  110  to  '/usr/local/oracle/data/oradata/index_feedetail.306.1109379181';
set newname for datafile  113  to  '/usr/local/oracle/data/oradata/data_feedetail.316.1109379187';
set newname for datafile  136  to  '/usr/local/oracle/data/oradata/data_medicinelist.372.1109379199';
set newname for datafile  141  to  '/usr/local/oracle/data/oradata/index_applyout.341.1109379193';
set newname for datafile  149  to  '/usr/local/oracle/data/oradata/data_user.415.1109379229';
set newname for datafile  150  to  '/usr/local/oracle/data/oradata/data_order.285.1109379161';
set newname for datafile  154  to  '/usr/local/oracle/data/oradata/data_user.276.1109379159';
set newname for datafile  155  to  '/usr/local/oracle/data/oradata/undotbs2.429.1109386101';
set newname for datafile  161  to  '/usr/local/oracle/data/oradata/emr52016.dbf';
set newname for datafile  166  to  '/usr/local/oracle/data/oradata/emr52021.dbf';
set newname for datafile  169  to  '/usr/local/oracle/data/oradata/emr5202301.dbf';
set newname for datafile  177  to  '/usr/local/oracle/data/oradata/emr52022_data41802.dbf';
set newname for datafile  183  to  '/usr/local/oracle/data/oradata/emr52023_data41804.dbf';
set newname for datafile  191  to  '/usr/local/oracle/data/oradata/emr52024_data04.dbf';
set newname for datafile  1  to  '/usr/local/oracle/data/oradata/system.413.1109379227';
set newname for datafile  4  to  '/usr/local/oracle/data/oradata/users.423.1109379259';
set newname for datafile  5  to  '/usr/local/oracle/data/oradata/system.369.1109379199';
set newname for datafile  11  to  '/usr/local/oracle/data/oradata/data_met.313.1109379185';
set newname for datafile  16  to  '/usr/local/oracle/data/oradata/data_emr.416.1109379229';
set newname for datafile  18  to  '/usr/local/oracle/data/oradata/data_cas.408.1109379221';
set newname for datafile  34  to  '/usr/local/oracle/data/oradata/index_com.392.1109379203';
set newname for datafile  37  to  '/usr/local/oracle/data/oradata/index_met.311.1109379181';
set newname for datafile  40  to  '/usr/local/oracle/data/oradata/index_aqu.405.1109379217';
set newname for datafile  55  to  '/usr/local/oracle/data/oradata/index_execundrug.351.1109379197';
set newname for datafile  66  to  '/usr/local/oracle/data/oradata/data_emr.358.1109379197';
set newname for datafile  71  to  '/usr/local/oracle/data/oradata/data_pha.336.1109379193';
set newname for datafile  72  to  '/usr/local/oracle/data/oradata/data_itemlist.278.1109379159';
set newname for datafile  73  to  '/usr/local/oracle/data/oradata/data_medicinelist.294.1109379173';
set newname for datafile  86  to  '/usr/local/oracle/data/oradata/index_pha.330.1109379191';
set newname for datafile  92  to  '/usr/local/oracle/data/oradata/index_emr.360.1109379197';
set newname for datafile  97  to  '/usr/local/oracle/data/oradata/index_itemlist.280.1109379159';
set newname for datafile  101  to  '/usr/local/oracle/data/oradata/index_applyout.357.1109379197';
set newname for datafile  114  to  '/usr/local/oracle/data/oradata/index_applyout.300.1109379179';
set newname for datafile  117  to  '/usr/local/oracle/data/oradata/data_fin.324.1109379187';
set newname for datafile  126  to  '/usr/local/oracle/data/oradata/data_applyout.287.1109379169';
set newname for datafile  131  to  '/usr/local/oracle/data/oradata/data_execdrug.317.1109379187';
set newname for datafile  132  to  '/usr/local/oracle/data/oradata/data_execundrug.335.1109379193';
set newname for datafile  140  to  '/usr/local/oracle/data/oradata/data_record.383.1109379201';
set newname for datafile  147  to  '/usr/local/oracle/data/oradata/data_fin.388.1109379203';
set newname for datafile  156  to  '/usr/local/oracle/data/oradata/nfemr.dbf';
set newname for datafile  162  to  '/usr/local/oracle/data/oradata/emr52017.dbf';
set newname for datafile  168  to  '/usr/local/oracle/data/oradata/emr5.403.1109379326.dbf';
set newname for datafile  172  to  '/usr/local/oracle/data/oradata/neuodts.dbf';
set newname for datafile  178  to  '/usr/local/oracle/data/oradata/emr52022_data41803.dbf';
set newname for datafile  192  to  '/usr/local/oracle/data/oradata/emr52024_data05.dbf';
set newname for datafile  2  to  '/usr/local/oracle/data/oradata/undotbs1.345.1109379195';
set newname for datafile  7  to  '/usr/local/oracle/data/oradata/users.347.1109379195';
set newname for datafile  12  to  '/usr/local/oracle/data/oradata/data_log.418.1109379233';
set newname for datafile  19  to  '/usr/local/oracle/data/oradata/data_ais.410.1109379223';
set newname for datafile  27  to  '/usr/local/oracle/data/oradata/data_output.286.1109379169';
set newname for datafile  28  to  '/usr/local/oracle/data/oradata/data_record.293.1109379173';
set newname for datafile  30  to  '/usr/local/oracle/data/oradata/data_execundrug.314.1109379185';
set newname for datafile  33  to  '/usr/local/oracle/data/oradata/index_user.404.1109379215';
set newname for datafile  36  to  '/usr/local/oracle/data/oradata/index_pha.288.1109379171';
set newname for datafile  42  to  '/usr/local/oracle/data/oradata/index_emr.395.1109379203';
set newname for datafile  46  to  '/usr/local/oracle/data/oradata/index_other.396.1109379209';
set newname for datafile  63  to  '/usr/local/oracle/data/oradata/data_goa.352.1109379197';
set newname for datafile  75  to  '/usr/local/oracle/data/oradata/data_feedetail.364.1109379199';
set newname for datafile  79  to  '/usr/local/oracle/data/oradata/data_execdrug.289.1109379171';
set newname for datafile  81  to  '/usr/local/oracle/data/oradata/data_order.307.1109379181';
set newname for datafile  84  to  '/usr/local/oracle/data/oradata/index_com.402.1109379215';
set newname for datafile  85  to  '/usr/local/oracle/data/oradata/index_fin.331.1109379191';
set newname for datafile  89  to  '/usr/local/oracle/data/oradata/index_goa.366.1109379199';
set newname for datafile  95  to  '/usr/local/oracle/data/oradata/index_ais.371.1109379199';
set newname for datafile  105  to  '/usr/local/oracle/data/oradata/index_execundrug.384.1109379201';
set newname for datafile  115  to  '/usr/local/oracle/data/oradata/data_execdrug.322.1109379187';
set newname for datafile  118  to  '/usr/local/oracle/data/oradata/index_com.390.1109379203';
set newname for datafile  121  to  '/usr/local/oracle/data/oradata/data_met.302.1109379179';
set newname for datafile  135  to  '/usr/local/oracle/data/oradata/data_itemlist.379.1109379201';
set newname for datafile  142  to  '/usr/local/oracle/data/oradata/index_execundrug.333.1109379193';
set newname for datafile  148  to  '/usr/local/oracle/data/oradata/data_output.353.1109379197';
set newname for datafile  153  to  '/usr/local/oracle/data/oradata/data_order.270.1109379159';
set newname for datafile  158  to  '/usr/local/oracle/data/oradata/emr52013.dbf';
set newname for datafile  174  to  '/usr/local/oracle/data/oradata/emr5202305.dbf';
set newname for datafile  180  to  '/usr/local/oracle/data/oradata/emr52023_data41801.dbf';
set newname for datafile  184  to  '/usr/local/oracle/data/oradata/emr52024_data41801.dbf';
set newname for datafile  186  to  '/usr/local/oracle/data/oradata/emr52024_data41803.dbf';
set newname for datafile  188  to  '/usr/local/oracle/data/oradata/emr52024_data01.dbf';
set newname for datafile  3  to  '/usr/local/oracle/data/oradata/sysaux.412.1109379225';
set newname for datafile  9  to  '/usr/local/oracle/data/oradata/data_com.386.1109379201';
set newname for datafile  14  to  '/usr/local/oracle/data/oradata/data_aqu.420.1109379239';
set newname for datafile  26  to  '/usr/local/oracle/data/oradata/data_applyout.275.1109379159';
set newname for datafile  29  to  '/usr/local/oracle/data/oradata/data_execdrug.272.1109379159';
set newname for datafile  35  to  '/usr/local/oracle/data/oradata/index_fin.312.1109379183';
set newname for datafile  38  to  '/usr/local/oracle/data/oradata/index_log.394.1109379203';
set newname for datafile  44  to  '/usr/local/oracle/data/oradata/index_cas.393.1109379203';
set newname for datafile  60  to  '/usr/local/oracle/data/oradata/data_fin.339.1109379193';
set newname for datafile  67  to  '/usr/local/oracle/data/oradata/data_lis.368.1109379199';
set newname for datafile  82  to  '/usr/local/oracle/data/oradata/data_recipedetail.387.1109379203';
set newname for datafile  93  to  '/usr/local/oracle/data/oradata/index_lis.359.1109379197';
set newname for datafile  96  to  '/usr/local/oracle/data/oradata/index_other.332.1109379193';
set newname for datafile  102  to  '/usr/local/oracle/data/oradata/index_output.374.1109379201';
set newname for datafile  107  to  '/usr/local/oracle/data/oradata/index_recipedetail.380.1109379201';
set newname for datafile  109  to  '/usr/local/oracle/data/oradata/index_feeinfo.296.1109379173';
set newname for datafile  111  to  '/usr/local/oracle/data/oradata/data_pha.323.1109379187';
set newname for datafile  116  to  '/usr/local/oracle/data/oradata/data_execundrug.338.1109379193';
set newname for datafile  125  to  '/usr/local/oracle/data/oradata/data_order.308.1109379181';
set newname for datafile  128  to  '/usr/local/oracle/data/oradata/index_execdrug.326.1109379189';
set newname for datafile  130  to  '/usr/local/oracle/data/oradata/index_output.309.1109379181';
set newname for datafile  134  to  '/usr/local/oracle/data/oradata/data_feedetail.377.1109379201';
set newname for datafile  138  to  '/usr/local/oracle/data/oradata/data_pha.411.1109379225';
set newname for datafile  144  to  '/usr/local/oracle/data/oradata/index_itemlist.346.1109379195';
set newname for datafile  152  to  '/usr/local/oracle/data/oradata/data_order.277.1109379159';
set newname for datafile  160  to  '/usr/local/oracle/data/oradata/emr52015.dbf';
set newname for datafile  165  to  '/usr/local/oracle/data/oradata/emr52020.dbf';
set newname for datafile  167  to  '/usr/local/oracle/data/oradata/emr52022.dbf';
set newname for datafile  170  to  '/usr/local/oracle/data/oradata/emr5202302.dbf';
set newname for datafile  176  to  '/usr/local/oracle/data/oradata/emr52022_data41801.dbf';
set newname for datafile  182  to  '/usr/local/oracle/data/oradata/emr52023_data41803.dbf';
set newname for datafile  190  to  '/usr/local/oracle/data/oradata/emr52024_data03.dbf';
set newname for datafile  6  to  '/usr/local/oracle/data/oradata/sysaux.419.1109379239';
set newname for datafile  8  to  '/usr/local/oracle/data/oradata/data_user.407.1109379221';
set newname for datafile  17  to  '/usr/local/oracle/data/oradata/data_lis.409.1109379223';
set newname for datafile  22  to  '/usr/local/oracle/data/oradata/data_itemlist.281.1109379159';
set newname for datafile  23  to  '/usr/local/oracle/data/oradata/data_medicinelist.282.1109379161';
set newname for datafile  31  to  '/usr/local/oracle/data/oradata/data_order.274.1109379159';
set newname for datafile  41  to  '/usr/local/oracle/data/oradata/index_sem.414.1109379227';
set newname for datafile  51  to  '/usr/local/oracle/data/oradata/index_applyout.284.1109379161';
set newname for datafile  53  to  '/usr/local/oracle/data/oradata/index_record.391.1109379203';
set newname for datafile  54  to  '/usr/local/oracle/data/oradata/index_execdrug.343.1109379195';
set newname for datafile  58  to  '/usr/local/oracle/data/oradata/data_user.401.1109379215';
set newname for datafile  62  to  '/usr/local/oracle/data/oradata/data_log.349.1109379197';
set newname for datafile  68  to  '/usr/local/oracle/data/oradata/data_cas.342.1109379193';
set newname for datafile  69  to  '/usr/local/oracle/data/oradata/data_ais.361.1109379199';
set newname for datafile  74  to  '/usr/local/oracle/data/oradata/data_feeinfo.321.1109379187';
set newname for datafile  77  to  '/usr/local/oracle/data/oradata/data_output.299.1109379177';
set newname for datafile  88  to  '/usr/local/oracle/data/oradata/index_log.334.1109379193';
set newname for datafile  94  to  '/usr/local/oracle/data/oradata/index_cas.367.1109379199';
set newname for datafile  98  to  '/usr/local/oracle/data/oradata/index_medicinelist.310.1109379181';
set newname for datafile  103  to  '/usr/local/oracle/data/oradata/index_record.381.1109379201';
set newname for datafile  112  to  '/usr/local/oracle/data/oradata/data_feeinfo.303.1109379179';
set newname for datafile  119  to  '/usr/local/oracle/data/oradata/index_order.305.1109379181';
set newname for datafile  122  to  '/usr/local/oracle/data/oradata/index_pha.319.1109379187';
set newname for datafile  124  to  '/usr/local/oracle/data/oradata/data_medicinelist.290.1109379171';
set newname for datafile  129  to  '/usr/local/oracle/data/oradata/index_feeinfo.337.1109379193';
set newname for datafile  133  to  '/usr/local/oracle/data/oradata/data_feeinfo.382.1109379201';
set newname for datafile  143  to  '/usr/local/oracle/data/oradata/index_feeinfo.385.1109379201';
set newname for datafile  157  to  '/usr/local/oracle/data/oradata/emr52012.dbf';
set newname for datafile  163  to  '/usr/local/oracle/data/oradata/emr52018.dbf';
set newname for datafile  171  to  '/usr/local/oracle/data/oradata/emr5202303.dbf';
set newname for datafile  179  to  '/usr/local/oracle/data/oradata/emr52022_data41804.dbf';
set newname for datafile  193  to  '/usr/local/oracle/data/oradata/emr52024_data06.dbf';
set newname for datafile  13  to  '/usr/local/oracle/data/oradata/data_goa.422.1109379259';
set newname for datafile  20  to  '/usr/local/oracle/data/oradata/data_other.406.1109379217';
set newname for datafile  21  to  '/usr/local/oracle/data/oradata/data_pha.292.1109379173';
set newname for datafile  24  to  '/usr/local/oracle/data/oradata/data_feeinfo.291.1109379171';
set newname for datafile  43  to  '/usr/local/oracle/data/oradata/index_lis.399.1109379213';
set newname for datafile  47  to  '/usr/local/oracle/data/oradata/index_itemlist.271.1109379159';
set newname for datafile  50  to  '/usr/local/oracle/data/oradata/index_feedetail.320.1109379187';
set newname for datafile  57  to  '/usr/local/oracle/data/oradata/index_recipedetail.397.1109379209';
set newname for datafile  59  to  '/usr/local/oracle/data/oradata/data_com.350.1109379197';
set newname for datafile  61  to  '/usr/local/oracle/data/oradata/data_met.340.1109379193';
set newname for datafile  65  to  '/usr/local/oracle/data/oradata/data_sem.355.1109379197';
set newname for datafile  76  to  '/usr/local/oracle/data/oradata/data_applyout.295.1109379173';
set newname for datafile  83  to  '/usr/local/oracle/data/oradata/index_user.417.1109379231';
set newname for datafile  87  to  '/usr/local/oracle/data/oradata/index_met.328.1109379189';
set newname for datafile  91  to  '/usr/local/oracle/data/oradata/index_sem.365.1109379199';
set newname for datafile  100  to  '/usr/local/oracle/data/oradata/index_feedetail.376.1109379201';
set newname for datafile  108  to  '/usr/local/oracle/data/oradata/index_applyout.301.1109379179';
set newname for datafile  120  to  '/usr/local/oracle/data/oradata/index_met.315.1109379185';
set newname for datafile  123  to  '/usr/local/oracle/data/oradata/index_medicinelist.304.1109379179';
set newname for datafile  127  to  '/usr/local/oracle/data/oradata/index_fin.329.1109379191';
set newname for datafile  137  to  '/usr/local/oracle/data/oradata/data_output.370.1109379199';
set newname for datafile  139  to  '/usr/local/oracle/data/oradata/data_recipedetail.283.1109379161';
set newname for datafile  145  to  '/usr/local/oracle/data/oradata/index_medicinelist.344.1109379195';
set newname for datafile  146  to  '/usr/local/oracle/data/oradata/index_output.375.1109379201';
set newname for datafile  151  to  '/usr/local/oracle/data/oradata/emr5.403.1109379215';
set newname for datafile  159  to  '/usr/local/oracle/data/oradata/emr52014.dbf';
set newname for datafile  164  to  '/usr/local/oracle/data/oradata/mr52019.dbf';
set newname for datafile  173  to  '/usr/local/oracle/data/oradata/neucbus.dbf';
set newname for datafile  175  to  '/usr/local/oracle/data/oradata/emr5202401.dbf';
set newname for datafile  181  to  '/usr/local/oracle/data/oradata/emr52023_data41802.dbf';
set newname for datafile  185  to  '/usr/local/oracle/data/oradata/emr52024_data41802.dbf';
set newname for datafile  187  to  '/usr/local/oracle/data/oradata/emr52024_data41804.dbf';
set newname for datafile  189  to  '/usr/local/oracle/data/oradata/emr52024_data02.dbf';
set newname for tempfile  1    to  '/usr/local/oracle/data/oradata/temp01';
set newname for tempfile  2    to  '/usr/local/oracle/data/oradata/temp02';
restore database;
switch datafile all;
switch tempfile all;
recover database;
}

恢复时保如下错误：

-- 提示缺少归档日志文件
archived log thread=1 sequence=279506
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/24/2024 16:07:52
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 279506 and starting SCN of 8200470803--手工执行recover database，恢复到 scn=8200470803
RMAN> recover database until scn 8200470803;Starting recover at 21-OCT-14
using channel ORA_DISK_1starting media recovery
media recovery complete, elapsed time: 00:00:00Finished recover at 21-OCT-14

查看磁盘空间的利用情况：

[root@node1 oradata]# df -h
文件系统                 容量  已用  可用 已用% 挂载点
/dev/mapper/centos-root   36G   16G   20G   44% /
devtmpfs                  32G     0   32G    0% /dev
tmpfs                     32G     0   32G    0% /dev/shm
tmpfs                     32G   12M   32G    1% /run
tmpfs                     32G     0   32G    0% /sys/fs/cgroup
/dev/vda6                355G  213G  125G   64% /usr/local/oracle/bak0921
/dev/vdb1                985G  747G  189G   80% /usr/local/oracle/data        # 数据文件
/dev/vda1               1014M  201M  814M   20% /boot
tmpfs                    6.3G   12K  6.3G    1% /run/user/42
tmpfs                    6.3G     0  6.3G    0% /run/user/0

八、恢复完成后的设置

1、修改日志文件

（1）查看日志文件

SQL> select member from v$logfile;MEMBER
--------------------------------------------------------------------------------
+DATA/hisdb/onlinelog/redo01.log
+DATA/hisdb/onlinelog/redo02.log
+DATA/hisdb/onlinelog/redo04.log
+DATA/hisdb/onlinelog/redo05.log
+DATA/hisdb/onlinelog/redo06.log
+DATA/hisdb/onlinelog/redo03.log
+DATA/hisdb/onlinelog/group_7.446.1121009477
+DATA/hisdb/onlinelog/group_8.447.1121009483
+DATA/hisdb/onlinelog/group_9.448.1121009489
+DATA/hisdb/onlinelog/group_10.449.1121009493
+DATA/hisdb/onlinelog/group_11.450.1121009499
+DATA/hisdb/onlinelog/group_12.451.1121009507
+DATA/hisdb/onlinelog/group_13.452.1121009507
+DATA/hisdb/onlinelog/group_14.453.112100950714 rows selected.

（2）修改日志文件名

alter database rename file '+DATA/hisdb/onlinelog/redo01.log' to '/usr/local/oracle/onlinelog/group_101';
alter database rename file '+DATA/hisdb/onlinelog/redo02.log' to '/usr/local/oracle/onlinelog/group_201';
alter database rename file '+DATA/hisdb/onlinelog/redo04.log' to '/usr/local/oracle/onlinelog/group_301';
alter database rename file '+DATA/hisdb/onlinelog/redo05.log' to '/usr/local/oracle/onlinelog/group_501';
alter database rename file '+DATA/hisdb/onlinelog/redo06.log' to '/usr/local/oracle/onlinelog/group_601';
alter database rename file '+DATA/hisdb/onlinelog/redo03.log' to '/usr/local/oracle/onlinelog/group_401';
alter database rename file '+DATA/hisdb/onlinelog/group_7.446.1121009477' to '/usr/local/oracle/onlinelog/group_701';
alter database rename file '+DATA/hisdb/onlinelog/group_8.447.1121009483' to '/usr/local/oracle/onlinelog/group_801';
alter database rename file '+DATA/hisdb/onlinelog/group_9.448.1121009489' to '/usr/local/oracle/onlinelog/group_901';
alter database rename file '+DATA/hisdb/onlinelog/group_10.449.1121009493' to '/usr/local/oracle/onlinelog/group_1001';
alter database rename file '+DATA/hisdb/onlinelog/group_11.450.1121009499' to '/usr/local/oracle/onlinelog/group_1101';
alter database rename file '+DATA/hisdb/onlinelog/group_12.451.1121009507' to '/usr/local/oracle/onlinelog/group_1201';
alter database rename file '+DATA/hisdb/onlinelog/group_13.452.1121009507' to '/usr/local/oracle/onlinelog/group_1301';
alter database rename file '+DATA/hisdb/onlinelog/group_14.453.1121009507' to '/usr/local/oracle/onlinelog/group_1401';

2、启动数据库

--启动时报错
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00392: log 4 of thread 1 is being cleared, operation not allowed
ORA-00312: online log 4 thread 1: '/usr/local/oracle/data/onlinelog/group_401'--手工执行如下命令
SQL> alter database clear logfile group 4;Database altered.--重新启动数据库
SQL> alter database open resetlogs;Database altered.

3、查看 redo log 信息，删除无效日志组（删除节点2的日志）

SQL> select THREAD#, STATUS, ENABLED from v$thread;THREAD# STATUS ENABLED
---------- ------ --------1 OPEN   PUBLIC2 CLOSED PUBLICSQL> select group# from v$log where THREAD#=2;    GROUP#
----------123SQL> alter database disable thread 2;
Database altered.SQL>  alter database drop logfile group 1;
Database altered.SQL>  alter database drop logfile group 2;
Database altered.SQL>  alter database drop logfile group 3;
Database altered.SQL>  select THREAD#, STATUS, ENABLED from v$thread;THREAD# STATUS ENABLED
---------- ------ --------1 OPEN   PUBLIC

4、查看 undo 表空间，并删除节点2的 undo 表空间

SQL>  select tablespace_name from dba_tablespaces where contents='UNDO';TABLESPACE_NAME
------------------------------
UNDOTBS1
UNDOTBS2SQL> drop tablespace UNDOTBS2 including contents and datafiles;
Tablespace dropped.

5、创建临时表空间

SQL> select tablespace_name from dba_tablespaces where contents='TEMPORARY';TABLESPACE_NAME
------------------------------
TEMPSQL> create temporary tablespace TEMP1 tempfile '/usr/local/oracle/data/oradata/temp03.dbf' size 50M;
Tablespace created.SQL> alter database default temporary tablespace TEMP1;
Database altered.SQL> drop tablespace TEMP including contents and datafiles;
Tablespace dropped.

6、重启数据库

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.SQL> startup
ORACLE instance started.
.....
Database mounted.
Database opened.

从 Oracle 集群到单节点环境（详细记录一次数据迁移过程）之三：在目标服务器上恢复数据

从 Oracle 集群到单节点环境（详细记录一次数据迁移过程）之三：在目标服务器上恢复数据目录从 Oracle 集群到单节点环境（详细记录一次数据迁移过程）之三：在目标服务器上恢复数据一、修改参数文件的内容二、…...

编程日记 2024/9/29 9:26:58

相互作用感知的 3D 分子生成 VAE 模型 - DeepICL 评测

DeepICL 是一个基于相互作用感知的 3D 分子生成模型，能够在目标结合口袋内进行相互作用引导的小分子设计。DeepICL 通过利用蛋白质-配体相互作用的普遍模式作为先验知识，在有限的实验数据下也能实现高度的泛化能力。一、背景介绍 DeepICL 来源于韩国科学…...

编程日记 2024/9/29 9:25:56

Java实现随机抽奖的方法有哪些

在Java中实现随机抽奖的方法，通常我们会使用java.util.Random类来生成随机数，然后基于这些随机数来选择中奖者。以下将给出几种常见的随机抽奖实现方式，包括从数组中抽取、从列表中抽取以及基于权重的抽奖方式。 1. 从数组中抽取 import ja…...

编程日记 2024/9/29 9:15:43

grafana加载缓慢解决方案

背景目前随着数据和图表的逐渐增多，Grafana 页面加载速度明显变慢，严重影响了用户体验，几次都有骂娘的冲动.，因此我们需要对 Grafana 进行优化，以提升加载性能。对于速度优化，我们可以从以下方面进行入…...

编程日记 2024/9/29 9:13:40

【湖南步联科技身份证】身份证读取与酒店收银系统源码整合———未来之窗行业应用跨平台架构

一、html5 <!DOCTYPE html> <html><head><meta http-equiv"Content-Type" content"text/html; charsetutf-8" /><script type"text/javascript" src"http://51.onelink.ynwlzc.net/o2o/tpl/Merchant/static/js…...

编程日记 2024/9/29 9:12:38

多路复用和事件轮询机制

多路复用：Nio 服务端只有一个线程处理多个连接事件轮询机制：select 底层用了 epoll。 select open 调用了 epoll 通过3个方法来实现事件轮询 1.epoll.create 创建epoll 多个集合 2.epoll.ctl 如果有事件会把事件挪到就绪事件列表。 3.epoll.wait 会监听…...

编程日记 2024/9/29 9:10:36

Android常用C++特性之std::abs

声明：本文内容生成自ChatGPT，目的是为方便大家了解学习作为引用到作者的其他文章中。 std::abs 是 C 标准库中的一个函数，用于计算整数、浮点数或其他数值类型的绝对值。它返回一个值，该值是参数的非负数形式，即去掉负…...

编程日记 2024/9/29 9:08:34

LabVIEW提高开发效率技巧----使用状态机架构

状态机架构（State Machine Architecture）是LabVIEW编程中的一种常见且高效的设计模式，特别适合用于处理具有多个操作状态的复杂系统。通过这种架构，程序能够根据不同的输入条件或事件，在多个状态之间切换，从…...

编程日记 2024/9/29 9:02:25

Feign：服务挂了也不会走fallback

Feign 本质上是一个 HTTP 客户端，用于简化微服务之间的 HTTP 通信。它允许开发者通过定义接口和注解来声明式地编写 HTTP 客户端，而无需手动编写 HTTP 请求和响应处理的代码。今天在模拟微服务A feign调用微服务B的时候，把微服务B关了&#…...

编程日记 2024/9/29 9:00:23

网络编程操作—函数

一、socket创建套接字 #include <sys/types.h> //头文件 #include <sys/socket.h> int socket(int domain, int type, int protocol); 三个参数：domain、type、protocol 1.domain:域名，领域，定义域（中文解释&…...

编程日记 2024/9/29 8:59:21

博客摘录「 GD32的flash读、擦除、写操作」2024年9月2日

关于GD32的Flash读、擦除、写操作，以下是基于当前可获得信息（截至2024年9月2日）的详细解答：一、GD32 Flash的基本特性存储空间：GD32的Flash存储空间大小因型号而异，可支持从几KB到几MB不等的存储容量。页大小：Flash按页组织，不同型号的GD32其页大小可能不同。例如，…...

编程日记 2024/9/29 8:58:20

【性能优化】低配starRocks常驻内存优化

背景说明由于服务器的实际资源小于starRocks官方的配置，导致starRocks在无任务的情况下，常驻内存偏高，可用于查询的资源变小。官方文档实际部署的集群一般是4C8G和8C16G，be的配置不达标为了解决单次查询内存不足的问题&…...

编程日记 2024/9/29 8:57:19

科研绘图系列：R语言树结构聚类热图（cluster heatmap）

文章目录介绍加载R包导入数据数据预处理画图修改图形导出数据系统信息介绍热图结合树结构展示聚类结果通常用于展示数据集中的模式和关系，这种图形被称为聚类热图或层次聚类热图。在这种图中，热图部分显示了数据矩阵的颜色编码值，而树结构（通常称为树状图或聚类树）则显…...

编程日记 2024/9/29 8:56:18

微信小程序操作蓝牙

主要流程： 1.初始化蓝牙适配器openBluetoothAdapter，如果不成功就onBluetoothAdapterStateChange监听蓝牙适配器状态变化事件 2.startBluetoothDevicesDiscovery开始搜寻附近的蓝牙外围设备 3.onBluetoothDeviceFound监听寻找到新设备的事件，…...

编程日记 2024/9/29 8:53:15

Python爱心射线（完整代码）

目录系列目录写在前面完整代码下载代码代码分析写在后面系列目录序号直达链接表白系列1Python制作一个无法拒绝的表白界面2Python满屏飘字表白代码3...

编程日记 2024/9/29 8:51:13

努比亚 Z17 NX563J Root 教程三方REC刷写工具教程

教程：1，自用成功正常链接列表 adb devices 检查fastboot链接列表 fastboot devices 解锁设备fastboot oem nubia_unlock NUBIA_NX563J 我用的解锁设备是：fastboot flashing unlock 1.打开开发者选项。将OEM解锁的按钮打开 2.下载附件努…...

编程日记 2024/9/29 8:48:08

Python 1-14 列表第一课 1437. 是否所有 1 都至少相隔 k 个元素 class Solution:def kLengthApart(self, nums: List[int], k: int) -> bool:cnt k # 处理第一个 1for i, x in enumerate(nums):if x 1:if cnt < k: return Falsecnt 0 # 遇到 1 从新记数else: cnt …...

编程日记 2024/9/29 8:47:07

【秋招笔试】09.28科大讯飞秋招(已改编)-研发岗

🍭 大家好这里是春秋招笔试突围，一起备战大厂笔试 💻 ACM金牌团队🏅️ | 多次AK大厂笔试｜大厂实习经历 ✨ 本系列打算持续跟新春秋招笔试题 👏 感谢大家的订阅➕ 和喜欢💗 和手里的小花花🌸 ✨ 笔试合集传送们 -> 🧷春秋招笔试合集本次的三题全部上线…...

编程日记 2024/9/29 8:44:04

[SAP ABAP] 锁对象

在SAP中使用锁对象，用于避免在数据库中插入或更改数据时出现不一致的情况 1.创建锁对象数据准备学校表(ZDBT_SCH_437) 使用事务码SE11创建锁对象点击"锁对象"单选按钮，输入以E开头的锁定对象的名称，然后点击创建按钮锁对象名…...

编程日记 2024/9/29 8:43:03

Docker快速部署RabbitMq教程

1、拉取RabbitMQ镜像 docker pull rabbitmq:management RabbitMQ Management 插件为 RabbitMQ 提供了一个基于 Web 的用户界面（Management UI），允许你通过浏览器来监控、管理 RabbitMQ 实例。因为docker默认是使用的是Docker Hub的官方镜…...

编程日记 2024/9/29 8:37:57

解决银河麒麟V10中/data目录执行权限问题

解决银河麒麟V10中/data目录执行权限问题 1、问题描述2、解决方案步骤一：编辑fstab文件步骤二：重启系统步骤三：验证更改 3、总结 💖The Begin💖点点关注，收藏不迷路💖 在使用银河麒麟桌面操作系…...

编程日记 2024/9/29 8:35:55

画两个数的平方和的曲线

代码1： from mpl_toolkits import mplot3d import numpy as np import matplotlib.pyplot as plt# Creating dataset x np.outer(np.linspace(-3, 3, 32), np.ones(32)) y x.copy().T # transpose z (x **2 y **2 )# Creating figure fig plt.figure(figsize …...

编程日记 2024/9/29 8:34:54

问：进程/线程上下文切换场景及相关概念?

进程、线程以及上下文切换是操作系统和并发编程中不可或缺的概念。这些概念不仅理论意义重大，而且在实际应用中起着至关重要的作用。掌柜将通过具体场景，探讨它们之间的关联以及上下文切换过程。_ 一、进程与线程进程（有时也称为任务&…...

编程日记 2024/9/29 8:32:51

神经网络（一）：神经网络入门

文章目录一、神经网络1.1神经元结构1.2单层神经网络：单层感知机1.3两层神经网络：多层感知机1.4多层神经网络二、全连接神经网络2.1基本结构2.2激活函数、前向传播、反向传播、损失函数2.2.1激活函数的意义2.2.2前向传播2.2.3损失函数、反向传播2.2.4梯…...

编程日记 2024/9/29 8:31:50

卸载apt-get 安装的PostgreSQL版本

文章目录卸载apt-get 安装的PostgreSQL版本查找已安装的PostgreSQL包卸载PostgreSQL：检查并删除残留文件验证卸载卸载apt-get 安装的PostgreSQL版本卸载通过apt-get安装的PostgreSQL 就版本，可以按照以下步骤进行。查找已安装的PostgreSQL包在卸…...

编程日记 2024/9/29 8:27:45

低代码用户中心：构建高效便捷的用户管理平台

什么是低代码用户中心？ 低代码用户中心是一种利用低代码开发平台构建的用户管理系统，允许企业快速创建、部署和管理用户信息、权限及互动记录。通过可视化界面和预置组件，企业可以在短时间内实现灵活的用户管理解决方案，而无需编…...

编程日记 2024/9/29 8:24:43

3款免费的GPT类工具

前言随着科技的飞速发展，人工智能（AI）的崛起与发展已经成为我们生活中不可或缺的一部分。它的出现彻底改变了我们与世界互动的方式，并为各行各业带来了前所未有的便利。一、Kimi 网址：点我前往国产AI模型Kimi是一…...

编程日记 2024/9/29 8:21:39

Mixture-of-Experts (MoE)：条件计算的诞生与崛起【上篇】

大型语言模型（LLM）的现代进步主要是缩放定律的产物[6]。假设模型是在足够大的数据集上训练出来的，那么随着底层模型规模的增加，我们会看到性能的平滑提升。这种扩展规律最终促使我们创建了 GPT-3 以及随后的其他（更强…...

编程日记 2024/9/29 8:19:37

【算法】分治：归并排序之LCR 170.交易逆序对的总数（hard）

系列专栏双指针模拟算法分治思想目录 1、题目链接 2、题目介绍 3、解法 4、代码 1、题目链接 LCR 159. 库存管理 III - 力扣（LeetCode） 2、题目介绍在股票交易中，如果前一天的股价高于后一天的股价，则可以认为存在一…...

编程日记 2024/9/29 8:18:36

2024.9.28 作业+思维导图

widget.cpp #include "widget.h"Widget::Widget(QWidget *parent): QWidget(parent) {this->setFixedSize(320,448);this->setWindowFlag(Qt::FramelessWindowHint);//QPushButtonQPushButton *PushButton1 new QPushButton("登录",this);PushButto…...

编程日记 2024/9/29 8:13:32

从 Oracle 集群到单节点环境（详细记录一次数据迁移过程）之三：在目标服务器上恢复数据

目录

一、修改参数文件的内容

二、创建参数文件中涉及到的所有目录

三、使用修改后的参数文件启动数据库到 nomount

四、生成 spfile 文件，关闭数据库，然后重新启动到 nomount

五、启动 rman，恢复控制文件，启动数据库到 mount

六、查看控制文件中的数据文件与临时文件信息

七、在目标服务器上开始恢复数据库

1、核对备份文件

2、删除失效的备份文件

3、重新核对备份文件

4、更新备份文件

5、查看备份集信息

6、恢复数据库

八、恢复完成后的设置

1、修改日志文件

2、启动数据库

3、查看 redo log 信息，删除无效日志组（删除节点2的日志）

4、查看 undo 表空间，并删除节点2的 undo 表空间

5、创建临时表空间

6、重启数据库

相关文章：