SAP Database Guide: Oracle (BC-DB-ORA-DBA)
New Features
New Features in SAP NetWeaver 7.0
New Features in SAP Release 6.40
New Features in SAP Release 6.30
New Features in SAP Release 6.20
New Features in SAP Release 6.10
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
GoingLive and Early Watch
Database System Configuration
Setting Up Archiving
Mirroring the Control File
Mirroring the Online Redo Log Files
Organizing Disk Storage
Database Parameters
SAP Naming Conventions for Tablespaces and Data Files
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
Limitations of the Oracle Database System
Approach to Oracle DBA
Instance Management
Recreate Database
Space Management
Managing Tablespaces
Managing Data Files
Segment Management
Reorganization
Export/Import
Special Export 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
Parameter tape_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 Verify
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
Veritas Quick I/O Feature
External Backup Programs
Fixing an Online Backup Crash
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 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
Showing Instance Status with BR*Tools
Showing Database Parameters 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
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
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
Deleting Harmful 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
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
Logging 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
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
-n2|-number2
-o|-output
-p|-profile
-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
-g|-scn|-change
-h|-help
-i|-interval
-j|-ins|-instance
-l|-language
-m|-pit|-time
-n|-seq|-sequence
-n|-seq1|-sequence1
-p|-profile
-r|-parfile
-s|-scroll
-t|-type
-u|-user
-V|-VERSION
-w|-own|-owner
BRRECOVER Logs
BRRECOVER Detail Log
BRRECOVER Summary Log
BRSPACE
Command options for BRSPACE
-c|-confirm
-f|-function
-f dbstart
-f dbshut
-f dbalter
-f dbparam
-f dbcreate
-f dbshow
-f tsextend
-f tscreate
-f tsdrop
-f tsalter
-f dfalter
-f dfmove
-f tbreorg
-f idrebuild
-f tbexport
-f tbimport
-f tbalter
-f idalter
-h|-help
-l|-language
-o|-output
-p|-profile
-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
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 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
backup_dev_type
backup_mode
backup_root_dir
backup_type
check_exclude
check_owner
cleanup_brarchive_log
cleanup_brbackup_log
cleanup_brconnect_log
cleanup_brrecover_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_brspace_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
exp_dump_dir
exp_table
expir_period
imp_table
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
primary_db
rebuild_index
recov_copy_dir
recov_degree
recov_interval
recov_type
remote_host
remote_user
reorg_table
restore_mode
resync_cmd
rewind
rewind_offline
rman_channels
rman_diskratio
rman_copies
rman_filesperset
rman_maxpiecesize
rman_maxopenfiles
rman_parms
rman_pool
rman_proxy
rman_rate
rman_send
rman_maxsetsize
saveset_members
scroll_lines
show_period
space_copy_dir
split_cmd
split_options
split_resync
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_system_interval
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 BR*Tools
Log Types
File System Logs
Database Logs for BRBACKUP, BRARCHIVE, BRSPACE, and BRCONNECT
Log Supplements
Messages and Return Codes for the 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