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

已于 2024-06-16 03:17:23 修改
阅读量845 收藏 12
点赞数 21
文章标签： 数据库
于 2024-06-14 15:47:54 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/jnrjian/article/details/139683081
版权

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>
 

jnrjian
关注
（第67天）RMAN Duplicate 克隆 PDB
LuciferLiu_DBA
12-12 212
在之前 NONCDB 版本我们经常使用 RMAN Duplicate 方式来在线搭建 DataGuard，非常方便快捷。从 12C 开始 Oracle 推出了 CDB 架构后，自然也就支持使用 Duplicate 的方式来复制 CDB，但是 12C 时还没有那么智能。从 18C 开始进行了升级，可以支持使用方式在线克隆 pdb 到现有的远端 CDB 中。语法如下（建议使用OMF## 复制后的 PDB 不改名......;## 复制后的 PDB 需要重命名......;如果不使用OMF...;
RMAN恢复数据库报ORA-19573错误
田攀的日志
07-15 2779
恢复数据库报ORA-19573错误，错误信息如下：RMAN> RESTORE DATABASE;Starting restore at 15-JUL-15using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=9 device
rman datafile恢复(归档模式)
weixin_30819163的博客
06-14 137
模拟环境 1. 做操作之前先备份数据库 RMAN> run { # Hot database level 0 whole backup allocate channel t1 type disk; backup incremental level 0 skip inaccessible format '/oracle/ba...
ORA-19600&ORA-19601
12-06 879
RMAN> run 2> { 3> ALLOCATE CHANNEL CH00 TYPE 'SBT_TAPE'; 4> SEND 'NB_ORA_CLIENT=essdb2,NB_ORA_S...
Oracle RMAN还原测试错误ORA-19571 ORA-19600 ORA-19601
congsong2560的博客
07-10 756
在进行数据库备份有效性验证时，测试到一半时，出现了让我觉得有点莫名的错误 RMAN-00571: ==========================================================...
RMAN-06214: Datafile Copy
about database article
05-28 5884
在使用rman备份的时候最后出现一个这样的错误： RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status RMAN-06210: Lis
oracle rman pdb异机恢复,使用RMAN来PDB执行完全恢复
weixin_30131105的博客
04-16 835
可以对一个或多个PDB执行完全恢复而不影响其它为open状态的PDB的操作。RMAN有两种方法来恢复PDB:.连接到CDB的root容器，然后使用restore pluggable database与recover pluggable database命令。这种方法能让你使用单个命令来恢复多个PDB。.连接到PDB并使用restore database与recover database语句，这种方...
oracle12c rman 恢复 单个pdb
qifengma的博客
02-07 2286
run { backup tag 'pdb02' format '/home/oracle/20180904/bk_%s_%p_%t_pdb02db.bak' database pdb02; sql 'alter system archive log current'; backup tag 'SEEDPDB' format '/home/oracle/20180904/bk_%s_%p_...
rman备份异机恢复部分pdb
vi_vi 的博客
02-10 1182
rman备份异机恢复部分pdb 参考资料： How to use Rman to Restore Of Single PDB in Multitenant to Alternate Server (文档 ID 2142675.1) Two PDB available are PDB1 and PDB2 In this case we are assuming a full backup of the database including the PDB1/PDB2 has been taken on .
oracle rman 异机恢复单个PDB
03-29
其中，/path/to/datafile是恢复的PDB文件的路径。 9. 如果需要，重建PDB的密码： ``` SQL> ALTER PLUGGABLE DATABASE pdb_name IDENTIFIED BY password; ``` 其中，password是您想要设置的新密码。 10. ...
Error:   ORA-1505…
babymouse1212的博客
05-02 648
ORA-15055  unable to connect to ASM i" />     ORA-15055  unable to connect to ASM i" /> While cloning the following error is reported, this error happened when i perform the step 5.1
使用RMAN工具-RMAN详解
大叶梧桐的博客
05-23 6837
rman工具详解
RMAN备份数据库_使用RMAN备份数据库文件
jetliu05的博客
06-15 4573
RMAN备份数据库文件
RMAN中各种文件的恢复方法
02-23 319
支持数据库版本：10gR2，11gR2 1. 完全介质恢复 # 数据库需要在 mount 状态 1-1. 挂载数据库 RMAN> startup mount; 1-2. 执行恢复 RMAN> ...
oceanbase V4.2.2社区版集群离线部署
最新发布
king_harry的专栏
11-01 669
版本，选择是上传文件，包含oceanbase-ce、oceanbase-ce-libs、oceanbase-ce-utils。关闭时展示，为 OBProxy 集群的访问地址，仅用于生成租户的连接串，不影响实际使用，需要自主配置负载均衡，如果是 VIP 地址，还需要您自主申请并绑定到 OBProxy Server。集群配置选项卡—更多配置—更改系统内存保留选项，默认是30G，如果测试机内存只有16G，则需要调小，本测试调整为2G，这样ocp-server安装不会失败。自定义待管理的集群的名称。
基于vue框架的的汇生活家居商城的设计与实现bdjlq（程序+源码+数据库+调试部署+开发环境）系统界面在最后面。
h2345678的博客
10-29 1362
项目功能：商品分类,商品信息,用户。
JAVA 插入 JSON 对象到 PostgreSQL
qq_52143611的博客
10-30 837
在现代软件开发中，由于 JSON 数据的轻量和通用性，处理 JSON 数据已经变得无处不在。PostgreSQL凭借其对 JSON 的强大支持，为存储和查询 JSON 数据提供了出色的平台。为了将JSON数据保存到PostgreSQL数据库中，我们可以将JSON数据转换为PostgreSQL的JSONB类型数据，然后将其存储在数据库中。在Java中，我们可以使用JDBC或者基于ORM框架的方式来实现这一功能。
第2章 Android App开发基础
L念安dd的博客
10-29 1081
本章介绍基于Android系统的App开发常识，包括以下几个方面：App开发与其他软件开发有什么不一 样，App工程是怎样的组织结构又是怎样配置的，App开发的前后端分离设计是如何运作实现的，App的活动页面是如何创建又是如何跳转的。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值