Oracle ASM 管理的数据库恢复为单实例数据库

ASM 管理的数据库恢复为单实例数据库(主要目的在于恢复测试)

一、恢复演练系统选择

  根据数据库情况选择恢复测试的环境。
  此次恢复测试主要针对 rhel linux 7.5环境下的ASM管理的数据库备份恢到单实例数据库,主要目的在于测试核心备份是否可用。

二、恢复演练记录(整库恢复)
注:本次恢复使用文件系统而不在是ASM文件系统
1、从生产库拷贝密码文件到目标库$ORACLE_HOME/dbs下并修改密码文件名称与恢复库相对应,也可以直接创建密码文件。

2、恢复spfile文件
从生产库导出pfile文件并修改对应参数,修改后参数如下:
ynsb.__data_transfer_cache_size=0
ynsb.__db_cache_size=169114337280
ynsb.__inmemory_ext_roarea=0
ynsb.__inmemory_ext_rwarea=0
ynsb.__java_pool_size=0
ynsb.__large_pool_size=2684354560
ynsb.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
ynsb.__pga_aggregate_target=21474836480
ynsb.__sga_target=193273528320
ynsb.__shared_io_pool_size=0
ynsb.__shared_pool_size=20937965568
ynsb.__streams_pool_size=0
ynsb.__unified_pga_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/ynsb/adump'
*.audit_trail='DB'
*.compatible='19.0.0'
*.control_file_record_keep_time=31
*.control_files='/u01/app/oracle/oradata/ynsb/control01.dbf','/u01/app/oracle/oradata/ynsb/control02.dbf'#Restore Controlfile
*.core_dump_dest='/u01/app/oracle/diag/rdbms/ynsb/ynsb/cdump'
*.db_block_size=8192
*.db_create_file_dest='/u01/app/oracle/oradata/'
*.db_files=2000
*.db_name='ynsb'
*.deferred_segment_creation=FALSE
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ynsbXDB)'
*.log_archive_dest_1='LOCATION=/u01/app/arch_log/'
*.open_cursors=3000
*.optimizer_features_enable='11.2.0.4'
*.optimizer_mode='CHOOSE'
*.pga_aggregate_target=20G
*.processes=4000
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_max_size=180G# internally adjusted
*.sga_target=180G

使pfile启动数据库到nomount模式
[oracle@sbcs ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Feb 13 15:41:25 2020
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup nomount pfile='/home/oracle/ynsb.ora';
ORACLE instance started.

Total System Global Area 1.9327E+11 bytes
Fixed Size 30143440 bytes
Variable Size 2.3622E+10 bytes
Database Buffers 1.6911E+11 bytes
Redo Buffers 506724352 bytes
SQL> create spfile from pfile='/home/oracle/ynsb.ora';
参数文件恢复完成。

3、 从备份恢复控制文件
[oracle@sbcs ~]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Mon Feb 17 15:47:28 2020
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.

connected to target database: YNSB (not mounted)

RMAN> restore controlfile from '/rmanbak/data/control_c-4180905620-20200217-00.BKU';

Starting restore at 2020-02-17 15:49:54
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=3151 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
output file name=/u01/app/oracle/oradata/ynsb/control01.dbf
output file name=/u01/app/oracle/oradata/ynsb/control02.dbf
Finished restore at 2020-02-17 15:50:03

RMAN> alter database mount;

released channel: ORA_DISK_1
Statement processed
控制文件恢复完成,这里可以选择交叉验证备份删除无效备份,也可以忽略,由于我们使用的备份文件的路径与控制文件路径一致,就不需要单独将备份注册到控制文件中去。

4、 恢复数据库
使用rman开始数据库全库恢复,恢复脚本如下:
Vi recover.sh

!/bin/bash

/u01/app/oracle/product/19.0.0/db_1/bin/rman cmdfile=/home/oracle/zzh/recover.rman log=/home/oracle/zzh/recover.out
Vi recover.rman
connect target /
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
allocate channel c5 type disk;
allocate channel c6 type disk;
allocate channel c7 type disk;
allocate channel c8 type disk;

set until scn 16713395278727;

set newname for database to '/u01/app/oracle/oradata/ynsb/%b';
RESTORE DATABASE;
SWITCH DATAFILE ALL;
recover database;
}
Exit
后台执行恢复脚本进行全库恢复:
$ ./recover.sh &
恢复过程如下:
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Feb 17 16:58:41 2020
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.

RMAN> connect target *
2> run{
3> allocate channel c1 type disk;
4> allocate channel c2 type disk;
5> allocate channel c3 type disk;
6> allocate channel c4 type disk;
7> allocate channel c5 type disk;
8> allocate channel c6 type disk;
9> allocate channel c7 type disk;
10> allocate channel c8 type disk;
11> #set until scn 16713395278727;
12> set newname for database to '/u01/app/oracle/oradata/ynsb/%b';
13> RESTORE DATABASE;
14> SWITCH DATAFILE ALL;
15> recover database;
16> }
17> exit
connected to target database: YNSB (DBID=4180905620, not open)

using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=3718 device type=DISK

allocated channel: c2
channel c2: SID=3781 device type=DISK

allocated channel: c3
channel c3: SID=3844 device type=DISK

allocated channel: c4
channel c4: SID=3907 device type=DISK

allocated channel: c5
channel c5: SID=3970 device type=DISK

allocated channel: c6
channel c6: SID=4033 device type=DISK

allocated channel: c7
channel c7: SID=4096 device type=DISK

allocated channel: c8
channel c8: SID=4159 device type=DISK

executing command: SET NEWNAME

Starting restore at 2020-02-17 16:58:49

channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00001 to /u01/app/oracle/oradata/ynsb/system.257.1007918865
channel c1: restoring datafile 00004 to /u01/app/oracle/oradata/ynsb/undotbs.493.1018792017
channel c1: restoring datafile 00012 to /u01/app/oracle/oradata/ynsb/data.283.1008242233
channel c1: restoring datafile 00020 to /u01/app/oracle/oradata/ynsb/data.291.1008242547
channel c1: restoring datafile 00028 to /u01/app/oracle/oradata/ynsb/data.299.1008242877
channel c1: restoring datafile 00036 to /u01/app/oracle/oradata/ynsb/data.307.1008243197
channel c1: restoring datafile 00044 to /u01/app/oracle/oradata/ynsb/data.315.1008243525
channel c1: restoring datafile 00052 to /u01/app/oracle/oradata/ynsb/data.323.1008243867
channel c1: restoring datafile 00060 to /u01/app/oracle/oradata/ynsb/data.331.1008244207
channel c1: restoring datafile 00068 to /u01/app/oracle/oradata/ynsb/data.339.1008244547
channel c1: restoring datafile 00076 to /u01/app/oracle/oradata/ynsb/data.347.1008244889
channel c1: restoring datafile 00084 to /u01/app/oracle/oradata/ynsb/data.355.1008245227
channel c1: restoring datafile 00092 to /u01/app/oracle/oradata/ynsb/data.363.1008245561
channel c1: restoring datafile 00100 to /u01/app/oracle/oradata/ynsb/data.371.1008245913
channel c1: restoring datafile 00108 to /u01/app/oracle/oradata/ynsb/data.379.1008246253
channel c1: restoring datafile 00116 to /u01/app/oracle/oradata/ynsb/data.387.1008246591
channel c1: restoring datafile 00124 to /u01/app/oracle/oradata/ynsb/data.395.1008246925
channel c1: restoring datafile 00132 to /u01/app/oracle/oradata/ynsb/data.403.1008247265
channel c1: restoring datafile 00140 to /u01/app/oracle/oradata/ynsb/data.411.1008247605
channel c1: restoring datafile 00148 to /u01/app/oracle/oradata/ynsb/data.419.1008247951
channel c1: restoring datafile 00156 to /u01/app/oracle/oradata/ynsb/data.427.1008248289
channel c1: restoring datafile 00164 to /u01/app/oracle/oradata/ynsb/data.435.1008248627
channel c1: restoring datafile 00172 to /u01/app/oracle/oradata/ynsb/data.443.1008248965
channel c1: restoring datafile 00180 to /u01/app/oracle/oradata/ynsb/data.451.1008249303
channel c1: restoring datafile 00188 to /u01/app/oracle/oradata/ynsb/data.459.1008249643
channel c1: restoring datafile 00196 to /u01/app/oracle/oradata/ynsb/data.467.1008249979
channel c1: restoring datafile 00203 to /u01/app/oracle/oradata/ynsb/data.490.1021997769
channel c1: restoring datafile 00206 to /u01/app/oracle/oradata/ynsb/data.487.1021997963
channel c1: restoring datafile 00214 to /u01/app/oracle/oradata/ynsb/data.479.1021998313
channel c1: restoring datafile 00222 to /u01/app/oracle/oradata/ynsb/data.503.1024336979
channel c1: restoring datafile 00230 to /u01/app/oracle/oradata/ynsb/data.511.1024345913
channel c1: restoring datafile 00256 to /u01/app/oracle/oradata/ynsb/data.532.1028365875
channel c1: restoring datafile 00264 to /u01/app/oracle/oradata/ynsb/data.547.1028366217
channel c1: reading from backup piece /rmanbak/data/ynsb_full_l0_a4uoms2c_1_1.BKU
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set
channel c2: restoring datafile 00013 to /u01/app/oracle/oradata/ynsb/data.284.1008242273
channel c2: restoring datafile 00021 to /u01/app/oracle/oradata/ynsb/data.292.1008242587
channel c2: restoring datafile 00029 to /u01/app/oracle/oradata/ynsb/data.300.1008242917
channel c2: restoring datafile 00037 to /u01/app/oracle/oradata/ynsb/data.308.1008243239
channel c2: restoring datafile 00045 to /u01/app/oracle/oradata/ynsb/data.316.1008243567
channel c2: restoring datafile 00053 to /u01/app/oracle/oradata/ynsb/data.324.1008243907
channel c2: restoring datafile 00061 to /u01/app/oracle/oradata/ynsb/data.332.1008244247
channel c2: restoring datafile 00069 to /u01/app/oracle/oradata/ynsb/data.340.1008244589
channel c2: restoring datafile 00077 to /u01/app/oracle/oradata/ynsb/data.348.1008244933
channel c2: restoring datafile 00085 to /u01/app/oracle/oradata/ynsb/data.356.1008245267
channel c2: restoring datafile 00093 to /u01/app/oracle/oradata/ynsb/data.364.1008245607
channel c2: restoring datafile 00101 to /u01/app/oracle/oradata/ynsb/data.372.1008245955
channel c2: restoring datafile 00109 to /u01/app/oracle/oradata/ynsb/data.380.1008246293
channel c2: restoring datafile 00117 to /u01/app/oracle/oradata/ynsb/data.388.1008246631
channel c2: restoring datafile 00125 to /u01/app/oracle/oradata/ynsb/data.396.1008246967
channel c2: restoring datafile 00133 to /u01/app/oracle/oradata/ynsb/data.404.1008247311
channel c2: restoring datafile 00141 to /u01/app/oracle/oradata/ynsb/data.412.1008247651
channel c2: restoring datafile 00149 to /u01/app/oracle/oradata/ynsb/data.420.1008247993
channel c2: restoring datafile 00157 to /u01/app/oracle/oradata/ynsb/data.428.1008248333
channel c2: restoring datafile 00165 to /u01/app/oracle/oradata/ynsb/data.436.1008248671
channel c2: restoring datafile 00173 to /u01/app/oracle/oradata/ynsb/data.444.1008249007
channel c2: restoring datafile 00181 to /u01/app/oracle/oradata/ynsb/data.452.1008249345
channel c2: restoring datafile 00189 to /u01/app/oracle/oradata/ynsb/data.460.1008249685
channel c2: restoring datafile 00197 to /u01/app/oracle/oradata/ynsb/data.468.1008250025
channel c2: restoring datafile 00201 to /u01/app/oracle/oradata/ynsb/undotbs.492.1018796645
channel c2: restoring datafile 00204 to /u01/app/oracle/oradata/ynsb/data.489.1021997879
channel c2: restoring datafile 00207 to /u01/app/oracle/oradata/ynsb/data.486.1021998007
channel c2: restoring datafile 00215 to /u01/app/oracle/oradata/ynsb/data.478.1021998357
channel c2: restoring datafile 00223 to /u01/app/oracle/oradata/ynsb/data.504.1024337037
channel c2: restoring datafile 00231 to /u01/app/oracle/oradata/ynsb/data.512.1024345955
channel c2: restoring datafile 00235 to /u01/app/oracle/oradata/ynsb/ogg.537.1011548331
channel c2: restoring datafile 00239 to /u01/app/oracle/oradata/ynsb/data.515.1024855385
channel c2: restoring datafile 00257 to /u01/app/oracle/oradata/ynsb/data.533.1028365919
channel c2: restoring datafile 00265 to /u01/app/oracle/oradata/ynsb/data.548.1030265917
channel c2: reading from backup piece /rmanbak/data/ynsb_full_l0_a2uoms2c_1_1.BKU
channel c3: starting datafile backup set restore
channel c3: specifying datafile(s) to restore from backup set
channel c3: restoring datafile 00005 to /u01/app/oracle/oradata/ynsb/data.277.1008241785
channel c3: restoring datafile 00007 to /u01/app/oracle/oradata/ynsb/users.260.1007918927
channel c3: restoring datafile 00019 to /u01/app/oracle/oradata/ynsb/data.290.1008242505
channel c3: restoring datafile 00027 to /u01/app/oracle/oradata/ynsb/data.298.1008242839
channel c3: restoring datafile 00035 to /u01/app/oracle/oradata/ynsb/data.306.1008243157
channel c3: restoring datafile 00043 to /u01/app/oracle/oradata/ynsb/data.314.1008243483
channel c3: restoring datafile 00051 to /u01/app/oracle/oradata/ynsb/data.322.1008243823
channel c3: restoring datafile 00059 to /u01/app/oracle/oradata/ynsb/data.330.1008244165
channel c3: restoring datafile 00067 to /u01/app/oracle/oradata/ynsb/data.338.1008244505
channel c3: restoring datafile 00075 to /u01/app/oracle/oradata/ynsb/data.346.1008244847
channel c3: restoring datafile 00083 to /u01/app/oracle/oradata/ynsb/data.354.1008245185
channel c3: restoring datafile 00091 to /u01/app/oracle/oradata/ynsb/data.362.1008245519
channel c3: restoring datafile 00099 to /u01/app/oracle/oradata/ynsb/data.370.1008245869
channel c3: restoring datafile 00107 to /u01/app/oracle/oradata/ynsb/data.378.1008246207
channel c3: restoring datafile 00115 to /u01/app/oracle/oradata/ynsb/data.386.1008246549
channel c3: restoring datafile 00123 to /u01/app/oracle/oradata/ynsb/data.394.1008246883
channel c3: restoring datafile 00131 to /u01/app/oracle/oradata/ynsb/data.402.1008247221
channel c3: restoring datafile 00139 to /u01/app/oracle/oradata/ynsb/data.410.1008247565
channel c3: restoring datafile 00147 to /u01/app/oracle/oradata/ynsb/data.418.1008247905
channel c3: restoring datafile 00155 to /u01/app/oracle/oradata/ynsb/data.426.1008248247
channel c3: restoring datafile 00163 to /u01/app/oracle/oradata/ynsb/data.434.1008248587
channel c3: restoring datafile 00171 to /u01/app/oracle/oradata/ynsb/data.442.1008248925
channel c3: restoring datafile 00179 to /u01/app/oracle/oradata/ynsb/data.450.1008249259
channel c3: restoring datafile 00187 to /u01/app/oracle/oradata/ynsb/data.458.1008249603
channel c3: restoring datafile 00195 to /u01/app/oracle/oradata/ynsb/data.466.1008249935
channel c3: restoring datafile 00202 to /u01/app/oracle/oradata/ynsb/data.491.1021997585
channel c3: restoring datafile 00205 to /u01/app/oracle/oradata/ynsb/data.488.1021997921
channel c3: restoring datafile 00213 to /u01/app/oracle/oradata/ynsb/data.480.1021998269
channel c3: restoring datafile 00221 to /u01/app/oracle/oradata/ynsb/data.275.1024336845
channel c3: restoring datafile 00229 to /u01/app/oracle/oradata/ynsb/data.510.1024345871
channel c3: restoring datafile 00250 to /u01/app/oracle/oradata/ynsb/data.526.1026556025
channel c3: restoring datafile 00258 to /u01/app/oracle/oradata/ynsb/data.541.1028365963
channel c3: restoring datafile 00266 to /u01/app/oracle/oradata/ynsb/data.549.1030265961
channel c3: reading from backup piece /rmanbak/data/ynsb_full_l0_a3uoms2c_1_1.BKU
channel c4: starting datafile backup set restore
channel c4: specifying datafile(s) to restore from backup set
channel c4: restoring datafile 00002 to /u01/app/oracle/oradata/ynsb/data.278.1008241959
channel c4: restoring datafile 00014 to /u01/app/oracle/oradata/ynsb/data.285.1008242313
channel c4: restoring datafile 00022 to /u01/app/oracle/oradata/ynsb/data.293.1008242625
channel c4: restoring datafile 00030 to /u01/app/oracle/oradata/ynsb/data.301.1008242957
channel c4: restoring datafile 00038 to /u01/app/oracle/oradata/ynsb/data.309.1008243279
channel c4: restoring datafile 00046 to /u01/app/oracle/oradata/ynsb/data.317.1008243609
channel c4: restoring datafile 00054 to /u01/app/oracle/oradata/ynsb/data.325.1008243949
channel c4: restoring datafile 00062 to /u01/app/oracle/oradata/ynsb/data.333.1008244287
channel c4: restoring datafile 00070 to /u01/app/oracle/oradata/ynsb/data.341.1008244633
channel c4: restoring datafile 00078 to /u01/app/oracle/oradata/ynsb/data.349.1008244975
channel c4: restoring datafile 00086 to /u01/app/oracle/oradata/ynsb/data.357.1008245309
channel c4: restoring datafile 00094 to /u01/app/oracle/oradata/ynsb/data.365.1008245651
channel c4: restoring datafile 00102 to /u01/app/oracle/oradata/ynsb/data.373.1008245997
channel c4: restoring datafile 00110 to /u01/app/oracle/oradata/ynsb/data.381.1008246337
channel c4: restoring datafile 00118 to /u01/app/oracle/oradata/ynsb/data.389.1008246677
channel c4: restoring datafile 00126 to /u01/app/oracle/oradata/ynsb/data.397.1008247009
channel c4: restoring datafile 00134 to /u01/app/oracle/oradata/ynsb/data.405.1008247351
channel c4: restoring datafile 00142 to /u01/app/oracle/oradata/ynsb/data.413.1008247693
channel c4: restoring datafile 00150 to /u01/app/oracle/oradata/ynsb/data.421.1008248037
channel c4: restoring datafile 00158 to /u01/app/oracle/oradata/ynsb/data.429.1008248379
channel c4: restoring datafile 00166 to /u01/app/oracle/oradata/ynsb/data.437.1008248713
channel c4: restoring datafile 00174 to /u01/app/oracle/oradata/ynsb/data.445.1008249047
channel c4: restoring datafile 00182 to /u01/app/oracle/oradata/ynsb/data.453.1008249387
channel c4: restoring datafile 00190 to /u01/app/oracle/oradata/ynsb/data.461.1008249725
channel c4: restoring datafile 00198 to /u01/app/oracle/oradata/ynsb/data.469.1008250067
channel c4: restoring datafile 00210 to /u01/app/oracle/oradata/ynsb/data.483.1021998137
channel c4: restoring datafile 00218 to /u01/app/oracle/oradata/ynsb/data.475.1021998489
channel c4: restoring datafile 00226 to /u01/app/oracle/oradata/ynsb/data.507.1024337413
channel c4: restoring datafile 00234 to /u01/app/oracle/oradata/ynsb/soe.536.1009549381
channel c4: restoring datafile 00242 to /u01/app/oracle/oradata/ynsb/data.518.1024855517
channel c4: restoring datafile 00245 to /u01/app/oracle/oradata/ynsb/data.521.1026555771
channel c4: restoring datafile 00251 to /u01/app/oracle/oradata/ynsb/data.527.1026556067
channel c4: restoring datafile 00259 to /u01/app/oracle/oradata/ynsb/data.542.1028366005
channel c4: reading from backup piece /rmanbak/data/ynsb_full_l0_9tuoms2a_1_1.BKU
channel c5: starting datafile backup set restore
channel c5: specifying datafile(s) to restore from backup set
channel c5: restoring datafile 00010 to /u01/app/oracle/oradata/ynsb/data.281.1008242155
channel c5: restoring datafile 00017 to /u01/app/oracle/oradata/ynsb/data.288.1008242429
channel c5: restoring datafile 00025 to /u01/app/oracle/oradata/ynsb/data.296.1008242755
channel c5: restoring datafile 00033 to /u01/app/oracle/oradata/ynsb/data.304.1008243077
channel c5: restoring datafile 00041 to /u01/app/oracle/oradata/ynsb/data.312.1008243403
channel c5: restoring datafile 00049 to /u01/app/oracle/oradata/ynsb/data.320.1008243737
channel c5: restoring datafile 00057 to /u01/app/oracle/oradata/ynsb/data.328.1008244081
channel c5: restoring datafile 00065 to /u01/app/oracle/oradata/ynsb/data.336.1008244419
channel c5: restoring datafile 00073 to /u01/app/oracle/oradata/ynsb/data.344.1008244761
channel c5: restoring datafile 00081 to /u01/app/oracle/oradata/ynsb/data.352.1008245099
channel c5: restoring datafile 00089 to /u01/app/oracle/oradata/ynsb/data.360.1008245437
channel c5: restoring datafile 00097 to /u01/app/oracle/oradata/ynsb/data.368.1008245783
channel c5: restoring datafile 00105 to /u01/app/oracle/oradata/ynsb/data.376.1008246121
channel c5: restoring datafile 00113 to /u01/app/oracle/oradata/ynsb/data.384.1008246463
channel c5: restoring datafile 00121 to /u01/app/oracle/oradata/ynsb/data.392.1008246801
channel c5: restoring datafile 00129 to /u01/app/oracle/oradata/ynsb/data.400.1008247137
channel c5: restoring datafile 00137 to /u01/app/oracle/oradata/ynsb/data.408.1008247481
channel c5: restoring datafile 00145 to /u01/app/oracle/oradata/ynsb/data.416.1008247823
channel c5: restoring datafile 00153 to /u01/app/oracle/oradata/ynsb/data.424.1008248161
channel c5: restoring datafile 00161 to /u01/app/oracle/oradata/ynsb/data.432.1008248503
channel c5: restoring datafile 00169 to /u01/app/oracle/oradata/ynsb/data.440.1008248841
channel c5: restoring datafile 00177 to /u01/app/oracle/oradata/ynsb/data.448.1008249173
channel c5: restoring datafile 00185 to /u01/app/oracle/oradata/ynsb/data.456.1008249513
channel c5: restoring datafile 00193 to /u01/app/oracle/oradata/ynsb/data.464.1008249853
channel c5: restoring datafile 00209 to /u01/app/oracle/oradata/ynsb/data.484.1021998093
channel c5: restoring datafile 00217 to /u01/app/oracle/oradata/ynsb/data.476.1021998445
channel c5: restoring datafile 00225 to /u01/app/oracle/oradata/ynsb/data.506.1024337361
channel c5: restoring datafile 00233 to /u01/app/oracle/oradata/ynsb/soe.535.1009471081
channel c5: restoring datafile 00236 to /u01/app/oracle/oradata/ynsb/undotbs.539.1011810525
channel c5: restoring datafile 00241 to /u01/app/oracle/oradata/ynsb/data.517.1024855473
channel c5: restoring datafile 00248 to /u01/app/oracle/oradata/ynsb/data.524.1026555939
channel c5: restoring datafile 00254 to /u01/app/oracle/oradata/ynsb/data.530.1026556195
channel c5: restoring datafile 00262 to /u01/app/oracle/oradata/ynsb/data.545.1028366135
channel c5: reading from backup piece /rmanbak/data/ynsb_full_l0_a0uoms2b_1_1.BKU
channel c6: starting datafile backup set restore
channel c6: specifying datafile(s) to restore from backup set
channel c6: restoring datafile 00003 to /u01/app/oracle/oradata/ynsb/sysaux.258.1007918901
channel c6: restoring datafile 00011 to /u01/app/oracle/oradata/ynsb/data.282.1008242195
channel c6: restoring datafile 00018 to /u01/app/oracle/oradata/ynsb/data.289.1008242467
channel c6: restoring datafile 00026 to /u01/app/oracle/oradata/ynsb/data.297.1008242797
channel c6: restoring datafile 00034 to /u01/app/oracle/oradata/ynsb/data.305.1008243117
channel c6: restoring datafile 00042 to /u01/app/oracle/oradata/ynsb/data.313.1008243443
channel c6: restoring datafile 00050 to /u01/app/oracle/oradata/ynsb/data.321.1008243781
channel c6: restoring datafile 00058 to /u01/app/oracle/oradata/ynsb/data.329.1008244123
channel c6: restoring datafile 00066 to /u01/app/oracle/oradata/ynsb/data.337.1008244459
channel c6: restoring datafile 00074 to /u01/app/oracle/oradata/ynsb/data.345.1008244805
channel c6: restoring datafile 00082 to /u01/app/oracle/oradata/ynsb/data.353.1008245141
channel c6: restoring datafile 00090 to /u01/app/oracle/oradata/ynsb/data.361.1008245479
channel c6: restoring datafile 00098 to /u01/app/oracle/oradata/ynsb/data.369.1008245827
channel c6: restoring datafile 00106 to /u01/app/oracle/oradata/ynsb/data.377.1008246163
channel c6: restoring datafile 00114 to /u01/app/oracle/oradata/ynsb/data.385.1008246507
channel c6: restoring datafile 00122 to /u01/app/oracle/oradata/ynsb/data.393.1008246843
channel c6: restoring datafile 00130 to /u01/app/oracle/oradata/ynsb/data.401.1008247179
channel c6: restoring datafile 00138 to /u01/app/oracle/oradata/ynsb/data.409.1008247521
channel c6: restoring datafile 00146 to /u01/app/oracle/oradata/ynsb/data.417.1008247865
channel c6: restoring datafile 00154 to /u01/app/oracle/oradata/ynsb/data.425.1008248205
channel c6: restoring datafile 00162 to /u01/app/oracle/oradata/ynsb/data.433.1008248545
channel c6: restoring datafile 00170 to /u01/app/oracle/oradata/ynsb/data.441.1008248883
channel c6: restoring datafile 00178 to /u01/app/oracle/oradata/ynsb/data.449.1008249217
channel c6: restoring datafile 00186 to /u01/app/oracle/oradata/ynsb/data.457.1008249557
channel c6: restoring datafile 00194 to /u01/app/oracle/oradata/ynsb/data.465.1008249893
channel c6: restoring datafile 00208 to /u01/app/oracle/oradata/ynsb/data.485.1021998051
channel c6: restoring datafile 00216 to /u01/app/oracle/oradata/ynsb/data.477.1021998401
channel c6: restoring datafile 00224 to /u01/app/oracle/oradata/ynsb/data.505.1024337103
channel c6: restoring datafile 00232 to /u01/app/oracle/oradata/ynsb/soe.534.1009470969
channel c6: restoring datafile 00240 to /u01/app/oracle/oradata/ynsb/data.516.1024855427
channel c6: restoring datafile 00249 to /u01/app/oracle/oradata/ynsb/data.525.1026555983
channel c6: restoring datafile 00255 to /u01/app/oracle/oradata/ynsb/data.531.1028365797
channel c6: restoring datafile 00263 to /u01/app/oracle/oradata/ynsb/data.546.1028366175
channel c6: reading from backup piece /rmanbak/data/ynsb_full_l0_a1uoms2b_1_1.BKU
channel c7: starting datafile backup set restore
channel c7: specifying datafile(s) to restore from backup set
channel c7: restoring datafile 00009 to /u01/app/oracle/oradata/ynsb/data.280.1008242115
channel c7: restoring datafile 00016 to /u01/app/oracle/oradata/ynsb/data.287.1008242391
channel c7: restoring datafile 00024 to /u01/app/oracle/oradata/ynsb/data.295.1008242711
channel c7: restoring datafile 00032 to /u01/app/oracle/oradata/ynsb/data.303.1008243037
channel c7: restoring datafile 00040 to /u01/app/oracle/oradata/ynsb/data.311.1008243361
channel c7: restoring datafile 00048 to /u01/app/oracle/oradata/ynsb/data.319.1008243695
channel c7: restoring datafile 00056 to /u01/app/oracle/oradata/ynsb/data.327.1008244037
channel c7: restoring datafile 00064 to /u01/app/oracle/oradata/ynsb/data.335.1008244375
channel c7: restoring datafile 00072 to /u01/app/oracle/oradata/ynsb/data.343.1008244721
channel c7: restoring datafile 00080 to /u01/app/oracle/oradata/ynsb/data.351.1008245057
channel c7: restoring datafile 00088 to /u01/app/oracle/oradata/ynsb/data.359.1008245395
channel c7: restoring datafile 00096 to /u01/app/oracle/oradata/ynsb/data.367.1008245737
channel c7: restoring datafile 00104 to /u01/app/oracle/oradata/ynsb/data.375.1008246079
channel c7: restoring datafile 00112 to /u01/app/oracle/oradata/ynsb/data.383.1008246421
channel c7: restoring datafile 00120 to /u01/app/oracle/oradata/ynsb/data.391.1008246759
channel c7: restoring datafile 00128 to /u01/app/oracle/oradata/ynsb/data.399.1008247093
channel c7: restoring datafile 00136 to /u01/app/oracle/oradata/ynsb/data.407.1008247435
channel c7: restoring datafile 00144 to /u01/app/oracle/oradata/ynsb/data.415.1008247779
channel c7: restoring datafile 00152 to /u01/app/oracle/oradata/ynsb/data.423.1008248119
channel c7: restoring datafile 00160 to /u01/app/oracle/oradata/ynsb/data.431.1008248463
channel c7: restoring datafile 00168 to /u01/app/oracle/oradata/ynsb/data.439.1008248799
channel c7: restoring datafile 00176 to /u01/app/oracle/oradata/ynsb/data.447.1008249131
channel c7: restoring datafile 00184 to /u01/app/oracle/oradata/ynsb/data.455.1008249471
channel c7: restoring datafile 00192 to /u01/app/oracle/oradata/ynsb/data.463.1008249811
channel c7: restoring datafile 00200 to /u01/app/oracle/oradata/ynsb/data.471.1008250153
channel c7: restoring datafile 00212 to /u01/app/oracle/oradata/ynsb/data.481.1021998225
channel c7: restoring datafile 00220 to /u01/app/oracle/oradata/ynsb/data.473.1021998575
channel c7: restoring datafile 00228 to /u01/app/oracle/oradata/ynsb/data.509.1024345827
channel c7: restoring datafile 00238 to /u01/app/oracle/oradata/ynsb/data.514.1024346927
channel c7: restoring datafile 00244 to /u01/app/oracle/oradata/ynsb/data.520.1024855603
channel c7: restoring datafile 00247 to /u01/app/oracle/oradata/ynsb/data.523.1026555895
channel c7: restoring datafile 00253 to /u01/app/oracle/oradata/ynsb/data.529.1026556153
channel c7: restoring datafile 00261 to /u01/app/oracle/oradata/ynsb/data.544.1028366091
channel c7: reading from backup piece /rmanbak/data/ynsb_full_l0_9vuoms2b_1_1.BKU
channel c8: starting datafile backup set restore
channel c8: specifying datafile(s) to restore from backup set
channel c8: restoring datafile 00008 to /u01/app/oracle/oradata/ynsb/data.279.1008242075
channel c8: restoring datafile 00015 to /u01/app/oracle/oradata/ynsb/data.286.1008242353
channel c8: restoring datafile 00023 to /u01/app/oracle/oradata/ynsb/data.294.1008242669
channel c8: restoring datafile 00031 to /u01/app/oracle/oradata/ynsb/data.302.1008242997
channel c8: restoring datafile 00039 to /u01/app/oracle/oradata/ynsb/data.310.1008243319
channel c8: restoring datafile 00047 to /u01/app/oracle/oradata/ynsb/data.318.1008243653
channel c8: restoring datafile 00055 to /u01/app/oracle/oradata/ynsb/data.326.1008243993
channel c8: restoring datafile 00063 to /u01/app/oracle/oradata/ynsb/data.334.1008244329
channel c8: restoring datafile 00071 to /u01/app/oracle/oradata/ynsb/data.342.1008244679
channel c8: restoring datafile 00079 to /u01/app/oracle/oradata/ynsb/data.350.1008245017
channel c8: restoring datafile 00087 to /u01/app/oracle/oradata/ynsb/data.358.1008245349
channel c8: restoring datafile 00095 to /u01/app/oracle/oradata/ynsb/data.366.1008245693
channel c8: restoring datafile 00103 to /u01/app/oracle/oradata/ynsb/data.374.1008246037
channel c8: restoring datafile 00111 to /u01/app/oracle/oradata/ynsb/data.382.1008246379
channel c8: restoring datafile 00119 to /u01/app/oracle/oradata/ynsb/data.390.1008246719
channel c8: restoring datafile 00127 to /u01/app/oracle/oradata/ynsb/data.398.1008247049
channel c8: restoring datafile 00135 to /u01/app/oracle/oradata/ynsb/data.406.1008247393
channel c8: restoring datafile 00143 to /u01/app/oracle/oradata/ynsb/data.414.1008247737
channel c8: restoring datafile 00151 to /u01/app/oracle/oradata/ynsb/data.422.1008248077
channel c8: restoring datafile 00159 to /u01/app/oracle/oradata/ynsb/data.430.1008248421
channel c8: restoring datafile 00167 to /u01/app/oracle/oradata/ynsb/data.438.1008248753
channel c8: restoring datafile 00175 to /u01/app/oracle/oradata/ynsb/data.446.1008249089
channel c8: restoring datafile 00183 to /u01/app/oracle/oradata/ynsb/data.454.1008249429
channel c8: restoring datafile 00191 to /u01/app/oracle/oradata/ynsb/data.462.1008249771
channel c8: restoring datafile 00199 to /u01/app/oracle/oradata/ynsb/data.470.1008250109
channel c8: restoring datafile 00211 to /u01/app/oracle/oradata/ynsb/data.482.1021998181
channel c8: restoring datafile 00219 to /u01/app/oracle/oradata/ynsb/data.474.1021998533
channel c8: restoring datafile 00227 to /u01/app/oracle/oradata/ynsb/data.508.1024345783
channel c8: restoring datafile 00237 to /u01/app/oracle/oradata/ynsb/data.513.1024346873
channel c8: restoring datafile 00243 to /u01/app/oracle/oradata/ynsb/data.519.1024855559
channel c8: restoring datafile 00246 to /u01/app/oracle/oradata/ynsb/data.522.1026555833
channel c8: restoring datafile 00252 to /u01/app/oracle/oradata/ynsb/data.528.1026556109
channel c8: restoring datafile 00260 to /u01/app/oracle/oradata/ynsb/data.543.1028366047
channel c8: reading from backup piece /rmanbak/data/ynsb_full_l0_9uuoms2a_1_1.BKU
channel c8: piece handle=/rmanbak/data/ynsb_full_l0_9uuoms2a_1_1.BKU tag=TAG20200216T190023
channel c8: restored backup piece 1
channel c8: reading from backup piece /rmanbak/data/ynsb_full_l0_9uuoms2a_2_1.BKU
channel c7: piece handle=/rmanbak/data/ynsb_full_l0_9vuoms2b_1_1.BKU tag=TAG20200216T190023
channel c7: restored backup piece 1
channel c7: reading from backup piece /rmanbak/data/ynsb_full_l0_9vuoms2b_2_1.BKU
channel c4: piece handle=/rmanbak/data/ynsb_full_l0_9tuoms2a_1_1.BKU tag=TAG20200216T190023
channel c4: restored backup piece 1
channel c4: reading from backup piece /rmanbak/data/ynsb_full_l0_9tuoms2a_2_1.BKU
channel c5: piece handle=/rmanbak/data/ynsb_full_l0_a0uoms2b_1_1.BKU tag=TAG20200216T190023
channel c5: restored backup piece 1
channel c5: reading from backup piece /rmanbak/data/ynsb_full_l0_a0uoms2b_2_1.BKU
channel c6: piece handle=/rmanbak/data/ynsb_full_l0_a1uoms2b_1_1.BKU tag=TAG20200216T190023
channel c6: restored backup piece 1
channel c6: reading from backup piece /rmanbak/data/ynsb_full_l0_a1uoms2b_2_1.BKU
channel c3: piece handle=/rmanbak/data/ynsb_full_l0_a3uoms2c_1_1.BKU tag=TAG20200216T190023
channel c3: restored backup piece 1
channel c3: reading from backup piece /rmanbak/data/ynsb_full_l0_a3uoms2c_2_1.BKU
channel c1: piece handle=/rmanbak/data/ynsb_full_l0_a4uoms2c_1_1.BKU tag=TAG20200216T190023
channel c1: restored backup piece 1
channel c1: reading from backup piece /rmanbak/data/ynsb_full_l0_a4uoms2c_2_1.BKU
channel c2: piece handle=/rmanbak/data/ynsb_full_l0_a2uoms2c_1_1.BKU tag=TAG20200216T190023
channel c2: restored backup piece 1
channel c2: reading from backup piece /rmanbak/data/ynsb_full_l0_a2uoms2c_2_1.BKU
channel c8: piece handle=/rmanbak/data/ynsb_full_l0_9uuoms2a_2_1.BKU tag=TAG20200216T190023
channel c8: restored backup piece 2
channel c8: reading from backup piece /rmanbak/data/ynsb_full_l0_9uuoms2a_3_1.BKU
channel c4: piece handle=/rmanbak/data/ynsb_full_l0_9tuoms2a_2_1.BKU tag=TAG20200216T190023
channel c4: restored backup piece 2
channel c4: reading from backup piece /rmanbak/data/ynsb_full_l0_9tuoms2a_3_1.BKU
channel c7: piece handle=/rmanbak/data/ynsb_full_l0_9vuoms2b_2_1.BKU tag=TAG20200216T190023
channel c7: restored backup piece 2
channel c7: reading from backup piece /rmanbak/data/ynsb_full_l0_9vuoms2b_3_1.BKU
channel c5: piece handle=/rmanbak/data/ynsb_full_l0_a0uoms2b_2_1.BKU tag=TAG20200216T190023
channel c5: restored backup piece 2
channel c5: reading from backup piece /rmanbak/data/ynsb_full_l0_a0uoms2b_3_1.BKU
channel c6: piece handle=/rmanbak/data/ynsb_full_l0_a1uoms2b_2_1.BKU tag=TAG20200216T190023
channel c6: restored backup piece 2
channel c6: reading from backup piece /rmanbak/data/ynsb_full_l0_a1uoms2b_3_1.BKU
channel c1: piece handle=/rmanbak/data/ynsb_full_l0_a4uoms2c_2_1.BKU tag=TAG20200216T190023
channel c1: restored backup piece 2
channel c1: reading from backup piece /rmanbak/data/ynsb_full_l0_a4uoms2c_3_1.BKU
channel c3: piece handle=/rmanbak/data/ynsb_full_l0_a3uoms2c_2_1.BKU tag=TAG20200216T190023
channel c3: restored backup piece 2
channel c3: reading from backup piece /rmanbak/data/ynsb_full_l0_a3uoms2c_3_1.BKU
channel c2: piece handle=/rmanbak/data/ynsb_full_l0_a2uoms2c_2_1.BKU tag=TAG20200216T190023
channel c2: restored backup piece 2
channel c2: reading from backup piece /rmanbak/data/ynsb_full_l0_a2uoms2c_3_1.BKU
channel c7: piece handle=/rmanbak/data/ynsb_full_l0_9vuoms2b_3_1.BKU tag=TAG20200216T190023
channel c7: restored backup piece 3
channel c7: reading from backup piece /rmanbak/data/ynsb_full_l0_9vuoms2b_4_1.BKU
channel c8: piece handle=/rmanbak/data/ynsb_full_l0_9uuoms2a_3_1.BKU tag=TAG20200216T190023
channel c8: restored backup piece 3
channel c8: reading from backup piece /rmanbak/data/ynsb_full_l0_9uuoms2a_4_1.BKU
channel c4: piece handle=/rmanbak/data/ynsb_full_l0_9tuoms2a_3_1.BKU tag=TAG20200216T190023
channel c4: restored backup piece 3
channel c4: reading from backup piece /rmanbak/data/ynsb_full_l0_9tuoms2a_4_1.BKU
channel c5: piece handle=/rmanbak/data/ynsb_full_l0_a0uoms2b_3_1.BKU tag=TAG20200216T190023
channel c5: restored backup piece 3
channel c5: reading from backup piece /rmanbak/data/ynsb_full_l0_a0uoms2b_4_1.BKU
channel c1: piece handle=/rmanbak/data/ynsb_full_l0_a4uoms2c_3_1.BKU tag=TAG20200216T190023
channel c1: restored backup piece 3
channel c1: reading from backup piece /rmanbak/data/ynsb_full_l0_a4uoms2c_4_1.BKU
channel c6: piece handle=/rmanbak/data/ynsb_full_l0_a1uoms2b_3_1.BKU tag=TAG20200216T190023
channel c6: restored backup piece 3
channel c6: reading from backup piece /rmanbak/data/ynsb_full_l0_a1uoms2b_4_1.BKU
channel c3: piece handle=/rmanbak/data/ynsb_full_l0_a3uoms2c_3_1.BKU tag=TAG20200216T190023
channel c3: restored backup piece 3
channel c3: reading from backup piece /rmanbak/data/ynsb_full_l0_a3uoms2c_4_1.BKU
channel c2: piece handle=/rmanbak/data/ynsb_full_l0_a2uoms2c_3_1.BKU tag=TAG20200216T190023
channel c2: restored backup piece 3
channel c2: reading from backup piece /rmanbak/data/ynsb_full_l0_a2uoms2c_4_1.BKU
channel c7: piece handle=/rmanbak/data/ynsb_full_l0_9vuoms2b_4_1.BKU tag=TAG20200216T190023
channel c7: restored backup piece 4
channel c7: reading from backup piece /rmanbak/data/ynsb_full_l0_9vuoms2b_5_1.BKU
channel c8: piece handle=/rmanbak/data/ynsb_full_l0_9uuoms2a_4_1.BKU tag=TAG20200216T190023
channel c8: restored backup piece 4
channel c8: reading from backup piece /rmanbak/data/ynsb_full_l0_9uuoms2a_5_1.BKU
channel c4: piece handle=/rmanbak/data/ynsb_full_l0_9tuoms2a_4_1.BKU tag=TAG20200216T190023
channel c4: restored backup piece 4
channel c4: reading from backup piece /rmanbak/data/ynsb_full_l0_9tuoms2a_5_1.BKU
channel c1: piece handle=/rmanbak/data/ynsb_full_l0_a4uoms2c_4_1.BKU tag=TAG20200216T190023
channel c1: restored backup piece 4
channel c1: reading from backup piece /rmanbak/data/ynsb_full_l0_a4uoms2c_5_1.BKU
channel c5: piece handle=/rmanbak/data/ynsb_full_l0_a0uoms2b_4_1.BKU tag=TAG20200216T190023
channel c5: restored backup piece 4
channel c5: reading from backup piece /rmanbak/data/ynsb_full_l0_a0uoms2b_5_1.BKU
channel c6: piece handle=/rmanbak/data/ynsb_full_l0_a1uoms2b_4_1.BKU tag=TAG20200216T190023
channel c6: restored backup piece 4
channel c6: reading from backup piece /rmanbak/data/ynsb_full_l0_a1uoms2b_5_1.BKU
channel c3: piece handle=/rmanbak/data/ynsb_full_l0_a3uoms2c_4_1.BKU tag=TAG20200216T190023
channel c3: restored backup piece 4
channel c3: reading from backup piece /rmanbak/data/ynsb_full_l0_a3uoms2c_5_1.BKU
channel c2: piece handle=/rmanbak/data/ynsb_full_l0_a2uoms2c_4_1.BKU tag=TAG20200216T190023
channel c2: restored backup piece 4
channel c2: reading from backup piece /rmanbak/data/ynsb_full_l0_a2uoms2c_5_1.BKU
channel c7: piece handle=/rmanbak/data/ynsb_full_l0_9vuoms2b_5_1.BKU tag=TAG20200216T190023
channel c7: restored backup piece 5
channel c7: reading from backup piece /rmanbak/data/ynsb_full_l0_9vuoms2b_6_1.BKU
channel c8: piece handle=/rmanbak/data/ynsb_full_l0_9uuoms2a_5_1.BKU tag=TAG20200216T190023
channel c8: restored backup piece 5
channel c8: reading from backup piece /rmanbak/data/ynsb_full_l0_9uuoms2a_6_1.BKU
channel c4: piece handle=/rmanbak/data/ynsb_full_l0_9tuoms2a_5_1.BKU tag=TAG20200216T190023
channel c4: restored backup piece 5
channel c4: reading from backup piece /rmanbak/data/ynsb_full_l0_9tuoms2a_6_1.BKU
channel c1: piece handle=/rmanbak/data/ynsb_full_l0_a4uoms2c_5_1.BKU tag=TAG20200216T190023
channel c1: restored backup piece 5
channel c1: reading from backup piece /rmanbak/data/ynsb_full_l0_a4uoms2c_6_1.BKU
channel c5: piece handle=/rmanbak/data/ynsb_full_l0_a0uoms2b_5_1.BKU tag=TAG20200216T190023
channel c5: restored backup piece 5
channel c5: reading from backup piece /rmanbak/data/ynsb_full_l0_a0uoms2b_6_1.BKU
channel c6: piece handle=/rmanbak/data/ynsb_full_l0_a1uoms2b_5_1.BKU tag=TAG20200216T190023
channel c6: restored backup piece 5
channel c6: reading from backup piece /rmanbak/data/ynsb_full_l0_a1uoms2b_6_1.BKU
channel c3: piece handle=/rmanbak/data/ynsb_full_l0_a3uoms2c_5_1.BKU tag=TAG20200216T190023
channel c3: restored backup piece 5
channel c3: reading from backup piece /rmanbak/data/ynsb_full_l0_a3uoms2c_6_1.BKU
channel c2: piece handle=/rmanbak/data/ynsb_full_l0_a2uoms2c_5_1.BKU tag=TAG20200216T190023
channel c2: restored backup piece 5
channel c2: reading from backup piece /rmanbak/data/ynsb_full_l0_a2uoms2c_6_1.BKU
channel c7: piece handle=/rmanbak/data/ynsb_full_l0_9vuoms2b_6_1.BKU tag=TAG20200216T190023
channel c7: restored backup piece 6
channel c7: reading from backup piece /rmanbak/data/ynsb_full_l0_9vuoms2b_7_1.BKU
channel c8: piece handle=/rmanbak/data/ynsb_full_l0_9uuoms2a_6_1.BKU tag=TAG20200216T190023
channel c8: restored backup piece 6
channel c8: reading from backup piece /rmanbak/data/ynsb_full_l0_9uuoms2a_7_1.BKU
channel c4: piece handle=/rmanbak/data/ynsb_full_l0_9tuoms2a_6_1.BKU tag=TAG20200216T190023
channel c4: restored backup piece 6
channel c4: reading from backup piece /rmanbak/data/ynsb_full_l0_9tuoms2a_7_1.BKU
channel c1: piece handle=/rmanbak/data/ynsb_full_l0_a4uoms2c_6_1.BKU tag=TAG20200216T190023
channel c1: restored backup piece 6
channel c1: reading from backup piece /rmanbak/data/ynsb_full_l0_a4uoms2c_7_1.BKU
channel c5: piece handle=/rmanbak/data/ynsb_full_l0_a0uoms2b_6_1.BKU tag=TAG20200216T190023
channel c5: restored backup piece 6
channel c5: reading from backup piece /rmanbak/data/ynsb_full_l0_a0uoms2b_7_1.BKU
channel c6: piece handle=/rmanbak/data/ynsb_full_l0_a1uoms2b_6_1.BKU tag=TAG20200216T190023
channel c6: restored backup piece 6
channel c6: reading from backup piece /rmanbak/data/ynsb_full_l0_a1uoms2b_7_1.BKU
channel c3: piece handle=/rmanbak/data/ynsb_full_l0_a3uoms2c_6_1.BKU tag=TAG20200216T190023
channel c3: restored backup piece 6
channel c3: reading from backup piece /rmanbak/data/ynsb_full_l0_a3uoms2c_7_1.BKU
channel c2: piece handle=/rmanbak/data/ynsb_full_l0_a2uoms2c_6_1.BKU tag=TAG20200216T190023
channel c2: restored backup piece 6
channel c2: reading from backup piece /rmanbak/data/ynsb_full_l0_a2uoms2c_7_1.BKU
channel c7: piece handle=/rmanbak/data/ynsb_full_l0_9vuoms2b_7_1.BKU tag=TAG20200216T190023
channel c7: restored backup piece 7
channel c7: reading from backup piece /rmanbak/data/ynsb_full_l0_9vuoms2b_8_1.BKU
channel c8: piece handle=/rmanbak/data/ynsb_full_l0_9uuoms2a_7_1.BKU tag=TAG20200216T190023
channel c8: restored backup piece 7
channel c8: reading from backup piece /rmanbak/data/ynsb_full_l0_9uuoms2a_8_1.BKU
channel c4: piece handle=/rmanbak/data/ynsb_full_l0_9tuoms2a_7_1.BKU tag=TAG20200216T190023
channel c4: restored backup piece 7
channel c4: reading from backup piece /rmanbak/data/ynsb_full_l0_9tuoms2a_8_1.BKU
channel c1: piece handle=/rmanbak/data/ynsb_full_l0_a4uoms2c_7_1.BKU tag=TAG20200216T190023
channel c1: restored backup piece 7
channel c1: reading from backup piece /rmanbak/data/ynsb_full_l0_a4uoms2c_8_1.BKU
channel c5: piece handle=/rmanbak/data/ynsb_full_l0_a0uoms2b_7_1.BKU tag=TAG20200216T190023
channel c5: restored backup piece 7
channel c5: reading from backup piece /rmanbak/data/ynsb_full_l0_a0uoms2b_8_1.BKU
channel c6: piece handle=/rmanbak/data/ynsb_full_l0_a1uoms2b_7_1.BKU tag=TAG20200216T190023
channel c6: restored backup piece 7
channel c6: reading from backup piece /rmanbak/data/ynsb_full_l0_a1uoms2b_8_1.BKU
channel c3: piece handle=/rmanbak/data/ynsb_full_l0_a3uoms2c_7_1.BKU tag=TAG20200216T190023
channel c3: restored backup piece 7
channel c3: reading from backup piece /rmanbak/data/ynsb_full_l0_a3uoms2c_8_1.BKU
channel c2: piece handle=/rmanbak/data/ynsb_full_l0_a2uoms2c_7_1.BKU tag=TAG20200216T190023
channel c2: restored backup piece 7
channel c2: reading from backup piece /rmanbak/data/ynsb_full_l0_a2uoms2c_8_1.BKU
channel c7: piece handle=/rmanbak/data/ynsb_full_l0_9vuoms2b_8_1.BKU tag=TAG20200216T190023
channel c7: restored backup piece 8
channel c7: reading from backup piece /rmanbak/data/ynsb_full_l0_9vuoms2b_9_1.BKU
channel c8: piece handle=/rmanbak/data/ynsb_full_l0_9uuoms2a_8_1.BKU tag=TAG20200216T190023
channel c8: restored backup piece 8
channel c8: reading from backup piece /rmanbak/data/ynsb_full_l0_9uuoms2a_9_1.BKU
channel c4: piece handle=/rmanbak/data/ynsb_full_l0_9tuoms2a_8_1.BKU tag=TAG20200216T190023
channel c4: restored backup piece 8
channel c4: reading from backup piece /rmanbak/data/ynsb_full_l0_9tuoms2a_9_1.BKU
channel c1: piece handle=/rmanbak/data/ynsb_full_l0_a4uoms2c_8_1.BKU tag=TAG20200216T190023
channel c1: restored backup piece 8
channel c1: reading from backup piece /rmanbak/data/ynsb_full_l0_a4uoms2c_9_1.BKU
channel c5: piece handle=/rmanbak/data/ynsb_full_l0_a0uoms2b_8_1.BKU tag=TAG20200216T190023
channel c5: restored backup piece 8
channel c5: reading from backup piece /rmanbak/data/ynsb_full_l0_a0uoms2b_9_1.BKU
channel c6: piece handle=/rmanbak/data/ynsb_full_l0_a1uoms2b_8_1.BKU tag=TAG20200216T190023
channel c6: restored backup piece 8
channel c6: reading from backup piece /rmanbak/data/ynsb_full_l0_a1uoms2b_9_1.BKU
channel c3: piece handle=/rmanbak/data/ynsb_full_l0_a3uoms2c_8_1.BKU tag=TAG20200216T190023
channel c3: restored backup piece 8
channel c3: reading from backup piece /rmanbak/data/ynsb_full_l0_a3uoms2c_9_1.BKU
channel c2: piece handle=/rmanbak/data/ynsb_full_l0_a2uoms2c_8_1.BKU tag=TAG20200216T190023
channel c2: restored backup piece 8
channel c2: reading from backup piece /rmanbak/data/ynsb_full_l0_a2uoms2c_9_1.BKU
channel c7: piece handle=/rmanbak/data/ynsb_full_l0_9vuoms2b_9_1.BKU tag=TAG20200216T190023
channel c7: restored backup piece 9
channel c7: reading from backup piece /rmanbak/data/ynsb_full_l0_9vuoms2b_10_1.BKU
channel c8: piece handle=/rmanbak/data/ynsb_full_l0_9uuoms2a_9_1.BKU tag=TAG20200216T190023
channel c8: restored backup piece 9
channel c8: reading from backup piece /rmanbak/data/ynsb_full_l0_9uuoms2a_10_1.BKU
channel c1: piece handle=/rmanbak/data/ynsb_full_l0_a4uoms2c_9_1.BKU tag=TAG20200216T190023
channel c1: restored backup piece 9
channel c1: reading from backup piece /rmanbak/data/ynsb_full_l0_a4uoms2c_10_1.BKU
channel c4: piece handle=/rmanbak/data/ynsb_full_l0_9tuoms2a_9_1.BKU tag=TAG20200216T190023
channel c4: restored backup piece 9
channel c4: reading from backup piece /rmanbak/data/ynsb_full_l0_9tuoms2a_10_1.BKU
channel c1: piece handle=/rmanbak/data/ynsb_full_l0_a4uoms2c_10_1.BKU tag=TAG20200216T190023
channel c1: restored backup piece 10
channel c1: restore complete, elapsed time: 26:46:51
channel c5: piece handle=/rmanbak/data/ynsb_full_l0_a0uoms2b_9_1.BKU tag=TAG20200216T190023
channel c5: restored backup piece 9
channel c5: reading from backup piece /rmanbak/data/ynsb_full_l0_a0uoms2b_10_1.BKU
channel c6: piece handle=/rmanbak/data/ynsb_full_l0_a1uoms2b_9_1.BKU tag=TAG20200216T190023
channel c6: restored backup piece 9
channel c6: reading from backup piece /rmanbak/data/ynsb_full_l0_a1uoms2b_10_1.BKU
channel c3: piece handle=/rmanbak/data/ynsb_full_l0_a3uoms2c_9_1.BKU tag=TAG20200216T190023
channel c3: restored backup piece 9
channel c3: reading from backup piece /rmanbak/data/ynsb_full_l0_a3uoms2c_10_1.BKU
channel c2: piece handle=/rmanbak/data/ynsb_full_l0_a2uoms2c_9_1.BKU tag=TAG20200216T190023
channel c2: restored backup piece 9
channel c2: reading from backup piece /rmanbak/data/ynsb_full_l0_a2uoms2c_10_1.BKU
channel c4: piece handle=/rmanbak/data/ynsb_full_l0_9tuoms2a_10_1.BKU tag=TAG20200216T190023
channel c4: restored backup piece 10
channel c4: restore complete, elapsed time: 28:00:16
channel c2: piece handle=/rmanbak/data/ynsb_full_l0_a2uoms2c_10_1.BKU tag=TAG20200216T190023
channel c2: restored backup piece 10
channel c2: restore complete, elapsed time: 28:05:58
channel c5: piece handle=/rmanbak/data/ynsb_full_l0_a0uoms2b_10_1.BKU tag=TAG20200216T190023
channel c5: restored backup piece 10
channel c5: restore complete, elapsed time: 28:41:28
channel c3: piece handle=/rmanbak/data/ynsb_full_l0_a3uoms2c_10_1.BKU tag=TAG20200216T190023
channel c3: restored backup piece 10
channel c3: restore complete, elapsed time: 28:55:40
channel c6: piece handle=/rmanbak/data/ynsb_full_l0_a1uoms2b_10_1.BKU tag=TAG20200216T190023
channel c6: restored backup piece 10
channel c6: restore complete, elapsed time: 29:04:29
channel c7: piece handle=/rmanbak/data/ynsb_full_l0_9vuoms2b_10_1.BKU tag=TAG20200216T190023
channel c7: restored backup piece 10
channel c7: restore complete, elapsed time: 29:09:49
channel c8: piece handle=/rmanbak/data/ynsb_full_l0_9uuoms2a_10_1.BKU tag=TAG20200216T190023
channel c8: restored backup piece 10
channel c8: restore complete, elapsed time: 29:15:39
Finished restore at 2020-02-18 22:14:37

