| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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
-----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 notfound 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!!!
-- 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-LReceived on Fri Jun 29 2001 - 16:20:55 CDT
(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).
 |
 |