Home » RDBMS Server » Backup & Recovery » Archive Log Errors (11g , Solaris 10)
Archive Log Errors [message #502683] Fri, 08 April 2011 01:56 Go to next message
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


Re: Archive Log Errors [message #502684 is a reply to message #502683] Fri, 08 April 2011 02:03 Go to previous messageGo to next message
Michel Cadot
Messages: 59749
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Archive Log Errors [message #502685 is a reply to message #502684] Fri, 08 April 2011 02:09 Go to previous messageGo to next message
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,,!!
Re: Archive Log Errors [message #502780 is a reply to message #502685] Sat, 09 April 2011 09:14 Go to previous messageGo to next message
babuknb
Messages: 1734
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
Re: Archive Log Errors [message #502795 is a reply to message #502780] Sat, 09 April 2011 20:24 Go to previous messageGo to next message
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
Re: Archive Log Errors [message #502798 is a reply to message #502795] Sat, 09 April 2011 21:31 Go to previous messageGo to next message
babuknb
Messages: 1734
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 
Re: Archive Log Errors [message #502824 is a reply to message #502798] Sun, 10 April 2011 11:11 Go to previous message
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.

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


Current Time: Sun Nov 23 07:59:49 CST 2014

Total time taken to generate the page: 0.08797 seconds