datafile 1 switched to datafile copy
input datafile copy RECID=266 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/system.257.1007918865
datafile 2 switched to datafile copy
input datafile copy RECID=267 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.278.1008241959
datafile 3 switched to datafile copy
input datafile copy RECID=268 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/sysaux.258.1007918901
datafile 4 switched to datafile copy
input datafile copy RECID=269 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/undotbs.493.1018792017
datafile 5 switched to datafile copy
input datafile copy RECID=270 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.277.1008241785
datafile 7 switched to datafile copy
input datafile copy RECID=271 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/users.260.1007918927
datafile 8 switched to datafile copy
input datafile copy RECID=272 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.279.1008242075
datafile 9 switched to datafile copy
input datafile copy RECID=273 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.280.1008242115
datafile 10 switched to datafile copy
input datafile copy RECID=274 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.281.1008242155
datafile 11 switched to datafile copy
input datafile copy RECID=275 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.282.1008242195
datafile 12 switched to datafile copy
input datafile copy RECID=276 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.283.1008242233
datafile 13 switched to datafile copy
input datafile copy RECID=277 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.284.1008242273
datafile 14 switched to datafile copy
input datafile copy RECID=278 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.285.1008242313
datafile 15 switched to datafile copy
input datafile copy RECID=279 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.286.1008242353
datafile 16 switched to datafile copy
input datafile copy RECID=280 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.287.1008242391
datafile 17 switched to datafile copy
input datafile copy RECID=281 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.288.1008242429
datafile 18 switched to datafile copy
input datafile copy RECID=282 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.289.1008242467
datafile 19 switched to datafile copy
input datafile copy RECID=283 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.290.1008242505
datafile 20 switched to datafile copy
input datafile copy RECID=284 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.291.1008242547
datafile 21 switched to datafile copy
input datafile copy RECID=285 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.292.1008242587
datafile 22 switched to datafile copy
input datafile copy RECID=286 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.293.1008242625
datafile 23 switched to datafile copy
input datafile copy RECID=287 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.294.1008242669
datafile 24 switched to datafile copy
input datafile copy RECID=288 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.295.1008242711
datafile 25 switched to datafile copy
input datafile copy RECID=289 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.296.1008242755
datafile 26 switched to datafile copy
input datafile copy RECID=290 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.297.1008242797
datafile 27 switched to datafile copy
input datafile copy RECID=291 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.298.1008242839
datafile 28 switched to datafile copy
input datafile copy RECID=292 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.299.1008242877
datafile 29 switched to datafile copy
input datafile copy RECID=293 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.300.1008242917
datafile 30 switched to datafile copy
input datafile copy RECID=294 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.301.1008242957
datafile 31 switched to datafile copy
input datafile copy RECID=295 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.302.1008242997
datafile 32 switched to datafile copy
input datafile copy RECID=296 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.303.1008243037
datafile 33 switched to datafile copy
input datafile copy RECID=297 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.304.1008243077
datafile 34 switched to datafile copy
input datafile copy RECID=298 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.305.1008243117
datafile 35 switched to datafile copy
input datafile copy RECID=299 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.306.1008243157
datafile 36 switched to datafile copy
input datafile copy RECID=300 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.307.1008243197
datafile 37 switched to datafile copy
input datafile copy RECID=301 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.308.1008243239
datafile 38 switched to datafile copy
input datafile copy RECID=302 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.309.1008243279
datafile 39 switched to datafile copy
input datafile copy RECID=303 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.310.1008243319
datafile 40 switched to datafile copy
input datafile copy RECID=304 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.311.1008243361
datafile 41 switched to datafile copy
input datafile copy RECID=305 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.312.1008243403
datafile 42 switched to datafile copy
input datafile copy RECID=306 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.313.1008243443
datafile 43 switched to datafile copy
input datafile copy RECID=307 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.314.1008243483
datafile 44 switched to datafile copy
input datafile copy RECID=308 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.315.1008243525
datafile 45 switched to datafile copy
input datafile copy RECID=309 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.316.1008243567
datafile 46 switched to datafile copy
input datafile copy RECID=310 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.317.1008243609
datafile 47 switched to datafile copy
input datafile copy RECID=311 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.318.1008243653
datafile 48 switched to datafile copy
input datafile copy RECID=312 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.319.1008243695
datafile 49 switched to datafile copy
input datafile copy RECID=313 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.320.1008243737
datafile 50 switched to datafile copy
input datafile copy RECID=314 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.321.1008243781
datafile 51 switched to datafile copy
input datafile copy RECID=315 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.322.1008243823
datafile 52 switched to datafile copy
input datafile copy RECID=316 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.323.1008243867
datafile 53 switched to datafile copy
input datafile copy RECID=317 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.324.1008243907
datafile 54 switched to datafile copy
input datafile copy RECID=318 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.325.1008243949
datafile 55 switched to datafile copy
input datafile copy RECID=319 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.326.1008243993
datafile 56 switched to datafile copy
input datafile copy RECID=320 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.327.1008244037
datafile 57 switched to datafile copy
input datafile copy RECID=321 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.328.1008244081
datafile 58 switched to datafile copy
input datafile copy RECID=322 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.329.1008244123
datafile 59 switched to datafile copy
input datafile copy RECID=323 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.330.1008244165
datafile 60 switched to datafile copy
input datafile copy RECID=324 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.331.1008244207
datafile 61 switched to datafile copy
input datafile copy RECID=325 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.332.1008244247
datafile 62 switched to datafile copy
input datafile copy RECID=326 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.333.1008244287
datafile 63 switched to datafile copy
input datafile copy RECID=327 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.334.1008244329
datafile 64 switched to datafile copy
input datafile copy RECID=328 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.335.1008244375
datafile 65 switched to datafile copy
input datafile copy RECID=329 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.336.1008244419
datafile 66 switched to datafile copy
input datafile copy RECID=330 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.337.1008244459
datafile 67 switched to datafile copy
input datafile copy RECID=331 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.338.1008244505
datafile 68 switched to datafile copy
input datafile copy RECID=332 STAMP=1032732878 file name=/u01/app/oracle/oradata/ynsb/data.339.1008244547
datafile 69 switched to datafile copy
input datafile copy RECID=333 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.340.1008244589
datafile 70 switched to datafile copy
input datafile copy RECID=334 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.341.1008244633
datafile 71 switched to datafile copy
input datafile copy RECID=335 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.342.1008244679
datafile 72 switched to datafile copy
input datafile copy RECID=336 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.343.1008244721
datafile 73 switched to datafile copy
input datafile copy RECID=337 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.344.1008244761
datafile 74 switched to datafile copy
input datafile copy RECID=338 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.345.1008244805
datafile 75 switched to datafile copy
input datafile copy RECID=339 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.346.1008244847
datafile 76 switched to datafile copy
input datafile copy RECID=340 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.347.1008244889
datafile 77 switched to datafile copy
input datafile copy RECID=341 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.348.1008244933
datafile 78 switched to datafile copy
input datafile copy RECID=342 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.349.1008244975
datafile 79 switched to datafile copy
input datafile copy RECID=343 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.350.1008245017
datafile 80 switched to datafile copy
input datafile copy RECID=344 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.351.1008245057
datafile 81 switched to datafile copy
input datafile copy RECID=345 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.352.1008245099
datafile 82 switched to datafile copy
input datafile copy RECID=346 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.353.1008245141
datafile 83 switched to datafile copy
input datafile copy RECID=347 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.354.1008245185
datafile 84 switched to datafile copy
input datafile copy RECID=348 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.355.1008245227
datafile 85 switched to datafile copy
input datafile copy RECID=349 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.356.1008245267
datafile 86 switched to datafile copy
input datafile copy RECID=350 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.357.1008245309
datafile 87 switched to datafile copy
input datafile copy RECID=351 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.358.1008245349
datafile 88 switched to datafile copy
input datafile copy RECID=352 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.359.1008245395
datafile 89 switched to datafile copy
input datafile copy RECID=353 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.360.1008245437
datafile 90 switched to datafile copy
input datafile copy RECID=354 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.361.1008245479
datafile 91 switched to datafile copy
input datafile copy RECID=355 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.362.1008245519
datafile 92 switched to datafile copy
input datafile copy RECID=356 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.363.1008245561
datafile 93 switched to datafile copy
input datafile copy RECID=357 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.364.1008245607
datafile 94 switched to datafile copy
input datafile copy RECID=358 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.365.1008245651
datafile 95 switched to datafile copy
input datafile copy RECID=359 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.366.1008245693
datafile 96 switched to datafile copy
input datafile copy RECID=360 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.367.1008245737
datafile 97 switched to datafile copy
input datafile copy RECID=361 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.368.1008245783
datafile 98 switched to datafile copy
input datafile copy RECID=362 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.369.1008245827
datafile 99 switched to datafile copy
input datafile copy RECID=363 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.370.1008245869
datafile 100 switched to datafile copy
input datafile copy RECID=364 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.371.1008245913
datafile 101 switched to datafile copy
input datafile copy RECID=365 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.372.1008245955
datafile 102 switched to datafile copy
input datafile copy RECID=366 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.373.1008245997
datafile 103 switched to datafile copy
input datafile copy RECID=367 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.374.1008246037
datafile 104 switched to datafile copy
input datafile copy RECID=368 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.375.1008246079
datafile 105 switched to datafile copy
input datafile copy RECID=369 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.376.1008246121
datafile 106 switched to datafile copy
input datafile copy RECID=370 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.377.1008246163
datafile 107 switched to datafile copy
input datafile copy RECID=371 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.378.1008246207
datafile 108 switched to datafile copy
input datafile copy RECID=372 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.379.1008246253
datafile 109 switched to datafile copy
input datafile copy RECID=373 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.380.1008246293
datafile 110 switched to datafile copy
input datafile copy RECID=374 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.381.1008246337
datafile 111 switched to datafile copy
input datafile copy RECID=375 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.382.1008246379
datafile 112 switched to datafile copy
input datafile copy RECID=376 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.383.1008246421
datafile 113 switched to datafile copy
input datafile copy RECID=377 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.384.1008246463
datafile 114 switched to datafile copy
input datafile copy RECID=378 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.385.1008246507
datafile 115 switched to datafile copy
input datafile copy RECID=379 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.386.1008246549
datafile 116 switched to datafile copy
input datafile copy RECID=380 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.387.1008246591
datafile 117 switched to datafile copy
input datafile copy RECID=381 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.388.1008246631
datafile 118 switched to datafile copy
input datafile copy RECID=382 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.389.1008246677
datafile 119 switched to datafile copy
input datafile copy RECID=383 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.390.1008246719
datafile 120 switched to datafile copy
input datafile copy RECID=384 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.391.1008246759
datafile 121 switched to datafile copy
input datafile copy RECID=385 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.392.1008246801
datafile 122 switched to datafile copy
input datafile copy RECID=386 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.393.1008246843
datafile 123 switched to datafile copy
input datafile copy RECID=387 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.394.1008246883
datafile 124 switched to datafile copy
input datafile copy RECID=388 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.395.1008246925
datafile 125 switched to datafile copy
input datafile copy RECID=389 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.396.1008246967
datafile 126 switched to datafile copy
input datafile copy RECID=390 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.397.1008247009
datafile 127 switched to datafile copy
input datafile copy RECID=391 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.398.1008247049
datafile 128 switched to datafile copy
input datafile copy RECID=392 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.399.1008247093
datafile 129 switched to datafile copy
input datafile copy RECID=393 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.400.1008247137
datafile 130 switched to datafile copy
input datafile copy RECID=394 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.401.1008247179
datafile 131 switched to datafile copy
input datafile copy RECID=395 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.402.1008247221
datafile 132 switched to datafile copy
input datafile copy RECID=396 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.403.1008247265
datafile 133 switched to datafile copy
input datafile copy RECID=397 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.404.1008247311
datafile 134 switched to datafile copy
input datafile copy RECID=398 STAMP=1032732879 file name=/u01/app/oracle/oradata/ynsb/data.405.1008247351
datafile 135 switched to datafile copy
input datafile copy RECID=399 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.406.1008247393
datafile 136 switched to datafile copy
input datafile copy RECID=400 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.407.1008247435
datafile 137 switched to datafile copy
input datafile copy RECID=401 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.408.1008247481
datafile 138 switched to datafile copy
input datafile copy RECID=402 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.409.1008247521
datafile 139 switched to datafile copy
input datafile copy RECID=403 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.410.1008247565
datafile 140 switched to datafile copy
input datafile copy RECID=404 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.411.1008247605
datafile 141 switched to datafile copy
input datafile copy RECID=405 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.412.1008247651
datafile 142 switched to datafile copy
input datafile copy RECID=406 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.413.1008247693
datafile 143 switched to datafile copy
input datafile copy RECID=407 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.414.1008247737
datafile 144 switched to datafile copy
input datafile copy RECID=408 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.415.1008247779
datafile 145 switched to datafile copy
input datafile copy RECID=409 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.416.1008247823
datafile 146 switched to datafile copy
input datafile copy RECID=410 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.417.1008247865
datafile 147 switched to datafile copy
input datafile copy RECID=411 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.418.1008247905
datafile 148 switched to datafile copy
input datafile copy RECID=412 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.419.1008247951
datafile 149 switched to datafile copy
input datafile copy RECID=413 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.420.1008247993
datafile 150 switched to datafile copy
input datafile copy RECID=414 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.421.1008248037
datafile 151 switched to datafile copy
input datafile copy RECID=415 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.422.1008248077
datafile 152 switched to datafile copy
input datafile copy RECID=416 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.423.1008248119
datafile 153 switched to datafile copy
input datafile copy RECID=417 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.424.1008248161
datafile 154 switched to datafile copy
input datafile copy RECID=418 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.425.1008248205
datafile 155 switched to datafile copy
input datafile copy RECID=419 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.426.1008248247
datafile 156 switched to datafile copy
input datafile copy RECID=420 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.427.1008248289
datafile 157 switched to datafile copy
input datafile copy RECID=421 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.428.1008248333
datafile 158 switched to datafile copy
input datafile copy RECID=422 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.429.1008248379
datafile 159 switched to datafile copy
input datafile copy RECID=423 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.430.1008248421
datafile 160 switched to datafile copy
input datafile copy RECID=424 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.431.1008248463
datafile 161 switched to datafile copy
input datafile copy RECID=425 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.432.1008248503
datafile 162 switched to datafile copy
input datafile copy RECID=426 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.433.1008248545
datafile 163 switched to datafile copy
input datafile copy RECID=427 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.434.1008248587
datafile 164 switched to datafile copy
input datafile copy RECID=428 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.435.1008248627
datafile 165 switched to datafile copy
input datafile copy RECID=429 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.436.1008248671
datafile 166 switched to datafile copy
input datafile copy RECID=430 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.437.1008248713
datafile 167 switched to datafile copy
input datafile copy RECID=431 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.438.1008248753
datafile 168 switched to datafile copy
input datafile copy RECID=432 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.439.1008248799
datafile 169 switched to datafile copy
input datafile copy RECID=433 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.440.1008248841
datafile 170 switched to datafile copy
input datafile copy RECID=434 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.441.1008248883
datafile 171 switched to datafile copy
input datafile copy RECID=435 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.442.1008248925
datafile 172 switched to datafile copy
input datafile copy RECID=436 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.443.1008248965
datafile 173 switched to datafile copy
input datafile copy RECID=437 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.444.1008249007
datafile 174 switched to datafile copy
input datafile copy RECID=438 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.445.1008249047
datafile 175 switched to datafile copy
input datafile copy RECID=439 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.446.1008249089
datafile 176 switched to datafile copy
input datafile copy RECID=440 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.447.1008249131
datafile 177 switched to datafile copy
input datafile copy RECID=441 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.448.1008249173
datafile 178 switched to datafile copy
input datafile copy RECID=442 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.449.1008249217
datafile 179 switched to datafile copy
input datafile copy RECID=443 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.450.1008249259
datafile 180 switched to datafile copy
input datafile copy RECID=444 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.451.1008249303
datafile 181 switched to datafile copy
input datafile copy RECID=445 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.452.1008249345
datafile 182 switched to datafile copy
input datafile copy RECID=446 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.453.1008249387
datafile 183 switched to datafile copy
input datafile copy RECID=447 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.454.1008249429
datafile 184 switched to datafile copy
input datafile copy RECID=448 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.455.1008249471
datafile 185 switched to datafile copy
input datafile copy RECID=449 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.456.1008249513
datafile 186 switched to datafile copy
input datafile copy RECID=450 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.457.1008249557
datafile 187 switched to datafile copy
input datafile copy RECID=451 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.458.1008249603
datafile 188 switched to datafile copy
input datafile copy RECID=452 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.459.1008249643
datafile 189 switched to datafile copy
input datafile copy RECID=453 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.460.1008249685
datafile 190 switched to datafile copy
input datafile copy RECID=454 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.461.1008249725
datafile 191 switched to datafile copy
input datafile copy RECID=455 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.462.1008249771
datafile 192 switched to datafile copy
input datafile copy RECID=456 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.463.1008249811
datafile 193 switched to datafile copy
input datafile copy RECID=457 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.464.1008249853
datafile 194 switched to datafile copy
input datafile copy RECID=458 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.465.1008249893
datafile 195 switched to datafile copy
input datafile copy RECID=459 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.466.1008249935
datafile 196 switched to datafile copy
input datafile copy RECID=460 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.467.1008249979
datafile 197 switched to datafile copy
input datafile copy RECID=461 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.468.1008250025
datafile 198 switched to datafile copy
input datafile copy RECID=462 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.469.1008250067
datafile 199 switched to datafile copy
input datafile copy RECID=463 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.470.1008250109
datafile 200 switched to datafile copy
input datafile copy RECID=464 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.471.1008250153
datafile 201 switched to datafile copy
input datafile copy RECID=465 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/undotbs.492.1018796645
datafile 202 switched to datafile copy
input datafile copy RECID=466 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.491.1021997585
datafile 203 switched to datafile copy
input datafile copy RECID=467 STAMP=1032732880 file name=/u01/app/oracle/oradata/ynsb/data.490.1021997769
datafile 204 switched to datafile copy
input datafile copy RECID=468 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.489.1021997879
datafile 205 switched to datafile copy
input datafile copy RECID=469 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.488.1021997921
datafile 206 switched to datafile copy
input datafile copy RECID=470 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.487.1021997963
datafile 207 switched to datafile copy
input datafile copy RECID=471 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.486.1021998007
datafile 208 switched to datafile copy
input datafile copy RECID=472 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.485.1021998051
datafile 209 switched to datafile copy
input datafile copy RECID=473 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.484.1021998093
datafile 210 switched to datafile copy
input datafile copy RECID=474 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.483.1021998137
datafile 211 switched to datafile copy
input datafile copy RECID=475 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.482.1021998181
datafile 212 switched to datafile copy
input datafile copy RECID=476 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.481.1021998225
datafile 213 switched to datafile copy
input datafile copy RECID=477 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.480.1021998269
datafile 214 switched to datafile copy
input datafile copy RECID=478 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.479.1021998313
datafile 215 switched to datafile copy
input datafile copy RECID=479 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.478.1021998357
datafile 216 switched to datafile copy
input datafile copy RECID=480 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.477.1021998401
datafile 217 switched to datafile copy
input datafile copy RECID=481 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.476.1021998445
datafile 218 switched to datafile copy
input datafile copy RECID=482 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.475.1021998489
datafile 219 switched to datafile copy
input datafile copy RECID=483 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.474.1021998533
datafile 220 switched to datafile copy
input datafile copy RECID=484 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.473.1021998575
datafile 221 switched to datafile copy
input datafile copy RECID=485 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.275.1024336845
datafile 222 switched to datafile copy
input datafile copy RECID=486 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.503.1024336979
datafile 223 switched to datafile copy
input datafile copy RECID=487 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.504.1024337037
datafile 224 switched to datafile copy
input datafile copy RECID=488 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.505.1024337103
datafile 225 switched to datafile copy
input datafile copy RECID=489 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.506.1024337361
datafile 226 switched to datafile copy
input datafile copy RECID=490 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.507.1024337413
datafile 227 switched to datafile copy
input datafile copy RECID=491 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.508.1024345783
datafile 228 switched to datafile copy
input datafile copy RECID=492 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.509.1024345827
datafile 229 switched to datafile copy
input datafile copy RECID=493 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.510.1024345871
datafile 230 switched to datafile copy
input datafile copy RECID=494 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.511.1024345913
datafile 231 switched to datafile copy
input datafile copy RECID=495 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.512.1024345955
datafile 232 switched to datafile copy
input datafile copy RECID=496 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/soe.534.1009470969
datafile 233 switched to datafile copy
input datafile copy RECID=497 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/soe.535.1009471081
datafile 234 switched to datafile copy
input datafile copy RECID=498 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/soe.536.1009549381
datafile 235 switched to datafile copy
input datafile copy RECID=499 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/ogg.537.1011548331
datafile 236 switched to datafile copy
input datafile copy RECID=500 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/undotbs.539.1011810525
datafile 237 switched to datafile copy
input datafile copy RECID=501 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.513.1024346873
datafile 238 switched to datafile copy
input datafile copy RECID=502 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.514.1024346927
datafile 239 switched to datafile copy
input datafile copy RECID=503 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.515.1024855385
datafile 240 switched to datafile copy
input datafile copy RECID=504 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.516.1024855427
datafile 241 switched to datafile copy
input datafile copy RECID=505 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.517.1024855473
datafile 242 switched to datafile copy
input datafile copy RECID=506 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.518.1024855517
datafile 243 switched to datafile copy
input datafile copy RECID=507 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.519.1024855559
datafile 244 switched to datafile copy
input datafile copy RECID=508 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.520.1024855603
datafile 245 switched to datafile copy
input datafile copy RECID=509 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.521.1026555771
datafile 246 switched to datafile copy
input datafile copy RECID=510 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.522.1026555833
datafile 247 switched to datafile copy
input datafile copy RECID=511 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.523.1026555895
datafile 248 switched to datafile copy
input datafile copy RECID=512 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.524.1026555939
datafile 249 switched to datafile copy
input datafile copy RECID=513 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.525.1026555983
datafile 250 switched to datafile copy
input datafile copy RECID=514 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.526.1026556025
datafile 251 switched to datafile copy
input datafile copy RECID=515 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.527.1026556067
datafile 252 switched to datafile copy
input datafile copy RECID=516 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.528.1026556109
datafile 253 switched to datafile copy
input datafile copy RECID=517 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.529.1026556153
datafile 254 switched to datafile copy
input datafile copy RECID=518 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.530.1026556195
datafile 255 switched to datafile copy
input datafile copy RECID=519 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.531.1028365797
datafile 256 switched to datafile copy
input datafile copy RECID=520 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.532.1028365875
datafile 257 switched to datafile copy
input datafile copy RECID=521 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.533.1028365919
datafile 258 switched to datafile copy
input datafile copy RECID=522 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.541.1028365963
datafile 259 switched to datafile copy
input datafile copy RECID=523 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.542.1028366005
datafile 260 switched to datafile copy
input datafile copy RECID=524 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.543.1028366047
datafile 261 switched to datafile copy
input datafile copy RECID=525 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.544.1028366091
datafile 262 switched to datafile copy
input datafile copy RECID=526 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.545.1028366135
datafile 263 switched to datafile copy
input datafile copy RECID=527 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.546.1028366175
datafile 264 switched to datafile copy
input datafile copy RECID=528 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.547.1028366217
datafile 265 switched to datafile copy
input datafile copy RECID=529 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.548.1030265917
datafile 266 switched to datafile copy
input datafile copy RECID=530 STAMP=1032732881 file name=/u01/app/oracle/oradata/ynsb/data.549.1030265961

