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: SUMMARY: BIG PROBLEM

RE: SUMMARY: BIG PROBLEM

From: Edward W. Carr <ecarr_at_qwest.com>
Date: Fri, 29 Jun 2001 16:04:40 -0700
Message-ID: <F001.0033E3BC.20010629155520@fatcity.com>

Yea Right!! :) Might try and get something going with TUSC.

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

Hofilena
Sent: Friday, June 29, 2001 4:24 PM
To: Multiple recipients of list ORACLE-L

Does that mean you won't need an Oracle DBA anymore? :)

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

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

This worked great!!!

Thanks to all who replied!

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

Applewhite
Sent: Friday, June 29, 2001 2:21 PM
To: Multiple recipients of list ORACLE-L

Edward,

Your database backup is OK. RMan just can't backup and delete the archived redo logs that you moved.

If you want RMan to backup, then delete, those archived redo logs, you'll have to move them back to the drive from which they came. Then do another backup. If you've got lots of logs, it may take several "batches" to get them all.

If you just want to go forward, with RMan backing up and deleting the logs from now on, issue the following command at the RMan prompt:

 allocate channel for maintenance type disk;  change archivelog all crosscheck;
 release channel;

That will cause RMan to "forget about" the archived redo logs you've moved, but it will pick up with the logs that have since been created and are still in the expected directory.

Good luck.

Jack



Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
japplewhite_at_inetprofit.com
(512)327-9068

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

Carr
Sent: Friday, June 29, 2001 2: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.

--

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

Author: Jack C. Applewhite
  INET: japplewhite_at_inetprofit.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: Edward W. Carr
  INET: ecarr_at_qwest.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).

--

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

Author: Edward W. Carr
  INET: ecarr_at_qwest.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 - 18:04:40 CDT

Original text of this message

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