RE: BIG PROBLEM

From: Guerra, Abraham J <AGUERRA_at_amfam.com>
Date: Fri, 29 Jun 2001 12:36:04 -0700
Message-ID: <F001.0033E0C4.20010629124626@fatcity.com>

Ask HR to hire the Oracle DBA back with double salary! Abraham

-----Original Message-----

Sent: Friday, June 29, 2001 3:13 PM
To: Multiple recipients of list ORACLE-L

ED,

Not what I'd call a big problem, but it is one that will need fixing. What
RMAN is complaining about is that it has a need to backup the archive file
listed and it can't find it in the archive_log_dest. Now I can understand that
you may not want it backing up that file, but it needs it and any generated
thereafter. I'm afraid that you'll have to put them back or change the command
your using to have RMAN ignore all archive files. It's just trying to put
together a backup set that can be used for a recovery, that's all.

Dick Goulet

____________________Reply Separator____________________
Author: "Edward W. Carr" <ecarr_at_qwest.com>
Date:       6/29/2001 11:51 AM

Hello all, I just joined this list today and am in need of desperate help!!!
In its infinite wisdom HR decided to lay off our only oracle dba!!!

I am trying to get some backups working on our database using rman. It seems to backup our datafiles ok, but I am getting the following error
...

RMAN-03022: compiling command: backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: backup
RMAN-06089: archived log /oradata/bdw/disk01/archive/bdw_1_24445.arc not

found or out of sync with catalog

The problem here is twofold:
1) It is looking in the wrong directory for the archive logs 2) We have been moving old archive logs off of the server to another server
to keep the disk from filling up while we were working on this backup problem, so I do not want it looking for the old logs.

As I am not a DBA I have no clue how to fix this, but it needs to be done
A.S.A.P. ...

Thanks to anyone who can help me!!!

Edward W. Carr
UNIX Systems Administrator
Qwest Communications
Broadband Services Inc.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Guerra, Abraham J
INET: AGUERRA_at_amfam.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jun 29 2001 - 14:36:04 CDT