Re: SUMMARY: BIG PROBLEM
devil's advocate here. Having worked on budgets, and been management (hopefully NOT damagement) in my career: full time employees have all sorts of additional costs. consultants can be fired at will. They also hit different budget lines -- non-fixed costs vs fixed costs. this is not to say that firing a full-timer and hiring a consultant is always the right decision, in fact, it usually is the WRONG one. But for very short-term things, and with downsizing going on, it is sometimes the only option. >From: Suzy Vordos <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: SUMMARY: BIG PROBLEM >Date: Tue, 07 Aug 2001 22:00:24 -0800 > > >Yep, that was me :) I left Qwest (formerly U S WEST) last year, one day >after my 19 year anniversary. No regrets, my new job challenges my >skills and keeps me busy (but leaves little time for beer). Geesh, here >it is August and I'm finally reading oracle-l from June... > > >John Kanagaraj wrote: > > > > Ed, > > > > >Yea Right!! :) Might try and get something going with TUSC. > > > > Don't the BeanCounters and Damagement know that this would probably cost > > more than retaining that other DBA??! (Was that Suzy Vordos at QWest?) > > Another pointy-haired decision IMHO. > > > > Apologies in advance to TUSCers in this list... > > > > John Kanagaraj > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: John Kanagaraj > > INET: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: Suzy Vordos > INET: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: SUMMARY: BIG PROBLEM
Yep, that was me :) I left Qwest (formerly U S WEST) last year, one day after my 19 year anniversary. No regrets, my new job challenges my skills and keeps me busy (but leaves little time for beer). Geesh, here it is August and I'm finally reading oracle-l from June... John Kanagaraj wrote: > > Ed, > > >Yea Right!! :) Might try and get something going with TUSC. > > Don't the BeanCounters and Damagement know that this would probably cost > more than retaining that other DBA??! (Was that Suzy Vordos at QWest?) > Another pointy-haired decision IMHO. > > Apologies in advance to TUSCers in this list... > > John Kanagaraj > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: John Kanagaraj > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Suzy Vordos INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: SUMMARY: BIG PROBLEM
Ed, >Yea Right!! :) Might try and get something going with TUSC. Don't the BeanCounters and Damagement know that this would probably cost more than retaining that other DBA??! (Was that Suzy Vordos at QWest?) Another pointy-haired decision IMHO. Apologies in advance to TUSCers in this list... John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: SUMMARY: BIG PROBLEM
Already started the Level 0 ... Thanks Guys ... -Original Message- Applewhite Sent: Friday, June 29, 2001 4:31 PM To: Multiple recipients of list ORACLE-L Edward, I don't want to lead you astray. I said your database backups were OK, but if your recent backups were incremental - anything short of a full or Level 0 backup - they cannot be used for recovery without those archived redo logs. If you executed the "change archivelog all crosscheck;" command, then you'll need to do a full cold or Level 0 backup and get all the archived redo logs during that operation to have a good backup. You'll also need to ensure that you keep backing up all archived redo logs from now on. Please tell your HR dept. for me that they are idiots and I said they need to get you a good DBA!8^) Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Carr Sent: Friday, June 29, 2001 4: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 [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: SUMMARY: BIG PROBLEM
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 [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] Fat City Network Services-- (858) 538
RE: SUMMARY: BIG PROBLEM
WAIT UNTIL YOU NEED TO RECOVER! -Original Message- Sent: Friday, June 29, 2001 5: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 [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Khedr, Waleed INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: SUMMARY: BIG PROBLEM
Why don't you cc: copy your e-mail to your HR. Just one look at the subject line will make them to realize what they've done... ;-) -Original Message- Sent: Friday, June 29, 2001 6: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 [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: INET: [EMAIL P
RE: SUMMARY: BIG PROBLEM
Edward, I don't want to lead you astray. I said your database backups were OK, but if your recent backups were incremental - anything short of a full or Level 0 backup - they cannot be used for recovery without those archived redo logs. If you executed the "change archivelog all crosscheck;" command, then you'll need to do a full cold or Level 0 backup and get all the archived redo logs during that operation to have a good backup. You'll also need to ensure that you keep backing up all archived redo logs from now on. Please tell your HR dept. for me that they are idiots and I said they need to get you a good DBA!8^) Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Carr Sent: Friday, June 29, 2001 4: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 [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: SUMMARY: BIG PROBLEM
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 [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: SUMMARY: BIG PROBLEM
Does that mean you won't be needing an Oracle DBA anymore? :) George -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 [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).