rman 备份失败 也会删除该删除的 所以失败的备份也有有用的内容
RMAN> list backup of database summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
40 B F A DISK 14-JUN-24 1 1 YES TAG20240614T145032
41 B F A DISK 14-JUN-24 1 1 YES TAG20240614T145032
81 B F A DISK 08-JUL-24 1 1 NO TAG20240708T160158
82 B F A DISK 08-JUL-24 1 1 NO TAG20240708T160158
83 B F A DISK 08-JUL-24 1 1 NO TAG20240708T160158
RMAN> list backup of archivelog all summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
59 B A A DISK 08-JUL-24 1 1 NO TAG20240708T154939
60 B A A DISK 08-JUL-24 1 1 NO TAG20240708T154939
80 B A A DISK 08-JUL-24 1 1 NO TAG20240708T160156
84 B A A DISK 08-JUL-24 1 1 NO TAG20240708T160214
RMAN> backup database root pluggable database PDB1,"PDB$SEED" plus archivelog delete input;
Starting backup at 08-JUL-24
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=53 RECID=774 STAMP=1173801767
input archived log thread=2 sequence=27 RECID=772 STAMP=1173758564
input archived log thread=3 sequence=30 RECID=773 STAMP=1173758564
channel ORA_DISK_1: starting piece 1 at 08-JUL-24
channel ORA_DISK_1: finished piece 1 at 08-JUL-24
piece handle=+DATA1/CDB/BACKUPSET/2024_07_08/annnf0_tag20240708t160247_0.393.1173758567 tag=TAG20240708T160247 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: deleting archived log(s)
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_07_08/thread_1_seq_53.389.1173758567 RECID=774 STAMP=1173801767
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_07_08/thread_2_seq_27.381.1173758565 RECID=772 STAMP=1173758564
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_07_08/thread_3_seq_30.385.1173758565 RECID=773 STAMP=1173758564
Finished backup at 08-JUL-24
Starting backup at 08-JUL-24
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA1/CDB/DATAFILE/system.333.1171597969
input datafile file number=00003 name=+DATA1/CDB/DATAFILE/sysaux.290.1171597969
input datafile file number=00004 name=+DATA1/CDB/DATAFILE/undotbs1.271.1171597969
input datafile file number=00009 name=+DATA1/CDB/DATAFILE/undotbs2.302.1171597969
input datafile file number=00010 name=+DATA1/CDB/DATAFILE/undotbs3.285.1171597969
input datafile file number=00007 name=+DATA1/CDB/DATAFILE/users.266.1171597969
channel ORA_DISK_1: starting piece 1 at 08-JUL-24
channel ORA_DISK_1: finished piece 1 at 08-JUL-24
piece handle=+DATA1/CDB/BACKUPSET/2024_07_08/nnndf0_tag20240708t160249_0.385.1173758569 tag=TAG20240708T160249 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00059 name=+DATA1/CDB/1AD5D2B5563030A9E0636401A8C014DD/DATAFILE/system.340.1171598105
input datafile file number=00060 name=+DATA1/CDB/1AD5D2B5563030A9E0636401A8C014DD/DATAFILE/sysaux.341.1171598105
input datafile file number=00061 name=+DATA1/CDB/1AD5D2B5563030A9E0636401A8C014DD/DATAFILE/undotbs1.342.1171598105
input datafile file number=00062 name=+DATA1/CDB/1AD5D2B5563030A9E0636401A8C014DD/DATAFILE/undo_2.262.1173336177
input datafile file number=00063 name=+DATA1/CDB/1AD5D2B5563030A9E0636401A8C014DD/DATAFILE/undo_3.259.1173336501
channel ORA_DISK_1: starting piece 1 at 08-JUL-24
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/08/2024 16:02:59
ORA-19510: failed to set size of 81920 blocks for file "+DATA1/CDB/1AD5D2B5563030A9E0636401A8C014DD/BACKUPSET/2024_07_08/nnndf0_tag20240708t160249_0.381.1173758577" (block size=8192)
ORA-17505: ksfdrsz:1 Failed to resize file to size 81920 blocks
ORA-15041: diskgroup "DATA1" space exhausted
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00005 name=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.329.1171598035
input datafile file number=00006 name=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.330.1171598035
input datafile file number=00008 name=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.293.1171598035
channel ORA_DISK_1: starting piece 1 at 08-JUL-24
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 07/08/2024 16:03:02
ORA-19510: failed to set size of 81920 blocks for file "+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_07_08/nnndf0_tag20240708t160249_0.381.1173758579" (block size=8192)
ORA-17505: ksfdrsz:1 Failed to resize file to size 81920 blocks
ORA-15041: diskgroup "DATA1" space exhausted
RMAN> list backup of archivelog all summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
59 B A A DISK 08-JUL-24 1 1 NO TAG20240708T154939
60 B A A DISK 08-JUL-24 1 1 NO TAG20240708T154939
80 B A A DISK 08-JUL-24 1 1 NO TAG20240708T160156
84 B A A DISK 08-JUL-24 1 1 NO TAG20240708T160214
86 B A A DISK 08-JUL-24 1 1 NO TAG20240708T160247
RMAN> list backup of database summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
40 B F A DISK 14-JUN-24 1 1 YES TAG20240614T145032
41 B F A DISK 14-JUN-24 1 1 YES TAG20240614T145032
81 B F A DISK 08-JUL-24 1 1 NO TAG20240708T160158
82 B F A DISK 08-JUL-24 1 1 NO TAG20240708T160158
83 B F A DISK 08-JUL-24 1 1 NO TAG20240708T160158
87 B F A DISK 08-JUL-24 1 1 NO TAG20240708T160249
RMAN> backup database root pluggable database PDB1,"PDB$SEED" plus archivelog delete input;
Starting backup at 08-JUL-24
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=2 sequence=28 RECID=778 STAMP=1173758699
input archived log thread=3 sequence=31 RECID=777 STAMP=1173758697
input archived log thread=1 sequence=54 RECID=775 STAMP=1173758695
input archived log thread=1 sequence=55 RECID=776 STAMP=1173758696
input archived log thread=1 sequence=56 RECID=781 STAMP=1173758724
input archived log thread=3 sequence=32 RECID=780 STAMP=1173758724
input archived log thread=2 sequence=29 RECID=779 STAMP=1173758723
channel ORA_DISK_1: starting piece 1 at 08-JUL-24
channel ORA_DISK_1: finished piece 1 at 08-JUL-24
piece handle=+DATA1/CDB/BACKUPSET/2024_07_08/annnf0_tag20240708t160524_0.359.1173758725 tag=TAG20240708T160524 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: deleting archived log(s)
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_07_08/thread_2_seq_28.343.1173758699 RECID=778 STAMP=1173758699
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_07_08/thread_3_seq_31.390.1173758697 RECID=777 STAMP=1173758697
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_07_08/thread_1_seq_54.381.1173758695 RECID=775 STAMP=1173758695
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_07_08/thread_1_seq_55.389.1173758697 RECID=776 STAMP=1173758696
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_07_08/thread_1_seq_56.308.1173758725 RECID=781 STAMP=1173758724
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_07_08/thread_3_seq_32.319.1173758725 RECID=780 STAMP=1173758724
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_07_08/thread_2_seq_29.274.1173758723 RECID=779 STAMP=1173758723
Finished backup at 08-JUL-24
Starting backup at 08-JUL-24
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA1/CDB/DATAFILE/system.333.1171597969
input datafile file number=00003 name=+DATA1/CDB/DATAFILE/sysaux.290.1171597969
input datafile file number=00004 name=+DATA1/CDB/DATAFILE/undotbs1.271.1171597969
input datafile file number=00009 name=+DATA1/CDB/DATAFILE/undotbs2.302.1171597969
input datafile file number=00010 name=+DATA1/CDB/DATAFILE/undotbs3.285.1171597969
input datafile file number=00007 name=+DATA1/CDB/DATAFILE/users.266.1171597969
channel ORA_DISK_1: starting piece 1 at 08-JUL-24
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/08/2024 16:05:29
ORA-19510: failed to set size of 81920 blocks for file "+DATA1/CDB/BACKUPSET/2024_07_08/nnndf0_tag20240708t160525_0.274.1173758727" (block size=8192)
ORA-17505: ksfdrsz:1 Failed to resize file to size 81920 blocks
ORA-15041: diskgroup "DATA1" space exhausted
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00059 name=+DATA1/CDB/1AD5D2B5563030A9E0636401A8C014DD/DATAFILE/system.340.1171598105
input datafile file number=00060 name=+DATA1/CDB/1AD5D2B5563030A9E0636401A8C014DD/DATAFILE/sysaux.341.1171598105
input datafile file number=00061 name=+DATA1/CDB/1AD5D2B5563030A9E0636401A8C014DD/DATAFILE/undotbs1.342.1171598105
input datafile file number=00062 name=+DATA1/CDB/1AD5D2B5563030A9E0636401A8C014DD/DATAFILE/undo_2.262.1173336177
input datafile file number=00063 name=+DATA1/CDB/1AD5D2B5563030A9E0636401A8C014DD/DATAFILE/undo_3.259.1173336501
channel ORA_DISK_1: starting piece 1 at 08-JUL-24
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/08/2024 16:05:32
ORA-19510: failed to set size of 81920 blocks for file "+DATA1/CDB/1AD5D2B5563030A9E0636401A8C014DD/BACKUPSET/2024_07_08/nnndf0_tag20240708t160525_0.274.1173758729" (block size=8192)
ORA-17505: ksfdrsz:1 Failed to resize file to size 81920 blocks
ORA-15041: diskgroup "DATA1" space exhausted
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00005 name=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.329.1171598035
input datafile file number=00006 name=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.330.1171598035
input datafile file number=00008 name=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.293.1171598035
channel ORA_DISK_1: starting piece 1 at 08-JUL-24
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 07/08/2024 16:05:35
ORA-19510: failed to set size of 81920 blocks for file "+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_07_08/nnndf0_tag20240708t160525_0.274.1173758733" (block size=8192)
ORA-17505: ksfdrsz:1 Failed to resize file to size 81920 blocks
ORA-15041: diskgroup "DATA1" space exhausted
RMAN> list backup of database summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
40 B F A DISK 14-JUN-24 1 1 YES TAG20240614T145032
41 B F A DISK 14-JUN-24 1 1 YES TAG20240614T145032
81 B F A DISK 08-JUL-24 1 1 NO TAG20240708T160158
82 B F A DISK 08-JUL-24 1 1 NO TAG20240708T160158
83 B F A DISK 08-JUL-24 1 1 NO TAG20240708T160158
87 B F A DISK 08-JUL-24 1 1 NO TAG20240708T160249
RMAN> list backup of archivelog all summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
59 B A A DISK 08-JUL-24 1 1 NO TAG20240708T154939
60 B A A DISK 08-JUL-24 1 1 NO TAG20240708T154939
80 B A A DISK 08-JUL-24 1 1 NO TAG20240708T160156
84 B A A DISK 08-JUL-24 1 1 NO TAG20240708T160214
86 B A A DISK 08-JUL-24 1 1 NO TAG20240708T160247
88 B A A DISK 08-JUL-24 1 1 NO TAG20240708T160524
RMAN>
2024_07_08/
ASMCMD> cd *
ASMCMD> ls
thread_1_seq_54.381.1173758695
thread_1_seq_55.389.1173758697
thread_2_seq_28.343.1173758699
thread_3_seq_31.390.1173758697
backup database root pluggable database PDB1,"PDB$SEED" plus archivelog delete inpu;
c
ASMCMD> ls
ASMCMD-8002: entry 'ARCHIVELOG' does not exist in directory '+DATA1/CDB/'
ASMCMD> ls
ASMCMD-8002: entry 'ARCHIVELOG' does not exist in directory '+DATA1/CDB/'
ASMCMD> ls
ASMCMD-8002: entry 'ARCHIVELOG' does not exist in directory '+DATA1/CDB/'
ASMCMD> ls
thread_1_seq_57.274.1173758743
ASMCMD>
原文地址：https://blog.csdn.net/jnrjian/article/details/140271626
免责声明：本站文章内容转载自网络资源，如本站内容侵犯了原著者的合法权益，可联系本站删除。更多内容请关注自学内容网（zxcms.com）！