Re: status of archive (newbie)

type ARCHIVE LOG LIST (with dba privs),

check your init.ora for something like:

log_archive_start = true
log_archive_dest_1 = "location=D:\oracle\oradata\prod01\archive"
log_archive_format = %%ORACLE_SID%%T%TS%S.ARC

vze24462 wrote:
>
> Is there anyway to find out the status of the redo archive. The reason I
> asking the question is, the arch_to_destination directory used to
> genarated *.arc files is no longer generating *.arc anymore after the
> system crash 2 days ago. Any help very appreciated...........
Received on Sat Feb 16 2002 - 10:44:31 CST