---用舊的控制文件恢復后 這個控制文件本身的備份信息不在此還原出的控制文件中。所以這個備份的控制文件就刪不掉,看不到。 但是只要設置正確的dbid,還是可以用恢復這個控制文件的
正常未恢復過controlfile的話,這個控制文件備份信息在現有的控制文件中,可以刪除的
RMAN> ? ?run {
2> allocate channel ch00 device type 'SBT_TAPE'
3> PARMS="SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)";
5> delete backup;
6> ? ? }
released channel: ORA_DISK_1
allocated channel: ch00
channel ch00: SID=38 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
------- ------- --- --- ----------- ----------- ----------
182 ? ? 141 ? ? 1 ? 1 ? AVAILABLE ? SBT_TAPE ? ?5j2tghj1_179_1_1
183 ? ? 142 ? ? 1 ? 1 ? AVAILABLE ? SBT_TAPE ? ?5k2tghj2_180_1_1
184 ? ? 143 ? ? 1 ? 1 ? AVAILABLE ? SBT_TAPE ? ?5l2tghk6_181_1_1
185 ? ? 144 ? ? 1 ? 1 ? AVAILABLE ? SBT_TAPE ? ?5m2tghkv_182_1_1
186 ? ? 145 ? ? 1 ? 1 ? AVAILABLE ? SBT_TAPE ? ?5n2tghlo_183_1_1
Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=5j2tghj1_179_1_1 RECID=182 STAMP=1171801697
deleted backup piece
backup piece handle=5k2tghj2_180_1_1 RECID=183 STAMP=1171801699
deleted backup piece
backup piece handle=5l2tghk6_181_1_1 RECID=184 STAMP=1171801734
deleted backup piece
backup piece handle=5m2tghkv_182_1_1 RECID=185 STAMP=1171801759
deleted backup piece
backup piece handle=5n2tghlo_183_1_1 RECID=186 STAMP=1171801784
Deleted 5 objects
released channel: ch00
RMAN>?
?[oracle@rac3 nfs]$ ls -ltr
total 24588
-rw-r--r--. 1 oracle asmadmin 25165840 Jun 16 12:29 c-2265125454-20240616-0e--沒刪掉
-rw-r--r--. 1 oracle asmadmin ? ? 7840 Jul ?7 02:28 Oracle_Disk_SBT_Catalog
RMAN> ? ?run {
2> allocate channel ch00 device type 'SBT_TAPE'
3> PARMS="SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)";
5> ##delete backup;
6> backup database;
7> ? ? }
allocated channel: ch00
channel ch00: SID=38 instance=cdb3 device type=SBT_TAPE
channel ch00: WARNING: Oracle Test Disk API
Starting backup at 07-JUL-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.347.1173663209
input datafile file number=00003 name=+DATA/CDB/DATAFILE/sysaux.269.1173663209
input datafile file number=00004 name=+DATA/CDB/DATAFILE/undotbs1.267.1173663209
input datafile file number=00009 name=+DATA/CDB/DATAFILE/undotbs2.270.1173663209
input datafile file number=00010 name=+DATA/CDB/DATAFILE/undotbs3.265.1173663209
input datafile file number=00007 name=+DATA/CDB/DATAFILE/users.268.1173663209
channel ch00: starting piece 1 at 07-JUL-24
channel ch00: finished piece 1 at 07-JUL-24
piece handle=5t2v9eop_189_1_1 tag=TAG20240707T022945 comment=API Version 2.0,MMS Version 8.1.3.0
channel ch00: backup set complete, elapsed time: 00:00:15
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.287.1173663255
input datafile file number=00012 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.261.1173663255
input datafile file number=00013 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.274.1173663255
input datafile file number=00014 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.360.1173663255
input datafile file number=00015 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.275.1173663255
input datafile file number=00016 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.282.1173663255
RMAN-03009: failure of backup command on ch00 channel at 07/07/2024 02:30:00
ORA-03115: unsupported network datatype or representation
ORA-06594: ICD is unable to compute a result
continuing other job steps, job failed will not be re-run
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.293.1173663279
input datafile file number=00006 name=+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.258.1173663279
input datafile file number=00008 name=+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.284.1173663279
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch00 channel at 07/07/2024 02:30:00
ORA-03115: unsupported network datatype or representation
ORA-06594: ICD is unable to compute a result
RMAN> ? ?run {
2> allocate channel ch00 device type 'SBT_TAPE'
3> PARMS="SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)";
5> delete backup;
6> ##backup database;
7> ? ? }
allocated channel: ch00
channel ch00: SID=38 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
------- ------- --- --- ----------- ----------- ----------
189 ? ? 148 ? ? 1 ? 1 ? AVAILABLE ? SBT_TAPE ? ?5t2v9eop_189_1_1
Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=5t2v9eop_189_1_1 RECID=189 STAMP=1173666585
Deleted 1 objects
released channel: ch00
RMAN>?
RMAN>?
RMAN>?
RMAN> ? ?run {
2> allocate channel ch00 device type 'SBT_TAPE'
3> PARMS="SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)";
5> ##delete backup;
6> backup as compressed backupset ?database;
7> ? ? }
allocated channel: ch00
channel ch00: SID=38 instance=cdb3 device type=SBT_TAPE
channel ch00: WARNING: Oracle Test Disk API
Starting backup at 07-JUL-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.347.1173663209
input datafile file number=00003 name=+DATA/CDB/DATAFILE/sysaux.269.1173663209
input datafile file number=00004 name=+DATA/CDB/DATAFILE/undotbs1.267.1173663209
input datafile file number=00009 name=+DATA/CDB/DATAFILE/undotbs2.270.1173663209
input datafile file number=00010 name=+DATA/CDB/DATAFILE/undotbs3.265.1173663209
input datafile file number=00007 name=+DATA/CDB/DATAFILE/users.268.1173663209
RMAN-03009: failure of backup command on ch00 channel at 07/07/2024 02:31:44
ORA-03115: unsupported network datatype or representation
ORA-06594: ICD is unable to compute a result
continuing other job steps, job failed will not be re-run
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.287.1173663255
input datafile file number=00012 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.261.1173663255
input datafile file number=00013 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.274.1173663255
input datafile file number=00014 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.360.1173663255
input datafile file number=00015 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.275.1173663255
input datafile file number=00016 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.282.1173663255
RMAN-03009: failure of backup command on ch00 channel at 07/07/2024 02:31:44
ORA-03115: unsupported network datatype or representation
ORA-06594: ICD is unable to compute a result
continuing other job steps, job failed will not be re-run
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.293.1173663279
input datafile file number=00006 name=+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.258.1173663279
input datafile file number=00008 name=+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.284.1173663279
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch00 channel at 07/07/2024 02:31:44
ORA-03115: unsupported network datatype or representation
ORA-06594: ICD is unable to compute a result
ORA-03115?ORA-06594--空間不足
RMAN> exit---退出重新 RMAN SQLPLUS 切換,退出再進??煩人
Recovery Manager complete.
[oracle@rac3 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Sun Jul 7 02:31:56 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)
RMAN> ? ?run {
2> allocate channel ch00 device type 'SBT_TAPE'
3> PARMS="SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)";
5> ##delete backup;
6> backup as compressed backupset ?database;
7> ? ? }
using target database control file instead of recovery catalog
allocated channel: ch00
channel ch00: SID=28 instance=cdb3 device type=SBT_TAPE
channel ch00: WARNING: Oracle Test Disk API
Starting backup at 07-JUL-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.347.1173663209
input datafile file number=00003 name=+DATA/CDB/DATAFILE/sysaux.269.1173663209
input datafile file number=00004 name=+DATA/CDB/DATAFILE/undotbs1.267.1173663209
input datafile file number=00009 name=+DATA/CDB/DATAFILE/undotbs2.270.1173663209
input datafile file number=00010 name=+DATA/CDB/DATAFILE/undotbs3.265.1173663209
input datafile file number=00007 name=+DATA/CDB/DATAFILE/users.268.1173663209
channel ch00: starting piece 1 at 07-JUL-24
channel ch00: finished piece 1 at 07-JUL-24
piece handle=632v9esv_195_1_1 tag=TAG20240707T023158 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.287.1173663255
input datafile file number=00012 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.261.1173663255
input datafile file number=00013 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.274.1173663255
input datafile file number=00014 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.360.1173663255
input datafile file number=00015 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.275.1173663255
input datafile file number=00016 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.282.1173663255
channel ch00: starting piece 1 at 07-JUL-24
channel ch00: finished piece 1 at 07-JUL-24
piece handle=642v9eu2_196_1_1 tag=TAG20240707T023158 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=00005 name=+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.293.1173663279
input datafile file number=00006 name=+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.258.1173663279
input datafile file number=00008 name=+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.284.1173663279
channel ch00: starting piece 1 at 07-JUL-24
channel ch00: finished piece 1 at 07-JUL-24
piece handle=652v9ev5_197_1_1 tag=TAG20240707T023158 comment=API Version 2.0,MMS Version 8.1.3.0
channel ch00: backup set complete, elapsed time: 00:00:25
Finished backup at 07-JUL-24
Starting Control File and SPFILE Autobackup at 07-JUL-24
piece handle=c-2265125454-20240707-02 comment=API Version 2.0,MMS Version 8.1.3.0
Finished Control File and SPFILE Autobackup at 07-JUL-24
released channel: ch00
RMAN> list backup;
List of Backup Sets
===================
BS Key ?Type LV Size ? ? ? Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
149 ? ? Full ? ?600.00M ? ?SBT_TAPE ? ?00:00:34 ? ? 07-JUL-24 ? ? ?
? ? ? ? BP Key: 190 ? Status: AVAILABLE ?Compressed: YES ?Tag: TAG20240707T023158
? ? ? ? Handle: 632v9esv_195_1_1 ? Media: /nfs,632v9esv_195_1_1
? List of Datafiles in backup set 149
? File LV Type Ckp SCN ? ?Ckp Time ?Abs Fuz SCN Sparse Name
? ---- -- ---- ---------- --------- ----------- ------ ----
? 1 ? ? ? Full 7612800 ? ?07-JUL-24 ? ? ? ? ? ? ?NO ? ?+DATA/CDB/DATAFILE/system.347.1173663209
? 3 ? ? ? Full 7612800 ? ?07-JUL-24 ? ? ? ? ? ? ?NO ? ?+DATA/CDB/DATAFILE/sysaux.269.1173663209
? 4 ? ? ? Full 7612800 ? ?07-JUL-24 ? ? ? ? ? ? ?NO ? ?+DATA/CDB/DATAFILE/undotbs1.267.1173663209
? 7 ? ? ? Full 7612800 ? ?07-JUL-24 ? ? ? ? ? ? ?NO ? ?+DATA/CDB/DATAFILE/users.268.1173663209
? 9 ? ? ? Full 7612800 ? ?07-JUL-24 ? ? ? ? ? ? ?NO ? ?+DATA/CDB/DATAFILE/undotbs2.270.1173663209
? 10 ? ? ?Full 7612800 ? ?07-JUL-24 ? ? ? ? ? ? ?NO ? ?+DATA/CDB/DATAFILE/undotbs3.265.1173663209
BS Key ?Type LV Size ? ? ? Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
150 ? ? Full ? ?424.00M ? ?SBT_TAPE ? ?00:00:25 ? ? 07-JUL-24 ? ? ?
? ? ? ? BP Key: 191 ? Status: AVAILABLE ?Compressed: YES ?Tag: TAG20240707T023158
? ? ? ? Handle: 642v9eu2_196_1_1 ? Media: /nfs,642v9eu2_196_1_1
? List of Datafiles in backup set 150
? Container ID: 3, PDB Name: PDB
? File LV Type Ckp SCN ? ?Ckp Time ?Abs Fuz SCN Sparse Name
? ---- -- ---- ---------- --------- ----------- ------ ----
? 11 ? ? ?Full 7612818 ? ?07-JUL-24 ? ? ? ? ? ? ?NO ? ?+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.287.1173663255
? 12 ? ? ?Full 7612818 ? ?07-JUL-24 ? ? ? ? ? ? ?NO ? ?+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.261.1173663255
? 13 ? ? ?Full 7612818 ? ?07-JUL-24 ? ? ? ? ? ? ?NO ? ?+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.274.1173663255
? 14 ? ? ?Full 7612818 ? ?07-JUL-24 ? ? ? ? ? ? ?NO ? ?+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.360.1173663255
? 15 ? ? ?Full 7612818 ? ?07-JUL-24 ? ? ? ? ? ? ?NO ? ?+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.275.1173663255
? 16 ? ? ?Full 7612818 ? ?07-JUL-24 ? ? ? ? ? ? ?NO ? ?+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.282.1173663255
BS Key ?Type LV Size ? ? ? Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
151 ? ? Full ? ?404.00M ? ?SBT_TAPE ? ?00:00:23 ? ? 07-JUL-24 ? ? ?
? ? ? ? BP Key: 192 ? Status: AVAILABLE ?Compressed: YES ?Tag: TAG20240707T023158
? ? ? ? Handle: 652v9ev5_197_1_1 ? Media: /nfs,652v9ev5_197_1_1
? List of Datafiles in backup set 151
? 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.293.1173663279
? 6 ? ? ? Full 5317292 ? ?27-SEP-23 ? ? ? ? ? ? ?NO ? ?+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.258.1173663279
? 8 ? ? ? Full 5317292 ? ?27-SEP-23 ? ? ? ? ? ? ?NO ? ?+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.284.1173663279
BS Key ?Type LV Size ? ? ? Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
152 ? ? Full ? ?24.00M ? ? SBT_TAPE ? ?00:00:00 ? ? 07-JUL-24 ? ? ?
? ? ? ? BP Key: 193 ? Status: AVAILABLE ?Compressed: NO ?Tag: TAG20240707T023334
? ? ? ? Handle: c-2265125454-20240707-02 ? Media: /nfs,c-2265125454-202407
? SPFILE Included: Modification time: 07-JUL-24
? SPFILE db_unique_name: CDB
? Control File Included: Ckp SCN: 7612860 ? ? ?Ckp time: 07-JUL-24
RMAN>?
RMAN>?
RMAN> ? ?run {
2> allocate channel ch00 device type 'SBT_TAPE'
3> PARMS="SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)";
5> delete backup;
6> ##backup as compressed backupset ?database;
7> ? ? }
? ? allocated channel: ch00
channel ch00: SID=28 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
------- ------- --- --- ----------- ----------- ----------
190 ? ? 149 ? ? 1 ? 1 ? AVAILABLE ? SBT_TAPE ? ?632v9esv_195_1_1
191 ? ? 150 ? ? 1 ? 1 ? AVAILABLE ? SBT_TAPE ? ?642v9eu2_196_1_1
192 ? ? 151 ? ? 1 ? 1 ? AVAILABLE ? SBT_TAPE ? ?652v9ev5_197_1_1
193 ? ? 152 ? ? 1 ? 1 ? AVAILABLE ? SBT_TAPE ? ?c-2265125454-20240707-02
Do you really want to delete the above objects (enter YES or NO)? YES
" ? ?YES" is an invalid response - please re-enter.
Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=632v9esv_195_1_1 RECID=190 STAMP=1173666719
deleted backup piece
backup piece handle=642v9eu2_196_1_1 RECID=191 STAMP=1173666754
deleted backup piece
backup piece handle=652v9ev5_197_1_1 RECID=192 STAMP=1173666789
deleted backup piece
backup piece handle=c-2265125454-20240707-02 RECID=193 STAMP=1173666814
Deleted 4 objects
released channel: ch00
-----控制文件確實刪掉了。刪不掉的情況就是上次用這個控制文件恢復了,控制文件不包含自己的備份信息。所以就一直在了
[oracle@rac3 nfs]$ ls -ltr
total 1511452
-rw-r--r--. 1 oracle asmadmin ?25165840 Jun 16 12:29 c-2265125454-20240616-0e
-rw-r--r--. 1 oracle asmadmin 629145616 Jul ?7 02:32 632v9esv_195_1_1
-rw-r--r--. 1 oracle asmadmin 444596240 Jul ?7 02:32 642v9eu2_196_1_1
-rw-r--r--. 1 oracle asmadmin 423624720 Jul ?7 02:33 652v9ev5_197_1_1
-rw-r--r--. 1 oracle asmadmin ?25165840 Jul ?7 02:33 c-2265125454-20240707-02
-rw-r--r--. 1 oracle asmadmin ? ? ?7840 Jul ?7 02:33 Oracle_Disk_SBT_Catalog
?
[oracle@rac3 nfs]$ ls -ltr
total 24588
-rw-r--r--. 1 oracle asmadmin 25165840 Jun 16 12:29 c-2265125454-20240616-0e
-rw-r--r--. 1 oracle asmadmin ? ? 7840 Jul ?7 02:34 Oracle_Disk_SBT_Catalog
[oracle@rac3 nfs]$ ls -ltr
total 24588
-rw-r--r--. 1 oracle asmadmin 25165840 Jun 16 12:29 c-2265125454-20240616-0e
-rw-r--r--. 1 oracle asmadmin ? ? 7840 Jul ?7 02:34 Oracle_Disk_SBT_Catalog
[oracle@rac3 nfs]$?