如何从磁带库中恢复备份集

2025-04-11 10:07:31
推荐回答(1个)
回答1:

操作如下
RMAN> list backupset 1055;
using target database control file instead of recovery catalog
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1055 81.25M SBT_TAPE 00:00:25 23-OCT-12
BP Key: 1055 Status: AVAILABLE Compressed: NO Tag: TAG20121023T042751
Handle: zlxppc_arch_20121023_797401672_1enoeoi8_1_1 Media: 47
List of Archived Logs in backup set 1055
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 711 22333056 22-OCT-12 22392632 23-OCT-12
1 712 22392632 23-OCT-12 22392640 23-OCT-12
RMAN> run{
2> allocate channel t1 type sbt send 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
3> backup backupset 1055 format '/home/oracle/%U';
4> release channel t1;
5> }
allocated channel: t1
channel t1: sid=3228 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.5.1.0
Starting backup at 24-OCT-12
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 10/24/2012 14:28:08
RMAN-06160: no backup pieces found for backup set key: 1055