Home » RDBMS Server » Backup & Recovery » RMAN expected archived log not found (Oracle)
RMAN expected archived log not found [message #442038] Thu, 04 February 2010 08:25 Go to next message
danielgrigoras
Messages: 4
Registered: February 2010
Junior Member
I receive everyday messages after back up manager finished the job. After I delete some file from detabase I started to receive this messages where back up has failed:

Starting backup at 04-FEB-10
current log archived
released channel: dev_0
released channel: dev_1 released channel: dev_2
released channel: dev_3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 02/04/2010 06:03:12
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file D:\ORACLE\ADMIN\OPERA\ARCHIVE\OPERAT001S003710609523929.ARC
ORA-27041: unable to open file
OSD-04002: unable to open file

what is the solution? I'm new in this business and maybe someone can give me a hand. Cheers

[Updated on: Thu, 04 February 2010 08:28]

Report message to a moderator

Re: RMAN expected archived log not found [message #442043 is a reply to message #442038] Thu, 04 February 2010 09:16 Go to previous messageGo to next message
entekeralam
Messages: 19
Registered: January 2010
Junior Member
Did you try...

crosscheck archivelog all;
and
delete expired;
from RMAN

[Updated on: Sat, 06 February 2010 09:38] by Moderator

Report message to a moderator

Re: RMAN expected archived log not found [message #442232 is a reply to message #442043] Fri, 05 February 2010 11:33 Go to previous messageGo to next message
danielgrigoras
Messages: 4
Registered: February 2010
Junior Member
./fa/7421/0/

I tried that but I think I need the target
Re: RMAN expected archived log not found [message #442242 is a reply to message #442232] Fri, 05 February 2010 20:13 Go to previous messageGo to next message
entekeralam
Messages: 19
Registered: January 2010
Junior Member
You have to connect to target

rman target /

RMAN> crosscheck archivelog all;

RMAN> delete expired archivelog all;
Re: RMAN expected archived log not found [message #442360 is a reply to message #442242] Sun, 07 February 2010 06:42 Go to previous messageGo to next message
danielgrigoras
Messages: 4
Registered: February 2010
Junior Member
Bellow I inserted part of the error messages from rman, I know that sound stupid but which one is the target and how do I type it in the RMAN> ?


[Major] From: ob2rman@jerzr-operadb.jerr.rezidor.com[/email] "opera" Time: 07/02/2010 06:09:48
Oracle Recovery Manager completed with errors.

[Major] From: ob2rman@jerzr-operadb.jerr.rezidor.com[/email] "opera" Time: 07/02/2010 06:09:48
Backup of target database failed.

Report Messages Other Than Normal [jerzr-dc.jerr.rezidor.com]:

[Warning] From: VBDA@jerzr-dc.jerr.rezidor.com[/email] "jerzr-dc.jerr.rezidor.com [/CONFIGURATION]" Time: 07/02/2010 01:00:49
Volume Shadow Copy backup is not supported for CONFIGURATION object.

Report Messages Other Than Normal [jerzr-operadb.jerr.rezidor.com]:

[Warning] From: VBDA@jerzr-operadb.jerr.rezidor.com[/email] "jerzr-operadb.jerr.rezidor.com [/CONFIGURATION]" Time: 07/02/2010 01:03:45
Volume Shadow Copy backup is not supported for CONFIGURATION object.
icon12.gif  Re: RMAN expected archived log not found [message #442578 is a reply to message #442360] Tue, 09 February 2010 03:32 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Why don't you post the image of the command window showing the RMAN errors? Mad

[Updated on: Tue, 09 February 2010 03:33]

Report message to a moderator

Re: RMAN expected archived log not found [message #444168 is a reply to message #442038] Fri, 19 February 2010 01:08 Go to previous messageGo to next message
pokhraj_d
Messages: 117
Registered: December 2007
Senior Member
Hi,
you can run the below command from rman:-

1. rman [Press Enter]
2. Connect catalog ID/PWD
3. Connect target /
4. run
{Allocate channel ch1 type disk format '%U';
crosscheck archivelog all;
backup database plus archivelog all;
release channel ch1;
}

Thanks-
P
Re: RMAN expected archived log not found [message #444231 is a reply to message #444168] Fri, 19 February 2010 08:49 Go to previous message
danielgrigoras
Messages: 4
Registered: February 2010
Junior Member
HI and thank you, this explination looks much clear, however to explain better: I have 6 servers are backed up by RMAN, the RMAN is running from my Domain Controler, the errors are coming to my e-mail are because of server called OperaDetabase. Now I tried to connect catalog with the password and log in ID from this server but rman says error, wrong id or password. Do I do the right thing?
Previous Topic: How to transfer RMAN backup from tape to disk
Next Topic: Database fail
Goto Forum:
  


Current Time: Fri Dec 09 15:13:21 CST 2016

Total time taken to generate the page: 0.40804 seconds