Skip to Content
avatar image
Former Member

Check DB - Error

Dear Gurus,

when i run check DB process on DB13 it was completed with following errors.

1. BR0973W Database operation alert - level: WARNING, operation: cdytxcet.cln, time: 2008-09-10 01.00.19, condition: Last successful 'cln' operation older than 10 days

2. BR0973W Database operation alert - level: WARNING, operation: bdyrjtjw.aft, time: 2008-08-27 18.00.28, condition: Last successful 'aft' operation older than 10 days

3.BR0973W Database operation alert - level: WARNING, operation: bdyqzgue.tib, time: 2008-08-25 14.49.08, condition: Last successful 'tib' operation older than 10 days

4. BR0973W Database operation alert - level: WARNING, operation: cdyqkdhh.dst, time: 2008-08-22 12.55.45, condition:

Last successful 'dst' operation older than 10 days

5. BR0973W Database operation alert - level: WARNING, operation: adygtzwb.cds, time: 2008-07-02 19.45.59, condition: Last successful. 'cds' operation older than 10 days

what is happening here. please explain that what i should do.

thanks

Madhushanka

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Sep 25, 2008 at 11:24 AM

    Hi Madhushanka,

    The statistics are out of date..

    So why dont you schedule a DB-UpdateStats first. After UpdateStats completes successfully, then try running DBCheck. It should then work fine..

    Regards

    Thilip Kumar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 25, 2008 at 11:33 AM

    Are there any warnings in DB16 ?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 25, 2008 at 01:25 PM

    These don't look related to statistics being out of date.

    They more relate to spadba/brbackup/brarchive/brconnect stuff.

    If you check trx DB14, click 'Function ID's you will see where each one comes from i.e. cln = Cleanup DBA logs (executed via DB13 or cmd-line 'brconnect -f cleanup')

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 26, 2008 at 03:07 AM

    Dear Experts,

    My first warning has been solved after running cleaning job.(cdytxcet.cln). But other warnings are still appearing daily.

    thanks.

    Madhushanka

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Madhushanka,

      The warnings are related to the last completion of the operations.

      aft - Offline backup

      tib - Tape initialization

      dst - delete damaging statistics, function -f stats -d

      cds - Archive log backups

      You must have not run these in the last 10 days hence the errors. Offline backup and Archive log backups are critical unless you have other means of backing them up (OS level etc)

      Rest I guess you could ignore.

      Please find the Oracle database guide at the below link.

      https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/3204a72f-0d01-0010-db84-e2335f934e88 which should provide additional details.

      Thanks and Best Regards,

      Sunil.

  • avatar image
    Former Member
    Sep 26, 2008 at 06:42 AM

    Hello Madhu

    1. BR0973W Database operation alert - level: WARNING, operation: cdytxcet.cln, time: 2008-09-10 01.00.19, condition: Last successful 'cln' operation older than 10 days

    Please Run DB13 T-Code and Run Job -

    1. Clean Up Logs

    Make changes in initSID.sap for example backup_root_dir/archive_root_dir

    2. Archive Logs Backup

    3. Online Database Backup

    4. Update Stats

    5. Check DB

    If you face any problem then run T-Code DB17 and define the trash hold valus yourself.

    I think you installed the fresh system that is why you are facing problem.

    Try this step I am sure you will find success

    Thanks & Regards

    Shishir

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 27, 2008 at 12:39 PM

    Hello,

    In addition to what Sishir ha sexplained.

    The above warnings/errors are issued on the basis of entries made in txcode DB17.

    Here there are entries like OPERATION_TOO_OLD . This tcode also suggests the corrective measures.Explore on this tcode

    Pl award if helpful.

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 03, 2008 at 02:20 AM

    thanks all of you..

    Add comment
    10|10000 characters needed characters exceeded