Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: status of archive (newbie)
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...........
>
select * from v$database, will give info on archivelog or noarchivelog mode. I assume you are running in noarchivelog mode, or your database would come to a halt (update|insert only) when all online redologs are full, and the archiver is unsuccessfull in archiving (disk full?). /svend Jensen Received on Sun Feb 17 2002 - 05:41:11 CST