磁带 SBT TAPE 备份支持Compressed

jnrjian

于 2024-06-16 18:55:49 发布

阅读量759

点赞数 17

文章标签：数据库 java 服务器

本文链接：https://blog.csdn.net/jnrjian/article/details/139723782

版权

1.backup recovery area 117 118 119 为什么多备份了一遍呢？ 1.4GB 变成了2.8GB

2. 直接备份到磁带支持Compressed

RMAN> list backup summary;

List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
111 B A A * 16-JUN-24 1 2 YES FULLDBBACKUP
112 B F A * 16-JUN-24 1 2 YES FULLDBBACKUP
113 B F A * 16-JUN-24 1 2 YES FULLDBBACKUP
114 B F A * 16-JUN-24 1 2 YES FULLDBBACKUP
115 B A A * 16-JUN-24 1 2 YES FULLDBBACKUP
116 B F A * 16-JUN-24 1 2 NO TAG20240616T055757
117 B F A SBT_TAPE 16-JUN-24 1 1 NO TAG20240616T055925
118 B A A SBT_TAPE 16-JUN-24 1 1 NO TAG20240616T055925
119 B F A SBT_TAPE 16-JUN-24 1 1 NO TAG20240616T055935

RMAN>

RMAN> backup as compressed backupset database tag 'fulldbbackup' plus archivelog tag 'fulldbbackup';

Starting backup at 16-JUN-24
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=54 instance=cdb3 device type=DISK
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=3 sequence=5 RECID=295 STAMP=1171776601
input archived log thread=3 sequence=6 RECID=296 STAMP=1171776698
input archived log thread=3 sequence=7 RECID=297 STAMP=1171776922
input archived log thread=3 sequence=8 RECID=298 STAMP=1171777008
input archived log thread=3 sequence=9 RECID=299 STAMP=1171777322
input archived log thread=3 sequence=10 RECID=300 STAMP=1171777459
input archived log thread=3 sequence=11 RECID=301 STAMP=1171777566
input archived log thread=3 sequence=12 RECID=302 STAMP=1171778189
channel ORA_DISK_1: starting piece 1 at 16-JUN-24
channel ORA_DISK_1: finished piece 1 at 16-JUN-24
piece handle=+DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.346.1171778191 tag=FULLDBBACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 16-JUN-24

Starting backup at 16-JUN-24
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/CDB/DATAFILE/system.258.1171775203
input datafile file number=00003 name=+DATA/CDB/DATAFILE/sysaux.287.1171775203
input datafile file number=00004 name=+DATA/CDB/DATAFILE/undotbs1.294.1171775205
input datafile file number=00009 name=+DATA/CDB/DATAFILE/undotbs2.276.1171775205
input datafile file number=00010 name=+DATA/CDB/DATAFILE/undotbs3.259.1171775205
input datafile file number=00007 name=+DATA/CDB/DATAFILE/users.298.1171775205
channel ORA_DISK_1: starting piece 1 at 16-JUN-24
channel ORA_DISK_1: finished piece 1 at 16-JUN-24
piece handle=+DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.353.1171778191 tag=FULLDBBACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00011 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.260.1171775211
input datafile file number=00012 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.261.1171775211
input datafile file number=00013 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.270.1171775211
input datafile file number=00014 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.274.1171775211
input datafile file number=00015 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.266.1171775211
input datafile file number=00016 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.301.1171775211
channel ORA_DISK_1: starting piece 1 at 16-JUN-24
channel ORA_DISK_1: finished piece 1 at 16-JUN-24
piece handle=+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.354.1171778227 tag=FULLDBBACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00005 name=+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.302.1171775215
input datafile file number=00006 name=+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.273.1171775215
input datafile file number=00008 name=+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.290.1171775215
channel ORA_DISK_1: starting piece 1 at 16-JUN-24
channel ORA_DISK_1: finished piece 1 at 16-JUN-24
piece handle=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.355.1171778251 tag=FULLDBBACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 16-JUN-24

Starting backup at 16-JUN-24
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=3 sequence=13 RECID=303 STAMP=1171778276
channel ORA_DISK_1: starting piece 1 at 16-JUN-24
channel ORA_DISK_1: finished piece 1 at 16-JUN-24
piece handle=+DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.352.1171778277 tag=FULLDBBACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 16-JUN-24

Starting Control File and SPFILE Autobackup at 16-JUN-24
piece handle=+DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171778277.362.1171778277 comment=NONE
Finished Control File and SPFILE Autobackup at 16-JUN-24

RMAN> list backup;

List of Backup Sets
===================

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
111 18.33M DISK 00:00:00 16-JUN-24
BP Key: 146 Status: AVAILABLE Compressed: YES Tag: FULLDBBACKUP
Piece Name: +DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.346.1171778191

