| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN backup of archived log fails
sounds like a bug. try oracle support. if the original backup command backed it up, and the backup is part of the catalog already, the backup archivelog delete all input shouldn't think it still needs to back it up. it is confused apparently, and not including this backup in its calculations about what it still needs.
from your "list" command, it seems it is aware of the backup from a reporting perspective, but not from a calculation about what needs to be backed up.
probably two separate code paths. produce a simple test case that reproduces this and send it to support.
if you get the error, it must be a bug (or a consequence of #2 that should be documented).
Job
Ken Naim <kennaim_at_gmail.com> wrote: Perform a crosscheck which should sync the catalog to the file system.
Ken
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Tony van Lingen
Sent: Monday, May 28, 2007 9:57 PM
To: oracle-l_at_freelists.org
Subject: RMAN backup of archived log fails
G'day all.
I've spent all day yesterday and today trying to figure this out - but no luck. Has anyone seen this before, or maybe a hint where to look? I've tried all Oracle doco, google, the list archives, etc. (but maybe my search terms are off..)
Versions are:
Oracle RDBMS 10.1.0.4 (both target, catalog and RMAN itself)
NetBackup: 5.1
Target OS: MS Windows 2003 sp 1
Catalog OS: RedHat Enterprise Linux 4
Some time ago we ran out of space on our archive log destination, due to ongoing problems with NetBackup and the Dell tape libraries.. that's now fixed and we backup up the archived log files by specifying sequence ranges (via NetBackup), as in
RMAN> backup archivelog until sequence #### delete input;
All backlog files are now backed up, but when we run the normal job, which has "backup archivelog all delete input", it fails complaining that it cannot find a file which was backup up with the sequence limited command. This is the error:
released channel: ch00
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ===========================================================RMAN-03002: failure of backup command at 05/29/2007 09:34:51 RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 2) The system cannot find the file specified.
Both the database and the catalog say that the file it complaints about are backed up:
Catalog:
RMAN> list backup of archivelog from sequence 49910 until sequence 49920;
List of Backup Sets
BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ---------------
767842 9M SBT_TAPE 00:00:51 28/MAY/07
BP Key: 767869 Status: AVAILABLE Compressed: NO Tag:
TAG20070528T152841
Handle: arch-s3807-p1 Media: 0282L2
List of Archived Logs in backup set 767842
Thrd Seq Low SCN Low Time Next SCN Next Time
768511 95M SBT_TAPE 00:00:59 28/MAY/07
BP Key: 768634 Status: AVAILABLE Compressed: NO Tag:
TAG20070528T164226
Handle: arch-s3918-p1 Media: 0282L2
List of Archived Logs in backup set 768511
Thrd Seq Low SCN Low Time Next SCN Next Time
SEQUENCE# ARC S BACKUP_COUNT
---------- --- - ------------
49910 YES D 1
49911 YES D 1
49912 YES D 1
49913 YES D 1
49914 YES D 1
49915 YES D 1
49916 YES D 1
49917 YES D 1
49918 YES D 1
49919 YES D 1
49920 YES D 1
-- Tony van Lingen EPA Queensland. ___________________________ Disclaimer WARNING: This e-mail (including any attachments) has originated from a Queensland Government department and may contain information that is confidential, private, or covered by legal professional privilege, and may be protected by copyright. You may use this e-mail only if you are the person(s) it was intended to be sent to and if you use it in an authorised way. No one is allowed to use, review, alter, transmit, disclose, distribute, print or copy this e-mail without appropriate authority. If you have received this e-mail in error, please inform the sender immediately by phone or e-mail and delete this e-mail, including any copies, from your computer system network and destroy any hardcopies. Unless otherwise stated, this e-mail represents the views of the sender and not the views of the Environmental Protection Agency. Although this e-mail has been checked for the presence of computer viruses, the Environmental Protection Agency provides no warranty that all viruses have been detected and cleaned. Any use of this e-mail could harm your computer system. It is your responsibility to ensure that this e-mail does not contain and is not affected by computer viruses, defects or interference by third parties or replication problems (including incompatibility with your computer system). E-mails sent to and from the Environmental Protection Agency will be electronically stored, managed and may be audited, in accordance with the law and Queensland Government Information Standards (IS31, IS38, IS40, IS41 and IS42) to the extent they are consistent with the law. ___________________________ -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l --------------------------------- Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on us. -- http://www.freelists.org/webpage/oracle-lReceived on Tue May 29 2007 - 12:38:17 CDT
 |
 |