• Oracle 数据库历史备份数据恢复验证

    Oracle ASM 管理的数据库历史备份数据恢复至单实例数据库

    简介：
    验证 ASM 管理的数据库的历史备份恢复至单实例数据库（主要目的在于验证历史备份是否可用的一次恢复演练）

    一、恢复演练系统选择

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

    二、恢复演练记录（基于rman历史备份全备恢复）
    注：本次恢复使用文件系统而不在是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;
    到此，数据库恢复遇到的错误已经全部解决，重启数据库再次验证均成功，数据库也顺利完成历史备份的恢复演练。

    五、历史备份恢复测试演练总结
    本次对...核心库的历史备份进行了恢复演练测试，恢复演练测试通过，证明历史数据库备份可用。

  • 相关阅读:
    详细介绍区块链之挖矿
    【LeetCode热题100】-- 45.跳跃游戏II
    Linux计划任务
    视觉语言跨模态特征语义相似度计算改进--表征空间维度语义依赖感知聚合算法 ACM MM
    C++ Qt开发：Charts绘制各类图表详解
    QT：debug日志—打不开头文件以及qDebug和Q_CLASSINFO的使用
    06实战：如何通过 ref 实现组件的子传父、父传子的交互(实例演示)？
    php实战案例记录(4)`include`和`require_once`的区别和用法
    【20221130】【每日一题】用最少数量的箭引爆气球
    OpenCV每日函数 计算摄影模块(1) 图像修复算法 inpaint函数
  • 原文地址：https://blog.csdn.net/baidu_17517885/article/details/143391981