List of Archived Logs in backup set 111
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
3 5 7375705 16-JUN-24 7388467 16-JUN-24
3 6 7388467 16-JUN-24 7388688 16-JUN-24
3 7 7388688 16-JUN-24 7390228 16-JUN-24
3 8 7390228 16-JUN-24 7390298 16-JUN-24
3 9 7390298 16-JUN-24 7490527 16-JUN-24
3 10 7490527 16-JUN-24 7492288 16-JUN-24
3 11 7492288 16-JUN-24 7492380 16-JUN-24
3 12 7492380 16-JUN-24 7493031 16-JUN-24

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
112 Full 585.52M DISK 00:00:30 16-JUN-24
BP Key: 147 Status: AVAILABLE Compressed: YES Tag: FULLDBBACKUP
Piece Name: +DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.353.1171778191
List of Datafiles in backup set 112
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
1 Full 7493049 16-JUN-24 NO +DATA/CDB/DATAFILE/system.258.1171775203
3 Full 7493049 16-JUN-24 NO +DATA/CDB/DATAFILE/sysaux.287.1171775203
4 Full 7493049 16-JUN-24 NO +DATA/CDB/DATAFILE/undotbs1.294.1171775205
7 Full 7493049 16-JUN-24 NO +DATA/CDB/DATAFILE/users.298.1171775205
9 Full 7493049 16-JUN-24 NO +DATA/CDB/DATAFILE/undotbs2.276.1171775205
10 Full 7493049 16-JUN-24 NO +DATA/CDB/DATAFILE/undotbs3.259.1171775205

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
113 Full 351.52M DISK 00:00:18 16-JUN-24
BP Key: 148 Status: AVAILABLE Compressed: YES Tag: FULLDBBACKUP
Piece Name: +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.354.1171778227
List of Datafiles in backup set 113
Container ID: 3, PDB Name: PDB
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
11 Full 7493743 16-JUN-24 NO +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.260.1171775211
12 Full 7493743 16-JUN-24 NO +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.261.1171775211
13 Full 7493743 16-JUN-24 NO +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.270.1171775211
14 Full 7493743 16-JUN-24 NO +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.274.1171775211
15 Full 7493743 16-JUN-24 NO +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.266.1171775211
16 Full 7493743 16-JUN-24 NO +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.301.1171775211

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
114 Full 402.36M DISK 00:00:21 16-JUN-24
BP Key: 149 Status: AVAILABLE Compressed: YES Tag: FULLDBBACKUP
Piece Name: +DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.355.1171778251
List of Datafiles in backup set 114
Container ID: 2, PDB Name: PDB$SEED
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
5 Full 5317292 27-SEP-23 NO +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.302.1171775215
6 Full 5317292 27-SEP-23 NO +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.273.1171775215
8 Full 5317292 27-SEP-23 NO +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.290.1171775215

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
115 344.00K DISK 00:00:00 16-JUN-24
BP Key: 150 Status: AVAILABLE Compressed: YES Tag: FULLDBBACKUP
Piece Name: +DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.352.1171778277

List of Archived Logs in backup set 115
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
3 13 7493031 16-JUN-24 7493768 16-JUN-24

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
116 Full 19.17M DISK 00:00:00 16-JUN-24
BP Key: 151 Status: AVAILABLE Compressed: NO Tag: TAG20240616T055757
Piece Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171778277.362.1171778277
SPFILE Included: Modification time: 16-JUN-24
SPFILE db_unique_name: CDB
Control File Included: Ckp SCN: 7493784 Ckp time: 16-JUN-24

RMAN>

-------磁带备份

RMAN> run {
2> allocate channel ch00 device type 'SBT_TAPE'
3> PARMS="SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)";
5> backup recovery area ; }

released channel: ORA_DISK_1
allocated channel: ch00
channel ch00: SID=54 instance=cdb3 device type=SBT_TAPE
channel ch00: WARNING: Oracle Test Disk API

