Oracle磁帶備份模擬

RMAN> run {

allocate channel ch00 device type 'SBT_TAPE'

PARMS="SBT_LIBRARY=oracle.disksbt,

ENV=(BACKUP_DIR=/tmp)";

backup datafile 1 format='%U';

}2> 3> 4> 5> 6>

allocated channel: ch00

channel ch00: SID=201 device type=SBT_TAPE

channel ch00: WARNING: Oracle Test Disk API

Starting backup at 03-APR-20

channel ch00: starting full datafile backup set

channel ch00: specifying datafile(s) in backup set

input datafile file number=00001 name=/oracle/app/oracle/oradata/orcl/system01.dbf

channel ch00: starting piece 1 at 03-APR-20

channel ch00: finished piece 1 at 03-APR-20

piece handle=14uso7sc_1_1 tag=TAG20200403T203316 comment=API Version 2.0,MMS Version 8.1.3.0

channel ch00: backup set complete, elapsed time: 00:00:25

channel ch00: starting full datafile backup set

channel ch00: specifying datafile(s) in backup set

including current control file in backup set

channel ch00: starting piece 1 at 03-APR-20

channel ch00: finished piece 1 at 03-APR-20

piece handle=15uso7t6_1_1 tag=TAG20200403T203316 comment=API Version 2.0,MMS Version 8.1.3.0

channel ch00: backup set complete, elapsed time: 00:00:01

Finished backup at 03-APR-20

released channel: ch00

RMAN> run {

allocate channel ch00 device type 'SBT_TAPE'

PARMS="SBT_LIBRARY=oracle.disksbt,

ENV=(BACKUP_DIR=/tmp)";

delete backup;

}2> 3> 4> 5> 6>

allocated channel: ch00

channel ch00: SID=15 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

------- ------- --- --- ----------- ----------- ----------

1 1 1 1 AVAILABLE SBT_TAPE oracle_orcl_backup01<orcl_3:981880213:1>.dbf

2 2 1 1 AVAILABLE SBT_TAPE oracle_orcl_backup01<orcl_2:981880213:1>.dbf

3 3 1 1 AVAILABLE SBT_TAPE oracle_orcl_backup01<orcl_1:981880213:1>.dbf

4 4 1 1 AVAILABLE SBT_TAPE oracle_orcl_backup01<orcl_5:981880298:1>.dbf

5 5 1 1 AVAILABLE SBT_TAPE oracle_orcl_backup01<orcl_4:981880298:1>.dbf

6 6 1 1 AVAILABLE SBT_TAPE oracle_orcl_backup01<orcl_7:981880303:1>.dbf

7 7 1 1 AVAILABLE SBT_TAPE oracle_orcl_backup01<orcl_6:981880303:1>.dbf

8 8 1 1 AVAILABLE SBT_TAPE oracle_orcl_backup01<orcl_8:981880307:1>.dbf

9 9 1 1 AVAILABLE SBT_TAPE oracle_orcl_backup01<orcl_15:981881499:1>.dbf

10 10 1 1 AVAILABLE SBT_TAPE oracle_orcl_backup01<orcl_14:981881499:1>.dbf

11 11 1 1 AVAILABLE SBT_TAPE oracle_orcl_backup01<orcl_16:981881499:1>.dbf

12 12 1 1 AVAILABLE SBT_TAPE oracle_orcl_backup01<orcl_18:981881544:1>.dbf

13 13 1 1 AVAILABLE SBT_TAPE oracle_orcl_backup01<orcl_17:981881544:1>.dbf

14 14 1 1 AVAILABLE SBT_TAPE oracle_orcl_backup01<orcl_19:981881548:1>.dbf

15 15 1 1 AVAILABLE SBT_TAPE oracle_orcl_backup01<orcl_20:981881548:1>.dbf

16 16 1 1 AVAILABLE SBT_TAPE oracle_orcl_backup01<orcl_21:981881548:1>.dbf

17 17 1 1 AVAILABLE SBT_TAPE oracle_orcl_backup01<orcl_22:981881551:1>.dbf

33 33 1 1 AVAILABLE SBT_TAPE 14uso7sc_1_1

34 34 1 1 AVAILABLE SBT_TAPE 15uso7t6_1_1

Do you really want to delete the above objects (enter YES or NO)? YES

deleted backup piece

backup piece handle=14uso7sc_1_1 RECID=33 STAMP=1036787596

deleted backup piece

backup piece handle=15uso7t6_1_1 RECID=34 STAMP=1036787647

Deleted 2 objects

RMAN-06207: WARNING: 17 objects could not be deleted for SBT_TAPE channel(s) due

RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status

RMAN-06210: List of Mismatched objects

RMAN-06211: ==========================

RMAN-06212: Object Type Filename/Handle

RMAN-06213: --------------- ---------------------------------------------------

RMAN-06214: Backup Piece oracle_orcl_backup01<orcl_3:981880213:1>.dbf

RMAN-06214: Backup Piece oracle_orcl_backup01<orcl_2:981880213:1>.dbf

RMAN-06214: Backup Piece oracle_orcl_backup01<orcl_1:981880213:1>.dbf

RMAN-06214: Backup Piece oracle_orcl_backup01<orcl_5:981880298:1>.dbf

RMAN-06214: Backup Piece oracle_orcl_backup01<orcl_4:981880298:1>.dbf

RMAN-06214: Backup Piece oracle_orcl_backup01<orcl_7:981880303:1>.dbf

RMAN-06214: Backup Piece oracle_orcl_backup01<orcl_6:981880303:1>.dbf

RMAN-06214: Backup Piece oracle_orcl_backup01<orcl_8:981880307:1>.dbf

RMAN-06214: Backup Piece oracle_orcl_backup01<orcl_15:981881499:1>.dbf

RMAN-06214: Backup Piece oracle_orcl_backup01<orcl_14:981881499:1>.dbf

RMAN-06214: Backup Piece oracle_orcl_backup01<orcl_16:981881499:1>.dbf

RMAN-06214: Backup Piece oracle_orcl_backup01<orcl_18:981881544:1>.dbf

RMAN-06214: Backup Piece oracle_orcl_backup01<orcl_17:981881544:1>.dbf

RMAN-06214: Backup Piece oracle_orcl_backup01<orcl_19:981881548:1>.dbf

RMAN-06214: Backup Piece oracle_orcl_backup01<orcl_20:981881548:1>.dbf

RMAN-06214: Backup Piece oracle_orcl_backup01<orcl_21:981881548:1>.dbf

RMAN-06214: Backup Piece oracle_orcl_backup01<orcl_22:981881551:1>.dbf

released channel: ch00

RMAN> run {

allocate channel ch00 device type 'SBT_TAPE'

PARMS="SBT_LIBRARY=oracle.disksbt,

ENV=(BACKUP_DIR=/tmp)";

crosscheck backup;

delete expired backup;

}

2> 3> 4> 5> 6> 7>

allocated channel: ch00

channel ch00: SID=15 device type=SBT_TAPE

channel ch00: WARNING: Oracle Test Disk API