Database Software

Hello,

I am not an Oracle DBA so I apologize for incompetence beforehand. This has fallen into my queue and I need to get it resolved if possible

I have an RMAN backup that is failing with the below error.

RMAN-03090: Starting backup at 30-JUN-12
RMAN-03033: current log archived
RMAN-08031: released channel: dev_0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 06/29/2012 14:42:35
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /opt/oracle/app/oracle/archive_logs/1_8761_670889647.dbf
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

I checked on the Oracle server and in fact the file it's looking for is not there.

I found a link stating that to fix this I need to run

RMAN>crosscheck copy of archivelog all;

Once the crosscheck command is executed successfully, we have to take the full backup of the database.

As I said I am not an Oracle DBA so I would like to know if there are any experienced DBA's out there that would suggest against or for this procedure?

Is there anything else I should try? What I am trying to avoid is doing any damage while trying to fix the issue. I have been reading RMAN documentation and it is a bit overwhelming trying to absorb the info in a short period of time.


Thank you

I have just seen that my filesystem where the archive logs are kept is full..Possibly the reason why archive logs are missing. Is there an intelligent way that I can free up space from this filesystem? How can I delete these archive logs, do a cold backup, and start the RMAN backups again?

Thanks

Edited by: user6240738 on Jul 6, 2012 12:25 PM