Starting backup at 16-JUN-24
channel ch00: starting full datafile backup set
channel ch00: including datafile copy of datafile 00001 in backup set
input file name=+DATA1/CDB/DATAFILE/system.312.1171725751
channel ch00: including datafile copy of datafile 00004 in backup set
input file name=+DATA1/CDB/DATAFILE/undotbs1.276.1171725751
channel ch00: including datafile copy of datafile 00009 in backup set
input file name=+DATA1/CDB/DATAFILE/undotbs2.300.1171725751
channel ch00: including datafile copy of datafile 00010 in backup set
input file name=+DATA1/CDB/DATAFILE/undotbs3.299.1171725751
channel ch00: including datafile copy of datafile 00007 in backup set
input file name=+DATA1/CDB/DATAFILE/users.293.1171725751
channel ch00: starting piece 1 at 16-JUN-24
channel ch00: finished piece 1 at 16-JUN-24
piece handle=4j2tfqpt_147_1_1 tag=TAG20240616T055925 comment=API Version 2.0,MMS Version 8.1.3.0
channel ch00: backup set complete, elapsed time: 00:00:03
channel ch00: starting archived log backup set
channel ch00: specifying archived log(s) in backup set
input archived log thread=3 sequence=5 RECID=295 STAMP=1171776601
input archived log thread=3 sequence=6 RECID=296 STAMP=1171776698
input archived log thread=3 sequence=7 RECID=297 STAMP=1171776922
input archived log thread=3 sequence=8 RECID=298 STAMP=1171777008
input archived log thread=3 sequence=9 RECID=299 STAMP=1171777322
input archived log thread=3 sequence=10 RECID=300 STAMP=1171777459
input archived log thread=3 sequence=11 RECID=301 STAMP=1171777566
input archived log thread=3 sequence=12 RECID=302 STAMP=1171778189
input archived log thread=3 sequence=13 RECID=303 STAMP=1171778276
channel ch00: starting piece 1 at 16-JUN-24
channel ch00: finished piece 1 at 16-JUN-24
piece handle=4k2tfqq0_148_1_1 tag=TAG20240616T055925 comment=API Version 2.0,MMS Version 8.1.3.0
channel ch00: backup set complete, elapsed time: 00:00:01
channel ch00: input backup set: count=141, stamp=1171778190, piece=1
channel ch00: starting piece 1 at 16-JUN-24
channel ch00: backup piece +DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.346.1171778191
piece handle=4d2tfqke_141_1_2 comment=API Version 2.0,MMS Version 8.1.3.0
channel ch00: finished piece 1 at 16-JUN-24
channel ch00: backup piece complete, elapsed time: 00:00:01
channel ch00: input backup set: count=142, stamp=1171778191, piece=1
channel ch00: starting piece 1 at 16-JUN-24
channel ch00: backup piece +DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.353.1171778191
piece handle=4e2tfqkf_142_1_2 comment=API Version 2.0,MMS Version 8.1.3.0
channel ch00: finished piece 1 at 16-JUN-24
channel ch00: backup piece complete, elapsed time: 00:00:01
channel ch00: input backup set: count=143, stamp=1171778226, piece=1
channel ch00: starting piece 1 at 16-JUN-24
channel ch00: backup piece +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.354.1171778227
piece handle=4f2tfqli_143_1_2 comment=API Version 2.0,MMS Version 8.1.3.0
channel ch00: finished piece 1 at 16-JUN-24
channel ch00: backup piece complete, elapsed time: 00:00:01
channel ch00: input backup set: count=144, stamp=1171778251, piece=1
channel ch00: starting piece 1 at 16-JUN-24
channel ch00: backup piece +DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.355.1171778251
piece handle=4g2tfqmb_144_1_2 comment=API Version 2.0,MMS Version 8.1.3.0
channel ch00: finished piece 1 at 16-JUN-24
channel ch00: backup piece complete, elapsed time: 00:00:01
channel ch00: input backup set: count=145, stamp=1171778276, piece=1
channel ch00: starting piece 1 at 16-JUN-24
channel ch00: backup piece +DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.352.1171778277
piece handle=4h2tfqn4_145_1_2 comment=API Version 2.0,MMS Version 8.1.3.0
channel ch00: finished piece 1 at 16-JUN-24
channel ch00: backup piece complete, elapsed time: 00:00:01
channel ch00: input backup set: count=146, stamp=1171778277, piece=1
channel ch00: starting piece 1 at 16-JUN-24
channel ch00: backup piece +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171778277.362.1171778277
piece handle=c-2265125454-20240616-05 comment=API Version 2.0,MMS Version 8.1.3.0
channel ch00: finished piece 1 at 16-JUN-24
channel ch00: backup piece complete, elapsed time: 00:00:01
Finished backup at 16-JUN-24

Starting Control File and SPFILE Autobackup at 16-JUN-24
piece handle=c-2265125454-20240616-06 comment=API Version 2.0,MMS Version 8.1.3.0
Finished Control File and SPFILE Autobackup at 16-JUN-24
released channel: ch00

RMAN>

RMAN> list backup;

using target database control file instead of recovery catalog

List of Backup Sets
===================

BS Key Size
------- ----------
111 18.33M

Backup Set Copy #1 of backup set 111
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:00 16-JUN-24 YES FULLDBBACKUP

List of Backup Pieces for backup set 111 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
146 1 AVAILABLE +DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.346.1171778191

Backup Set Copy #2 of backup set 111
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
SBT_TAPE 00:00:00 16-JUN-24 YES FULLDBBACKUP

List of Backup Pieces for backup set 111 Copy #2
BP Key Pc# Status Media Piece Name
------- --- ----------- ----------------------- ----------
154 1 AVAILABLE /nfs,4d2tfqke_141_1_2 4d2tfqke_141_1_2

BS Key Type LV Size
------- ---- -- ----------
112 Full 585.52M
List of Datafiles in backup set 112
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
1 Full 7493049 16-JUN-24 NO +DATA/CDB/DATAFILE/system.258.1171775203
3 Full 7493049 16-JUN-24 NO +DATA/CDB/DATAFILE/sysaux.287.1171775203
4 Full 7493049 16-JUN-24 NO +DATA/CDB/DATAFILE/undotbs1.294.1171775205
7 Full 7493049 16-JUN-24 NO +DATA/CDB/DATAFILE/users.298.1171775205
9 Full 7493049 16-JUN-24 NO +DATA/CDB/DATAFILE/undotbs2.276.1171775205
10 Full 7493049 16-JUN-24 NO +DATA/CDB/DATAFILE/undotbs3.259.1171775205

Backup Set Copy #1 of backup set 112
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:30 16-JUN-24 YES FULLDBBACKUP

List of Backup Pieces for backup set 112 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
147 1 AVAILABLE +DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.353.1171778191

Backup Set Copy #2 of backup set 112
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
SBT_TAPE 00:00:30 16-JUN-24 YES FULLDBBACKUP

List of Backup Pieces for backup set 112 Copy #2
BP Key Pc# Status Media Piece Name
------- --- ----------- ----------------------- ----------
155 1 AVAILABLE /nfs,4e2tfqkf_142_1_2 4e2tfqkf_142_1_2

BS Key Type LV Size
------- ---- -- ----------
113 Full 351.52M
List of Datafiles in backup set 113
Container ID: 3, PDB Name: PDB
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
11 Full 7493743 16-JUN-24 NO +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.260.1171775211
12 Full 7493743 16-JUN-24 NO +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.261.1171775211
13 Full 7493743 16-JUN-24 NO +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.270.1171775211
14 Full 7493743 16-JUN-24 NO +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.274.1171775211
15 Full 7493743 16-JUN-24 NO +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.266.1171775211
16 Full 7493743 16-JUN-24 NO +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.301.1171775211

Backup Set Copy #1 of backup set 113
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:18 16-JUN-24 YES FULLDBBACKUP

List of Backup Pieces for backup set 113 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
148 1 AVAILABLE +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.354.1171778227

Backup Set Copy #2 of backup set 113
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
SBT_TAPE 00:00:18 16-JUN-24 YES FULLDBBACKUP

List of Backup Pieces for backup set 113 Copy #2
BP Key Pc# Status Media Piece Name
------- --- ----------- ----------------------- ----------
156 1 AVAILABLE /nfs,4f2tfqli_143_1_2 4f2tfqli_143_1_2

BS Key Type LV Size
------- ---- -- ----------
114 Full 402.36M
List of Datafiles in backup set 114
Container ID: 2, PDB Name: PDB$SEED
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
5 Full 5317292 27-SEP-23 NO +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.302.1171775215
6 Full 5317292 27-SEP-23 NO +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.273.1171775215
8 Full 5317292 27-SEP-23 NO +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.290.1171775215

Backup Set Copy #1 of backup set 114
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:21 16-JUN-24 YES FULLDBBACKUP

List of Backup Pieces for backup set 114 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
149 1 AVAILABLE +DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.355.1171778251

Backup Set Copy #2 of backup set 114
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
SBT_TAPE 00:00:21 16-JUN-24 YES FULLDBBACKUP

List of Backup Pieces for backup set 114 Copy #2
BP Key Pc# Status Media Piece Name
------- --- ----------- ----------------------- ----------
157 1 AVAILABLE /nfs,4g2tfqmb_144_1_2 4g2tfqmb_144_1_2

BS Key Size
------- ----------
115 344.00K

List of Archived Logs in backup set 115
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
3 13 7493031 16-JUN-24 7493768 16-JUN-24

Backup Set Copy #1 of backup set 115
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:00 16-JUN-24 YES FULLDBBACKUP

List of Backup Pieces for backup set 115 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
150 1 AVAILABLE +DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.352.1171778277

Backup Set Copy #2 of backup set 115
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
SBT_TAPE 00:00:00 16-JUN-24 YES FULLDBBACKUP

