Recommended for D13 time table

[Former Member]

Where can i found info on the recommended way of scheduling db check, verify, delete logs and such.... at DB13

[Former Member]

How do you guys come up with these suggestions? Is it documented by SAP ( guides or SAP notes ) or base on experience?

[Former Member]

Mohammad,

We schedule below mentioned DB related job based on experience.

1. DB check ( Daily)

2. Update statics ( Daily)

3. Delete Old Logs ( weekly)

4. Adapt next extent(weekly) ( if DB is dictionary managed)

5.Online Backup for Prod ( daily)

5. Archive logs ( daily ( every 4 hours), depends upon how many redo logs gets generated)

6.RSORATOD Refresh DB03 stats

http://help.sap.com/erp2005_ehp_04/helpdata/DE/df/455e77747111d6b25100508b6b8a93/frameset.htm

Hope this helps

Thanks

Sushil

[Former Member]

Run T-code DB13

Double click on Completed Action .new window will be opend. select the SHort Log or Detail Log Button u will get complete History or Log.

Thanks

Presu

[abhimanyu_pandey]

Hi..

You can schedule following action in DB13,

1. DB check ( Daily otherwise weekly if load is there in night)

2. Update statics ( weekly for highl loaded system)

3. Delete Old Logs ( weekly)

4. Adapt next extent(weekly) ( if DB is dictionary managed)

5. Archive logs ( daily, depends upon your policy).

Regards,

Abhimanyu

Edited by: Abhimanyu Pandey on May 18, 2009 9:32 AM

[Former Member]

I just need to know when is the best or recommended time to do check db, verify db and delete logs. Is there any document cover this?

[Former Member]

Check DB must be performed weekly preferably on the weekends when the load on the system is less

Verify DB must be performed when you take the full backup of database

Rohit

[Former Member]

Refer to http://help.sap.com/saphelp_nw70/helpdata/en/2a/cd71f5200f784690bf0b9624d045a2/frameset.htm

This might help you

Rohit

[Former Member]

hello

schedule checkDb daily during night time of the sap system, means when the users are very less in number

schedule cleanup logs weekly

[Former Member]

What do you mean by recommended ways:

Check DB should be scheduled once in a week when the load is low

Regarding other things like scheduling backup..you should built upon a strategy

Let us know what exactly you require so that we can help you

Rohit

[Former Member]

Hi,

Please refer to following link for Database Administration for Oracle databases using DB13.

http://help.sap.com/saphelp_nw70/helpdata/EN/df/455e12747111d6b25100508b6b8a93/frameset.htm

With Regard,

Saurabh