Starting recover at 2020-02-18 22:14:45

starting media recovery

channel c1: starting archived log restore to default destination
channel c1: restoring archived log
archived log thread=1 sequence=49153
channel c1: reading from backup piece /rmanbak/data/ynsb_full_l0_a5uont2d_1_1.BKU
channel c2: starting archived log restore to default destination
channel c2: restoring archived log
archived log thread=1 sequence=49154
channel c2: reading from backup piece /rmanbak/data/ynsb_full_l0_a6uont2d_1_1.BKU
channel c3: starting archived log restore to default destination
channel c3: restoring archived log
archived log thread=1 sequence=49155
channel c3: reading from backup piece /rmanbak/data/ynsb_full_l0_a7uont2d_1_1.BKU
channel c3: piece handle=/rmanbak/data/ynsb_full_l0_a7uont2d_1_1.BKU tag=TAG20200217T042341
channel c3: restored backup piece 1
channel c3: restore complete, elapsed time: 00:00:15
channel c2: piece handle=/rmanbak/data/ynsb_full_l0_a6uont2d_1_1.BKU tag=TAG20200217T042341
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:00:56
channel c1: piece handle=/rmanbak/data/ynsb_full_l0_a5uont2d_1_1.BKU tag=TAG20200217T042341
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:01:06
archived log file name=/u01/app/arch_log/1_49153_1007918999.dbf thread=1 sequence=49153
archived log file name=/u01/app/arch_log/1_49154_1007918999.dbf thread=1 sequence=49154
archived log file name=/u01/app/arch_log/1_49155_1007918999.dbf thread=1 sequence=49155
unable to find archived log
archived log thread=1 sequence=49156
released channel: c1
released channel: c2
released channel: c3
released channel: c4
released channel: c5
released channel: c6
released channel: c7
released channel: c8
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/18/2020 22:17:02
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 49156 and starting SCN of 16713395493958
Recovery Manager complete.