List of Backup Pieces for backup set 115 Copy #2
BP Key Pc# Status Media Piece Name
------- --- ----------- ----------------------- ----------
158 1 AVAILABLE /nfs,4h2tfqn4_145_1_2 4h2tfqn4_145_1_2

BS Key Type LV Size
------- ---- -- ----------
116 Full 19.17M
SPFILE Included: Modification time: 16-JUN-24
SPFILE db_unique_name: CDB
Control File Included: Ckp SCN: 7493784 Ckp time: 16-JUN-24

Backup Set Copy #1 of backup set 116
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:00 16-JUN-24 NO TAG20240616T055757

List of Backup Pieces for backup set 116 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
151 1 AVAILABLE +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171778277.362.1171778277

Backup Set Copy #2 of backup set 116
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
SBT_TAPE 00:00:00 16-JUN-24 NO TAG20240616T055757

List of Backup Pieces for backup set 116 Copy #2
BP Key Pc# Status Media Piece Name
------- --- ----------- ----------------------- ----------
159 1 AVAILABLE /nfs,c-2265125454-202406 c-2265125454-20240616-05

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
117 Full 1.25G SBT_TAPE 00:00:02 16-JUN-24
BP Key: 152 Status: AVAILABLE Compressed: NO Tag: TAG20240616T055925
Handle: 4j2tfqpt_147_1_1 Media: /nfs,4j2tfqpt_147_1_1
List of Datafiles in backup set 117
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
1 Full 7329710 16-JUN-24 NO +DATA/CDB/DATAFILE/system.258.1171775203
4 Full 7329710 16-JUN-24 NO +DATA/CDB/DATAFILE/undotbs1.294.1171775205
7 Full 7329710 16-JUN-24 NO +DATA/CDB/DATAFILE/users.298.1171775205
9 Full 7329710 16-JUN-24 NO +DATA/CDB/DATAFILE/undotbs2.276.1171775205
10 Full 7329710 16-JUN-24 NO +DATA/CDB/DATAFILE/undotbs3.259.1171775205

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
118 62.50M SBT_TAPE 00:00:00 16-JUN-24
BP Key: 153 Status: AVAILABLE Compressed: NO Tag: TAG20240616T055925
Handle: 4k2tfqq0_148_1_1 Media: /nfs,4k2tfqq0_148_1_1

List of Archived Logs in backup set 118
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
3 5 7375705 16-JUN-24 7388467 16-JUN-24
3 6 7388467 16-JUN-24 7388688 16-JUN-24
3 7 7388688 16-JUN-24 7390228 16-JUN-24
3 8 7390228 16-JUN-24 7390298 16-JUN-24
3 9 7390298 16-JUN-24 7490527 16-JUN-24
3 10 7490527 16-JUN-24 7492288 16-JUN-24
3 11 7492288 16-JUN-24 7492380 16-JUN-24
3 12 7492380 16-JUN-24 7493031 16-JUN-24
3 13 7493031 16-JUN-24 7493768 16-JUN-24

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
119 Full 24.00M SBT_TAPE 00:00:00 16-JUN-24
BP Key: 160 Status: AVAILABLE Compressed: NO Tag: TAG20240616T055935
Handle: c-2265125454-20240616-06 Media: /nfs,c-2265125454-202406
SPFILE Included: Modification time: 16-JUN-24
SPFILE db_unique_name: CDB
Control File Included: Ckp SCN: 7493888 Ckp time: 16-JUN-24

RMAN>

[oracle@rac3 nfs]$ du -sk
24 .
[oracle@rac3 nfs]$ ls
Oracle_Disk_SBT_Catalog

[oracle@rac3 nfs]$ du -sk
2819648 .
[oracle@rac3 nfs]$ du -sk
2819648 .
[oracle@rac3 nfs]$ pwd
/nfs
[oracle@rac3 nfs]$

/nfs
[oracle@rac3 nfs]$ ls -ltr
total 2819644
-rw-r--r--. 1 oracle asmadmin 1342177296 Jun 16 05:59 4j2tfqpt_147_1_1
-rw-r--r--. 1 oracle asmadmin 65536016 Jun 16 05:59 4k2tfqq0_148_1_1
-rw-r--r--. 1 oracle asmadmin 19398672 Jun 16 05:59 4d2tfqke_141_1_2
-rw-r--r--. 1 oracle asmadmin 616562704 Jun 16 05:59 4e2tfqkf_142_1_2
-rw-r--r--. 1 oracle asmadmin 369098768 Jun 16 05:59 4f2tfqli_143_1_2
-rw-r--r--. 1 oracle asmadmin 423624720 Jun 16 05:59 4g2tfqmb_144_1_2
-rw-r--r--. 1 oracle asmadmin 524304 Jun 16 05:59 4h2tfqn4_145_1_2
-rw-r--r--. 1 oracle asmadmin 25165840 Jun 16 05:59 c-2265125454-20240616-05
-rw-r--r--. 1 oracle asmadmin 25165840 Jun 16 05:59 c-2265125454-20240616-06
-rw-r--r--. 1 oracle asmadmin 22400 Jun 16 05:59 Oracle_Disk_SBT_Catalog
[oracle@rac3 nfs]$

