OraFAQ Forum: Backup & Recovery » Archive Log Errors

Home » RDBMS Server » Backup & Recovery » Archive Log Errors (11g , Solaris 10)

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

Archive Log Errors [message #502683]

Fri, 08 April 2011 01:56

sanjaysatish
Messages: 4
Registered: April 2011
Location: INDIA

Junior Member

Hi All,

I am trying to take backup of archive logs but its showing the below error, clearly stating that archive 13762 is missing.
But that file is not there as its been deleted accidentely.

*****************************************************************
Starting backup at 07-APR-11
current log archived
released channel: ch00
released channel: ch01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 04/07/2011 21:05:33
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /u001/oracle/test/arch/test_0000013762_707664977_1.arc
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

*****************************************************************

I am using RMAN to take archive backups.

I am NOW using the below backup command to take archive backup.

*****************************************
BACKUP
SKIP INACCESSIBLE
filesperset 20
FORMAT 'TEST_ARCH_%s_%p_%t'
ARCHIVELOG ALL DELETE INPUT;

*****************************************

My Database is having no issue but i wanted to avoid the below message in the log files.

" skipping inaccessible file /u001/oracle/TEST/arch/TEST_0000013762_707664977_1.arc
archived log /u001/oracle/TEST/arch/TEST_0000013763_707664977_1.arc not found or out of sync with catalog "

How can i go about it to achieve it.

Please do update any solution for the same and thanks for the replies in advance.

Thanks and Regards,
Sanjay

Report message to a moderator

Re: Archive Log Errors [message #502684 is a reply to message #502683]

Fri, 08 April 2011 02:03

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you have a missing archived log then you cannot recover from before it to after it.
So you can only recover just before the missing one (or after it if you have another incremental backup but only from the time of this backup).

Regards
Michel

Report message to a moderator

Re: Archive Log Errors [message #502685 is a reply to message #502684]

Fri, 08 April 2011 02:09

sanjaysatish
Messages: 4
Registered: April 2011
Location: INDIA

Junior Member

Thanks for Quick response Mr.Michel,,
As i understood the consequences in the coming days,, i am taking the full Database backup and all the archives present till date through RMAN,,, will that serve the purpose,,!!

Report message to a moderator

Re: Archive Log Errors [message #502780 is a reply to message #502685]

Sat, 09 April 2011 09:14

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

are you sure any other job running? deleted archivelog already backuped by RMAN? have you tried

crosscheck archivelog all

before taking backup?

thanks

Report message to a moderator

Re: Archive Log Errors [message #502795 is a reply to message #502780]

Sat, 09 April 2011 20:24

sanjaysatish
Messages: 4
Registered: April 2011
Location: INDIA

Junior Member

Sorry for Late reply Mr.Babu,

Well i dint used that command "crosscheck archivelog all" to check any non backed up archives. As i told the archives were deleted accidentally before backup and now i took a full RMAN Level 0 backup after archive log deletion, so that i can make a full recovery from that point during times, but still its showing the same error message as "archive 13762 is missing". when i take a RMAN archive log backup.

How can i go about further to avoid that message in my archive logs file.

Thanks

Report message to a moderator

Re: Archive Log Errors [message #502798 is a reply to message #502795]

Sat, 09 April 2011 21:31

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

do one think, follow the below process right away

1. crosscheck archivelog all;

2. delete expired archivelog all;

3. Take FULL backup

Report message to a moderator

Re: Archive Log Errors [message #502824 is a reply to message #502798]

Sun, 10 April 2011 11:11

sanjaysatish
Messages: 4
Registered: April 2011
Location: INDIA

Junior Member

I followed the steps you mentioned, and guess what my issue is resolved.

Thanks a Lot Mr. Babu and thanks to Mr. Michel also.

Report message to a moderator

Previous Topic:	ORACLE dump file to txt file
Next Topic:	Recovery Catalog

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 06:57:21 CST 2024