Independent backup and cross-validation of mongolerman backup logs

Source: Internet
Author: User

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 ';

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.