Home » RDBMS Server » Backup & Recovery » RMAN-06059: expected archived log not found (Recovery Manager: 10.2.0.3.0)
RMAN-06059: expected archived log not found [message #343519] Wed, 27 August 2008 08:10 Go to next message
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
Re: RMAN-06059: expected archived log not found [message #343520 is a reply to message #343519] Wed, 27 August 2008 08:14 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

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


Re: RMAN-06059: expected archived log not found [message #343537 is a reply to message #343520] Wed, 27 August 2008 08:37 Go to previous messageGo to next message
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..)
Re: RMAN-06059: expected archived log not found [message #343555 is a reply to message #343537] Wed, 27 August 2008 09:14 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

RMAN>crosscheck copy;
RMAN> delete expired copy;


check above commands.
Re: RMAN-06059: expected archived log not found [message #343589 is a reply to message #343555] Wed, 27 August 2008 10:33 Go to previous messageGo to next message
sparacello
Messages: 3
Registered: August 2008
Location: Turin
Junior Member

Well.. it seems it work Smile
Thank you
Re: RMAN-06059: expected archived log not found [message #343729 is a reply to message #343589] Wed, 27 August 2008 23:36 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

You'r welcome.
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:
  


Current Time: Sat Dec 03 05:53:23 CST 2016

Total time taken to generate the page: 0.09710 seconds