REDO Logs Again
From: Eva Vanderwerf <evanderw_at_mpr.ca>
Date: 25 Jun 92 03:04:53 GMT
Message-ID: <1992Jun25.030453.18329_at_mprgate.mpr.ca>
Date: 25 Jun 92 03:04:53 GMT
Message-ID: <1992Jun25.030453.18329_at_mprgate.mpr.ca>
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.caReceived on Thu Jun 25 1992 - 05:04:53 CEST