Check teh redo log size. It may be that the sizes of your redologs are
not big enough to hold the transaction in progress before commit. You
have several options.

1. Resize the Redo Logs.
2. Look for the transactions that is generating these redologs. If you
are inserting into table, use SQLLoader. If you are deleating table,
use Truncate.
3. look for "log_checkpoint_interval" ,
"log_checkpoint_timeout" & "log_checkpoints_to_alert"
parameter in the init.ora file.

Niaz
[Email address protected]
323-842-2146

> Dear Friends,
>
> we r having 9 instances in our group, in that one instance
yesterday for every 13 minutes 1 archive log created. i.e. total 115
logs . how to find out what is the operation is carried out for that
instance. today morning instance gone down and came up now for every 1
hr one archive log as normal.
>
> can anybody suggest me what was gone wrong yesterday to write that
115 archive log files and how to trace what was the operation
>
> Regards
>
>
>
> Mohamed Ayub
> IT Division, Al Mulla Group
> Kuwait.
>
> Disclaimer :
>
> This e.mail message may contain confidential, proprietary or legally
privileged information. It should not be used by anyone who is not the
original intended recipient. If you have erroneously received this
message, please delete it immediately and notify the sender. The
recipient acknowledges that Al Mulla Group or its subsidiaries and
associated companies*, are unable to exercise control or ensure or
guarantee the integrity of / over the contents of the information
contained in e.mail transmissions and further acknowledges that any
views expressed in this message are those of the individual sender and
no binding nature of the message shall be implied or assumed unless the
sender does so expressly with due authority of Al Mulla Group. Before
opening any attachments please check them for viruses and defects.
>
> * List of Companies covered under Al Mulla Group of Companies.
> 1. Bader Al Mulla & Brothers Co. W.L.L.
> 2. Saleh Jamal & Co. W.L.L
> 3. Maseelah Trading Co. W.L.L
> 4. Al Mulla Rental & Leasing of Vehicles & Equipment Co. WL.L.
> 5. Al Mulla International Trading & Contracting Co. W.L.L
> 6. Al Mulla Cleaning & Maintenance Service Co. W.L.L
> 7. Gulf Trading Group W.L.L.
> 8. Al Mulla Insurance, Reinsurance & Broking Co. W.L.L.
> 9. Al Mulla Consultancy Co. W.L.L.
> 10. Al Mulla Environmental Systems W.L.L
> 11. Al Mulla Real Estate
> 12. Al Mulla Security Services Co. W.L.L.
> 13. Al Mulla International Exchange Co.
>
>
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>



Oracle LazyDBA home page