PRODUCTION ARCHIVE LOG MISSING

[Former Member]

Hello,

From Production system,after every increment of 10 MB data,Archive logs are generated.

These archive logs are pushed from production to DR server using "XCOPY" command at a interval of every 15 min.

Archive log sequence number is 6 Digit

one archive log was not saved in the designated archive directory

Archive log number(ARC158139 Dt: 16/12/2010 10:00 A.M)is not available in our directory

Why this particular archive log was missed out our system? Please answer any one for this issue

Regards

M.Karthikkumar

+91 99401 87552

[volker_borowski2 · Accepted solution]

Hi,

> From Production system,after every increment of 10 MB data,Archive logs are generated.

Nothing wrong with that allthough this is quite frequently.

> Archive log sequence number is 6 Digit

I do not think so. Check parameter log_archive_format. the "1" is probaly the oracle instance number.

> These archive logs are pushed from production to DR server using "XCOPY" command at a interval of every 15 min.

HOW? Using /M or any other flags to prevent repeated copy?

Any mechanism included to avoid copying the file, before the archiver has finished writing to it?

Which is most likely the root cause with xcopy and the archiver accessing the same file.

Best regards

Volker

[Former Member]

hi,

you can write that;

sqlplus> show parameter dest

and;

why do u use to "xcopy"?

ferhan

[Former Member]

Hi Karthik,

If you follow Markus's advice and see that indeed the Oracle log was archived...then here's a possible scenario..

If Oracle could not archive the log then definitely you would experienced a hang and then maybe someone went in and manually cleaned things up to clear up the hanging issue...i.e. after making space available the log could be archived...

In the clean-up process the log may have been moved or deleted...just guessing...

Also, if someone was slick they might have done:

alter system set log_archive_dest = '/Path_to_new_Location'

Some food for thought...

[markus_doehr2]

> Archive log number(ARC158139 Dt: 16/12/2010 10:00 A.M)is not available in our directory

> Why this particular archive log was missed out our system? Please answer any one for this issue

Please check the Oracle alert<SID>.log and have a look if this log was archived.

Probably the log wasn't written completely and hence xcopy could not copy it and deleted it neverless. That could be ONE reason.

Markus