Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: BIG PROBLEM

RE: BIG PROBLEM

From: George Hofilena <GHofilena_at_cnv.org>
Date: Fri, 29 Jun 2001 14:18:03 -0700
Message-ID: <F001.0033E2A2.20010629142335@fatcity.com>

>One possible reason is that someone might have deleted some archived logs
>before doing a backup ...

the ex-DBA? :)

-----Original Message-----
Sent: Friday, June 29, 2001 1:17 PM
To: Multiple recipients of list ORACLE-L

One possible reason is that someone might have deleted some archived logs before doing a backup ...
solution:
log into rman

     rman rcvcat rman/password target /
change archivelog all crosscheck;
allocate channel for maintenance type 'SBT_TAPE'; delete expired backup;
exit

the above is for a separate rman database running on a sun box using a netbackup tape system ...

hth

Nechama Glasrot
Oracle DBA
Seisint, Inc.
6601 Park of Commerce Blvd.
Boca Raton, Florida 33487
nglasrot @seisint.com <mailto:nglasrot_at_seisint.com> Direct 561.999.3977
Main 561.999.4400
Fax 561.999.4695  

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

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.

This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format.
Thank you

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Glasrot, Nechama
  INET: NGlasrot_at_seisint.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: George Hofilena
  INET: GHofilena_at_cnv.org

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 - 16:18:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US