Skip to Content
avatar image
Former Member

DB13 Activities

Dear Experts.

In DB13, there are many options like scheduling backup and Update Statistics etc, as i am familiar with both the tasks i have mentioned, i request experts please guide me as what are the other tasks that should run in DB13 on daily basis as-well as at certain time intervals.

Thanks in advance.

Regards

Mohd Basis

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 17, 2014 at 08:35 AM

    Addition to above updates, you may schedule these jobs as below (Ideal):

    Check database   - Daily

    Redo log backup -  Multiple (2 min) times everyday (to minimize the risk of data loss, but depends on your backup configuration and capability etc.)

    Validate structure - Weekly

    Verify database - Weekly

    Cleanup logs - Weekly

    Online+archivelog backups - Daily

    Update statistics - Daily

    Regards,

    Nick Loy

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 17, 2014 at 06:05 AM

    Hi,

    It is advisable to start the following activities from time to time and it depends on the system needs and available timeframes to perform:

    - Check database

    - Redo log backup

    - Validate structure

    - Verify database

    This way you can ensure the database is not only checked for corruptions but also maintained well and in case of any problems you can react in time.

    But the actions you need to perform is really system dependent, so the decision in your hand.

    Regards,

    János

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 17, 2014 at 07:37 AM

    Hi Mohd.

    Please make a note that the below jobs - Verify database

    Consume lot of system resources and if required should be planned on weekends or very low system loads.

    Hope this helps.

    Regard,s

    Deepak Kori

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 20, 2014 at 06:01 AM

    Hi,

    As an administrator I would use all different action (except different backup types, because you would need normally two of them only) to make sure, my system is running correctly and to lower the  chance to encounter any unexpected situations.

    Regards,

    János

    Add comment
    10|10000 characters needed characters exceeded