| Database Administration (Oracle) with SAPDBA |
| New Features in SAP R/3 Release 4.0 |
| New Features in SAP R/3 Release 4.5 |
| SAPDBA |
| BRBACKUP, BRARCHIVE and BRRESTORE |
| New Features in SAP R/3 Release 4.6 |
| Sources of Information for the Database Administrator |
| Computing Center Management System |
| R/3 Tables in the ABAP Dictionary |
| Database Utility |
| SAPNet |
| EarlyWatch Service |
| Setting Up the Database System |
| SAPDBA: Archive mode |
| ARCHIVELOG Mode |
| Archiving Parameters |
| Mirroring the Control File |
| Mirroring Online Redo Log Files |
| Organizing Disk Storage |
| Database Parameters |
| Tablespaces and SAP Naming Conventions |
| Using SAPDBA |
| Configuring SAPDBA |
| Environment Variables (UNIX) |
| Directory Structure (Unix) |
| Configuring the Display Length |
| Configuring the UNIX Command at |
| Setting the Log Checks Option |
| Users and Roles |
| Database Users |
| UNIX User Configurations |
| SAPDBA: Expert Mode |
| Defining the Password |
| Restricted Session |
| SAPDBA and Autoextend |
| Starting SAPDBA |
| SAPDBA: Release Information |
| SAPDBA Command Options |
| -analyze |
| -check |
| -check_db_open |
| -checkopt |
| -cleanup |
| -delete |
| -export |
| -fill_tables |
| -next |
| -r |
| -shutdown(_abort) |
| -startup(_dba) |
| -version |
| Return Codes for SAPDBA Command Options |
| SAPDBA: Initial Menu |
| Displaying and Managing Logs and Profiles |
| SAPDBA: Show/Cleanup |
| Deleting Log and Trace Files |
| Support for the Cost-Based Optimizer |
| SAPDBA: DB Optimizer Control |
| SAPDBA Internal Rules for Determining Statistics |
| Starting up and Shutting down the Database System |
| Status of the Database System |
| Starting Up the Database System |
| Shutting down the Database System |
| Backup Concepts |
| Logical Backup and Image Backup |
| Backup Methods and Backup Frequency |
| Complete Backups |
| Incremental Backup |
| RMAN Backup Strategies |
| Incremental Backups After Structural Changes |
| Restoring Incremental Backups with RMAN |
| Backup Media |
| Tape Devices with Hardware Compression |
| Software Compression |
| Backup to Multiple Disks |
| Backup to a Remote Disk. |
| Backup to a Remote Tape Device |
| Two-Phase Backup |
| Online Mode and Offline Mode |
| Consistent Online Backup |
| Structure-Retaining Database Copy |
| Backing up Executable Programs and Other Component |
| Backing Up Data Tablespaces |
| Duration of the Backup |
| Parallel Backup |
| BRBACKUP and BRARCHIVE Backups in One Run |
| Unattended Backup |
| Volume Management |
| Volume Initialization |
| Volume Label Check |
| Scratch Volumes |
| Volume Expiration Period |
| Used Volumes |
| Selecting Volumes Manually |
| Selecting Volumes with External Tools |
| Automatic Volume Management |
| Backup Verifications |
| Verification of RMAN Backups |
| Integration of the Recovery Manager |
| RMAN Backups with the SAP Backup Library |
| Backup with an External Backup Library |
| Incremental Backup Strategy Without a Backup Libra |
| Saveset Grouping |
| Tape Layout |
| Profile Parameters and BRBACKUP Command Options |
| Backup of Large Oracle Databases |
| Hardware and Duration Example for a 100 GB Backup |
| Backup Devices for Large Databases |
| Backing Up Large Databases to Tape with BRBACKUP |
| External Backup Programs for Large Databases |
| Parallel Backup of Large Databases to Disk with BRBACKUP |
| Optimization of File Distribution |
| Optimization with a Logical Volume Manager |
| Partial Backups |
| Standby Database Scenario |
| Standby Database Configuration |
| Standby Database: Support by BRARCHIVE |
| Standby Database: Backup with BRBACKUP |
| Split Mirror Disks Backup |
| Split Mirror Online Backup |
| Split Mirror Offline Backup |
| Split Mirror Backup: Software Configuration |
| Backup with Jukebox/Autoloader |
| Mount / Dismount Command |
| Example: Backup with an Autoloader |
| Backing Up the Database with SAPDBA |
| SAPDBA: Backup Database |
| SAPDBA: Backup Database: Special Options |
| Archiving the Offline Redo Log Files |
| SAPDBA: Backup Offline Redo Logs |
| SAPDBA: Backup Offline Redo Logs: Special Options |
| Grouping the Offline Redo Log Files |
| SAP Backup Utilities |
| Using BRBACKUP and BRARCHIVE |
| Supported Backup Media |
| Automatic Tape Changing |
| Effects of the Command Options |
| cpio Continuation Tape |
| cpio Error |
| Canceling a Backup |
| BRBACKUP |
| Backing up Non-Database Files and Directories |
| Completion of BRBACKUP Backups |
| Backing up Database Files |
| Hardware Compression |
| BRARCHIVE |
| Hardware Compression |
| Logging |
| Using BRRESTORE |
| Restoring Files |
| Completion of BRRESTORE Runs |
| Examples |
| BRCONNECT and BRTOOLS |
| Using External Backup Programs |
| Advantages |
| Companies that Support the Interface to External B |
| The SAP Utilities under Windows NT |
| SAP Conventions (Windows NT) |
| Environment Variables (Windows NT) |
| Directory Structure (Windows NT) |
| Directory Tree (Windows NT) |
| Naming Conventions for Files (Windows NT) |
| Executables |
| Starting the SAP Utility Programs |
| Reorganization (Windows NT) |
| Database Analysis |
| Restrictions on SAPDBA (Windows NT) |
| Backup Strategy (Windows NT) |
| NTBackup |
| BRBACKUP/BRARCHIVE |
| Other Backup Programs |
| Initialization Profile init<DBSID>.dba |
| backup_util_name |
| blkdev_dir |
| check_controlfile_mirror |
| check_initial_settings |
| check_redolog_mirror |
| chop_util_name |
| exe_dir |
| exireo_dumpdir |
| exireo_exp_imp_buf |
| expir_period_brarchive |
| exp_imp_degree |
| file_or_raw |
| help_<xy> and language |
| index_degree |
| max_file_size |
| message_buf |
| ops |
| orapwd_always_used |
| parallel_instance |
| rawdev_dir |
| recovery_degree |
| sqldba_path |
| trace_level |
| tspadd_tspname |
| Sample Initialization Profile |
| Overview of Script Types |
| Starting SQL Scripts Manually with SQLPLUS |
| SAPDBA Scripts and Files |
| Starting Individual SQL Scripts with SAPDBA |
| Starting Shell Scripts for ORACLE Export/Import |
| SAPDBA Logs |
| Log Files and Their Contents |
| Structure Log |
| Central Log reorg<DBSID>.log |
| RC |
| Logging of Parallel Export/Import Processes |
| Connection to CCMS |
| Initialization Profile init<DBSID>.sap |
| Using the Profile init<DBSID>.sap |
| Parameter Format |
| Description of Parameters |
| archive_copy_dir |
| archive_function |
| archive_stage_dir |
| backup_dev_type |
| backup_mode |
| backup_root_dir |
| backup_type |
| compress |
| compress_cmd |
| compress_dir |
| copy_in_cmd |
| copy_out_cmd |
| cpio_disk_flags |
| cpio_flags |
| cpio_in_flags |
| dd_flags |
| dd_in_flags |
| dismount_cmd |
| exec_parallel |
| expir_period |
| mount_cmd |
| mount_par_file |
| new_db_home |
| parallel_instances |
| primary_db |
| remote_host |
| remote_user |
| resync_cmd |
| rewind |
| rewind_offline |
| saveset_members |
| split_cmd |
| stage_copy_cmd |
| stage_root_dir |
| tape_address |
| tape_address_arch |
| tape_address_ctl |
| tape_address_ctl_arch |
| tape_address_rew |
| tape_address_rew_arch |
| tape_copy_cmd |
| tape_pos_cmd |
| tape_size |
| tape_size_arch |
| tape_use_count |
| uncompress_cmd |
| util_par_file |
| volume_archive |
| volume_backup |
| Command Options for BRBACKUP, BRARCHIVE, and BRRESTORE |
| Command Options for BRBACKUP |
| -a|-archive |
| -b|-backup |
| -bd|-backup_delete |
| -c|-confirm |
| -d|-device |
| -e|-execute |
| -f|-fillup |
| -h|-help |
| -i|-initialize |
| -k|-compress |
| -l|-language |
| -m|-mode |
| -n|-number |
| -o|-output |
| -p|-profile |
| -q|-query |
| -r|-parfile |
| -s|-saveset |
| -t|-type |
| -u|-user |
| -v|-volume |
| -w|-verify |
| Command Options for BRARCHIVE |
| -a|-archive |
| -b|-backup |
| -c|-confirm |
| -d|-device |
| -f|-fill |
| -h|-help |
| -i|-initialize |
| -k|-compress |
| -l|-language |
| -m|-modify |
| -n|-number |
| -o|-output |
| -p|-profile |
| -q|-query |
| -r|-parfile |
| -s|-sc|-ds|-dc|-sd|-scd|-ss|-ssd|-cs|-cds |
| -sd|-ds|-dc|-scd|-cds|-ssd |
| -u|-user |
| -v|-volume |
| -w|-verify |
| Command Options for BRRESTORE |
| -a|-archive|a1|archive1 |
| -a2|-archive2 |
| -b|-backup |
| -b2|-backup2 |
| -c|-confirm |
| -d|-device |
| -e|-execute |
| -f|-fillup |
| -h|-help |
| -incr |
| -k|-compress |
| -l|-language |
| -m|-mode |
| -n|-number |
| -o|-output |
| -p|-profile |
| -q|-query |
| -r|-parfile |
| -w|-verify |
| BRBACKUP, BRARCHIVE, and BRRESTORE Logs |
| Log Types |
| File system logs |
| Database Logs |
| BRBACKUP Logs |
| Names of the Detail Logs |
| Detail Log |
| Log Supplements |
| Summary Log |
| BRARCHIVE Logs |
| Names of the Detail Logs |
| Detail Log |
| Summary Log |
| BRRESTORE Logs |
| Names of the Detail Logs |
| Detail Log |
| Sample Logs |
| Volume Initialization |
| Detail Log of an Offline Backup |
| Supplements to a Detail Log |
| Log for an RMAN Preparation Run |
| Summary BRBACKUP Log |
| Detail BRARCHIVE Log |
| Summary BRARCHIVE Log |
| BRRESTORE Logs: Restoring a Complete Backup |
| Messages and Return Codes: BRBACKUP, BRARCHIVE, an |
| Return Codes for BRBACKUP / BRRESTORE |
| Messages |
| Messages from BR002I to BR028E |
| Messages from BR029E to BR70W |
| Messages from BR071E to BR115I |
| Messages from BR116I to BR151E |
| Messages from BR152I to BR181E |
| Messages from BR182E to BR218E |
| Messages from BR219W to BR241I |
| Messages from BR242I to BR269W |
| Messages from BR270W to BR307I |
| Messages from BR308I to BR339W |
| Messages from BR340I to BR383E |
| Messages from BR384E to BR429W |
| Messages from BR430E to BR464W |
| Messages from BR465E to BR468I |
| Messages from BR501I to BR607E |
| Database Reorganization |
| Reorganization Concepts |
| Status of the Database |
| Limitations of the Database System |
| Reorganization Type |
| Reorganization of a Single Object |
| Reorganization of an Object List |
| Reorganization of a Tablespace |
| Reorganization of Special Tablespaces |
| Reorganization of a Tablespace with Data Files |
| Moving/Renaming the Data Files of a Tablespace |
| Resizing the Data Files of a Tablespace |
| Procedure for a Reorganization |
| Procedures in Detail |
| Backup Concepts in Reorganizations |
| Freespace Check |
| Freespace Check during Reorganization of a Single |
| Freespace Check during Reorganization of a Tablesp |
| Freespace Check during Reorganization of a Tablesp |
| Freespace Check During CREATE TABLE AS SELECT, in |
| SAPDBA: Reorganization |
| Reorganization |
| Before a Reorganization |
| Checking Statistics |
| Extent Check Functions |
| Command Option -analyze |
| Number of Data Files |
| Analyzing the Statistics |
| Changing MAXEXTENTS and NEXT |
| Command Option -next |
| Carrying out a Reorganization |
| SAPDBA: Reorganization Menu |
| Changing the Extent Size |
| Moving a Table or Index |
| Performance Maximization during Reorganization |
| Speeding Up a Reorganization |
| Archiving Mode during the Reorganization |
| Reorganizing in NOARCHIVELOG Mode |
| Performing Processes in Parallel |
| Restarting a Reorganization |
| Preparing for the Restart |
| Restart Procedure |
| Restart File for Reorganizations |
| Resetting a Reorganization |
| Data Transport During a Reorganization |
| Reorganization with Create table ... as select |
| Exporting and Importing Database Objects |
| Data Consistency |
| SAPDBA: Export/import |
| Export Types |
| Parallel Export/Import |
| SAPDBA: Export Menu |
| Exporting Tables with Indexes and Data |
| Prerequisites for Export and Import |
| Export Options for Tables and Indexes with Data |
| Exporting Table and Index Definitions |
| Export Options for Tables and Indexes |
| Exporting Constraints, Synonyms, Sequences, Views, |
| Export Options for Constraints, Synonyms, Sequence |
| Importing Tables with Indexes and Data |
| Import Options for Tables with Data |
| Structure Import |
| Import Options for Object Structures |
| Restarting the Export/Import |
| Restart File for Export/Import |
| SAP unload/load, SQL*Loader |
| Changing Storage Parameters |
| Overview of the Storage Parameters |
| Options for Changing and Checking the Storage Para |
| Compress Extents |
| Default Value for NEXT |
| Checking Freespace |
| Reducing the Size of the Table or Index |
| Changing the Storage Parameters Manually |
| Tablespace Administration |
| Tablespace Administration: Overview |
| Backup Recommended |
| SAPDBA: Tablespace Administration |
| Checking Tablespaces |
| Freespace Statistics |
| Check Functions |
| Files/Raw Devices of a Tablespace |
| Extending a Tablespace |
| Specifying the File Size |
| Naming Convention |
| New Path |
| SAPDBA Troubleshooting |
| Creating a Tablespace |
| SAPDBA Database Recovery |
| SAPDBA: Check (and Repair) Database |
| Recovering the Database Automatically |
| Checking the Database Files |
| Finding the Backup Files |
| Restoring the Backup Files |
| Changing the Restore Parameters |
| Finding Incremental Backups |
| Restoring Incremental Backups |
| Finding the Archived Redo Logs |
| Restoring Archived Redo Logs |
| Recovering the Database |
| Full Restore and Recovery |
| Resetting the Database |
| Restoring One Tablespace |
| Restoring Individual Files |
| Recovery with SVRMGR |
| Recovery with SVRMGR: Overview |
| Types of Database Errors |
| Error Analysis |
| Recovery after User Errors |
| Recovery after Statement Errors |
| Recovery after Process Errors |
| Recovery after an Instance Error |
| Recovery after Media Errors |
| Recovery: One Control File Missing |
| Recovery: All Control Files Missing |
| Recovery: Current Online Redo Log Missing |
| Recovery: One Inactive Online Redo Log Missing |
| Recovery: User Tablespace Missing |
| Recovery: SYSTEM Tablespace Missing |
| Recovery: Index Tablespace Missing |
| Recovery: Errors During the Archiving of Online Re |
| Partial Recovery |
| Actions after a Partial Recovery |
| Automating the Recovery |
| Updating the Control File |
| Disaster Recovery |
| Oracle Databases on Raw Devices |
| SAPDBA Support for Raw Device Configuration |
| Raw Devices and BRBACKUP/ BRRESTORE |
| ORACLE Databases and Parallel Server Option |
| OPS with BRBACKUP, BRARCHIVE and BRRESTORE |
| Information in the Profile init<DBSID>.sap |
| Special Features of BRBACKUP |
| Special Features of BRARCHIVE |
| Special Features of BRRESTORE |
| Distributed Scenario |
| Central Scenario |
| Mixed Scenario |