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

Home » RDBMS Server » Backup & Recovery » RMAN-06059: expected archived log not found (Recovery Manager: 10.2.0.3.0)

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

RMAN-06059: expected archived log not found [message #343519]

Wed, 27 August 2008 08:10

sparacello
Messages: 3
Registered: August 2008
Location: Turin

Junior Member

Hi folk.
I'm a beginner DBA with no knowldedge about rman.
I implemented a "data protector" instance who back up archivelog file.

I don't know what happen but I get this error

RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /prp2/ARCHIVE/TPRP001M/arch/arch_634479320_1_24338.arc
ORA-27037: unable to obtain file status

It is a just-imported DB so I'm not interested in preserve data, I can import again. But
How I can say rman that it have to ignore file /prp2/ARCHIVE/TPRP001M/arch/arch_634479320_1_24338.arc missing?
Where rman keep trace of archive files?

thanks, Gianluca

Report message to a moderator

Re: RMAN-06059: expected archived log not found [message #343520 is a reply to message #343519]

Wed, 27 August 2008 08:14

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

RMAN> crosscheck archivelog all;
RMAN> delete noprompt archivelog all;

Report message to a moderator

Re: RMAN-06059: expected archived log not found [message #343537 is a reply to message #343520]

Wed, 27 August 2008 08:37

sparacello
Messages: 3
Registered: August 2008
Location: Turin

Junior Member

thanks a lot.
This is what I did first.

I did it again now.
Rman deleted these files..
which are file I currently have on
/prp2/ARCHIVE/TPRP001M/arch/

/prp2/ARCHIVE/TPRP001M/arch/arch_634479320_1_24637.arc
/prp2/ARCHIVE/TPRP001M/arch/arch_634479320_1_24638.arc
/prp2/ARCHIVE/TPRP001M/arch/arch_634479320_1_24639.arc
..and so on

But error still tell me that I miss
arch_634479320_1_24338.arc (which are not in /prp2/ARCHIVE/TPRP001M/arch/ directory..)

Report message to a moderator

Re: RMAN-06059: expected archived log not found [message #343555 is a reply to message #343537]

Wed, 27 August 2008 09:14

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

RMAN>crosscheck copy;
RMAN> delete expired copy;

check above commands.

Report message to a moderator

Re: RMAN-06059: expected archived log not found [message #343589 is a reply to message #343555]

Wed, 27 August 2008 10:33

sparacello
Messages: 3
Registered: August 2008
Location: Turin

Junior Member

Well.. it seems it work Smile

Thank you

Report message to a moderator

Re: RMAN-06059: expected archived log not found [message #343729 is a reply to message #343589]

Wed, 27 August 2008 23:36

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

You'r welcome.

Report message to a moderator

Previous Topic:	Restore fails with ORA-19870 ORA-19587, ORA-27091, ORA-27067
Next Topic:	Restore 9i rman backups to 10g excutable on host2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 28 20:12:02 CDT 2024