From ecarr@qwest.com Fri, 29 Jun 2001 13:20:49 -0700 From: "Edward W. Carr" Date: Fri, 29 Jun 2001 13:20:49 -0700 Subject: SUMMARY: BIG PROBLEM Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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@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@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@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@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@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).