Manually back up archived logs
1. database01
[Oraprod @ db01 scripts] $ pwd
/Usr/tivoli/scripts
[Oraprod @ db01 scripts] $ ls
1. txt nohup. out oraicr0.sh scheoraicr0.sh
BKlog null oraicr1.sh scheoraicr0.sh. test
BKlog.tar oraarch. sh oraicr1.sh. orig scheoraicr1.sh
DBArchivelogBK. sh oraarch. sh. BK091206 oraicr1v. sh scheoraicr1.sh. test
DBArchivelogBK1130.sh oraarch. sh. yt oraicr2.sh scheoraicr1v. sh
DBFileBK_full.sh oraarch2.sh recover. sh scheoraicr2.sh
Backup20130428.log oraarchyzz. sh refull. sh scheoraicr2.sh. test
Nihao. c orafull. sh schearch. sh tdpora.tar
Nihao. sh orafull. sh.20120912combak schearch. sh. bak test. sh
Nihao02.sh orafull. sh. BK091206 scheorafull. sh
[Oraprod @ db01 scripts] $ rman target/catalog rman/rman @ rman log = backup2013_05_01.log
RMAN> @ oraarchyzz. sh
Database 02
[Oraprod @ db02 archivelog] $ pwd
/U01/archivelog
[Oraprod @ db02 archivelog] $ cat backuparc. SQL
Run {
#### Backup archivelog ####
Allocate channel t1 type 'sbt _ tape 'parms' ENV = (TDPO_OPTFILE =/usr/tivoli/tsm/client/oracle/bin64/tdpo. opt )'
Connect backup/bk1949coal @ PROD1;
Allocate channel t2 type 'sbt _ tape 'parms' ENV = (TDPO_OPTFILE =/usr/tivoli/tsm/client/oracle/bin64/tdpo. opt )'
Connect backup/bk1949coal @ PROD2;
Backup filesperset 10
(Archivelog all skip inaccessible delete input format '/arch _ % s _ % p /');
Release channel t1;
Release channel t2;
}
[Oraprod @ db02 archivelog] $ rman target/catalog rman/rman @ rman log = backup20130501.log
PS: manual backup of archive logs. Each time the logs are backed up from the latest archive log, they are used before the backup. If the backup is omitted earlier, the backup may not be backed up every time it is executed. In this case, you may need to execute the cross-check command to confirm how many backup logs are successfully backed up in the system,
Crosscheck archivelog all;
Crosscheck backupset;
Enter rman:
List backup of archivelog all;
List backup of archivelog sequence 6474;
RMAN> list backup of archivelog from sequence 100425627276 thread 2;
RMAN> list backup of archivelog all; ------------ list all archived logs
RMAN> list backup of archivelog from sequence 8116 thread 2; ------------ list an archived log
List of Backup Sets
==============================
BS Key Size Device Type Elapsed Time Completion Time
-------------------------------------------------------
1728048 11.14G SBT_TAPE 00:16:16 06-SEP-13
BP Key: 1728052 Status: AVAILABLE Compressed: NO Tag: TAG20130906T091351
Handle:/arch_40509_1/Media: 103
List of Archived Logs in backups set 1728048
Thrd Seq Low SCN Low Time Next SCN Next Time
-------------------------------------------------
2 7774 100425627276 06-SEP-13 100431144864 06-SEP-13
RMAN>
It should have been deleted after archiving log backup. Is there no cross-check?
Crosscheck archivelog all;
Delete archivelog all completed before 'sysdate-7 ';