------------------直接到带库看看

RMAN> run {
2> allocate channel ch00 device type 'SBT_TAPE'
3> PARMS="SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)";
5> delete backup device type sbt;
6> }

allocated channel: ch00
channel ch00: SID=54 instance=cdb3 device type=SBT_TAPE
channel ch00: WARNING: Oracle Test Disk API

List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
154 111 1 2 AVAILABLE SBT_TAPE 4d2tfqke_141_1_2
155 112 1 2 AVAILABLE SBT_TAPE 4e2tfqkf_142_1_2
156 113 1 2 AVAILABLE SBT_TAPE 4f2tfqli_143_1_2
157 114 1 2 AVAILABLE SBT_TAPE 4g2tfqmb_144_1_2
158 115 1 2 AVAILABLE SBT_TAPE 4h2tfqn4_145_1_2
159 116 1 2 AVAILABLE SBT_TAPE c-2265125454-20240616-05
152 117 1 1 AVAILABLE SBT_TAPE 4j2tfqpt_147_1_1
153 118 1 1 AVAILABLE SBT_TAPE 4k2tfqq0_148_1_1
160 119 1 1 AVAILABLE SBT_TAPE c-2265125454-20240616-06

Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=4d2tfqke_141_1_2 RECID=154 STAMP=1171778369
deleted backup piece
backup piece handle=4e2tfqkf_142_1_2 RECID=155 STAMP=1171778371
deleted backup piece
backup piece handle=4f2tfqli_143_1_2 RECID=156 STAMP=1171778372
deleted backup piece
backup piece handle=4g2tfqmb_144_1_2 RECID=157 STAMP=1171778373
deleted backup piece
backup piece handle=4h2tfqn4_145_1_2 RECID=158 STAMP=1171778373
deleted backup piece
backup piece handle=c-2265125454-20240616-05 RECID=159 STAMP=1171778374
deleted backup piece
backup piece handle=4j2tfqpt_147_1_1 RECID=152 STAMP=1171778365
deleted backup piece
backup piece handle=4k2tfqq0_148_1_1 RECID=153 STAMP=1171778368
deleted backup piece
backup piece handle=c-2265125454-20240616-06 RECID=160 STAMP=1171778375
Deleted 9 objects

released channel: ch00

RMAN>

RMAN> delete backup;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=54 instance=cdb3 device type=DISK

List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
146 111 1 1 AVAILABLE DISK +DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.346.1171778191
147 112 1 1 AVAILABLE DISK +DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.353.1171778191
148 113 1 1 AVAILABLE DISK +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.354.1171778227
149 114 1 1 AVAILABLE DISK +DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.355.1171778251
150 115 1 1 AVAILABLE DISK +DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.352.1171778277
151 116 1 1 AVAILABLE DISK +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171778277.362.1171778277

Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=+DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.346.1171778191 RECID=146 STAMP=1171778190
deleted backup piece
backup piece handle=+DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.353.1171778191 RECID=147 STAMP=1171778191
deleted backup piece
backup piece handle=+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.354.1171778227 RECID=148 STAMP=1171778226
deleted backup piece
backup piece handle=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.355.1171778251 RECID=149 STAMP=1171778251
deleted backup piece
backup piece handle=+DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.352.1171778277 RECID=150 STAMP=1171778276
deleted backup piece
backup piece handle=+DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171778277.362.1171778277 RECID=151 STAMP=1171778277
Deleted 6 objects

RMAN> list backup;

specification does not match any backup in the repository

RMAN> list backup device type sbt;

specification does not match any backup in the repository

RMAN>

----------------------------------压缩备份

RMAN> list backup;

specification does not match any backup in the repository

RMAN> list backup device type sbt;

specification does not match any backup in the repository

RMAN> run {
2> allocate channel ch00 device type 'SBT_TAPE'
3> PARMS="SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)";
5> backup as compressed backupset database tag 'fulldbbackup' plus archivelog tag 'fulldbbackup';}

released channel: ORA_DISK_1
allocated channel: ch00
channel ch00: SID=54 instance=cdb3 device type=SBT_TAPE
channel ch00: WARNING: Oracle Test Disk API

