اخواني ساعدوني كيف التعامل مع alert log file وكيف ومتى على انا امسحه

السلام عليكم


Oracle's alert.log

Oracle's

alert.log

chronologically records messages and errors arising from the daily database operation. Also, there are pointers to

trace files

and dump files.

These messages include

• startups and shutdowns of the instance
• Messages to the operator console
• Errors causing trace files.
• Create, alter and drop SQL statements on databases,tablespaces and rollback segments.
• Errors when a materialized view is refreshed.
• ORA-00600 (internal) errors.
• ORA-01578 errors (block corruption)
• ORA-00060 errors (deadlocks)
  

لا افضل ان يتم حذف الملف قبل الاحتفاظ بنسخه منه

السلام عليكم

                                        
                    Oracle's alert.log
                                                                                                                  

Oracle's

alert.log

chronologically records messages and errors arising from the daily database operation. Also, there are pointers to

trace files

and dump files.

                These messages include                

• startups and shutdowns of the instance
• Messages to the operator console
• Errors causing trace files.
• Create, alter and drop SQL statements on databases,tablespaces and rollback segments.
• Errors when a materialized view is refreshed.
• ORA-00600 (internal) errors.
• ORA-01578 errors (block corruption)
• ORA-00060 errors (deadlocks)
  

لا افضل ان يتم حذف الملف قبل الاحتفاظ بنسخه منه

بارك الله فيك بس اخر نقطه يعني يجب علي حذفه وعدم الاحتفاظ بنسخه يعني

تم تعديل 9 فبراير 201214 سنة بواسطة نور بوظبي

السلام عليكم


Oracle's alert.log

Oracle's

alert.log

chronologically records messages and errors arising from the daily database operation. Also, there are pointers to

trace files

and dump files.

These messages include

• startups and shutdowns of the instance
• Messages to the operator console
• Errors causing trace files.
• Create, alter and drop SQL statements on databases,tablespaces and rollback segments.
• Errors when a materialized view is refreshed.
• ORA-00600 (internal) errors.
• ORA-01578 errors (block corruption)
• ORA-00060 errors (deadlocks)
  

لا افضل ان يتم حذف الملف قبل الاحتفاظ بنسخه منه

بارك الله فيك بس اخر نقطه يعني يجب علي حذفه وعدم الاحتفاظ بنسخه يعني

السلام عليكم

معنى كلامى انك تاخد نسخه منه ثم تقوم بحذف محتويات الملف