perform Database Stats, Check Database, and Backup Jobs – Oracle?

Creating Database Statistics, Index Rebuilds, and Log Backup Jobs – Oracle

1. Log on to the appropriate SAP instance any client.

2. Go to transaction DB13.

3. On the DBA Planning Calender for Oracle Database <SID>: Maintain screen, double-click on a blank line on any day in the future.

4. On the Schedule Action for <Day>. DD.MM.YYYY popup, use the radio button to turn “on” the task you want to do. For each action, you need to fill in the Start Time in military time format, the Period (Weeks) which is how many weeks between running of this job – blank for one time only, 1 for weekly, 2 for bi-weekly, etc. and Calender if you want to use any calendar except the SAP supplied standard Factory calendar.

These are the details for each action:

Whole database offline + redo log or
Whole database offline backup or
Whole database online + redo log or
Whole database online backup

Generic tape names for database backup

Database backup profile – usually init<SID>.sap

Options for ReDo log backup

Redo log backup

Generic tape names for database backup

Options for ReDo log backup

Partial database offline backup or

Partial database online backup

Tablespace names to be included in the back up

Generic tape names for database backup

Database backup profile – usually init<SID>.sap

Check and update optimizer status

Tablespace names to be included in the statistics run

Adapt next extents

Tablespace names for next extents adaption

Check database
N/A
Verify database
Tablespace names to be verified
Database backup profile – usually init<SID>.sap
Cleanup logs
N/A

5. You may now leave the DB13 transaction.