Manually back up the archive log
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: Manually back up the archive log, each time from the most recent archive log to start the backup, before the backup, before the earlier missed backup may not be backed up every execution. In this case, you may need to perform a cross-check command to confirm how many backup logs have been successfully backed up,
Crosscheck Archivelog All;
Crosscheck backupset;
Into 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 archive logs
Rman>list backup of archivelog from sequence 8116 thread 2; ------------List an archive 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 backup set 1728048
THRD Seq Low SCN low time next SCN next
---- ------- ---------- --------- ---------- ---------
2 7774 100425627276 06-sep-13 100431144864 06-sep-13
Rman>
Should be archived log backup was deleted after it, did not do cross test?
Crosscheck Archivelog All;
Delete Archivelog all completed before ' sysdate-7 ';