Starting backup at 16-JUN-24
current log archived
channel ch00: starting compressed archived log backup set
channel ch00: specifying archived log(s) in backup set
input archived log thread=3 sequence=5 RECID=295 STAMP=1171776601
input archived log thread=3 sequence=6 RECID=296 STAMP=1171776698
input archived log thread=3 sequence=7 RECID=297 STAMP=1171776922
input archived log thread=3 sequence=8 RECID=298 STAMP=1171777008
input archived log thread=3 sequence=9 RECID=299 STAMP=1171777322
input archived log thread=3 sequence=10 RECID=300 STAMP=1171777459
input archived log thread=3 sequence=11 RECID=301 STAMP=1171777566
input archived log thread=3 sequence=12 RECID=302 STAMP=1171778189
input archived log thread=3 sequence=13 RECID=303 STAMP=1171778276
input archived log thread=3 sequence=14 RECID=304 STAMP=1171779381
channel ch00: starting piece 1 at 16-JUN-24
channel ch00: finished piece 1 at 16-JUN-24
piece handle=4s2tfrpm_156_1_1 tag=FULLDBBACKUP comment=API Version 2.0,MMS Version 8.1.3.0
channel ch00: backup set complete, elapsed time: 00:00:01
Finished backup at 16-JUN-24

Starting backup at 16-JUN-24
channel ch00: starting compressed full datafile backup set
channel ch00: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/CDB/DATAFILE/system.258.1171775203
input datafile file number=00003 name=+DATA/CDB/DATAFILE/sysaux.287.1171775203
input datafile file number=00004 name=+DATA/CDB/DATAFILE/undotbs1.294.1171775205
input datafile file number=00009 name=+DATA/CDB/DATAFILE/undotbs2.276.1171775205
input datafile file number=00010 name=+DATA/CDB/DATAFILE/undotbs3.259.1171775205
input datafile file number=00007 name=+DATA/CDB/DATAFILE/users.298.1171775205
channel ch00: starting piece 1 at 16-JUN-24
channel ch00: finished piece 1 at 16-JUN-24
piece handle=4t2tfrpn_157_1_1 tag=FULLDBBACKUP comment=API Version 2.0,MMS Version 8.1.3.0
channel ch00: backup set complete, elapsed time: 00:00:35
channel ch00: starting compressed full datafile backup set
channel ch00: specifying datafile(s) in backup set
input datafile file number=00011 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.260.1171775211
input datafile file number=00012 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.261.1171775211
input datafile file number=00013 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.270.1171775211
input datafile file number=00014 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.274.1171775211
input datafile file number=00015 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.266.1171775211
input datafile file number=00016 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.301.1171775211
channel ch00: starting piece 1 at 16-JUN-24
channel ch00: finished piece 1 at 16-JUN-24
piece handle=4u2tfrqq_158_1_1 tag=FULLDBBACKUP comment=API Version 2.0,MMS Version 8.1.3.0
channel ch00: backup set complete, elapsed time: 00:00:25
channel ch00: starting compressed full datafile backup set
channel ch00: specifying datafile(s) in backup set
input datafile file number=00005 name=+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.302.1171775215
input datafile file number=00006 name=+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.273.1171775215
input datafile file number=00008 name=+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.290.1171775215
channel ch00: starting piece 1 at 16-JUN-24
channel ch00: finished piece 1 at 16-JUN-24
piece handle=4v2tfrrj_159_1_1 tag=FULLDBBACKUP comment=API Version 2.0,MMS Version 8.1.3.0
channel ch00: backup set complete, elapsed time: 00:00:25
Finished backup at 16-JUN-24

Starting backup at 16-JUN-24
current log archived
channel ch00: starting compressed archived log backup set
channel ch00: specifying archived log(s) in backup set
input archived log thread=3 sequence=15 RECID=305 STAMP=1171779468
channel ch00: starting piece 1 at 16-JUN-24
channel ch00: finished piece 1 at 16-JUN-24
piece handle=502tfrsc_160_1_1 tag=FULLDBBACKUP comment=API Version 2.0,MMS Version 8.1.3.0
channel ch00: backup set complete, elapsed time: 00:00:01
Finished backup at 16-JUN-24

Starting Control File and SPFILE Autobackup at 16-JUN-24
piece handle=c-2265125454-20240616-07 comment=API Version 2.0,MMS Version 8.1.3.0
Finished Control File and SPFILE Autobackup at 16-JUN-24
released channel: ch00

RMAN>

RMAN> run {
2> allocate channel ch00 device type 'SBT_TAPE'
3> PARMS="SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)";
5> backup database tag 'fulldbbackup' plus archivelog tag 'fulldbbackup';}

