信阳企业网站开发,广州装修公司排名,ps做素材下载网站有哪些,logo免费下载网站从 Oracle 集群到单节点环境#xff08;详细记录一次数据迁移过程#xff09;之三#xff1a;在目标服务器上恢复数据 目录 从 Oracle 集群到单节点环境#xff08;详细记录一次数据迁移过程#xff09;之三#xff1a;在目标服务器上恢复数据一、修改参数文件的内容二、…从 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、重启数据库 在目标服务器上恢复数据执行如下操作 一、修改参数文件的内容
参数文件的位置如下
[oraclenode1 ~]$ pwd
/home/oracle
[oraclenode1 ~]$ 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
*.compatible11.2.0.4.0
*.control_files/usr/local/oracle/controlfile/control01.ctl,/usr/local/oracle/data/controlfile/control02.ctl
*.db_block_size8192
*.db_namehisdb
*.db_recovery_file_dest/usr/local/oracle/data/flash_recovery_area
*.db_recovery_file_dest_size536870912000
*.diagnostic_dest/usr/local/oracle
*.dispatchers(PROTOCOLTCP) (SERVICEhisdbXDB)
*.log_archive_dest_1location/usr/local/oracle/data/arch
*.log_archive_format%t_%s_%r.dbf
*.open_cursors300
*.processes1500
*.remote_login_passwordfileexclusive
*.undo_tablespaceUNDOTBS1
*.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
[rootnode1 bak]# pwd
/usr/local/oracle/bak0921/bak
[rootnode1 bak]# mv control_bak_1094.bak ../# 把控制文件复制到 /usr/local/oracle/bak0921/
[rootnode1 bak]# cd ..
[rootnode1 bak0921]# pwd
/usr/local/oracle/bak0921
[rootnode1 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 lostfound
drwxr-xr-x 3 oracle oinstall 4096 9月 23 21:31 usr恢复控制文件
-- 启动rman
[oraclenode1 ~]$ 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: SID996 device typeDISKchannel 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: SID996 device typeDISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID1138 device typeDISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID1280 device typeDISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID1422 device typeDISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID1563 device typeDISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID1706 device typeDISK
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 DatafilesFile 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 FilesFile 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 RECID610 STAMP1109378722
crosschecked backup piece: found to be EXPIRED
backup piece handle/data_bak/HISDB_1726452655_611_1_20220706.BKP RECID611 STAMP1109378723
crosschecked backup piece: found to be EXPIRED
backup piece handle/data_bak/HISDB_1726452655_612_1_20220706.BKP RECID612 STAMP1109378723
crosschecked backup piece: found to be EXPIRED
backup piece handle/data_bak/HISDB_1726452655_613_1_20220706.BKP RECID613 STAMP1109378723
crosschecked backup piece: found to be EXPIRED
backup piece handle/data_bak/HISDB_1726452655_614_1_20220706.BKP RECID614 STAMP1109378723
crosschecked backup piece: found to be EXPIRED
backup piece handle/data_bak/HISDB_1726452655_615_1_20220706.BKP RECID615 STAMP1109378723
crosschecked backup piece: found to be EXPIRED
backup piece handle/data_bak/HISDB_1726452655_616_1_20220706.BKP RECID616 STAMP1109378723
crosschecked backup piece: found to be EXPIRED
backup piece handle/data_bak/HISDB_1726452655_617_1_20220706.BKP RECID617 STAMP1109378723
crosschecked backup piece: found to be EXPIRED
backup piece handle/data_bak/HISDB_1726452655_618_1_20220706.BKP RECID618 STAMP1109378723
crosschecked backup piece: found to be EXPIRED
backup piece handle/data_bak/HISDB_1726452655_619_1_20220706.BKP RECID619 STAMP1109378723
crosschecked backup piece: found to be EXPIRED
backup piece handle/data_bak/HISDB_1726452655_620_1_20220706.BKP RECID620 STAMP1109378723
crosschecked backup piece: found to be EXPIRED
backup piece handle/data_bak/HISDB_1726452655_621_1_20220706.BKP RECID621 STAMP1109378723
crosschecked backup piece: found to be EXPIRED
backup piece handle/data_bak/HISDB_1726452655_622_1_20220706.BKP RECID622 STAMP1109378723
crosschecked backup piece: found to be EXPIRED
backup piece handle/data_bak/HISDB_1726452655_623_1_20220706.BKP RECID623 STAMP1109378723
crosschecked backup piece: found to be EXPIRED
backup piece handle/data_bak/HISDB_1726452655_624_1_20220706.BKP RECID624 STAMP1109378723
crosschecked backup piece: found to be EXPIRED
backup piece handle/data_bak/HISDB_1726452655_625_1_20220706.BKP RECID625 STAMP1109378723
crosschecked backup piece: found to be EXPIRED
backup piece handle/data_bak/HISDB_1726452655_626_1_20220706.BKP RECID626 STAMP1109378723
crosschecked backup piece: found to be EXPIRED
backup piece handle/data_bak/HISDB_1726452655_627_1_20220706.BKP RECID627 STAMP1109378723
crosschecked backup piece: found to be EXPIRED
backup piece handle/bak0921/control_bak_1085.bak RECID628 STAMP1180273157
crosschecked backup piece: found to be EXPIRED
backup piece handle/bak0921/HISDB_1726452655_1089_1_20240921.bkp RECID629 STAMP1180273227
crosschecked backup piece: found to be EXPIRED
backup piece handle/bak0921/HISDB_1726452655_1092_1_20240921.bkp RECID630 STAMP1180275114
crosschecked backup piece: found to be EXPIRED
backup piece handle/bak0921/HISDB_1726452655_1093_1_20240921.bkp RECID631 STAMP1180275117
crosschecked backup piece: found to be EXPIRED
backup piece handle/bak0921/HISDB_1726452655_1087_1_20240921.bkp RECID632 STAMP1180273226
crosschecked backup piece: found to be EXPIRED
backup piece handle/bak0921/HISDB_1726452655_1091_1_20240921.bkp RECID633 STAMP1180273228
crosschecked backup piece: found to be EXPIRED
backup piece handle/bak0921/HISDB_1726452655_1088_1_20240921.bkp RECID634 STAMP1180273226
crosschecked backup piece: found to be EXPIRED
backup piece handle/bak0921/HISDB_1726452655_1090_1_20240921.bkp RECID635 STAMP1180273227
crosschecked backup piece: found to be EXPIRED
backup piece handle/bak0921/HISDB_1726452655_1086_1_20240921.bkp RECID636 STAMP1180273226
Crosschecked 27 objects
2、删除失效的备份文件
RMAN delete expired backup;--
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
610 610 1 1 EXPIRED DISK /data_bak/HISDB_1726452655_610_1_20220706.BKP
611 611 1 1 EXPIRED DISK /data_bak/HISDB_1726452655_611_1_20220706.BKP
612 612 1 1 EXPIRED DISK /data_bak/HISDB_1726452655_612_1_20220706.BKP
613 613 1 1 EXPIRED DISK /data_bak/HISDB_1726452655_613_1_20220706.BKP
614 614 1 1 EXPIRED DISK /data_bak/HISDB_1726452655_614_1_20220706.BKP
615 615 1 1 EXPIRED DISK /data_bak/HISDB_1726452655_615_1_20220706.BKP
616 616 1 1 EXPIRED DISK /data_bak/HISDB_1726452655_616_1_20220706.BKP
617 617 1 1 EXPIRED DISK /data_bak/HISDB_1726452655_617_1_20220706.BKP
618 618 1 1 EXPIRED DISK /data_bak/HISDB_1726452655_618_1_20220706.BKP
619 619 1 1 EXPIRED DISK /data_bak/HISDB_1726452655_619_1_20220706.BKP
620 620 1 1 EXPIRED DISK /data_bak/HISDB_1726452655_620_1_20220706.BKP
621 621 1 1 EXPIRED DISK /data_bak/HISDB_1726452655_621_1_20220706.BKP
622 622 1 1 EXPIRED DISK /data_bak/HISDB_1726452655_622_1_20220706.BKP
623 623 1 1 EXPIRED DISK /data_bak/HISDB_1726452655_623_1_20220706.BKP
624 624 1 1 EXPIRED DISK /data_bak/HISDB_1726452655_624_1_20220706.BKP
625 625 1 1 EXPIRED DISK /data_bak/HISDB_1726452655_625_1_20220706.BKP
626 626 1 1 EXPIRED DISK /data_bak/HISDB_1726452655_626_1_20220706.BKP
627 627 1 1 EXPIRED DISK /data_bak/HISDB_1726452655_627_1_20220706.BKP
628 628 1 1 EXPIRED DISK /bak0921/control_bak_1085.bak
629 629 1 1 EXPIRED DISK /bak0921/HISDB_1726452655_1089_1_20240921.bkp
630 630 1 1 EXPIRED DISK /bak0921/HISDB_1726452655_1092_1_20240921.bkp
631 631 1 1 EXPIRED DISK /bak0921/HISDB_1726452655_1093_1_20240921.bkp
632 632 1 1 EXPIRED DISK /bak0921/HISDB_1726452655_1087_1_20240921.bkp
633 633 1 1 EXPIRED DISK /bak0921/HISDB_1726452655_1091_1_20240921.bkp
634 634 1 1 EXPIRED DISK /bak0921/HISDB_1726452655_1088_1_20240921.bkp
635 635 1 1 EXPIRED DISK /bak0921/HISDB_1726452655_1090_1_20240921.bkp
636 636 1 1 EXPIRED DISK /bak0921/HISDB_1726452655_1086_1_20240921.bkpDo you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle/data_bak/HISDB_1726452655_610_1_20220706.BKP RECID610 STAMP1109378722
deleted backup piece
backup piece handle/data_bak/HISDB_1726452655_611_1_20220706.BKP RECID611 STAMP1109378723
deleted backup piece
backup piece handle/data_bak/HISDB_1726452655_612_1_20220706.BKP RECID612 STAMP1109378723
deleted backup piece
backup piece handle/data_bak/HISDB_1726452655_613_1_20220706.BKP RECID613 STAMP1109378723
deleted backup piece
backup piece handle/data_bak/HISDB_1726452655_614_1_20220706.BKP RECID614 STAMP1109378723
deleted backup piece
backup piece handle/data_bak/HISDB_1726452655_615_1_20220706.BKP RECID615 STAMP1109378723
deleted backup piece
backup piece handle/data_bak/HISDB_1726452655_616_1_20220706.BKP RECID616 STAMP1109378723
deleted backup piece
backup piece handle/data_bak/HISDB_1726452655_617_1_20220706.BKP RECID617 STAMP1109378723
deleted backup piece
backup piece handle/data_bak/HISDB_1726452655_618_1_20220706.BKP RECID618 STAMP1109378723
deleted backup piece
backup piece handle/data_bak/HISDB_1726452655_619_1_20220706.BKP RECID619 STAMP1109378723
deleted backup piece
backup piece handle/data_bak/HISDB_1726452655_620_1_20220706.BKP RECID620 STAMP1109378723
deleted backup piece
backup piece handle/data_bak/HISDB_1726452655_621_1_20220706.BKP RECID621 STAMP1109378723
deleted backup piece
backup piece handle/data_bak/HISDB_1726452655_622_1_20220706.BKP RECID622 STAMP1109378723
deleted backup piece
backup piece handle/data_bak/HISDB_1726452655_623_1_20220706.BKP RECID623 STAMP1109378723
deleted backup piece
backup piece handle/data_bak/HISDB_1726452655_624_1_20220706.BKP RECID624 STAMP1109378723
deleted backup piece
backup piece handle/data_bak/HISDB_1726452655_625_1_20220706.BKP RECID625 STAMP1109378723
deleted backup piece
backup piece handle/data_bak/HISDB_1726452655_626_1_20220706.BKP RECID626 STAMP1109378723
deleted backup piece
backup piece handle/data_bak/HISDB_1726452655_627_1_20220706.BKP RECID627 STAMP1109378723
deleted backup piece
backup piece handle/bak0921/control_bak_1085.bak RECID628 STAMP1180273157
deleted backup piece
backup piece handle/bak0921/HISDB_1726452655_1089_1_20240921.bkp RECID629 STAMP1180273227
deleted backup piece
backup piece handle/bak0921/HISDB_1726452655_1092_1_20240921.bkp RECID630 STAMP1180275114
deleted backup piece
backup piece handle/bak0921/HISDB_1726452655_1093_1_20240921.bkp RECID631 STAMP1180275117
deleted backup piece
backup piece handle/bak0921/HISDB_1726452655_1087_1_20240921.bkp RECID632 STAMP1180273226
deleted backup piece
backup piece handle/bak0921/HISDB_1726452655_1091_1_20240921.bkp RECID633 STAMP1180273228
deleted backup piece
backup piece handle/bak0921/HISDB_1726452655_1088_1_20240921.bkp RECID634 STAMP1180273226
deleted backup piece
backup piece handle/bak0921/HISDB_1726452655_1090_1_20240921.bkp RECID635 STAMP1180273227
deleted backup piece
backup piece handle/bak0921/HISDB_1726452655_1086_1_20240921.bkp RECID636 STAMP1180273226
Deleted 27 EXPIRED objectsRMAN-08591: WARNING: invalid archived log deletion policy3、重新核对备份文件
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 repository4、更新备份文件
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 DatabaseFile 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 FilesFile 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 database5、查看备份集信息
list backup; ----备份集列表归档日志文件、数据文件、spfile、control file
list backupset; ----备份集列表归档日志文件、数据文件、spfile、control file
list backup of database; --显示数据文件
list backup of controlfile; ---显示控制文件
list backup of spfile; ----显示spfile文件
list backup of archivelog all; ---显示归档日志文件--
RMAN list backup of database;
--List of Backup Sets
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
705 Full 39.10G DISK 00:00:00 24-SEP-24 BP Key: 705 Status: AVAILABLE Compressed: YES Tag: TAG20240924T101007Piece Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1095_1_20240924.bkpList of Datafiles in backup set 705File LV Type Ckp SCN Ckp Time Name---- -- ---- ---------- --------- ----10 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/data_fin.318.110937918715 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/data_sem.400.110937921325 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/data_feedetail.354.110937919732 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/data_recipedetail.389.110937920339 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/index_goa.398.110937921145 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/index_ais.421.110937924348 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/index_medicinelist.279.110937915949 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/index_feeinfo.273.110937915952 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/index_output.298.110937917356 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/index_order.325.110937918964 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/data_aqu.348.110937919570 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/data_other.356.110937919778 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/data_record.297.110937917380 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/data_execundrug.327.110937918990 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/index_aqu.363.110937919999 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/index_feeinfo.362.1109379199104 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/index_execdrug.378.1109379201106 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/index_order.373.1109379199110 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/index_feedetail.306.1109379181113 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/data_feedetail.316.1109379187136 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/data_medicinelist.372.1109379199141 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/index_applyout.341.1109379193149 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/data_user.415.1109379229150 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/data_order.285.1109379161154 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/data_user.276.1109379159155 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/undotbs2.429.1109386101161 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/emr52016.dbf166 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/emr52021.dbf169 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/emr5202301.dbf177 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/emr52022_data41802.dbf183 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/emr52023_data41804.dbf191 Full 8200079404 24-SEP-24 DATA/hisdb/datafile/emr52024_data04.dbfBS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
716 Full 18.07G DISK 00:00:00 24-SEP-24 BP Key: 716 Status: AVAILABLE Compressed: YES Tag: TAG20240924T101007Piece Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1100_1_20240924.bkpList of Datafiles in backup set 716File LV Type Ckp SCN Ckp Time Name---- -- ---- ---------- --------- ----1 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/system.413.11093792274 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/users.423.11093792595 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/system.369.110937919911 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/data_met.313.110937918516 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/data_emr.416.110937922918 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/data_cas.408.110937922134 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/index_com.392.110937920337 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/index_met.311.110937918140 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/index_aqu.405.110937921755 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/index_execundrug.351.110937919766 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/data_emr.358.110937919771 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/data_pha.336.110937919372 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/data_itemlist.278.110937915973 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/data_medicinelist.294.110937917386 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/index_pha.330.110937919192 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/index_emr.360.110937919797 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/index_itemlist.280.1109379159101 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/index_applyout.357.1109379197114 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/index_applyout.300.1109379179117 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/data_fin.324.1109379187126 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/data_applyout.287.1109379169131 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/data_execdrug.317.1109379187132 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/data_execundrug.335.1109379193140 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/data_record.383.1109379201147 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/data_fin.388.1109379203156 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/nfemr.dbf162 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/emr52017.dbf168 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/emr5.403.1109379326.dbf172 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/neuodts.dbf178 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/emr52022_data41803.dbf192 Full 8200079430 24-SEP-24 DATA/hisdb/datafile/emr52024_data05.dbfBS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
750 Full 28.82G DISK 00:00:00 24-SEP-24 BP Key: 750 Status: AVAILABLE Compressed: YES Tag: TAG20240924T101007Piece Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1099_1_20240924.bkpList of Datafiles in backup set 750File LV Type Ckp SCN Ckp Time Name---- -- ---- ---------- --------- ----2 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/undotbs1.345.11093791957 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/users.347.110937919512 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/data_log.418.110937923319 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/data_ais.410.110937922327 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/data_output.286.110937916928 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/data_record.293.110937917330 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/data_execundrug.314.110937918533 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/index_user.404.110937921536 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/index_pha.288.110937917142 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/index_emr.395.110937920346 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/index_other.396.110937920963 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/data_goa.352.110937919775 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/data_feedetail.364.110937919979 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/data_execdrug.289.110937917181 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/data_order.307.110937918184 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/index_com.402.110937921585 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/index_fin.331.110937919189 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/index_goa.366.110937919995 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/index_ais.371.1109379199105 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/index_execundrug.384.1109379201115 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/data_execdrug.322.1109379187118 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/index_com.390.1109379203121 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/data_met.302.1109379179135 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/data_itemlist.379.1109379201142 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/index_execundrug.333.1109379193148 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/data_output.353.1109379197153 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/data_order.270.1109379159158 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/emr52013.dbf174 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/emr5202305.dbf180 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/emr52023_data41801.dbf184 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/emr52024_data41801.dbf186 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/emr52024_data41803.dbf188 Full 8200079411 24-SEP-24 DATA/hisdb/datafile/emr52024_data01.dbfBS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
788 Full 46.35G DISK 00:00:00 24-SEP-24 BP Key: 788 Status: AVAILABLE Compressed: YES Tag: TAG20240924T101007Piece Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1096_1_20240924.bkpList of Datafiles in backup set 788File LV Type Ckp SCN Ckp Time Name---- -- ---- ---------- --------- ----3 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/sysaux.412.11093792259 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/data_com.386.110937920114 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/data_aqu.420.110937923926 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/data_applyout.275.110937915929 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/data_execdrug.272.110937915935 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/index_fin.312.110937918338 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/index_log.394.110937920344 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/index_cas.393.110937920360 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/data_fin.339.110937919367 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/data_lis.368.110937919982 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/data_recipedetail.387.110937920393 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/index_lis.359.110937919796 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/index_other.332.1109379193102 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/index_output.374.1109379201107 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/index_recipedetail.380.1109379201109 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/index_feeinfo.296.1109379173111 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/data_pha.323.1109379187116 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/data_execundrug.338.1109379193125 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/data_order.308.1109379181128 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/index_execdrug.326.1109379189130 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/index_output.309.1109379181134 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/data_feedetail.377.1109379201138 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/data_pha.411.1109379225144 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/index_itemlist.346.1109379195152 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/data_order.277.1109379159160 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/emr52015.dbf165 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/emr52020.dbf167 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/emr52022.dbf170 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/emr5202302.dbf176 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/emr52022_data41801.dbf182 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/emr52023_data41803.dbf190 Full 8200079405 24-SEP-24 DATA/hisdb/datafile/emr52024_data03.dbfBS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
807 Full 34.15G DISK 00:00:00 24-SEP-24 BP Key: 807 Status: AVAILABLE Compressed: YES Tag: TAG20240924T101007Piece Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1098_1_20240924.bkpList of Datafiles in backup set 807File LV Type Ckp SCN Ckp Time Name---- -- ---- ---------- --------- ----6 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/sysaux.419.11093792398 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/data_user.407.110937922117 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/data_lis.409.110937922322 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/data_itemlist.281.110937915923 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/data_medicinelist.282.110937916131 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/data_order.274.110937915941 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/index_sem.414.110937922751 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/index_applyout.284.110937916153 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/index_record.391.110937920354 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/index_execdrug.343.110937919558 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/data_user.401.110937921562 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/data_log.349.110937919768 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/data_cas.342.110937919369 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/data_ais.361.110937919974 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/data_feeinfo.321.110937918777 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/data_output.299.110937917788 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/index_log.334.110937919394 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/index_cas.367.110937919998 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/index_medicinelist.310.1109379181103 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/index_record.381.1109379201112 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/data_feeinfo.303.1109379179119 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/index_order.305.1109379181122 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/index_pha.319.1109379187124 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/data_medicinelist.290.1109379171129 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/index_feeinfo.337.1109379193133 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/data_feeinfo.382.1109379201143 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/index_feeinfo.385.1109379201157 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/emr52012.dbf163 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/emr52018.dbf171 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/emr5202303.dbf179 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/emr52022_data41804.dbf193 Full 8200079410 24-SEP-24 DATA/hisdb/datafile/emr52024_data06.dbfBS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
852 Full 46.21G DISK 00:00:00 24-SEP-24 BP Key: 852 Status: AVAILABLE Compressed: YES Tag: TAG20240924T101007Piece Name: /usr/local/oracle/bak0921/bak/HISDB_1726452655_1097_1_20240924.bkpList of Datafiles in backup set 852File LV Type Ckp SCN Ckp Time Name---- -- ---- ---------- --------- ----13 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/data_goa.422.110937925920 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/data_other.406.110937921721 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/data_pha.292.110937917324 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/data_feeinfo.291.110937917143 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/index_lis.399.110937921347 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/index_itemlist.271.110937915950 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/index_feedetail.320.110937918757 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/index_recipedetail.397.110937920959 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/data_com.350.110937919761 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/data_met.340.110937919365 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/data_sem.355.110937919776 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/data_applyout.295.110937917383 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/index_user.417.110937923187 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/index_met.328.110937918991 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/index_sem.365.1109379199100 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/index_feedetail.376.1109379201108 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/index_applyout.301.1109379179120 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/index_met.315.1109379185123 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/index_medicinelist.304.1109379179127 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/index_fin.329.1109379191137 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/data_output.370.1109379199139 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/data_recipedetail.283.1109379161145 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/index_medicinelist.344.1109379195146 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/index_output.375.1109379201151 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/emr5.403.1109379215159 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/emr52014.dbf164 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/mr52019.dbf173 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/neucbus.dbf175 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/emr5202401.dbf181 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/emr52023_data41802.dbf185 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/emr52024_data41802.dbf187 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/emr52024_data41804.dbf189 Full 8200079406 24-SEP-24 DATA/hisdb/datafile/emr52024_data02.dbf
6、恢复数据库
run{
set newname for datafile 10 to /usr/local/oracle/data/oradata/data_fin.318.1109379187;
set newname for datafile 15 to /usr/local/oracle/data/oradata/data_sem.400.1109379213;
set newname for datafile 25 to /usr/local/oracle/data/oradata/data_feedetail.354.1109379197;
set newname for datafile 32 to /usr/local/oracle/data/oradata/data_recipedetail.389.1109379203;
set newname for datafile 39 to /usr/local/oracle/data/oradata/index_goa.398.1109379211;
set newname for datafile 45 to /usr/local/oracle/data/oradata/index_ais.421.1109379243;
set newname for datafile 48 to /usr/local/oracle/data/oradata/index_medicinelist.279.1109379159;
set newname for datafile 49 to /usr/local/oracle/data/oradata/index_feeinfo.273.1109379159;
set newname for datafile 52 to /usr/local/oracle/data/oradata/index_output.298.1109379173;
set newname for datafile 56 to /usr/local/oracle/data/oradata/index_order.325.1109379189;
set newname for datafile 64 to /usr/local/oracle/data/oradata/data_aqu.348.1109379195;
set newname for datafile 70 to /usr/local/oracle/data/oradata/data_other.356.1109379197;
set newname for datafile 78 to /usr/local/oracle/data/oradata/data_record.297.1109379173;
set newname for datafile 80 to /usr/local/oracle/data/oradata/data_execundrug.327.1109379189;
set newname for datafile 90 to /usr/local/oracle/data/oradata/index_aqu.363.1109379199;
set newname for datafile 99 to /usr/local/oracle/data/oradata/index_feeinfo.362.1109379199;
set newname for datafile 104 to /usr/local/oracle/data/oradata/index_execdrug.378.1109379201;
set newname for datafile 106 to /usr/local/oracle/data/oradata/index_order.373.1109379199;
set newname for datafile 110 to /usr/local/oracle/data/oradata/index_feedetail.306.1109379181;
set newname for datafile 113 to /usr/local/oracle/data/oradata/data_feedetail.316.1109379187;
set newname for datafile 136 to /usr/local/oracle/data/oradata/data_medicinelist.372.1109379199;
set newname for datafile 141 to /usr/local/oracle/data/oradata/index_applyout.341.1109379193;
set newname for datafile 149 to /usr/local/oracle/data/oradata/data_user.415.1109379229;
set newname for datafile 150 to /usr/local/oracle/data/oradata/data_order.285.1109379161;
set newname for datafile 154 to /usr/local/oracle/data/oradata/data_user.276.1109379159;
set newname for datafile 155 to /usr/local/oracle/data/oradata/undotbs2.429.1109386101;
set newname for datafile 161 to /usr/local/oracle/data/oradata/emr52016.dbf;
set newname for datafile 166 to /usr/local/oracle/data/oradata/emr52021.dbf;
set newname for datafile 169 to /usr/local/oracle/data/oradata/emr5202301.dbf;
set newname for datafile 177 to /usr/local/oracle/data/oradata/emr52022_data41802.dbf;
set newname for datafile 183 to /usr/local/oracle/data/oradata/emr52023_data41804.dbf;
set newname for datafile 191 to /usr/local/oracle/data/oradata/emr52024_data04.dbf;
set newname for datafile 1 to /usr/local/oracle/data/oradata/system.413.1109379227;
set newname for datafile 4 to /usr/local/oracle/data/oradata/users.423.1109379259;
set newname for datafile 5 to /usr/local/oracle/data/oradata/system.369.1109379199;
set newname for datafile 11 to /usr/local/oracle/data/oradata/data_met.313.1109379185;
set newname for datafile 16 to /usr/local/oracle/data/oradata/data_emr.416.1109379229;
set newname for datafile 18 to /usr/local/oracle/data/oradata/data_cas.408.1109379221;
set newname for datafile 34 to /usr/local/oracle/data/oradata/index_com.392.1109379203;
set newname for datafile 37 to /usr/local/oracle/data/oradata/index_met.311.1109379181;
set newname for datafile 40 to /usr/local/oracle/data/oradata/index_aqu.405.1109379217;
set newname for datafile 55 to /usr/local/oracle/data/oradata/index_execundrug.351.1109379197;
set newname for datafile 66 to /usr/local/oracle/data/oradata/data_emr.358.1109379197;
set newname for datafile 71 to /usr/local/oracle/data/oradata/data_pha.336.1109379193;
set newname for datafile 72 to /usr/local/oracle/data/oradata/data_itemlist.278.1109379159;
set newname for datafile 73 to /usr/local/oracle/data/oradata/data_medicinelist.294.1109379173;
set newname for datafile 86 to /usr/local/oracle/data/oradata/index_pha.330.1109379191;
set newname for datafile 92 to /usr/local/oracle/data/oradata/index_emr.360.1109379197;
set newname for datafile 97 to /usr/local/oracle/data/oradata/index_itemlist.280.1109379159;
set newname for datafile 101 to /usr/local/oracle/data/oradata/index_applyout.357.1109379197;
set newname for datafile 114 to /usr/local/oracle/data/oradata/index_applyout.300.1109379179;
set newname for datafile 117 to /usr/local/oracle/data/oradata/data_fin.324.1109379187;
set newname for datafile 126 to /usr/local/oracle/data/oradata/data_applyout.287.1109379169;
set newname for datafile 131 to /usr/local/oracle/data/oradata/data_execdrug.317.1109379187;
set newname for datafile 132 to /usr/local/oracle/data/oradata/data_execundrug.335.1109379193;
set newname for datafile 140 to /usr/local/oracle/data/oradata/data_record.383.1109379201;
set newname for datafile 147 to /usr/local/oracle/data/oradata/data_fin.388.1109379203;
set newname for datafile 156 to /usr/local/oracle/data/oradata/nfemr.dbf;
set newname for datafile 162 to /usr/local/oracle/data/oradata/emr52017.dbf;
set newname for datafile 168 to /usr/local/oracle/data/oradata/emr5.403.1109379326.dbf;
set newname for datafile 172 to /usr/local/oracle/data/oradata/neuodts.dbf;
set newname for datafile 178 to /usr/local/oracle/data/oradata/emr52022_data41803.dbf;
set newname for datafile 192 to /usr/local/oracle/data/oradata/emr52024_data05.dbf;
set newname for datafile 2 to /usr/local/oracle/data/oradata/undotbs1.345.1109379195;
set newname for datafile 7 to /usr/local/oracle/data/oradata/users.347.1109379195;
set newname for datafile 12 to /usr/local/oracle/data/oradata/data_log.418.1109379233;
set newname for datafile 19 to /usr/local/oracle/data/oradata/data_ais.410.1109379223;
set newname for datafile 27 to /usr/local/oracle/data/oradata/data_output.286.1109379169;
set newname for datafile 28 to /usr/local/oracle/data/oradata/data_record.293.1109379173;
set newname for datafile 30 to /usr/local/oracle/data/oradata/data_execundrug.314.1109379185;
set newname for datafile 33 to /usr/local/oracle/data/oradata/index_user.404.1109379215;
set newname for datafile 36 to /usr/local/oracle/data/oradata/index_pha.288.1109379171;
set newname for datafile 42 to /usr/local/oracle/data/oradata/index_emr.395.1109379203;
set newname for datafile 46 to /usr/local/oracle/data/oradata/index_other.396.1109379209;
set newname for datafile 63 to /usr/local/oracle/data/oradata/data_goa.352.1109379197;
set newname for datafile 75 to /usr/local/oracle/data/oradata/data_feedetail.364.1109379199;
set newname for datafile 79 to /usr/local/oracle/data/oradata/data_execdrug.289.1109379171;
set newname for datafile 81 to /usr/local/oracle/data/oradata/data_order.307.1109379181;
set newname for datafile 84 to /usr/local/oracle/data/oradata/index_com.402.1109379215;
set newname for datafile 85 to /usr/local/oracle/data/oradata/index_fin.331.1109379191;
set newname for datafile 89 to /usr/local/oracle/data/oradata/index_goa.366.1109379199;
set newname for datafile 95 to /usr/local/oracle/data/oradata/index_ais.371.1109379199;
set newname for datafile 105 to /usr/local/oracle/data/oradata/index_execundrug.384.1109379201;
set newname for datafile 115 to /usr/local/oracle/data/oradata/data_execdrug.322.1109379187;
set newname for datafile 118 to /usr/local/oracle/data/oradata/index_com.390.1109379203;
set newname for datafile 121 to /usr/local/oracle/data/oradata/data_met.302.1109379179;
set newname for datafile 135 to /usr/local/oracle/data/oradata/data_itemlist.379.1109379201;
set newname for datafile 142 to /usr/local/oracle/data/oradata/index_execundrug.333.1109379193;
set newname for datafile 148 to /usr/local/oracle/data/oradata/data_output.353.1109379197;
set newname for datafile 153 to /usr/local/oracle/data/oradata/data_order.270.1109379159;
set newname for datafile 158 to /usr/local/oracle/data/oradata/emr52013.dbf;
set newname for datafile 174 to /usr/local/oracle/data/oradata/emr5202305.dbf;
set newname for datafile 180 to /usr/local/oracle/data/oradata/emr52023_data41801.dbf;
set newname for datafile 184 to /usr/local/oracle/data/oradata/emr52024_data41801.dbf;
set newname for datafile 186 to /usr/local/oracle/data/oradata/emr52024_data41803.dbf;
set newname for datafile 188 to /usr/local/oracle/data/oradata/emr52024_data01.dbf;
set newname for datafile 3 to /usr/local/oracle/data/oradata/sysaux.412.1109379225;
set newname for datafile 9 to /usr/local/oracle/data/oradata/data_com.386.1109379201;
set newname for datafile 14 to /usr/local/oracle/data/oradata/data_aqu.420.1109379239;
set newname for datafile 26 to /usr/local/oracle/data/oradata/data_applyout.275.1109379159;
set newname for datafile 29 to /usr/local/oracle/data/oradata/data_execdrug.272.1109379159;
set newname for datafile 35 to /usr/local/oracle/data/oradata/index_fin.312.1109379183;
set newname for datafile 38 to /usr/local/oracle/data/oradata/index_log.394.1109379203;
set newname for datafile 44 to /usr/local/oracle/data/oradata/index_cas.393.1109379203;
set newname for datafile 60 to /usr/local/oracle/data/oradata/data_fin.339.1109379193;
set newname for datafile 67 to /usr/local/oracle/data/oradata/data_lis.368.1109379199;
set newname for datafile 82 to /usr/local/oracle/data/oradata/data_recipedetail.387.1109379203;
set newname for datafile 93 to /usr/local/oracle/data/oradata/index_lis.359.1109379197;
set newname for datafile 96 to /usr/local/oracle/data/oradata/index_other.332.1109379193;
set newname for datafile 102 to /usr/local/oracle/data/oradata/index_output.374.1109379201;
set newname for datafile 107 to /usr/local/oracle/data/oradata/index_recipedetail.380.1109379201;
set newname for datafile 109 to /usr/local/oracle/data/oradata/index_feeinfo.296.1109379173;
set newname for datafile 111 to /usr/local/oracle/data/oradata/data_pha.323.1109379187;
set newname for datafile 116 to /usr/local/oracle/data/oradata/data_execundrug.338.1109379193;
set newname for datafile 125 to /usr/local/oracle/data/oradata/data_order.308.1109379181;
set newname for datafile 128 to /usr/local/oracle/data/oradata/index_execdrug.326.1109379189;
set newname for datafile 130 to /usr/local/oracle/data/oradata/index_output.309.1109379181;
set newname for datafile 134 to /usr/local/oracle/data/oradata/data_feedetail.377.1109379201;
set newname for datafile 138 to /usr/local/oracle/data/oradata/data_pha.411.1109379225;
set newname for datafile 144 to /usr/local/oracle/data/oradata/index_itemlist.346.1109379195;
set newname for datafile 152 to /usr/local/oracle/data/oradata/data_order.277.1109379159;
set newname for datafile 160 to /usr/local/oracle/data/oradata/emr52015.dbf;
set newname for datafile 165 to /usr/local/oracle/data/oradata/emr52020.dbf;
set newname for datafile 167 to /usr/local/oracle/data/oradata/emr52022.dbf;
set newname for datafile 170 to /usr/local/oracle/data/oradata/emr5202302.dbf;
set newname for datafile 176 to /usr/local/oracle/data/oradata/emr52022_data41801.dbf;
set newname for datafile 182 to /usr/local/oracle/data/oradata/emr52023_data41803.dbf;
set newname for datafile 190 to /usr/local/oracle/data/oradata/emr52024_data03.dbf;
set newname for datafile 6 to /usr/local/oracle/data/oradata/sysaux.419.1109379239;
set newname for datafile 8 to /usr/local/oracle/data/oradata/data_user.407.1109379221;
set newname for datafile 17 to /usr/local/oracle/data/oradata/data_lis.409.1109379223;
set newname for datafile 22 to /usr/local/oracle/data/oradata/data_itemlist.281.1109379159;
set newname for datafile 23 to /usr/local/oracle/data/oradata/data_medicinelist.282.1109379161;
set newname for datafile 31 to /usr/local/oracle/data/oradata/data_order.274.1109379159;
set newname for datafile 41 to /usr/local/oracle/data/oradata/index_sem.414.1109379227;
set newname for datafile 51 to /usr/local/oracle/data/oradata/index_applyout.284.1109379161;
set newname for datafile 53 to /usr/local/oracle/data/oradata/index_record.391.1109379203;
set newname for datafile 54 to /usr/local/oracle/data/oradata/index_execdrug.343.1109379195;
set newname for datafile 58 to /usr/local/oracle/data/oradata/data_user.401.1109379215;
set newname for datafile 62 to /usr/local/oracle/data/oradata/data_log.349.1109379197;
set newname for datafile 68 to /usr/local/oracle/data/oradata/data_cas.342.1109379193;
set newname for datafile 69 to /usr/local/oracle/data/oradata/data_ais.361.1109379199;
set newname for datafile 74 to /usr/local/oracle/data/oradata/data_feeinfo.321.1109379187;
set newname for datafile 77 to /usr/local/oracle/data/oradata/data_output.299.1109379177;
set newname for datafile 88 to /usr/local/oracle/data/oradata/index_log.334.1109379193;
set newname for datafile 94 to /usr/local/oracle/data/oradata/index_cas.367.1109379199;
set newname for datafile 98 to /usr/local/oracle/data/oradata/index_medicinelist.310.1109379181;
set newname for datafile 103 to /usr/local/oracle/data/oradata/index_record.381.1109379201;
set newname for datafile 112 to /usr/local/oracle/data/oradata/data_feeinfo.303.1109379179;
set newname for datafile 119 to /usr/local/oracle/data/oradata/index_order.305.1109379181;
set newname for datafile 122 to /usr/local/oracle/data/oradata/index_pha.319.1109379187;
set newname for datafile 124 to /usr/local/oracle/data/oradata/data_medicinelist.290.1109379171;
set newname for datafile 129 to /usr/local/oracle/data/oradata/index_feeinfo.337.1109379193;
set newname for datafile 133 to /usr/local/oracle/data/oradata/data_feeinfo.382.1109379201;
set newname for datafile 143 to /usr/local/oracle/data/oradata/index_feeinfo.385.1109379201;
set newname for datafile 157 to /usr/local/oracle/data/oradata/emr52012.dbf;
set newname for datafile 163 to /usr/local/oracle/data/oradata/emr52018.dbf;
set newname for datafile 171 to /usr/local/oracle/data/oradata/emr5202303.dbf;
set newname for datafile 179 to /usr/local/oracle/data/oradata/emr52022_data41804.dbf;
set newname for datafile 193 to /usr/local/oracle/data/oradata/emr52024_data06.dbf;
set newname for datafile 13 to /usr/local/oracle/data/oradata/data_goa.422.1109379259;
set newname for datafile 20 to /usr/local/oracle/data/oradata/data_other.406.1109379217;
set newname for datafile 21 to /usr/local/oracle/data/oradata/data_pha.292.1109379173;
set newname for datafile 24 to /usr/local/oracle/data/oradata/data_feeinfo.291.1109379171;
set newname for datafile 43 to /usr/local/oracle/data/oradata/index_lis.399.1109379213;
set newname for datafile 47 to /usr/local/oracle/data/oradata/index_itemlist.271.1109379159;
set newname for datafile 50 to /usr/local/oracle/data/oradata/index_feedetail.320.1109379187;
set newname for datafile 57 to /usr/local/oracle/data/oradata/index_recipedetail.397.1109379209;
set newname for datafile 59 to /usr/local/oracle/data/oradata/data_com.350.1109379197;
set newname for datafile 61 to /usr/local/oracle/data/oradata/data_met.340.1109379193;
set newname for datafile 65 to /usr/local/oracle/data/oradata/data_sem.355.1109379197;
set newname for datafile 76 to /usr/local/oracle/data/oradata/data_applyout.295.1109379173;
set newname for datafile 83 to /usr/local/oracle/data/oradata/index_user.417.1109379231;
set newname for datafile 87 to /usr/local/oracle/data/oradata/index_met.328.1109379189;
set newname for datafile 91 to /usr/local/oracle/data/oradata/index_sem.365.1109379199;
set newname for datafile 100 to /usr/local/oracle/data/oradata/index_feedetail.376.1109379201;
set newname for datafile 108 to /usr/local/oracle/data/oradata/index_applyout.301.1109379179;
set newname for datafile 120 to /usr/local/oracle/data/oradata/index_met.315.1109379185;
set newname for datafile 123 to /usr/local/oracle/data/oradata/index_medicinelist.304.1109379179;
set newname for datafile 127 to /usr/local/oracle/data/oradata/index_fin.329.1109379191;
set newname for datafile 137 to /usr/local/oracle/data/oradata/data_output.370.1109379199;
set newname for datafile 139 to /usr/local/oracle/data/oradata/data_recipedetail.283.1109379161;
set newname for datafile 145 to /usr/local/oracle/data/oradata/index_medicinelist.344.1109379195;
set newname for datafile 146 to /usr/local/oracle/data/oradata/index_output.375.1109379201;
set newname for datafile 151 to /usr/local/oracle/data/oradata/emr5.403.1109379215;
set newname for datafile 159 to /usr/local/oracle/data/oradata/emr52014.dbf;
set newname for datafile 164 to /usr/local/oracle/data/oradata/mr52019.dbf;
set newname for datafile 173 to /usr/local/oracle/data/oradata/neucbus.dbf;
set newname for datafile 175 to /usr/local/oracle/data/oradata/emr5202401.dbf;
set newname for datafile 181 to /usr/local/oracle/data/oradata/emr52023_data41802.dbf;
set newname for datafile 185 to /usr/local/oracle/data/oradata/emr52024_data41802.dbf;
set newname for datafile 187 to /usr/local/oracle/data/oradata/emr52024_data41804.dbf;
set newname for datafile 189 to /usr/local/oracle/data/oradata/emr52024_data02.dbf;
set newname for tempfile 1 to /usr/local/oracle/data/oradata/temp01;
set newname for tempfile 2 to /usr/local/oracle/data/oradata/temp02;
restore database;
switch datafile all;
switch tempfile all;
recover database;
}恢复时保如下错误
-- 提示缺少归档日志文件
archived log thread1 sequence279506
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恢复到 scn8200470803
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查看磁盘空间的利用情况
[rootnode1 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 PUBLIC4、查看 undo 表空间并删除节点2的 undo 表空间
SQL select tablespace_name from dba_tablespaces where contentsUNDO;TABLESPACE_NAME
------------------------------
UNDOTBS1
UNDOTBS2SQL drop tablespace UNDOTBS2 including contents and datafiles;
Tablespace dropped.5、创建临时表空间
SQL select tablespace_name from dba_tablespaces where contentsTEMPORARY;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.