5、 解决恢复过程中的错误
在第四步出现RMAN-06054的错误,根据提示信息可以知道本次全库恢复只能恢复到SCN为16713395493958时的数据,主要由于我们在做恢复的时候没有查看数据库最新SCN号或可恢复到的时间点,所以才会出现上述错误,这里我们可以根据错误提示来解决recover操作失败的问题,解决方式如下,基于SCN重新做recover:
RMAN> run{
2> set until scn 16713395493958;
3> recover database;
4> }

executing command: SET until clause

Starting recover at 2020-02-19 08:47:50
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:04

Finished recover at 2020-02-19 08:48:00
至此全库恢复完成。

6、 重置REDO日志组
将REDO日志组路径从ASM修改至文件系统,如下
alter database rename file '+DATA/YNSB/ONLINELOG/group_6.268.1007919001' to '/u01/app/oracle/oradata/onlinelog/group_6.268.1007919001';
alter database rename file '+DATA/YNSB/ONLINELOG/group_6.270.1007919005' to '/u01/app/oracle/oradata/onlinelog/group_6.270.1007919005';
alter database rename file '+DATA/YNSB/ONLINELOG/group_5.267.1007918999' to '/u01/app/oracle/oradata/onlinelog/group_5.267.1007918999';
alter database rename file '+DATA/YNSB/ONLINELOG/group_5.271.1007919005' to '/u01/app/oracle/oradata/onlinelog/group_5.271.1007919005';
alter database rename file '+DATA/YNSB/ONLINELOG/group_4.266.1007918999' to '/u01/app/oracle/oradata/onlinelog/group_4.266.1007918999';
alter database rename file '+DATA/YNSB/ONLINELOG/group_4.273.1007919005' to '/u01/app/oracle/oradata/onlinelog/group_4.273.1007919005';
alter database rename file '+DATA/YNSB/ONLINELOG/group_3.265.1007918999' to '/u01/app/oracle/oradata/onlinelog/group_3.265.1007918999';
alter database rename file '+DATA/YNSB/ONLINELOG/group_3.272.1007919005' to '/u01/app/oracle/oradata/onlinelog/group_3.272.1007919005';
alter database rename file '+DATA/YNSB/ONLINELOG/group_2.264.1007918999' to '/u01/app/oracle/oradata/onlinelog/group_2.264.1007918999';
alter database rename file '+DATA/YNSB/ONLINELOG/group_2.274.1007919005' to '/u01/app/oracle/oradata/onlinelog/group_2.274.1007919005';
alter database rename file '+DATA/YNSB/ONLINELOG/group_1.263.1007918999' to '/u01/app/oracle/oradata/onlinelog/group_1.263.1007918999';
alter database rename file '+DATA/YNSB/ONLINELOG/group_1.269.1007919005' to '/u01/app/oracle/oradata/onlinelog/group_1.269.1007919005';
alter database rename file '+DATA/YNSB/ONLINELOG/group_7.501.1015883139' to '/u01/app/oracle/oradata/onlinelog/group_7.501.1015883139';
alter database rename file '+DATA/YNSB/ONLINELOG/group_8.500.1015883151' to '/u01/app/oracle/oradata/onlinelog/group_8.500.1015883151';
alter database rename file '+DATA/YNSB/ONLINELOG/group_9.499.1015883155' to '/u01/app/oracle/oradata/onlinelog/group_9.499.1015883155';
alter database rename file '+DATA/YNSB/ONLINELOG/group_10.498.1015883157' to '/u01/app/oracle/oradata/onlinelog/group_10.498.1015883157';
alter database rename file '+DATA/YNSB/ONLINELOG/group_11.497.1015883159' to '/u01/app/oracle/oradata/onlinelog/group_11.497.1015883159';
alter database rename file '+DATA/YNSB/ONLINELOG/group_12.496.1015883161' to '/u01/app/oracle/oradata/onlinelog/group_12.496.1015883161';
alter database rename file '+DATA/YNSB/ONLINELOG/group_13.495.1015883163' to '/u01/app/oracle/oradata/onlinelog/group_13.495.1015883163';

7、 打开数据库并验证
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-19751: could not create the change tracking file
ORA-19750: change tracking file: '+DATA/YNSB/CHANGETRACKING/ctf.538.1011809175'
ORA-17502: ksfdcre:1 Failed to create file
+DATA/YNSB/CHANGETRACKING/ctf.538.1011809175
ORA-17501: logical block size 4294967295 is invalid
ORA-29701: unable to connect to Cluster Synchronization Service
ORA-17503: ksfdopn:2 Failed to open file
+DATA/YNSB/CHANGETRACKING/ctf.538.1011809175
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15374: invalid cluster configuration
当我们在打开数据库的时候报上述错,根据错误信息我们知道数数据启用的块改变跟踪文件存储位置没有修改导致,这里禁用块改变跟踪或是修改跟踪文件存储路径即可,如下:
alter database disable block change tracking;
alter database open;
到目前为止,数据库恢复遇到的错误已经全部解决,重启数据库再次验证均成功,数据库也顺利完成恢复演练测试。

五、恢复测试演练总结

本次对...核心库的备份进行了恢复演练测试,恢复演练测试结果通过,数据库全库恢复全部恢复完成。
上一篇:centos7系统优化定制


下一篇:Java生产环境下性能监控与调优详解