Re: REDO Logs Again
Date: Thu, 25 Jun 92 20:10:30 GMT
Message-ID: <1992Jun25.201030.10128_at_sequent.com>
evanderw_at_mpr.ca (Eva Vanderwerf) writes:
>HI,
> I posted earlier on how to resolve the warning message
> 'Cannot allocate new log, needs checkpointing...'
> Thanks for all who offered advice. I have created two new
> redologs of a larger size, and have dropped my two old ones,
> and everything seems to work.
> My question: How do I know for sure which redo logs are active?
> the SYS.DBA_DATA_FILES table only lists tablespaces, there's nothing
> in 'show parameters' or in 'monitor' which tells me which log
> it is currently on, and which are available.
> Thanks for any help you can give me.
>--
>--------------------------------+----------------------------------
>Eva Vanderwerf | Voice : (604) 293-6072
>MPR Teltech Ltd. 8999 Nelson Way| FAX : (604) 293-5787
>Burnaby, BC, Canada, V5A 4B5 | Internet : evanderw_at_mprgate.mpr.ca
You can select from v$logfile. Or, look at the lgwr trace file to see the advancement from log to log. Received on Thu Jun 25 1992 - 22:10:30 CEST