Oraclerman BACKUP LOG separate backup and cross check

Source: Internet
Author: User

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

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.