OraFAQ Forum: Backup & Recovery » RMAN expected archived log not found

Home » RDBMS Server » Backup & Recovery » RMAN expected archived log not found (Oracle)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN expected archived log not found [message #442038]

Thu, 04 February 2010 08:25

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

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

danielgrigoras
Messages: 4
Registered: February 2010

Junior Member

I tried that but I think I need the target

Attachment: clip_image002.jpg
(Size: 40.02KB, Downloaded 3005 times)

Report message to a moderator

Re: RMAN expected archived log not found [message #442242 is a reply to message #442232]

Fri, 05 February 2010 20:13

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;

Report message to a moderator

Re: RMAN expected archived log not found [message #442360 is a reply to message #442242]

Sun, 07 February 2010 06:42

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.

Report message to a moderator

Re: RMAN expected archived log not found [message #442578 is a reply to message #442360]

Tue, 09 February 2010 03:32

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

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

Report message to a moderator

Re: RMAN expected archived log not found [message #444231 is a reply to message #444168]

Fri, 19 February 2010 08:49

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?

Report message to a moderator

Previous Topic:	How to transfer RMAN backup from tape to disk
Next Topic:	Database fail

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 20:38:23 CST 2024