Computing Center Management System (SAP Library - Database Administration (Oracle) with SAPDBA)

Computing Center Management System

You can make backups of the database and of the offline redo log files from the R/3 system. To do this, use the Computing Center Management System (CCMS). You can trigger the following actions from CCMS and then display the resulting logs.

Database offl. full bkup+archive logs: Offline backup of the entire database using BRBACKUP followed by archiving of those offline redo log files that have not yet been archived using BRARCHIVE.

Database offline full backup: Offline backup of the entire database using BRBACKUP.

Database online full bkup+archive logs: Online backup of the entire database using BRBACKUP followed by archiving of the offline redo log files using BRARCHIVE to keep the backup consistent.

Database online full backup: Online backup of the entire database using BRBACKUP.

Archive redo log files: Archiving of all offline redo log files not yet backed up from the archive directory to tape using BRARCHIVE.

Partial offline database backup: Offline backup of specified tablespaces using BRBACKUP.

Partial online database backup: Online backup of specified tablespaces using BRBACKUP.

Analyze tables in tablespace(s): Table analysis of a specified tablespace using SAPDBA ( sapdba -analyze ).

Analyze tables via control table: Analysis of the table statistics generated by SAPDBA ( sapdba -analyze ).

Compute and adapt next table extents: Adjustment of the values for the NEXT extent of tables in a specified tablespace with SAPDBA ( sapdba -next ).

You can find detailed information about planning and displaying backups and database analyses in the sections of the R/3 Library on the Computing Center Management System. CCMS also offers several monitoring functions that you can use to monitor how your database system operates. For detailed information, see The Monitoring Architecture: Concept or R/3 System Monitoring: Overview.