Redo Log File Error
Date: Mon, 15 Jun 92 16:34:27 GMT
Message-ID: <1992Jun15.163427.2118_at_mprgate.mpr.ca>
Hi, I've been getting the following message in by lgwr.trc file:
...
I imagine that I need to either add another log-file, increase the
size of the files, or decrease the log_checkpoint_interval variable.
I have the default log-files right now: 2 of 500K.
All my log-variables in INIT.ORA are defaults. I've read and mostly
understood the chapters regarding Redo Logs in the DBA Manual, but was
wondering if anyone else has any friendly words of advice, before I start
changing things.
Thanks in advance, please post or email.
Advanced to log sequence 5815 file /usr/local/oracle/dbs/log1P.dbf
Advanced to log sequence 5816 file /usr/local/oracle/dbs/log2P.dbf
Mon Jun 15 01:13:04 1992
cannot allocate new log, seq 5817, needs checkpointing
Advanced to log sequence 5817 file /usr/local/oracle/dbs/log1P.dbf
...
--
--------------------------------+----------------------------------
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
Received on Mon Jun 15 1992 - 18:34:27 CEST