Re: archivr logs in archive directory ziped?

David, I guess you'll find that the 'arc' suffix on file names has been associated with the WINZIP program. The Oracle archived log files are not actually zipped, they just look like they are.

If you had set 'log_archive_format' to %%ORACLE_SID%%S.DOC, then MS-Word would probably try to open the archives and report them as invalid documents.

Change the 'log_archive_format' setting to something else - for example %%ORACLE_SID%%S.ALF [ archived log file ] - that most likely won't be associated with any current program.

HTH JR
Jeremy_Russell_at_dci-ltd.com

David Spaisman <davedba_at_intercall.com> wrote:

>Hello:
>
>I have restarted working on practicing hot backups and recovery today on
>a development database established.
>
> I noticed that the archive files is zipped(by winzip) in the archive
>directory and the fil header on the zip file sems to be invalid and
>corrupted . In looking at the init ora file I see that I was using
>log_archive_format = %%ORACLE_SID%%S.ARC instead of something else.
>
> I will try %%ORACLE_SID%%T%TS%S.ARc and see if the same thing happens
> tomorrow.
>
> What format should I use for the log_archive_format paramater in the
>init
> ora file on my application so that the archive logs are readable? Has
>any one else experienced something like this?
>
> Thanks.
>David Spaisman
>
Received on Thu Apr 22 1999 - 08:25:29 CDT