Re: REDO logs

In article <34C50A0B.33EF31CB_at_jhuapl.edu>,   stan_novinsky_at_jhuapl.edu wrote:
>
> Is there a commnad that can tell you what REDO log is currently being
> written into. I
> checked the SYS.V$LOGFILE. This gives info for the ACTIVE, STALE, etc.
>
> Thanks

Hi,

Select from the v$log to check which logfiles are defined and which of them is current. The active logfile has the status "CURRENT". If you are using Unix, go the directory where logfiles are defined and see their time stamp. The one with the latest timestamp is currently in use. Alternatively go the alert.log file in the bdump directory and look for a log switch. It will also give you information on the current log file.

I hope this helps.
Bye
Ajit Singh
Sr. System & DBA

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet