Database Administration |
Database Administration for SAP HANA |
 DBA Cockpit for SAP HANA |
Database Administration for SAP Sybase ASE |
Database Administration for SAP MaxDB |
 SAP MaxDB |
 Database Administration in CCMS: SAP MaxDB |
Database Administration for IBM DB2 for i |
 SAP Database Guide: IBM DB2 for i |
 CCMS: IBM DB2 for i |
Database Administration for IBM DB2 for Linux, UNIX, and Windows |
Database Administration for DB2 for z/OS |
 CCMS: SAP on DB2 for z/OS |
Database Administration for Microsoft SQL Server |
 SAP/ MS SQL Server DBA in CCMS |
Database Administration for Oracle |
SAP Database Guide: Oracle |
New Features |
New Features in SAP BR*Tools 7.20 |
New Features in SAP BR*Tools 7.10 |
New Features in SAP BR*Tools 7.00 |
Getting Started with Oracle and the SAP System |
Database Security |
Computing Center Management System |
Specification of SAP Tables in the ABAP Dictionary |
Oracle Database Storage Parameters in the ABAP Dictionary |
Support on SAP Service Marketplace |
Database System Configuration |
Setting Up Archiving |
Mirroring the Control File |
Mirroring the Online Redo Log Files |
Organizing Disk Storage |
SAP Naming Conventions for Tablespaces and Data Files |
Database Parameters |
Environment Variables (UNIX) |
Environment Variables (Windows) |
Directory Structure (UNIX) |
Directory Structure (Windows) |
Users and Roles |
Oracle Databases on Raw Devices |
Raw Devices and BR*Tools |
Raw Devices with BRBACKUP and BRRESTORE |
Automatic Storage Management |
Limitations of the Oracle Database System |
Approach to Oracle DBA |
Instance Management |
Recreate Database |
Manage Online Redo Logs |
Manage Data Encryption |
Space Management |
Managing Tablespaces |
Managing Data Files |
Segment Management |
Reorganization |
Export/Import |
Special Export and Import Functions with BRSPACE |
Reorganization Case Study |
Reorganization with the Redefinition Package |
Database Backup |
Backup Overview |
Why Back Up the Database? |
What Needs Backing Up? |
Database Backup Types |
Online and Offline Backup |
Consistent Online Backup |
Complete Backup |
Incremental Backup |
Backup Cycles |
Backup Approach with Daily Complete Backups |
Backup Approach for Very Large Database with Partial Backups |
Backup Approach with One-Day Retention Period |
Backup Media |
Volume Management |
Volume Initialization |
Volume Label Check |
Volume Expiration Period |
Used Volumes |
Scratch Volume |
Selecting Volumes Manually |
Selecting Volumes with External Tools |
Selecting Volumes Automatically |
Tape Volume Size |
Hardware Compression |
Software Compression |
Backup Methods |
Backup to Multiple Disks |
Backup to a Remote Disk |
Backup to a Remote Tape Device |
Two-Phase Backup |
Structure-Retaining Database Copy |
Parallel Backup |
Unattended Backup |
BRBACKUP and BRARCHIVE Backups in One Run |
Backup Verification |
Grouping Offline Redo Log Files |
Advanced Backup and Recovery |
Backup of Large Oracle Databases |
Backup Devices for Large Databases |
Backup of 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 |
Tablespace Backups |
Backup Example for a Large Database |
Speeding Up the Backup |
Standby Database |
Standby Database Configuration |
Standby Database: BRARCHIVE Backup of Offline Redo Log Files |
Standby Database: BRBACKUP Backup of Database Files |
Standby Database: Restore and Recovery |
Standby Database: Remote Database Connect Requirements |
Split Mirror Backup |
Split Mirror Online Backup |
Split Mirror Offline Backup |
Split Mirror Backup: Software Configuration |
Backup with Automatic Tape Changers |
Mount and Dismount Commands |
Autoloader Backup Example |
External Backup Programs |
Fixing an Online Backup Crash |
Abort of Archive, Backup, or Restore |
Restore and Recovery |
Complete Database Recovery |
Database Point-In-Time Recovery |
Tablespace Point-in-Time Recovery |
Whole Database Reset |
Restore of Individual Backup Files |
Restore and Application of Offline Redo Log Files |
Disaster Recovery |
Database System Check |
Update Statistics |
BR*Tools Studio for Oracle DBA |
Getting Started with BR*Tools Studio |
Installing BR*Tools Studio |
Running BR*Tools Studio for the First Time |
BR*Tools Studio: Console |
BR*Tools Studio: Wizard |
BR*Tools Studio: Administration |
BR*Tools Studio: Landscape |
BR*Tools Studio: Case Study |
BR*Tools Studio: Role Concept |
BR*Tools for Oracle DBA |
Getting Started with BR*Tools |
Configuration of BR*Tools |
Configuring the Scroll Line Count for BR*Tools |
Configuring the UNIX Command at for BR*Tools Batch Functions |
Setting the Option To Log Displayed Information for BRSPACE |
Effects of Autoextend and Resize on BR*Tools |
Starting BR*Tools |
BR*Tools User Interface |
How to Use BR*Tools |
Checking BR*Tools Release Information |
BR*Tools in Action |
Instance Management with BR*Tools |
Starting Up the Database with BR*Tools |
Shutting Down the Database with BR*Tools |
Altering the Database Instance with BR*Tools |
Altering Database Parameters with BR*Tools |
Recreating a Database with BR*Tools |
Managing Online Redo Logs |
Managing Data Encryption |
Showing Instance Status with BR*Tools |
Showing Database Parameters with BR*Tools |
Showing Database Owners with BR*Tools |
Showing Flashback Status with BR*Tools |
Showing Encryption Status with BR*Tools |
Space Management with BR*Tools |
Extending a Tablespace with BR*Tools |
Creating a Tablespace with BR*Tools |
Dropping a Tablespace with BR*Tools |
Altering a Tablespace with BR*Tools |
Altering a Data File with BR*Tools |
Moving a Data File with BR*Tools |
Showing Tablespaces with BR*Tools |
Showing Data Files with BR*Tools |
Showing Redo Log Files with BR*Tools |
Showing Control Files with BR*Tools |
Showing Disk Volumes with BR*Tools |
Segment Management with BR*Tools |
Reorganizing Tables with BR*Tools |
Rebuilding Indexes with BR*Tools |
Exporting Tables with BR*Tools |
Importing Tables with BR*Tools |
Altering Tables with BR*Tools |
Altering Indexes with BR*Tools |
Showing Tables with BR*Tools |
Showing Indexes with BR*Tools |
Showing Table Partitions with BR*Tools |
Showing Index Partitions with BR*Tools |
Showing Segments with BR*Tools |
Showing Segment Extents with BR*Tools |
Showing Free Extents with BR*Tools |
Backup and Database Copy with BR*Tools |
Backing Up the Database with BR*Tools |
Backing Up the Offline Redo Log Files with BR*Tools |
Copying the Database with BR* Tools |
Non-Database Backup with BR*Tools |
Backing Up a Database Disk Backup |
Verifying a Database Backup with BR*Tools |
Verifying an Offline Redo Log Backup with BR*Tools |
Additional Functions for Backup and Database Copy with BR*Tools |
Updating Compression Rates with BR*Tools |
Preparing RMAN Backups with BR*Tools |
Deleting Database Disk Backups with BR*Tools |
Deleting Offline Redo Log Backups on Disk with BR*Tools |
Controlling of BRARCHIVE Run with BR*Tools |
Initializing BRBACKUP Tape Volumes with BR*Tools |
Initializing BRARCHIVE Tape Volumes with BR*Tools |
Restore and Recovery with BR*Tools |
Complete Database Recovery with BR*Tools |
Database Point-In-Time Recovery with BR*Tools |
Tablespace Point-In-Time Recovery with BR*Tools |
Whole Database Reset with BR*Tools |
Restore of Individual Backup Files with BR*Tools |
Restore and Application of Offline Redo Log Files with BR*Tools |
Disaster Recovery with BR*Tools |
Managing Flashback Database with BR*Tools |
Procedures for Restore and Recovery with BR*Tools |
Setting Point In Time and Tablespaces for Recovery |
Checking the Status of Database Files - I |
Selecting Database Backups |
Checking the Status of Database Files - II |
Checking the Status of Tablespaces |
Exporting the Tablespaces Not Being Recovered |
Restoring Control Files |
Restoring Data Files |
Restoring and Applying an Incremental Backup |
Restoring and Applying Offline Redo Log Files |
Performing Flashback Database |
Opening the Database |
Check and Verification with BR*Tools |
Checking the Database System with BR*Tools |
Validating the Database Structure with BR*Tools |
Verifying Database Blocks with BR*Tools |
Database Statistics with BR*Tools |
Updating Database Statistics with BR*Tools |
Collecting Missing Statistics with BR*Tools |
Collecting Dictionary Statistics with BR*Tools |
Collecting System Statistics with BR*Tools |
Deleting Harmful Statistics with BR*Tools |
Managing Database Statistics with BR*Tools |
Additional Functions with BR*Tools |
Showing Profiles and Logs with BR*Tools |
Cleaning Up DBA Logs and Tables with BR*Tools |
Adapting Next Extents with BR*Tools |
Methods of Adapting Next Extent Size |
Changing the Password of the Database User with BR*Tools |
Creating or Changing Synonyms for DBA Tables |
BR*Tools in Detail |
BRBACKUP |
Backing Up Database Files |
Backing Up Non-Database Files and Directories |
Completion of BRBACKUP Backups |
Hardware Compression for BRBACKUP |
Command Options for BRBACKUP |
-a|-archive |
-b|-backup |
-bd|-backup_delete |
-c|-confirm |
-db|-delete_backup |
-d|-device |
-e|-execute |
-f|-fillup |
-g|-gun|-abort |
-h|-help |
-i|-initialize |
-k|-compress |
-l|-language |
-m|-mode |
-n|-number |
-o|-output |
-p|-profile |
-pr|-pass_rman|-PR|-PASS_RMAN |
-pw|-pass_wallet|-PW|-PASS_WALLET |
-q|-query |
-r|-parfile |
-s|-saveset |
-t|-type |
-u|-user |
-v|-volume |
-w|-verify |
-V|-VERSION |
BRBACKUP Logs |
Names of the BRBACKUP Detail Logs |
BRBACKUP Detail Log |
BRBACKUP Summary Log |
BRARCHIVE |
Hardware Compression for BRARCHIVE |
Command Options for BRARCHIVE |
-a|-archive |
-b|-backup |
-c|-confirm |
-d|-device |
-e|-execute |
-f|-fill |
-g|-gun|-abort |
-h|-help |
-i|-initialize |
-k|-compress |
-l|-language |
-m|-modify |
-n|-number |
-o|-output |
-p|-profile |
-pr|-pass_rman|-PR|-PASS_RMAN |
-q|-query |
-r|-parfile |
-s|-sc|-ds|-dc|-sd|-scd|-ss|-ssd|-cs|-cds |
-u|-user |
-v|-volume |
-w|-verify |
-V|-VERSION |
BRARCHIVE Logs |
Names of the BRARCHIVE Detail Logs |
BRARCHIVE Detail Log |
BRARCHIVE Summary Log |
BRRESTORE |
Restoring Files |
Completion of BRRESTORE Runs |
Examples of BRRESTORE Runs |
Command Options for BRRESTORE |
-a|-archive|-a1|-archive1 |
-a2|-archive2 |
-b|-backup|b1|backup1 |
-b2|-backup2 |
-c|-confirm |
-d|-device |
-e|-execute |
-f|-fillup |
-g|-gun|-abort |
-h|-help |
-i|-interval |
-k|-compress |
-l|-language |
-m|-mode |
-n|-number |
-n2|-number2 |
-o|-output |
-p|-profile |
-pr|-pass_rman|-PR|-PASS_RMAN |
-q|-query |
-r|-parfile |
-u|-user |
-w|-verify |
-V|-VERSION |
BRRESTORE Logs |
Names of the BRRESTORE Detail Logs |
BRRESTORE Detail Log |
BRRESTORE Summary Log |
BRRECOVER |
Command Options for BRRECOVER |
-a|-tsp|-tablespace |
-b|-backup |
-c|-confirm |
-d|-device |
-e|-degree |
-E|-execute |
-f|-ccf|-crctlfile |
-g|-scn|-change |
-h|-help |
-i|-interval |
-ie|-idegree |
-ip|-iparallel |
-j|-ins|-instance |
-l|-language |
-m|-pit|-time |
-n|-seq|-sequence |
-n1|-seq1|-sequence1 |
-o|-rpt|-point |
-p|-profile |
-pcp|-prof_cpio |
-pdd|-prof_dd |
-prm|-prof_rman |
-prd|-prof_rman_dd |
-prs|-prof_rman_set |
-pbt|-prof_brtools |
-pr|-pass_rman|-PR|-PASS_RMAN |
-pw|-pass_wallet|-PW|-PASS_WALLET |
-r|-parfile |
-s|-scroll |
-t|-type |
-u|-user |
-x|-map|-remap |
-V|-VERSION |
-w|-own|-owner |
BRRECOVER Logs |
BRRECOVER Detail Log |
BRRECOVER Summary Log |
BRSPACE |
Command Options for BRSPACE |
-c|-confirm |
-f|-function |
-f dbalter |
-f dbcreate |
-f dbparam |
-f dbshow |
-f dbshut |
-f dbstart |
-f dfalter |
-f dfmove |
-f idalter |
-f idrebuild |
-f mdencr |
-f mfback |
-f moredo |
-f mstats |
-f tbalter |
-f tbexport |
-f tbimport |
-f tbreorg |
-f tsalter |
-f tscreate |
-f tsdrop |
-f tsextend |
-h|-help |
-l|-language |
-o|-output |
-p|-profile |
-q|-query |
-s|-scroll |
-u|-user |
-V|-VERSION |
BRSPACE Logs |
BRSPACE Detail Log |
BRSPACE Summary Log |
BRSPACE Structure Change Log |
BRSPACE Parameter Change Log |
BRCONNECT |
Database System Check with BRCONNECT |
BRCONNECT Default Conditions for Database Administration |
BRCONNECT Default Conditions for Database Operations |
Adapt Next Extents with BRCONNECT |
Internal Rules for Determining Next Extent Size |
Update Statistics with BRCONNECT |
-force with Update Statistics |
Deletion of Damaging Statistics |
Verification of Table and Index Structure |
Internal Rules for Update Statistics |
Update Statistics for InfoCube Tables |
Sample Sizes for Update Statistics |
Changing Database User Passwords with BRCONNECT |
Clean Up Old Logs and Trace Files with BRCONNECT |
Additional BRCONNECT Functions |
Command Options for BRCONNECT |
-c|-confirm |
-f|-function |
-f check |
-f chpass |
-f cleanup |
-f crsyn |
-f dbshut |
-f dbstart |
-f dbstate |
-f lscorr |
-f lsinv |
-f next |
-f stats |
-h|-help |
-l|-language |
-o|-output |
-p|-profile |
-q|-query |
-u|-user |
-V|-VERSION |
BRCONNECT Logs |
Names of the BRCONNECT Detail Logs |
BRCONNECT Detail Log |
BRCONNECT Summary Log |
BRTOOLS |
Command Options for BRTOOLS |
-c|-confirm |
-h|-help |
-i|-interval |
-l|-language |
-p|-profile |
-s|-scroll |
-u|-user |
-w|-show |
-V|-VERSION |
Profiles, Logs, Messages, and Return Codes for BR*Tools |
Initialization Profile init<DBSID>.sap |
archive_copy_dir |
archive_dupl_del |
archive_function |
archive_stage_dir |
asm_ora_home |
asm_ora_sid |
asm_ora_sid |
backup_dev_type |
backup_mode |
backup_root_dir |
backup_type |
check_cond |
check_exclude |
check_owner |
cleanup_brarchive_log |
cleanup_brbackup_log |
cleanup_brconnect_log |
cleanup_brrecover_log |
cleanup_brrestore_log |
cleanup_brspace_log |
cleanup_check_msg |
cleanup_db_log |
cleanup_disk_archive |
cleanup_disk_backup |
cleanup_exp_dump |
cleanup_ora_dir |
cleanup_ora_sdir |
cleanup_ora_trace |
cleanup_owner |
cleanup_xdb_log |
compress |
compress_cmd |
compress_dir |
copy_in_cmd |
copy_out_cmd |
cpio_disk_flags |
cpio_flags |
cpio_in_flags |
db_services |
dd_flags |
dd_in_flags |
disk_copy_cmd |
dismount_cmd |
exec_parallel |
exp_dump_dir |
exp_table |
expir_period |
imp_table |
loc_ora_homes |
mount_cmd |
mount_par_file |
new_db_home |
next_exclude |
next_limit_count |
next_max_size |
next_owner |
next_special |
next_table |
orig_db_home |
parallel_instances |
pipe_copy_cmd |
post_arch_cmd |
post_back_cmd |
post_shut_cmd |
post_split_cmd |
pre_arch_cmd |
pre_back_cmd |
pre_shut_cmd |
pre_split_cmd |
primary_db |
rebuild_index |
rebuild_indpart |
recov_copy_dir |
recov_degree |
recov_interval |
recov_type |
remote_host |
remote_user |
reorg_table |
reorg_tabpart |
restore_mode |
resync_cmd |
rewind |
rewind_offline |
rman_channels |
rman_compress |
rman_copies |
rman_cross_check |
rman_diskratio |
rman_duration |
rman_filesperset |
rman_keep |
rman_maxcorrupt |
rman_maxopenfiles |
rman_maxpiecesize |
rman_maxsetsize |
rman_parms |
rman_pool |
rman_proxy |
rman_rate |
rman_sectionsize |
rman_send |
saveset_members |
scroll_lines |
show_period |
space_copy_dir |
split_cmd |
split_options |
split_resync |
stage_copy_cmd |
stage_db_home |
stage_root_dir |
standby_db |
stats_bucket_count |
stats_change_threshold |
stats_dbms_stats |
stats_dict_cycle |
stats_dict_degree |
stats_dict_method |
stats_dict_sample |
stats_exclude |
stats_info_cubes |
stats_limit_time |
stats_method |
stats_owner |
stats_parallel_degree |
stats_sample_size |
stats_special |
stats_system_cycle |
stats_system_interval |
stats_table |
tape_address |
tape_address_arch |
tape_address_ctl |
tape_address_ctl_arch |
tape_address_rew |
tape_address_rew_arch |
tape_block_size |
tape_copy_cmd |
tape_pos_cmd |
tape_set_offline |
tape_size |
tape_size_arch |
tape_use_count |
uncompress_cmd |
util_options |
util_par_file |
util_path |
util_vol_access |
util_vol_nlist |
util_vol_options |
util_vol_par_file |
util_vol_path |
util_vol_unit |
valid_exclude |
volume_archive |
volume_backup |
Logs for BR*Tools |
Log Types |
File System Logs |
Database Logs for BRBACKUP, BRARCHIVE, BRSPACE, and BRCONNECT |
Log Supplements |
Messages and Return Codes for BR*Tools |
Common Features of BRBACKUP and BRARCHIVE |
Supported Backup Media |
Effects of the Command Options |
cpio Continuation Tape |
cpio Error |
Canceling a Backup |
Other Tools for Oracle DBA |
Database Recovery with SQLPLUS |
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 |
Recovering from One Control File Missing |
Recovering from All Control Files Missing |
Recovering from Current Online Redo Log Missing |
Recovering from One Inactive Online Redo Log Missing |
Recovering from User Tablespace Missing |
Recovering from SYSTEM Tablespace Missing |
Recovering from Index Tablespace Missing |
Recovering from Errors During the Archiving of Online Redo Logs |
Performing an Incomplete Recovery |
Finishing an Incomplete Recovery |
Automating the Recovery |
Updating the Control File |
Oracle Recovery Manager |
RMAN Backup Strategies |
RMAN Incremental Backups After Structural Changes |
RMAN Restore of Incremental Backups |
RMAN Backup with the SAP Backup Library |
RMAN Backup with an External Backup Library |
RMAN Incremental Backups Without a Backup Library |
RMAN Backup of the Offline Redo Log File |
RMAN Tape Layout |
RMAN Backup Verify |
RMAN Save-Set Grouping |
RMAN-Relevant Profile Parameters |
The SAP Tools with Windows |
SAP Conventions (Windows) |
Naming Conventions for Files (Windows) |
Executables |
Starting the SAP Utility Programs |
Database Analysis |
Backup Strategy (Windows) |
NTBackup |
BRBACKUP/BRARCHIVE |
Other Backup Programs |
Structure-Retaining Database Copy or Restore on Windows |
Offline Backup with Oracle Fail Safe for Cluster Systems |
Oracle Real Application Cluster |
RAC with BR*Tools |
RAC with BRSPACE |
RAC with BRBACKUP |
RAC with BRARCHIVE |
RAC with BRRESTORE and BRRECOVER |
RAC with the init<DBSID>.sap Profile |
 CCMS: Oracle |