RMAN> RUN {
set until time "to_date('14-JUN-2024 14:53:00','DD-MON-YYYY HH24:MI:SS')";
set newname for database to '+data1';
restore database ;
}2> 3> 4> 5>
executing command: SET until clause
executing command: SET NEWNAME
Starting restore at 14-JUN-24
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=30 instance=cdb1 device type=DISK
channel ORA_DISK_1: restoring datafile 00001
input datafile copy RECID=125 STAMP=1171638627 file name=+DATA1/CDB/DATAFILE/system.268.1171595425
destination for restore of datafile 00001: +data1
ORA-19505: failed to identify file "+DATA1/CDB/DATAFILE/system.268.1171595425"
ORA-17503: ksfdopn:2 Failed to open file +DATA1/CDB/DATAFILE/system.268.1171595425
ORA-15012: ASM file '+DATA1/CDB/DATAFILE/system.268.1171595425' does not exist
ORA-19600: input file is datafile-copy 125 (+DATA1/CDB/DATAFILE/system.268.1171595425)
ORA-19601: output file is datafile-copy 0 (+DATA1)
channel ORA_DISK_1: restoring datafile 00003
input datafile copy RECID=126 STAMP=1171638630 file name=+DATA1/CDB/DATAFILE/sysaux.299.1171595427
destination for restore of datafile 00003: +data1
ORA-19505: failed to identify file "+DATA1/CDB/DATAFILE/sysaux.299.1171595427"
ORA-17503: ksfdopn:2 Failed to open file +DATA1/CDB/DATAFILE/sysaux.299.1171595427
ORA-15012: ASM file '+DATA1/CDB/DATAFILE/sysaux.299.1171595427' does not exist
ORA-19600: input file is datafile-copy 126 (+DATA1/CDB/DATAFILE/sysaux.299.1171595427)
ORA-19601: output file is datafile-copy 0 (+DATA1)
channel ORA_DISK_1: restoring datafile 00004
input datafile copy RECID=127 STAMP=1171638632 file name=+DATA1/CDB/DATAFILE/undotbs1.265.1171595431
destination for restore of datafile 00004: +data1
ORA-19505: failed to identify file "+DATA1/CDB/DATAFILE/undotbs1.265.1171595431"
ORA-17503: ksfdopn:2 Failed to open file +DATA1/CDB/DATAFILE/undotbs1.265.1171595431
ORA-15012: ASM file '+DATA1/CDB/DATAFILE/undotbs1.265.1171595431' does not exist
ORA-19600: input file is datafile-copy 127 (+DATA1/CDB/DATAFILE/undotbs1.265.1171595431)
ORA-19601: output file is datafile-copy 0 (+DATA1)
channel ORA_DISK_1: restoring datafile 00005
input datafile copy RECID=109 STAMP=1171638413 file name=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.330.1171595211
destination for restore of datafile 00005: +data1
ORA-19505: failed to identify file "+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.330.1171595211"
ORA-17503: ksfdopn:2 Failed to open file +DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.330.1171595211
ORA-15012: ASM file '+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.330.1171595211' does not exist
channel ORA_DISK_1: restoring datafile 00006
input datafile copy RECID=110 STAMP=1171638416 file name=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.329.1171595215
destination for restore of datafile 00006: +data1
ORA-19505: failed to identify file "+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.329.1171595215"
ORA-17503: ksfdopn:2 Failed to open file +DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.329.1171595215
ORA-15012: ASM file '+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.329.1171595215' does not exist
channel ORA_DISK_1: restoring datafile 00007
input datafile copy RECID=128 STAMP=1171638635 file name=+DATA1/CDB/DATAFILE/users.334.1171595435
destination for restore of datafile 00007: +data1
ORA-19505: failed to identify file "+DATA1/CDB/DATAFILE/users.334.1171595435"
ORA-17503: ksfdopn:2 Failed to open file +DATA1/CDB/DATAFILE/users.334.1171595435
ORA-15012: ASM file '+DATA1/CDB/DATAFILE/users.334.1171595435' does not exist
ORA-19600: input file is datafile-copy 128 (+DATA1/CDB/DATAFILE/users.334.1171595435)
ORA-19601: output file is datafile-copy 0 (+DATA1)
channel ORA_DISK_1: restoring datafile 00008
input datafile copy RECID=112 STAMP=1171638419 file name=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.266.1171595219
destination for restore of datafile 00008: +data1
ORA-19505: failed to identify file "+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.266.1171595219"
ORA-17503: ksfdopn:2 Failed to open file +DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.266.1171595219
ORA-15012: ASM file '+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.266.1171595219' does not exist
channel ORA_DISK_1: restoring datafile 00009
input datafile copy RECID=129 STAMP=1171638638 file name=+DATA1/CDB/DATAFILE/undotbs2.325.1171595437
destination for restore of datafile 00009: +data1
ORA-19505: failed to identify file "+DATA1/CDB/DATAFILE/undotbs2.325.1171595437"
ORA-17503: ksfdopn:2 Failed to open file +DATA1/CDB/DATAFILE/undotbs2.325.1171595437
ORA-15012: ASM file '+DATA1/CDB/DATAFILE/undotbs2.325.1171595437' does not exist
ORA-19600: input file is datafile-copy 129 (+DATA1/CDB/DATAFILE/undotbs2.325.1171595437)
ORA-19601: output file is datafile-copy 0 (+DATA1)
channel ORA_DISK_1: restoring datafile 00010
input datafile copy RECID=130 STAMP=1171638638 file name=+DATA1/CDB/DATAFILE/undotbs3.312.1171595439
destination for restore of datafile 00010: +data1
ORA-19505: failed to identify file "+DATA1/CDB/DATAFILE/undotbs3.312.1171595439"
ORA-17503: ksfdopn:2 Failed to open file +DATA1/CDB/DATAFILE/undotbs3.312.1171595439
ORA-15012: ASM file '+DATA1/CDB/DATAFILE/undotbs3.312.1171595439' does not exist
ORA-19600: input file is datafile-copy 130 (+DATA1/CDB/DATAFILE/undotbs3.312.1171595439)
ORA-19601: output file is datafile-copy 0 (+DATA1)
channel ORA_DISK_1: restoring datafile 00050
input datafile copy RECID=115 STAMP=1171638423 file name=+DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/system.300.1171595223
destination for restore of datafile 00050: +data1
ORA-19505: failed to identify file "+DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/system.300.1171595223"
ORA-17503: ksfdopn:2 Failed to open file +DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/system.300.1171595223
ORA-15012: ASM file '+DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/system.300.1171595223' does not exist
channel ORA_DISK_1: restoring datafile 00051
input datafile copy RECID=116 STAMP=1171638426 file name=+DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/sysaux.336.1171595225
destination for restore of datafile 00051: +data1
ORA-19505: failed to identify file "+DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/sysaux.336.1171595225"
ORA-17503: ksfdopn:2 Failed to open file +DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/sysaux.336.1171595225
ORA-15012: ASM file '+DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/sysaux.336.1171595225' does not exist
channel ORA_DISK_1: restoring datafile 00052
input datafile copy RECID=117 STAMP=1171638428 file name=+DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/undotbs1.337.1171595229
destination for restore of datafile 00052: +data1
ORA-19505: failed to identify file "+DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/undotbs1.337.1171595229"
ORA-17503: ksfdopn:2 Failed to open file +DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/undotbs1.337.1171595229
ORA-15012: ASM file '+DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/undotbs1.337.1171595229' does not exist
failover to previous backup
channel ORA_DISK_1: restoring datafile 00001
input datafile copy RECID=119 STAMP=1171638584 file name=+DATA1/CDB/DATAFILE/system.337.1171595383
destination for restore of datafile 00001: +data1
ORA-19505: failed to identify file "+DATA1/CDB/DATAFILE/system.337.1171595383"
ORA-17503: ksfdopn:2 Failed to open file +DATA1/CDB/DATAFILE/system.337.1171595383
ORA-15012: ASM file '+DATA1/CDB/DATAFILE/system.337.1171595383' does not exist
ORA-19600: input file is datafile-copy 119 (+DATA1/CDB/DATAFILE/system.337.1171595383)
ORA-19601: output file is datafile-copy 0 (+DATA1)
channel ORA_DISK_1: restoring datafile 00003
input datafile copy RECID=120 STAMP=1171638587 file name=+DATA1/CDB/DATAFILE/sysaux.336.1171595385
destination for restore of datafile 00003: +data1
ORA-19505: failed to identify file "+DATA1/CDB/DATAFILE/sysaux.336.1171595385"
ORA-17503: ksfdopn:2 Failed to open file +DATA1/CDB/DATAFILE/sysaux.336.1171595385
ORA-15012: ASM file '+DATA1/CDB/DATAFILE/sysaux.336.1171595385' does not exist
ORA-19600: input file is datafile-copy 120 (+DATA1/CDB/DATAFILE/sysaux.336.1171595385)
ORA-19601: output file is datafile-copy 0 (+DATA1)
channel ORA_DISK_1: restoring datafile 00004
input datafile copy RECID=121 STAMP=1171638590 file name=+DATA1/CDB/DATAFILE/undotbs1.300.1171595389
destination for restore of datafile 00004: +data1
ORA-19505: failed to identify file "+DATA1/CDB/DATAFILE/undotbs1.300.1171595389"
ORA-17503: ksfdopn:2 Failed to open file +DATA1/CDB/DATAFILE/undotbs1.300.1171595389
ORA-15012: ASM file '+DATA1/CDB/DATAFILE/undotbs1.300.1171595389' does not exist
ORA-19600: input file is datafile-copy 121 (+DATA1/CDB/DATAFILE/undotbs1.300.1171595389)
ORA-19601: output file is datafile-copy 0 (+DATA1)
channel ORA_DISK_1: restoring datafile 00005
input datafile copy RECID=102 STAMP=1171638339 file name=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.276.1171595107
destination for restore of datafile 00005: +data1
^C
user interrupt received
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/14/2024 15:12:16
RMAN-03099: job cancelled at user request
----------前一次做过set newname，orace会从newname 下找备份不从 backup找----------------
RMAN> crosscheck datafilecopy all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=30 instance=cdb1 device type=DISK
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/system.268.1171595425 RECID=125 STAMP=1171638627
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/system.337.1171595383 RECID=119 STAMP=1171638584
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/system.338.1171595313 RECID=118 STAMP=1171638515
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/system.267.1171595203 RECID=106 STAMP=1171638405
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/system.308.1171595043 RECID=99 STAMP=1171638298
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/system.326.1171436025 RECID=88 STAMP=1171479228
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/system.334.1171435765 RECID=82 STAMP=1171478967
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/system.260.1171435599 RECID=75 STAMP=1171478856
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/sysaux.299.1171595427 RECID=126 STAMP=1171638630
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/sysaux.336.1171595385 RECID=120 STAMP=1171638587
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/sysaux.327.1171595205 RECID=107 STAMP=1171638408
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/sysaux.274.1171595043 RECID=98 STAMP=1171638286
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/sysaux.298.1171436029 RECID=89 STAMP=1171479230
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/sysaux.333.1171435769 RECID=83 STAMP=1171478970
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/sysaux.327.1171435599 RECID=74 STAMP=1171478842
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/undotbs1.265.1171595431 RECID=127 STAMP=1171638632
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/undotbs1.300.1171595389 RECID=121 STAMP=1171638590
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/undotbs1.260.1171595209 RECID=108 STAMP=1171638411
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/undotbs1.289.1171595043 RECID=95 STAMP=1171638243
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/undotbs1.259.1171436031 RECID=90 STAMP=1171479233
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/undotbs1.270.1171435771 RECID=84 STAMP=1171478973
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/undotbs1.267.1171435599 RECID=73 STAMP=1171478802
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.330.1171595211 RECID=109 STAMP=1171638413
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.276.1171595107 RECID=102 STAMP=1171638339
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.323.1171420875 RECID=23 STAMP=1171464077
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.329.1171595215 RECID=110 STAMP=1171638416
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.294.1171595107 RECID=101 STAMP=1171638336
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.304.1171420875 RECID=22 STAMP=1171464077
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/users.334.1171595435 RECID=128 STAMP=1171638635
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/users.264.1171595393 RECID=122 STAMP=1171638593
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/users.257.1171595219 RECID=111 STAMP=1171638418
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/users.304.1171595043 RECID=94 STAMP=1171638242
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/users.280.1171436035 RECID=91 STAMP=1171479234
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/users.328.1171435775 RECID=85 STAMP=1171478974
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/users.304.1171435729 RECID=79 STAMP=1171478929
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/users.261.1171435599 RECID=70 STAMP=1171478799
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.266.1171595219 RECID=112 STAMP=1171638419
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.293.1171595107 RECID=100 STAMP=1171638319
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.276.1171420875 RECID=21 STAMP=1171464076
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/undotbs2.325.1171595437 RECID=129 STAMP=1171638638
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/undotbs2.273.1171595395 RECID=123 STAMP=1171638595
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/undotbs2.320.1171595221 RECID=113 STAMP=1171638420
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/undotbs2.335.1171595043 RECID=97 STAMP=1171638244
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/undotbs2.312.1171436035 RECID=92 STAMP=1171479235
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/undotbs2.321.1171435775 RECID=86 STAMP=1171478975
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/undotbs2.323.1171435731 RECID=80 STAMP=1171478930
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/undotbs2.264.1171435599 RECID=72 STAMP=1171478800
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/undotbs3.312.1171595439 RECID=130 STAMP=1171638638
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/undotbs3.261.1171595397 RECID=124 STAMP=1171638596
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/undotbs3.282.1171595221 RECID=114 STAMP=1171638421
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/undotbs3.323.1171595043 RECID=96 STAMP=1171638244
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/undotbs3.332.1171436037 RECID=93 STAMP=1171479236
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/undotbs3.315.1171435777 RECID=87 STAMP=1171478976
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/undotbs3.335.1171435731 RECID=81 STAMP=1171478931
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/DATAFILE/undotbs3.273.1171435599 RECID=71 STAMP=1171478800
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/16319B746634595EE0636401A8C07807/DATAFILE/system.307.1171423197 RECID=52 STAMP=1171478160
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/16319B746634595EE0636401A8C07807/DATAFILE/system.324.1171420871 RECID=47 STAMP=1171478159
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/16319B746634595EE0636401A8C07807/DATAFILE/sysaux.258.1171423197 RECID=53 STAMP=1171478160
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/16319B746634595EE0636401A8C07807/DATAFILE/sysaux.283.1171420871 RECID=48 STAMP=1171478159
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/16319B746634595EE0636401A8C07807/DATAFILE/undotbs1.286.1171423197 RECID=54 STAMP=1171478160
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/16319B746634595EE0636401A8C07807/DATAFILE/undotbs1.287.1171420871 RECID=49 STAMP=1171478159
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/16319B746634595EE0636401A8C07807/DATAFILE/undotbs2.313.1171423197 RECID=55 STAMP=1171478160
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/16319B746634595EE0636401A8C07807/DATAFILE/undotbs2.309.1171420871 RECID=50 STAMP=1171478159
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/16319B746634595EE0636401A8C07807/DATAFILE/undotbs3.297.1171423197 RECID=56 STAMP=1171478160
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/16319B746634595EE0636401A8C07807/DATAFILE/undotbs3.325.1171420871 RECID=51 STAMP=1171478159
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/1AAF224E3E417AE1E0636401A8C065E9/DATAFILE/system.333.1171432513 RECID=57 STAMP=1171478160
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/1AAF224E3E417AE1E0636401A8C065E9/DATAFILE/sysaux.334.1171432513 RECID=58 STAMP=1171478160
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/1AAF224E3E417AE1E0636401A8C065E9/DATAFILE/undotbs1.335.1171432513 RECID=59 STAMP=1171478160
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/system.300.1171595223 RECID=115 STAMP=1171638423
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/system.261.1171595143 RECID=105 STAMP=1171638374
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/sysaux.336.1171595225 RECID=116 STAMP=1171638426
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/sysaux.273.1171595143 RECID=104 STAMP=1171638371
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/undotbs1.337.1171595229 RECID=117 STAMP=1171638428
validation failed for datafile copy
datafile copy file name=+DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/undotbs1.264.1171595143 RECID=103 STAMP=1171638354
Crosschecked 74 objects
RMAN> RUN {
set until time "to_date('14-JUN-2024 14:53:00','DD-MON-YYYY HH24:MI:SS')";
set newname for database to '+data1';
restore database ;
}2> 3> 4> 5>
executing command: SET until clause
executing command: SET NEWNAME
Starting restore at 14-JUN-24
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to +data1
channel ORA_DISK_1: restoring datafile 00003 to +data1
channel ORA_DISK_1: restoring datafile 00004 to +data1
channel ORA_DISK_1: restoring datafile 00007 to +data1
channel ORA_DISK_1: restoring datafile 00009 to +data1
channel ORA_DISK_1: restoring datafile 00010 to +data1
channel ORA_DISK_1: reading from backup piece +DATA1/CDB/BACKUPSET/2024_06_14/nnndf0_tag20240614t145032_0.256.1171594233
channel ORA_DISK_1: piece handle=+DATA1/CDB/BACKUPSET/2024_06_14/nnndf0_tag20240614t145032_0.256.1171594233 tag=TAG20240614T145032
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:05
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00005 to +data1
channel ORA_DISK_1: restoring datafile 00006 to +data1
channel ORA_DISK_1: restoring datafile 00008 to +data1
channel ORA_DISK_1: reading from backup piece +DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_14/nnndf0_tag20240614t145032_0.302.1171594289 找对了 NNfile
channel ORA_DISK_1: ORA-19870: error while restoring backup piece +DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_14/nnndf0_tag20240614t145032_0.302.1171594289
ORA-19505: failed to identify file "+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_14/nnndf0_tag20240614t145032_0.302.1171594289"
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00050 to +data1
channel ORA_DISK_1: restoring datafile 00051 to +data1
channel ORA_DISK_1: restoring datafile 00052 to +data1
channel ORA_DISK_1: reading from backup piece +DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/BACKUPSET/2024_06_14/nnndf0_tag20240614t145032_0.334.1171594323
channel ORA_DISK_1: ORA-19870: error while restoring backup piece +DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/BACKUPSET/2024_06_14/nnndf0_tag20240614t145032_0.334.1171594323
ORA-19505: failed to identify file "+DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/BACKUPSET/2024_06_14/nnndf0_tag20240614t145032_0.334.1171594323"
failover to previous backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/14/2024 15:14:12
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 52 found to restore
RMAN-06023: no backup or copy of datafile 51 found to restore
RMAN-06023: no backup or copy of datafile 50 found to restore
RMAN> RUN {
set until time "to_date('14-JUN-2024 14:54:00','DD-MON-YYYY HH24:MI:SS')";
set newname for database to '+data1';
restore database ;
}2> 3> 4> 5>
executing command: SET until clause
executing command: SET NEWNAME
Starting restore at 14-JUN-24
using channel ORA_DISK_1
channel ORA_DISK_1: restoring datafile 00001
input datafile copy RECID=136 STAMP=1171638842 file name=+DATA1/CDB/DATAFILE/system.312.1171595585
destination for restore of datafile 00001: +data1
channel ORA_DISK_1: copied datafile copy of datafile 00001, elapsed time: 00:00:03
output file name=+DATA1/CDB/DATAFILE/system.261.1171595675 RECID=137 STAMP=1171638877
channel ORA_DISK_1: restoring datafile 00003
input datafile copy RECID=135 STAMP=1171638830 file name=+DATA1/CDB/DATAFILE/sysaux.325.1171595585
destination for restore of datafile 00003: +data1
channel ORA_DISK_1: copied datafile copy of datafile 00003, elapsed time: 00:00:03
output file name=+DATA1/CDB/DATAFILE/sysaux.273.1171595677 RECID=138 STAMP=1171638880
channel ORA_DISK_1: restoring datafile 00004
input datafile copy RECID=132 STAMP=1171638786 file name=+DATA1/CDB/DATAFILE/undotbs1.334.1171595585
destination for restore of datafile 00004: +data1
channel ORA_DISK_1: copied datafile copy of datafile 00004, elapsed time: 00:00:03
output file name=+DATA1/CDB/DATAFILE/undotbs1.264.1171595681 RECID=139 STAMP=1171638883
channel ORA_DISK_1: restoring datafile 00007
input datafile copy RECID=131 STAMP=1171638785 file name=+DATA1/CDB/DATAFILE/users.268.1171595585
destination for restore of datafile 00007: +data1
channel ORA_DISK_1: copied datafile copy of datafile 00007, elapsed time: 00:00:02
output file name=+DATA1/CDB/DATAFILE/users.300.1171595685 RECID=140 STAMP=1171638884
channel ORA_DISK_1: restoring datafile 00009
input datafile copy RECID=134 STAMP=1171638788 file name=+DATA1/CDB/DATAFILE/undotbs2.265.1171595585
destination for restore of datafile 00009: +data1
channel ORA_DISK_1: copied datafile copy of datafile 00009, elapsed time: 00:00:01
output file name=+DATA1/CDB/DATAFILE/undotbs2.336.1171595685 RECID=141 STAMP=1171638885
channel ORA_DISK_1: restoring datafile 00010
input datafile copy RECID=133 STAMP=1171638787 file name=+DATA1/CDB/DATAFILE/undotbs3.299.1171595585
destination for restore of datafile 00010: +data1
channel ORA_DISK_1: copied datafile copy of datafile 00010, elapsed time: 00:00:01
output file name=+DATA1/CDB/DATAFILE/undotbs3.337.1171595687 RECID=142 STAMP=1171638886
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00005 to +data1
channel ORA_DISK_1: restoring datafile 00006 to +data1
channel ORA_DISK_1: restoring datafile 00008 to +data1
channel ORA_DISK_1: reading from backup piece +DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_14/nnndf0_tag20240614t145032_0.302.1171594289
channel ORA_DISK_1: ORA-19870: error while restoring backup piece +DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_14/nnndf0_tag20240614t145032_0.302.1171594289
ORA-19505: failed to identify file "+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_14/nnndf0_tag20240614t145032_0.302.1171594289"
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00050 to +data1
channel ORA_DISK_1: restoring datafile 00051 to +data1
channel ORA_DISK_1: restoring datafile 00052 to +data1
channel ORA_DISK_1: reading from backup piece +DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/BACKUPSET/2024_06_14/nnndf0_tag20240614t145032_0.334.1171594323
channel ORA_DISK_1: ORA-19870: error while restoring backup piece +DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/BACKUPSET/2024_06_14/nnndf0_tag20240614t145032_0.334.1171594323
ORA-19505: failed to identify file "+DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/BACKUPSET/2024_06_14/nnndf0_tag20240614t145032_0.334.1171594323"
failover to previous backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/14/2024 15:14:49
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 52 found to restore
RMAN-06023: no backup or copy of datafile 51 found to restore
RMAN-06023: no backup or copy of datafile 50 found to restore
RMAN> exit
Recovery Manager complete.
[oracle@rac1 ~]$ ls
bin bin.tar expimp
[oracle@rac1 ~]$ s
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jun 14 15:15:07 2024
Version 19.20.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0
SQL> startup force;
ORACLE instance started.
Total System Global Area 2382361320 bytes
Fixed Size 9167592 bytes
Variable Size 1275068416 bytes
Database Buffers 1090519040 bytes
Redo Buffers 7606272 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 50 - see DBWR trace file
ORA-01110: data file 50:
'+DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/system.268.1171594051'
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 50:
'+DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/system.268.1171594051'
ORA-01157: cannot identify/lock data file 50 - see DBWR trace file
ORA-01110: data file 50:
'+DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/system.268.1171594051'
SQL> alter database datafile 50 offline drop;
alter database datafile 50 offline drop
*
ERROR at line 1:
ORA-01516: nonexistent log file, data file, or temporary file "50" in the
current container
SQL> alter database datafile '+DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/system.268.1171594051'
2 offline drop;
alter database datafile '+DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/system.268.1171594051'
*
ERROR at line 1:
ORA-01516: nonexistent log file, data file, or temporary file
"+DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/system.268.1171594051" in
the current container
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0
[oracle@rac1 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Fri Jun 14 15:17:49 2024
Version 19.20.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB (DBID=2265125454, not open)
RMAN> alter database open resetlogs;
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/14/2024 15:17:59
ORA-01157: cannot identify/lock data file 50 - see DBWR trace file
ORA-01110: data file 50: '+DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/system.268.1171594051'
RMAN> alter database datafile 50 offline drop;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/14/2024 15:18:11
ORA-01516: nonexistent log file, data file, or temporary file "50" in the current container
RMAN> report schema;
Report of database schema for database with db_unique_name CDB
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 1300 SYSTEM *** +DATA/CDB/DATAFILE/system.275.1148478571
3 1090 SYSAUX *** +DATA/CDB/DATAFILE/sysaux.263.1148478647
4 1085 UNDOTBS1 *** +DATA/CDB/DATAFILE/undotbs1.264.1148478683
5 510 PDB$SEED:SYSTEM *** +DATA/CDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.272.1148480251
6 480 PDB$SEED:SYSAUX *** +DATA/CDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/sysaux.271.1148480251
7 5 USERS *** +DATA/CDB/DATAFILE/users.269.1148478683
8 215 PDB$SEED:UNDOTBS1 *** +DATA/CDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/undotbs1.267.1148480251
9 250 UNDOTBS2 *** +DATA/CDB/DATAFILE/undotbs2.268.1148480549
10 25 UNDOTBS3 *** +DATA/CDB/DATAFILE/undotbs3.262.1148480551
50 0 PDB2:SYSTEM *** +DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/system.268.1171594051
51 0 PDB2:SYSAUX *** +DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/sysaux.299.1171594051
52 0 PDB2:UNDOTBS1 *** +DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/DATAFILE/undotbs1.265.1171594051
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 272 TEMP 32767 +DATA/CDB/TEMPFILE/temp.273.1148478745
2 36 PDB$SEED:TEMP 32767 +DATA/CDB/0633F844101D69CBE0636401A8C09D55/TEMPFILE/temp.265.1166407887
3 36 PDB2:TEMP 32767 +DATA1/CDB/1AD4FD5625E420FFE0636401A8C0AF99/TEMPFILE/temp.290.1171594055
RMAN> alter session set container=pdb2;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/14/2024 15:18:39
RMAN-06815: cannot change the container in RMAN session.
----------------------要从SQL 删除
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0
SQL> alter session set container=pdb2;
Session altered.
SQL> alter database datafile 50 offline drop;
Database altered.
SQL> alter database datafile 51
SQL> alter database datafile 50 2
3
SQL>
SQL> alter database datafile 51 offline drop;
Database altered.
SQL> alter database datafile 52 offline drop;
Database altered.
SQL>
RMAN> alter database open resetlogs;
Statement processed
RMAN>
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB2 MOUNTED
SQL> alter pluggable database pdb2 open;
alter pluggable database pdb2 open
*
ERROR at line 1:
ORA-01147: SYSTEM tablespace file 50 is offline
SQL> drop pluggable database pdb2 including datafiles;
Pluggable database dropped.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
SQL>