SAP Database Guide: Oracle (BC-DB-ORA-DBA) |
New Features |
New Features in SAP Release 6.20 |
New Features in SAP Release 6.10 |
New Features in SAP R/3 Release 4.6 |
New Features in SAP R/3 Release 4.5 |
Release 4.5: SAPDBA |
Release 4.5: BRBACKUP, BRARCHIVE, and BRRESTORE |
New Features in SAP R/3 Release 4.0 |
Getting Started with Oracle and the SAP System |
Computing Center Management System |
Specification of SAP Tables in the ABAP Dictionary |
Oracle Database Storage Parameters in the ABAP Dictionary |
Support with SAP Service Marketplace |
GoingLive and EarlyWatch |
Oracle Databases on Raw Devices |
Raw Devices and SAPDBA |
Raw Devices with BRBACKUP and BRRESTORE |
Limitations of the Oracle Database System |
Database System Configuration |
Changing Database User Passwords |
Initializing SAP Connect |
Setting Archive and Database Mode with SAPDBA |
Setting Up Archiving |
Mirroring the Control File |
Mirroring Online Redo Log Files |
Organizing Disk Storage |
Database Parameters |
SAP Naming Conventions for Tablespaces and Data Files |
Environment Variables (UNIX) |
Environment Variables (Windows NT) |
Directory Structure (UNIX) |
Directory Structure (Windows NT) |
Approach to Oracle DBA |
Database Mode |
Database System Check |
Space Management |
Update Statistics |
Backup, Restore, and Recovery |
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 Retention Period Zero |
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 |
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 Verify |
Approach to Restore and Recovery |
Disaster Recovery |
Partial Restore and Complete Recovery |
Full Restore and Point-In-Time Recovery |
Database Reset |
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 |
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 Disk 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 |
Veritas Quick I/O Feature |
External Backup Programs |
Tools for Oracle DBA |
SAPDBA for Oracle |
Getting Started with SAPDBA |
SAPDBA Configuration |
Configuring the SAPDBA Display Length |
Configuring the UNIX Command at |
Setting the Log Checks Option |
Users and Roles |
UNIX User Configurations |
Effects of Autoextend and Resize on SAPDBA |
Starting SAPDBA |
Checking SAPDBA Release Information |
SAPDBA Main Menu |
Show/Cleanup to Manage Logs and Profiles with SAPDBA |
Initialization Profile init<DBSID>.dba with SAPDBA |
backup_util_name |
blkdev_dir |
check_controlfile_mirror |
check_initial_settings |
check_redolog_mirror |
exe_dir |
exireo_dumpdir |
exireo_exp_imp_buf |
expir_period_brarchive |
exp_imp_degree |
file_or_raw |
index_degree |
max_file_size |
message_buf |
orapwd_always_used |
parallel_instances |
rawdev_dir |
recovery_degree |
sqldba_path |
trace_level |
tspadd_tspname |
Sample Initialization Profile |
SAPDBA Log Files and Their Contents |
Structure Log |
Central Log reorg<DBSID>.log |
Return Codes in the Central Log reorg<DBSID>.log |
Logs for Parallel Export and Import Processes |
Logging Information in CCMS |
Deleting Log, Directory, Audit, and Trace Files |
SAPDBA Scripts and Files |
Starting SQL Scripts Manually with SQLPLUS |
Starting Individual SQL Scripts with SAPDBA |
Starting Shell Scripts for Oracle Export and Import |
Startup and Shutdown of the Oracle Database with SAPDBA |
Checking the Status of the Oracle Database System |
Starting Up the Oracle Database System |
Shutting Down the Oracle Database System |
Switching to Restricted Session Mode |
Update Statistics for the Cost-Based Optimizer with SAPDBA |
Updating Statistics using Integrated Approach with SAPDBA |
Updating Statistics using Optimizer Control with SAPDBA |
Update Statistics: Internal Rules with SAPDBA |
Tablespace Administration with SAPDBA |
Check Tablespaces |
Checking Freespace for Tablespaces |
Checking Freespace for Objects in Tablespace |
Preventing Tablespace Overflow |
Extending a Tablespace |
Creating or Dropping a Tablespace |
Specifying the Path for the New Data File |
Specifying the Size for the New Data File |
Checks for Tablespace Extension and Creation |
Backing Up After Tablespace Operations |
Displaying File and Raw Device Information for a Tablespace |
Reorganization with SAPDBA |
Preparations for Reorganization |
Checking Statistics for a Reorganization |
Checking Extents and Fragmentation |
Deciding if a Reorganization is Necessary |
Performance Improvements for Reorganization |
Changing the Initialization Profile to Speed Up Reorganization |
Performing Processes in Parallel to Speed Up Reorganization |
Reorganizing in NOARCHIVELOG Mode |
Choosing a Reorganization Type |
Backing Up the Database for Reorganization |
Change Storage Parameters with SAPDBA |
Viewing and Changing Storage Parameters |
Storage Parameters |
Default Value for NEXT |
Reorganization |
Reorganizing a Single Table or Index |
Reorganizing a List of Tables and Indexes |
Reorganizing a Tablespace |
Reorganization of Special Tablespaces |
Reorganizing a Tablespace and Data Files |
Moving or Renaming the Data Files of a Tablespace |
Resizing the Data Files of a Tablespace |
Restarting a Reorganization |
Restart File for Reorganizations |
Freespace Check for a Reorganization |
Background Reorganization |
Reorganization Methods |
Storage Parameters for Reorganization and Export/Import |
Export and Import of Database Objects with SAPDBA |
Preparations for Export and Import |
Types of Export and Import |
Parallel Export and Import |
Export with SAPDBA |
Exporting Tables and Indexes Including Data |
Exporting Structures of Tables and Indexes |
Exporting Constraints, Synonyms, Sequences, Views, and Grants |
Storage Parameters for Reorganization and Export/Import |
Import with SAPDBA |
Importing Tables and Indexes Including Data |
Importing Structures |
Restarting an Export or Import |
Restart File for Export or Import |
Database Backup with SAPDBA |
Backing Up the Database with SAPDBA |
Setting Parameters for SAPDBA Database Backup |
Setting Special Options for SAPDBA Database Backup |
Backup of the Offline Redo Log Files with SAPDBA |
Backing Up the Offline Redo Log Files with SAPDBA |
Setting Parameters for SAPDBA Backup of Offline Redo Logs |
Setting Special Options for SAPDBA Backup of Offline Redo Logs |
Grouping Offline Redo Log Files |
Database Restore and Recovery with SAPDBA |
Partial Restore and Complete Recovery with SAPDBA |
Checking the Database |
Finding the Backup Files |
Restoring the Backup Files |
Finding Incremental Backups |
Restoring Incremental Backups |
Finding the Offline Redo Log Files |
Restoring the Offline Redo Log Files |
Recovering the Database |
Recovering the Database Automatically |
Changing the Restore and Recovery Options |
Performing a Full Restore and Point-In-Time Recovery with SAPDBA |
Resetting the Database |
Restoring One Tablespace |
Restoring Individual Files |
SAPDBA Command Options |
sapdba -alter_user |
sapdba -analyze |
sapdba -check |
sapdba -check_db_open |
sapdba -checkopt |
sapdba -cleanup |
sapdba -delete |
sapdba -export |
sapdba -fill_tables |
sapdba -init_sap_connect |
sapdba -next <tablespace(s)> |
sapdba -r |
sapdba -shutdown(_abort) |
sapdba -startup(_dba) |
sapdba -statistics |
sapdba -version |
Return Codes for SAPDBA Command Options |
BRBACKUP, BRARCHIVE, BRRESTORE, and BRCONNECT |
Common Features of BRBACKUP and BRARCHIVE |
Supported Backup Media |
Effects of the Command Options |
cpio Continuation Tape |
cpio Error |
Canceling a Backup |
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 |
-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 |
-V|-VERSION |
BRBACKUP Logs |
Names of the BRBACKUP Detail Logs |
BRBACKUP Detail Log |
BRBACKUP Summary Log |
Profile Parameters and BRBACKUP Command Options |
BRARCHIVE |
Hardware Compression for BRARCHIVE |
Logging for BRARCHIVE |
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 |
-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 |
-h|-help |
-k|-compress |
-l|-language |
-m|-mode |
-n|-number |
-o|-output |
-p|-profile |
-q|-query |
-r|-parfile |
-w|-verify |
-V|-VERSION |
BRRESTORE Logs |
Names of the BRRESTORE Detail Logs |
BRRESTORE Detail Log |
BRRESTORE Summary 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 |
Clean Up Old Logs and Traces with BRCONNECT |
Additional BRCONNECT Functions |
Command Options for BRCONNECT |
-c|-confirm |
-f|-function |
-f check |
-f chpass |
-f cleanup |
-f crsyn |
-f dbshut |
-f next |
-f stats |
-h|-help |
-l|-language |
-o|-output |
-p|-profile |
-q|-query |
-s|-sapsid |
-u|-user |
-V|-VERSION |
BRCONNECT Logs |
Names of the BRCONNECT Detail Logs |
BRCONNECT Detail Log |
BRCONNECT Summary Log |
BRTOOLS |
Initialization Profile init<DBSID>.sap |
archive_copy_dir |
archive_function |
archive_stage_dir |
backup_dev_type |
backup_mode |
backup_root_dir |
backup_type |
check_exclude |
check_owner |
cleanup_brarchive_log |
cleanup_brbackup_log |
cleanup_brconnect_log |
cleanup_brrestore_log |
cleanup_check_msg |
cleanup_db_log |
cleanup_disk_archive |
cleanup_disk_backup |
cleanup_exp_dump |
cleanup_ora_trace |
cleanup_owner |
cleanup_sapdba_log |
cleanup_xdb_log |
compress |
compress_cmd |
compress_dir |
copy_in_cmd |
copy_out_cmd |
cpio_disk_flags |
cpio_flags |
cpio_in_flags |
dd_flags |
dd_in_flags |
disk_copy_cmd |
dismount_cmd |
exec_parallel |
expir_period |
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 |
primary_db |
remote_host |
remote_user |
restore_mode |
resync_cmd |
rewind |
rewind_offline |
rman_channels |
rman_diskratio |
rman_duplex |
rman_filesperset |
rman_kbytes |
rman_maxopenfiles |
rman_parms |
rman_pool |
rman_proxy |
rman_readrate |
rman_setsize |
saveset_members |
split_cmd |
stage_copy_cmd |
stage_db_home |
stage_root_dir |
stats_bucket_count |
stats_change_threshold |
stats_dbms_stats |
stats_exclude |
stats_info_cubes |
stats_limit_time |
stats_method |
stats_owner |
stats_parallel_degree |
stats_sample_size |
stats_table |
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 |
Logs for BRBACKUP, BRARCHIVE, BRRESTORE, and BRCONNECT |
Log Types |
File System Logs |
Database Logs for BRBACKUP, BRARCHIVE, and BRCONNECT |
Log Supplements |
Messages and Return Codes for the BR Tools |
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 |
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 Redo Logs |
Partial Recovery |
Actions after a Partial Recovery |
Automating the Recovery |
Updating the Control File |
The SAP Utilities with Windows NT |
SAP Conventions (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 |
Structure-Retaining Database Copy or Restore on Windows NT |
Offline Backup with Oracle Fail Safe for Cluster Systems |