allocated channel: ch00
channel ch00: SID=54 instance=cdb3 device type=SBT_TAPE
channel ch00: WARNING: Oracle Test Disk API

Starting backup at 16-JUN-24
current log archived
channel ch00: starting archived log backup set
channel ch00: specifying archived log(s) in backup set
input archived log thread=3 sequence=5 RECID=295 STAMP=1171776601
input archived log thread=3 sequence=6 RECID=296 STAMP=1171776698
input archived log thread=3 sequence=7 RECID=297 STAMP=1171776922
input archived log thread=3 sequence=8 RECID=298 STAMP=1171777008
input archived log thread=3 sequence=9 RECID=299 STAMP=1171777322
input archived log thread=3 sequence=10 RECID=300 STAMP=1171777459
input archived log thread=3 sequence=11 RECID=301 STAMP=1171777566
input archived log thread=3 sequence=12 RECID=302 STAMP=1171778189
input archived log thread=3 sequence=13 RECID=303 STAMP=1171778276
input archived log thread=3 sequence=14 RECID=304 STAMP=1171779381
input archived log thread=3 sequence=15 RECID=305 STAMP=1171779468
input archived log thread=3 sequence=16 RECID=306 STAMP=1171779566
channel ch00: starting piece 1 at 16-JUN-24
channel ch00: finished piece 1 at 16-JUN-24
piece handle=522tfrve_162_1_1 tag=FULLDBBACKUP comment=API Version 2.0,MMS Version 8.1.3.0
channel ch00: backup set complete, elapsed time: 00:00:01
Finished backup at 16-JUN-24

Starting backup at 16-JUN-24
channel ch00: starting full datafile backup set
channel ch00: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/CDB/DATAFILE/system.258.1171775203
input datafile file number=00003 name=+DATA/CDB/DATAFILE/sysaux.287.1171775203
input datafile file number=00004 name=+DATA/CDB/DATAFILE/undotbs1.294.1171775205
input datafile file number=00009 name=+DATA/CDB/DATAFILE/undotbs2.276.1171775205
input datafile file number=00010 name=+DATA/CDB/DATAFILE/undotbs3.259.1171775205
input datafile file number=00007 name=+DATA/CDB/DATAFILE/users.298.1171775205
channel ch00: starting piece 1 at 16-JUN-24
channel ch00: finished piece 1 at 16-JUN-24
piece handle=532tfrvf_163_1_1 tag=FULLDBBACKUP comment=API Version 2.0,MMS Version 8.1.3.0
channel ch00: backup set complete, elapsed time: 00:00:07
channel ch00: starting full datafile backup set
channel ch00: specifying datafile(s) in backup set
input datafile file number=00011 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.260.1171775211
input datafile file number=00012 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.261.1171775211
input datafile file number=00013 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.270.1171775211
input datafile file number=00014 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.274.1171775211
input datafile file number=00015 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.266.1171775211
input datafile file number=00016 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.301.1171775211
channel ch00: starting piece 1 at 16-JUN-24
channel ch00: finished piece 1 at 16-JUN-24
piece handle=542tfrvm_164_1_1 tag=FULLDBBACKUP comment=API Version 2.0,MMS Version 8.1.3.0
channel ch00: backup set complete, elapsed time: 00:00:03
channel ch00: starting full datafile backup set
channel ch00: specifying datafile(s) in backup set
input datafile file number=00005 name=+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.302.1171775215
input datafile file number=00006 name=+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.273.1171775215
input datafile file number=00008 name=+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.290.1171775215
channel ch00: starting piece 1 at 16-JUN-24
channel ch00: finished piece 1 at 16-JUN-24
piece handle=552tfrvp_165_1_1 tag=FULLDBBACKUP comment=API Version 2.0,MMS Version 8.1.3.0
channel ch00: backup set complete, elapsed time: 00:00:03
Finished backup at 16-JUN-24

Starting backup at 16-JUN-24
current log archived
channel ch00: starting archived log backup set
channel ch00: specifying archived log(s) in backup set
input archived log thread=3 sequence=17 RECID=307 STAMP=1171779580
channel ch00: starting piece 1 at 16-JUN-24
channel ch00: finished piece 1 at 16-JUN-24
piece handle=562tfrvt_166_1_1 tag=FULLDBBACKUP comment=API Version 2.0,MMS Version 8.1.3.0
channel ch00: backup set complete, elapsed time: 00:00:01
Finished backup at 16-JUN-24

Starting Control File and SPFILE Autobackup at 16-JUN-24
piece handle=c-2265125454-20240616-08 comment=API Version 2.0,MMS Version 8.1.3.0
Finished Control File and SPFILE Autobackup at 16-JUN-24
released channel: ch00

RMAN>