Release 4.5: SAPDBA (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Release 4.5: SAPDBA

Reorganization

When you reorganize individual tables (single reorganization) the table is no longer deleted directly after the import, instead it is renamed. The old data is deleted only after the reorganized new tables have been created and imported. This deferred mode increases data security.

Update Statistics for the Cost-Based Optimizer in CCMS (Oracle)

You can schedule all actions for checking and updating statistics in CCMS.

Checking the Database System

The database system check has been extended with new DBA, ORA and PROF parameters (such as TABLES_NOT_IN_TABLE_TABLESPACE).

You can check the database system while the database is mounted.

You can individually specify how often you want the check to be repeated for each parameter of the database system check.

You can display the results of the database system check in different ways (for example, you can display the errors only).

Database Recovery: Support for Incremental Backups with RMAN

The SAPDBA restore/recovery logic takes into account incremental backups made with BRBACKUP/Oracle Recovery Manager (RMAN).

AUTOEXTEND and RESIZE (Oracle)

As of Release 4.5A, SAPDBA supports the Oracle options AUTOEXTEND and RESIZE. This means that backups of files whose sizes have changed due to AUTOEXTEND or RESIZE can be used for Restore and Recovery functions. For more information, see SAPDBA and Autoextend.

New Command Option

Use the command option -V|-VERSION to obtain patch information.