Adding Actions to DBA Planning Calendar (Oracle) 

Use

This section describes how to add actions to the DBA Planning Calendar for Oracle.

If you started the DBA Planning Calendar using Local Calendar from the Central DBA Planning Calendar, you can schedule actions for all remote systems running on the same platform and with the same characteristics. This assumes that you have already defined the remote systems to the Central DBA Planning Calendar.

For example, assume that you call the DBA Planning Calendar from the Central DBA Planning Calendar on system FUD, which runs Oracle version 9. You can then schedule actions for all other Oracle systems running Oracle version 9. If the action you want to schedule also runs on Oracle version 9, then you can also schedule that action for all systems running Oracle version 8.

This only applies if you started the local calendar from the Central DBA Planning Calendar.

Procedure

...

       1.      Choose Administration ® CCMS ® DB Administration ® DBA Planning Calendar ® Local to start the DBA Planning Calendar. Alternatively, call transaction DB13.

The system displays the calendar, with a list of actions for each day.

       2.      Place the cursor on a day to which you want to add a new action and choose Create action.

The system lists the actions supported by the Planning Calendar.

       3.      Define the basic parameters for the action:

...

                            a.      Enter the Start Time for the action, for example, 22:00.

                            b.      If required, enter the interval at which you want the action repeated in Period. For example, if you enter 2, this means the action is automatically repeated every two weeks.

                            c.      If required, enter the ID of the factory calendar to use for the action. Actions are not executed on public holidays.

                            d.      If you are entering an action for the current date, you can trigger an action immediately by choosing Start immediately. This allows you to start an action manually if, for example, the planned action was unsuccessful.

       4.      Choose the activity you want to schedule from the following:

For more information on the different backup types, see Database Backup Types.

○       Whole database offline + redo log backup or
Full database offline + redo log backup

Performs a whole or full (level 0) offline backup of the database using BRBACKUP, followed automatically by backup of the offline redo log files using BRARCHIVE. After the offline redo log files have been successfully backed up, you can delete them from the redo log archiving directory according to the BRARCHIVE function you have selected.

○       Whole database offline backup or
Full database offline backup

Performs a whole or full (level 0) offline backup of the database using BRBACKUP

○       Whole database online + redo log backup or
Full database online + redo log backup

Performs a whole or full (level 0) online backup of the database using BRBACKUP, followed automatically by backup of the offline redo log files, using BRARCHIVE. After the offline redo log files have been successfully backed up, you can delete them from the redo log archiving directory according to the BRARCHIVE function you have selected.

○       Whole database online backup or
Full database online backup

Performs a whole or full (level 0) online backup of the database using BRBACKUP

○       Redo log backup

Performs a backup of the redo log files from the archiving directory, using BRARCHIVE After the offline redo log files have been successfully backed up, you can delete them from the redo log archiving directory according to the BRARCHIVE function you have selected.

○       Partial database offline backup

Performs an offline backup of the specified tablespaces using BRBACKUP.

○       Partial database online backup

Performs an online backup of the specified tablespaces using BRBACKUP

○       Check and update optimizer statistics

Checks and, if necessary, updates either all tables or tables of the specified tablespaces, using brconnect -f stats

○       Adapt next extents

Adapts the values for the NEXTEXTENT of all tables or tables of the specified tablespace, using brconnect -f next.

○       Check database

Checks the database system, using brconnect -f check

○       Verify database

Verifies the database using brbackup -w only_dbv.

○       Cleanup logs

Cleans up the database logs, using brconnect -f cleanup.

○       Incremental offline + redo log backup

Performs offline incremental database backup using BRBACKUP, followed automatically by backup of the offline redo log files using BRARCHIVE.

○       Incremental database offline backup

Performs offline incremental database backup using BRBACKUP.

○       Incremental online + redo log backup

Performs online incremental database backup using BRBACKUP, followed automatically by backup of the offline redo log files using BRARCHIVE.

○       Incremental database online backup

Performs online incremental database backup using BRBACKUP.

○       Compress database

Updates the compression rates of the database with brbackup -k only.

○       Prepare for RMAN backup

Prepares for RMAN backup with brbackup -d rman_prep.

○       Initialize tape

Initializes one backup tape with the name SCRATCH. This tape is automatically renamed during the next backup.

○       Validate structure

Validates database structure using brconnect -f stats -v.

       5.      Define parameters for the chosen action.

       6.      Choose Continue to finish scheduling the action.

The system checks for conflicts with previously scheduled activities. If any are found, the conflict are displayed and the action is not scheduled. Otherwise the action is added to the Planning Calendar and the required background job is scheduled.