Home
All Oracle Error Codes
Oracle DBA Forum

Frequent Oracle Errors

TNS:could not resolve the connect identifier specified
Backtrace message unwound by exceptions
invalid identifier
PL/SQL compilation error
internal error
missing expression
table or view does not exist
end-of-file on communication channel
TNS:listener unknown in connect descriptor
insufficient privileges
PL/SQL: numeric or value error string
TNS:protocol adapter error
ORACLE not available
target host or object does not exist
invalid number
unable to allocate string bytes of shared memory
resource busy and acquire with NOWAIT specified
error occurred at recursive SQL level string
ORACLE initialization or shutdown in progress
archiver error. Connect internal only, until freed
snapshot too old
unable to extend temp segment by string in tablespace
Credential retrieval failed
missing or invalid option
invalid username/password; logon denied
unable to create INITIAL extent for segment
out of process memory when trying to allocate string bytes
shared memory realm does not exist
cannot insert NULL
TNS:unable to connect to destination
remote database not found ora-02019
exception encountered: core dump
inconsistent datatypes
no data found
TNS:operation timed out
PL/SQL: could not find program
existing state of packages has been discarded
maximum number of processes exceeded
error signaled in parallel query server
ORACLE instance terminated. Disconnection forced
TNS:packet writer failure
see ORA-12699
missing right parenthesis
name is already used by an existing object
cannot identify/lock data file
invalid file operation
quoted string not properly terminated

RE: RMAN backup of archived log fails

Ken Naim

2007-05-28

Replies:
Perform a crosscheck which should sync the catalog to the file system.

Ken

-----Original Message-----
From: oracle-l-bounce@(protected)]
On Behalf Of Tony van Lingen
Sent: Monday, May 28, 2007 9:57 PM
To: oracle-l@(protected)
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-19625: error identifying file
C:\ORA02\ORAARCH\PRD2\1_49911_579631123.DBF
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
---- ------- ---------- --------- ---------- ---------
1   49910  1027045799 30/APR/07 1027170213 30/APR/07

BS Key Size     Device Type Elapsed Time Completion 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
---- ------- ---------- --------- ---------- ---------
1   49911  1027170213 30/APR/07 1027622380 01/MAY/07
1   49912  1027622380 01/MAY/07 1028243184 01/MAY/07
1   49913  1028243184 01/MAY/07 1028327534 01/MAY/07
1   49914  1028327534 01/MAY/07 1028435075 01/MAY/07
1   49915  1028435075 01/MAY/07 1028485654 01/MAY/07
1   49916  1028485654 01/MAY/07 1028485809 01/MAY/07
1   49917  1028485809 01/MAY/07 1028485966 01/MAY/07
1   49918  1028485966 01/MAY/07 1028486121 01/MAY/07
1   49919  1028486121 01/MAY/07 1028486277 01/MAY/07
1   49920  1028486277 01/MAY/07 1028486439 01/MAY/07

RMAN>

Target database:
----------------
SQL> select sequence#, archived, status, backup_count from
v$archived_log where sequence# between 49910 and 49920 ;

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