从 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 objects2、删除失效的备份文件
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.dbf6、恢复数据库
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 集群到单节点环境（详细记录一次数据迁移过程）之三：在目标服务器上恢复数据一、修改参数文件的内容二、…...
相互作用感知的 3D 分子生成 VAE 模型 - DeepICL 评测
DeepICL 是一个基于相互作用感知的 3D 分子生成模型，能够在目标结合口袋内进行相互作用引导的小分子设计。DeepICL 通过利用蛋白质-配体相互作用的普遍模式作为先验知识，在有限的实验数据下也能实现高度的泛化能力。 一、背景介绍 DeepICL 来源于韩国科学…...
Java实现随机抽奖的方法有哪些
在Java中实现随机抽奖的方法，通常我们会使用java.util.Random类来生成随机数，然后基于这些随机数来选择中奖者。以下将给出几种常见的随机抽奖实现方式，包括从数组中抽取、从列表中抽取以及基于权重的抽奖方式。 1. 从数组中抽取 import ja…...
grafana加载缓慢解决方案
背景 目前随着数据和图表的逐渐增多，Grafana 页面加载速度明显变慢，严重影响了用户体验，几次都有骂娘的冲动.，因此我们需要对 Grafana 进行优化，以提升加载性能。 对于速度优化，我们可以从以下方面进行入…...
【湖南步联科技身份证】 身份证读取与酒店收银系统源码整合———未来之窗行业应用跨平台架构
一、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…...
多路复用和事件轮询机制
多路复用：Nio 服务端只有一个线程处理多个连接 事件轮询机制：select 底层用了 epoll。 select open 调用了 epoll 通过3个方法来实现事件轮询 1.epoll.create 创建epoll 多个集合 2.epoll.ctl 如果有事件会把事件挪到就绪事件列表。 3.epoll.wait 会监听…...
Android常用C++特性之std::abs
声明：本文内容生成自ChatGPT，目的是为方便大家了解学习作为引用到作者的其他文章中。 std::abs 是 C 标准库中的一个函数，用于计算整数、浮点数或其他数值类型的绝对值。它返回一个值，该值是参数的非负数形式，即去掉负…...
LabVIEW提高开发效率技巧----使用状态机架构
状态机架构（State Machine Architecture）是LabVIEW编程中的一种常见且高效的设计模式，特别适合用于处理具有多个操作状态的复杂系统。通过这种架构，程序能够根据不同的输入条件或事件，在多个状态之间切换，从…...
Feign：服务挂了也不会走fallback
Feign 本质上是一个 HTTP 客户端，用于简化微服务之间的 HTTP 通信。它允许开发者通过定义接口和注解来声明式地编写 HTTP 客户端，而无需手动编写 HTTP 请求和响应处理的代码。 今天在模拟微服务A feign调用微服务B的时候，把微服务B关了&#…...
网络编程操作—函数
一、socket创建套接字 #include <sys/types.h> //头文件 #include <sys/socket.h> int socket(int domain, int type, int protocol); 三个参数：domain、type、protocol 1.domain:域名，领域，定义域（中文解释&…...
博客摘录「 GD32的flash读、擦除、写操作」2024年9月2日
关于GD32的Flash读、擦除、写操作，以下是基于当前可获得信息（截至2024年9月2日）的详细解答： 一、GD32 Flash的基本特性 存储空间：GD32的Flash存储空间大小因型号而异，可支持从几KB到几MB不等的存储容量。页大小：Flash按页组织，不同型号的GD32其页大小可能不同。例如，…...
【性能优化】低配starRocks常驻内存优化
背景说明 由于服务器的实际资源小于starRocks官方的配置，导致starRocks在无任务的情况下，常驻内存偏高，可用于查询的资源变小。 官方文档 实际部署的集群一般是4C8G和8C16G，be的配置不达标 为了解决单次查询内存不足的问题&…...
科研绘图系列：R语言树结构聚类热图（cluster heatmap）
文章目录 介绍加载R包导入数据数据预处理画图修改图形导出数据系统信息介绍 热图结合树结构展示聚类结果通常用于展示数据集中的模式和关系，这种图形被称为聚类热图或层次聚类热图。在这种图中，热图部分显示了数据矩阵的颜色编码值，而树结构（通常称为树状图或聚类树）则显…...
微信小程序操作蓝牙
主要流程： 1.初始化蓝牙适配器openBluetoothAdapter，如果不成功就onBluetoothAdapterStateChange监听蓝牙适配器状态变化事件 2.startBluetoothDevicesDiscovery开始搜寻附近的蓝牙外围设备 3.onBluetoothDeviceFound监听寻找到新设备的事件，…...
Python爱心射线（完整代码）
目录 系列目录 写在前面 完整代码 下载代码 代码分析 写在后面 系列目录 序号直达链接表白系列1Python制作一个无法拒绝的表白界面2Python满屏飘字表白代码3...
努比亚 Z17 NX563J Root 教程三方REC刷写工具教程
教程：1，自用成功 正常链接列表 adb devices 检查fastboot链接列表 fastboot devices 解锁设备fastboot oem nubia_unlock NUBIA_NX563J 我用的解锁设备是：fastboot flashing unlock 1.打开开发者选项。将OEM解锁的按钮打开 2.下载附件努…...
python 02 List
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 …...
-研发岗)
【秋招笔试】09.28科大讯飞秋招(已改编)-研发岗
🍭 大家好这里是 春秋招笔试突围，一起备战大厂笔试 💻 ACM金牌团队🏅️ | 多次AK大厂笔试 ｜ 大厂实习经历 ✨ 本系列打算持续跟新 春秋招笔试题 👏 感谢大家的订阅➕ 和 喜欢💗 和 手里的小花花🌸 ✨ 笔试合集传送们 -> 🧷春秋招笔试合集 本次的三题全部上线…...
[SAP ABAP] 锁对象
在SAP中使用锁对象，用于避免在数据库中插入或更改数据时出现不一致的情况 1.创建锁对象 数据准备 学校表(ZDBT_SCH_437) 使用事务码SE11创建锁对象 点击"锁对象"单选按钮，输入以E开头的锁定对象的名称，然后点击创建按钮 锁对象名…...
Docker快速部署RabbitMq教程
1、拉取RabbitMQ镜像 docker pull rabbitmq:management RabbitMQ Management 插件为 RabbitMQ 提供了一个基于 Web 的用户界面（Management UI），允许你通过浏览器来监控、管理 RabbitMQ 实例。 因为docker默认是使用的是Docker Hub的官方镜…...
大数据学习栈记——Neo4j的安装与使用
本文介绍图数据库Neofj的安装与使用，操作系统：Ubuntu24.04，Neofj版本：2025.04.0。 Apt安装 Neofj可以进行官网安装：Neo4j Deployment Center - Graph Database & Analytics 我这里安装是添加软件源的方法 最新版…...
如何将联系人从 iPhone 转移到 Android
从 iPhone 换到 Android 手机时，你可能需要保留重要的数据，例如通讯录。好在，将通讯录从 iPhone 转移到 Android 手机非常简单，你可以从本文中学习 6 种可靠的方法，确保随时保持连接，不错过任何信息。 第 1…...
Python如何给视频添加音频和字幕
在Python中，给视频添加音频和字幕可以使用电影文件处理库MoviePy和字幕处理库Subtitles。下面将详细介绍如何使用这些库来实现视频的音频和字幕添加，包括必要的代码示例和详细解释。 环境准备 在开始之前，需要安装以下Python库：…...
Device Mapper 机制
Device Mapper 机制详解 Device Mapper（简称 DM）是 Linux 内核中的一套通用块设备映射框架，为 LVM、加密磁盘、RAID 等提供底层支持。本文将详细介绍 Device Mapper 的原理、实现、内核配置、常用工具、操作测试流程，并配以详细的…...
Python 包管理器 uv 介绍
Python 包管理器 uv 全面介绍 uv 是由 Astral（热门工具 Ruff 的开发者）推出的下一代高性能 Python 包管理器和构建工具，用 Rust 编写。它旨在解决传统工具（如 pip、virtualenv、pip-tools）的性能瓶颈，同时…...
MySQL 部分重点知识篇
一、数据库对象 1. 主键 定义 ：主键是用于唯一标识表中每一行记录的字段或字段组合。它具有唯一性和非空性特点。 作用 ：确保数据的完整性，便于数据的查询和管理。 示例 ：在学生信息表中，学号可以作为主键ÿ…...
破解路内监管盲区：免布线低位视频桩重塑停车管理新标准
城市路内停车管理常因行道树遮挡、高位设备盲区等问题，导致车牌识别率低、逃费率高，传统模式在复杂路段束手无策。免布线低位视频桩凭借超低视角部署与智能算法，正成为破局关键。该设备安装于车位侧方0.5-0.7米高度，直接规避树枝遮…...
区块链技术概述
区块链技术是一种去中心化、分布式账本技术，通过密码学、共识机制和智能合约等核心组件，实现数据不可篡改、透明可追溯的系统。 一、核心技术 1. 去中心化 特点：数据存储在网络中的多个节点（计算机），而非…...
Mysql故障排插与环境优化
前置知识点 最上层是一些客户端和连接服务，包含本 sock 通信和大多数jiyukehuduan/服务端工具实现的TCP/IP通信。主要完成一些简介处理、授权认证、及相关的安全方案等。在该层上引入了线程池的概念，为通过安全认证接入的客户端提供线程。同样在该层上可…...
STL 2迭代器
文章目录 1.迭代器2.输入迭代器3.输出迭代器1.插入迭代器 4.前向迭代器5.双向迭代器6.随机访问迭代器7.不同容器返回的迭代器类型1.输入 / 输出迭代器2.前向迭代器3.双向迭代器4.随机访问迭代器5.特殊迭代器适配器6.为什么 unordered_set 只提供前向迭代器？ 1.迭代器…...