ORA-03115 ORA-06594--空间不足 rman 磁带压缩备份 控制文件恢复后备份信息丢失

已于 2024-07-07 14:48:12 修改
阅读量752 收藏 20
点赞数 25
CC 4.0 BY-SA版权
文章标签： oracle
于 2024-07-07 14:45:39 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/jnrjian/article/details/140246114

---用旧的控制文件恢复后 这个控制文件本身的备份信息不在此还原出的控制文件中。所以这个备份的控制文件就删不掉，看不到。 但是只要设置正确的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]$ 

jnrjian
关注
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值