rman 后 PDB datafile 丢失要在PDB级删除

  • 开发
  • 7

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>
 

阅读全部

相关推荐

  1. rman 后 PDB datafile 丢失要在PDB级删除

    2024-06-15 09:20:01       8 阅读

  5. 在容器镜像中为了安全为什么要删除 setuid 和 setgid?

    2024-06-15 09:20:01       24 阅读

  6. oracle 临时表 在sql 里面用完要删除吗

    2024-06-15 09:20:01       8 阅读

  8. 想要在浏览器中访问pdf内容，服务器器该如何配置

    2024-06-15 09:20:01       17 阅读

最近更新

  4. TCP协议是安全的吗?

    2024-06-15 09:20:01       10 阅读

  12. 阿里云服务器执行yum，一直下载docker-ce-stable失败

    2024-06-15 09:20:01       12 阅读

  13. 【Python教程】压缩PDF文件大小

    2024-06-15 09:20:01       11 阅读

  18. 通过文章id递归查询所有评论（xml）

    2024-06-15 09:20:01       14 阅读

热门阅读

  3. 【技巧】Leetcode 191. 位1的个数【简单】

    2024-06-15 09:20:01       7 阅读

  5. 工业设计初学者手册——第四部分：制造工艺

    2024-06-15 09:20:01       7 阅读

  7. 浅析双面PCB电路板制造过程

    2024-06-15 09:20:01       5 阅读

  9. git commit 报错：Git: xargs: flake8: No such file or directory

    2024-06-15 09:20:01       5 阅读

  12. Web后端开发（分层解耦）

    2024-06-15 09:20:01       4 阅读

  15. 2023-2024山东大学软件学院web数据管理期末

    2024-06-15 09:20:01       7 阅读

  23. 7号楼地面东照西和南照北

    2024-06-15 09:20:01       7 阅读

  25. 嵌入式linux中GPIO和Pinctrl子系统分享

    2024-06-15 09:20:01       6 阅读

  26. 双指针练习：三数之和

    2024-06-15 09:20:01       8 阅读