SAP Database Guide: OracleNew FeaturesNew Features in SAP BR*Tools 7.20New Features in SAP BR*Tools 7.10New Features in SAP BR*Tools 7.00Getting Started with Oracle and the SAP SystemDatabase SecurityComputing Center Management SystemSpecification of SAP Tables in the ABAP DictionaryOracle Database Storage Parameters in the ABAP DictionarySupport on SAP Service MarketplaceDatabase System ConfigurationSetting Up ArchivingMirroring the Control FileMirroring the Online Redo Log FilesOrganizing Disk StorageSAP Naming Conventions for Tablespaces and Data FilesDatabase ParametersEnvironment Variables (UNIX)Environment Variables (Windows)Directory Structure (UNIX)Directory Structure (Windows)Users and RolesOracle Databases on Raw DevicesRaw Devices and BR*ToolsRaw Devices with BRBACKUP and BRRESTOREAutomatic Storage ManagementLimitations of the Oracle Database SystemApproach to Oracle DBAInstance ManagementRecreate DatabaseManage Online Redo LogsManage Data EncryptionSpace ManagementManaging TablespacesManaging Data FilesSegment ManagementReorganizationExport/ImportSpecial Export and Import Functions with BRSPACEReorganization Case StudyReorganization with the Redefinition PackageDatabase BackupBackup OverviewWhy Back Up the Database?What Needs Backing Up?Database Backup TypesOnline and Offline BackupConsistent Online BackupComplete BackupIncremental BackupBackup CyclesBackup Approach with Daily Complete BackupsBackup Approach for Very Large Database with Partial BackupsBackup Approach with One-Day Retention PeriodBackup MediaVolume ManagementVolume InitializationVolume Label CheckVolume Expiration PeriodUsed VolumesScratch VolumeSelecting Volumes ManuallySelecting Volumes with External ToolsSelecting Volumes AutomaticallyTape Volume SizeHardware CompressionSoftware CompressionBackup MethodsBackup to Multiple DisksBackup to a Remote DiskBackup to a Remote Tape DeviceTwo-Phase BackupStructure-Retaining Database CopyParallel BackupUnattended BackupBRBACKUP and BRARCHIVE Backups in One RunBackup VerificationGrouping Offline Redo Log FilesAdvanced Backup and RecoveryBackup of Large Oracle DatabasesBackup Devices for Large DatabasesBackup of Large Databases to Tape with BRBACKUPExternal Backup Programs for Large DatabasesParallel Backup of Large Databases to Disk with BRBACKUPOptimization of File DistributionOptimization with a Logical Volume ManagerPartial BackupsTablespace BackupsBackup Example for a Large DatabaseSpeeding Up the BackupStandby DatabaseStandby Database ConfigurationStandby Database: BRARCHIVE Backup of Offline Redo Log FilesStandby Database: BRBACKUP Backup of Database FilesStandby Database: Restore and RecoveryStandby Database: Remote Database Connect RequirementsSplit Mirror BackupSplit Mirror Online BackupSplit Mirror Offline BackupSplit Mirror Backup: Software ConfigurationBackup with Automatic Tape ChangersMount and Dismount CommandsAutoloader Backup ExampleExternal Backup ProgramsFixing an Online Backup CrashAbort of Archive, Backup, or RestoreRestore and RecoveryComplete Database RecoveryDatabase Point-In-Time RecoveryTablespace Point-in-Time RecoveryWhole Database ResetRestore of Individual Backup FilesRestore and Application of Offline Redo Log FilesDisaster RecoveryDatabase System CheckUpdate StatisticsBR*Tools Studio for Oracle DBAGetting Started with BR*Tools StudioInstalling BR*Tools StudioRunning BR*Tools Studio for the First TimeBR*Tools Studio: ConsoleBR*Tools Studio: WizardBR*Tools Studio: AdministrationBR*Tools Studio: LandscapeBR*Tools Studio: Case StudyBR*Tools Studio: Role ConceptBR*Tools for Oracle DBAGetting Started with BR*ToolsConfiguration of BR*ToolsConfiguring the Scroll Line Count for BR*ToolsConfiguring the UNIX Command at for BR*Tools Batch FunctionsSetting the Option To Log Displayed Information for BRSPACEEffects of Autoextend and Resize on BR*ToolsStarting BR*ToolsBR*Tools User InterfaceHow to Use BR*ToolsChecking BR*Tools Release InformationBR*Tools in ActionInstance Management with BR*ToolsStarting Up the Database with BR*ToolsShutting Down the Database with BR*ToolsAltering the Database Instance with BR*ToolsAltering Database Parameters with BR*ToolsRecreating a Database with BR*ToolsManaging Online Redo LogsManaging Data EncryptionShowing Instance Status with BR*ToolsShowing Database Parameters with BR*ToolsShowing Database Owners with BR*ToolsShowing Flashback Status with BR*ToolsShowing Encryption Status with BR*ToolsSpace Management with BR*ToolsExtending a Tablespace with BR*ToolsCreating a Tablespace with BR*ToolsDropping a Tablespace with BR*ToolsAltering a Tablespace with BR*ToolsAltering a Data File with BR*ToolsMoving a Data File with BR*ToolsShowing Tablespaces with BR*ToolsShowing Data Files with BR*ToolsShowing Redo Log Files with BR*ToolsShowing Control Files with BR*ToolsShowing Disk Volumes with BR*ToolsSegment Management with BR*ToolsReorganizing Tables with BR*ToolsRebuilding Indexes with BR*ToolsExporting Tables with BR*ToolsImporting Tables with BR*ToolsAltering Tables with BR*ToolsAltering Indexes with BR*ToolsShowing Tables with BR*ToolsShowing Indexes with BR*ToolsShowing Table Partitions with BR*ToolsShowing Index Partitions with BR*ToolsShowing Segments with BR*ToolsShowing Segment Extents with BR*ToolsShowing Free Extents with BR*ToolsBackup and Database Copy with BR*ToolsBacking Up the Database with BR*ToolsBacking Up the Offline Redo Log Files with BR*ToolsCopying the Database with BR* ToolsNon-Database Backup with BR*ToolsBacking Up a Database Disk BackupVerifying a Database Backup with BR*ToolsVerifying an Offline Redo Log Backup with BR*ToolsAdditional Functions for Backup and Database Copy with BR*ToolsUpdating Compression Rates with BR*ToolsPreparing RMAN Backups with BR*ToolsDeleting Database Disk Backups with BR*ToolsDeleting Offline Redo Log Backups on Disk with BR*ToolsControlling of BRARCHIVE Run with BR*ToolsInitializing BRBACKUP Tape Volumes with BR*ToolsInitializing BRARCHIVE Tape Volumes with BR*ToolsRestore and Recovery with BR*ToolsComplete Database Recovery with BR*ToolsDatabase Point-In-Time Recovery with BR*ToolsTablespace Point-In-Time Recovery with BR*ToolsWhole Database Reset with BR*ToolsRestore of Individual Backup Files with BR*ToolsRestore and Application of Offline Redo Log Files with BR*ToolsDisaster Recovery with BR*ToolsManaging Flashback Database with BR*ToolsProcedures for Restore and Recovery with BR*ToolsSetting Point In Time and Tablespaces for RecoveryChecking the Status of Database Files - ISelecting Database BackupsChecking the Status of Database Files - IIChecking the Status of TablespacesExporting the Tablespaces Not Being RecoveredRestoring Control FilesRestoring Data FilesRestoring and Applying an Incremental BackupRestoring and Applying Offline Redo Log FilesPerforming Flashback DatabaseOpening the DatabaseCheck and Verification with BR*ToolsChecking the Database System with BR*ToolsValidating the Database Structure with BR*ToolsVerifying Database Blocks with BR*ToolsDatabase Statistics with BR*ToolsUpdating Database Statistics with BR*ToolsCollecting Missing Statistics with BR*ToolsCollecting Dictionary Statistics with BR*ToolsCollecting System Statistics with BR*ToolsDeleting Harmful Statistics with BR*ToolsManaging Database Statistics with BR*ToolsAdditional Functions with BR*ToolsShowing Profiles and Logs with BR*ToolsCleaning Up DBA Logs and Tables with BR*ToolsAdapting Next Extents with BR*ToolsMethods of Adapting Next Extent SizeChanging the Password of the Database User with BR*ToolsCreating or Changing Synonyms for DBA TablesBR*Tools in DetailBRBACKUPBacking Up Database FilesBacking Up Non-Database Files and DirectoriesCompletion of BRBACKUP BackupsHardware Compression for BRBACKUPCommand 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|-VERSIONBRBACKUP LogsNames of the BRBACKUP Detail LogsBRBACKUP Detail LogBRBACKUP Summary LogBRARCHIVEHardware Compression for BRARCHIVECommand 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|-VERSIONBRARCHIVE LogsNames of the BRARCHIVE Detail LogsBRARCHIVE Detail LogBRARCHIVE Summary LogBRRESTORERestoring FilesCompletion of BRRESTORE RunsExamples of BRRESTORE RunsCommand 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|-VERSIONBRRESTORE LogsNames of the BRRESTORE Detail LogsBRRESTORE Detail LogBRRESTORE Summary LogBRRECOVERCommand 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|-ownerBRRECOVER LogsBRRECOVER Detail LogBRRECOVER Summary LogBRSPACECommand 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|-VERSIONBRSPACE LogsBRSPACE Detail LogBRSPACE Summary LogBRSPACE Structure Change LogBRSPACE Parameter Change LogBRCONNECTDatabase System Check with BRCONNECTBRCONNECT Default Conditions for Database AdministrationBRCONNECT Default Conditions for Database OperationsAdapt Next Extents with BRCONNECTInternal Rules for Determining Next Extent SizeUpdate Statistics with BRCONNECT-force with Update StatisticsDeletion of Damaging StatisticsVerification of Table and Index StructureInternal Rules for Update StatisticsUpdate Statistics for InfoCube TablesSample Sizes for Update StatisticsChanging Database User Passwords with BRCONNECTClean Up Old Logs and Trace Files with BRCONNECTAdditional BRCONNECT FunctionsCommand 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|-VERSIONBRCONNECT LogsNames of the BRCONNECT Detail LogsBRCONNECT Detail LogBRCONNECT Summary LogBRTOOLSCommand Options for BRTOOLS-c|-confirm-h|-help-i|-interval-l|-language-p|-profile-s|-scroll-u|-user-w|-show-V|-VERSIONProfiles, Logs, Messages, and Return Codes for BR*ToolsInitialization Profile init<DBSID>.saparchive_copy_dirarchive_dupl_delarchive_functionarchive_stage_dirasm_ora_homeasm_ora_sidasm_ora_sidbackup_dev_typebackup_modebackup_root_dirbackup_typecheck_condcheck_excludecheck_ownercleanup_brarchive_logcleanup_brbackup_logcleanup_brconnect_logcleanup_brrecover_logcleanup_brrestore_logcleanup_brspace_logcleanup_check_msgcleanup_db_logcleanup_disk_archivecleanup_disk_backupcleanup_exp_dumpcleanup_ora_dircleanup_ora_sdircleanup_ora_tracecleanup_ownercleanup_xdb_logcompresscompress_cmdcompress_dircopy_in_cmdcopy_out_cmdcpio_disk_flagscpio_flagscpio_in_flagsdb_servicesdd_flagsdd_in_flagsdisk_copy_cmddismount_cmdexec_parallelexp_dump_direxp_tableexpir_periodimp_tableloc_ora_homesmount_cmdmount_par_filenew_db_homenext_excludenext_limit_countnext_max_sizenext_ownernext_specialnext_tableorig_db_homeparallel_instancespipe_copy_cmdpost_arch_cmdpost_back_cmdpost_shut_cmdpost_split_cmdpre_arch_cmdpre_back_cmdpre_shut_cmdpre_split_cmdprimary_dbrebuild_indexrebuild_indpartrecov_copy_dirrecov_degreerecov_intervalrecov_typeremote_hostremote_userreorg_tablereorg_tabpartrestore_moderesync_cmdrewindrewind_offlinerman_channelsrman_compressrman_copiesrman_cross_checkrman_diskratiorman_durationrman_filespersetrman_keeprman_maxcorruptrman_maxopenfilesrman_maxpiecesizerman_maxsetsizerman_parmsrman_poolrman_proxyrman_raterman_sectionsizerman_sendsaveset_membersscroll_linesshow_periodspace_copy_dirsplit_cmdsplit_optionssplit_resyncstage_copy_cmdstage_db_homestage_root_dirstandby_dbstats_bucket_countstats_change_thresholdstats_dbms_statsstats_dict_cyclestats_dict_degreestats_dict_methodstats_dict_samplestats_excludestats_info_cubesstats_limit_timestats_methodstats_ownerstats_parallel_degreestats_sample_sizestats_specialstats_system_cyclestats_system_intervalstats_tabletape_addresstape_address_archtape_address_ctltape_address_ctl_archtape_address_rewtape_address_rew_archtape_block_sizetape_copy_cmdtape_pos_cmdtape_set_offlinetape_sizetape_size_archtape_use_countuncompress_cmdutil_optionsutil_par_fileutil_pathutil_vol_accessutil_vol_nlistutil_vol_optionsutil_vol_par_fileutil_vol_pathutil_vol_unitvalid_excludevolume_archivevolume_backupLogs for BR*ToolsLog TypesFile System LogsDatabase Logs for BRBACKUP, BRARCHIVE, BRSPACE, and BRCONNECTLog SupplementsMessages and Return Codes for BR*ToolsCommon Features of BRBACKUP and BRARCHIVESupported Backup MediaEffects of the Command Optionscpio Continuation Tapecpio ErrorCanceling a BackupOther Tools for Oracle DBADatabase Recovery with SQLPLUSTypes of Database ErrorsError AnalysisRecovery after User ErrorsRecovery after Statement ErrorsRecovery after Process ErrorsRecovery after an Instance ErrorRecovery after Media ErrorsRecovering from One Control File MissingRecovering from All Control Files MissingRecovering from Current Online Redo Log MissingRecovering from One Inactive Online Redo Log MissingRecovering from User Tablespace MissingRecovering from SYSTEM Tablespace MissingRecovering from Index Tablespace MissingRecovering from Errors During the Archiving of Online Redo LogsPerforming an Incomplete RecoveryFinishing an Incomplete RecoveryAutomating the RecoveryUpdating the Control FileOracle Recovery ManagerRMAN Backup StrategiesRMAN Incremental Backups After Structural ChangesRMAN Restore of Incremental BackupsRMAN Backup with the SAP Backup LibraryRMAN Backup with an External Backup LibraryRMAN Incremental Backups Without a Backup LibraryRMAN Backup of the Offline Redo Log FileRMAN Tape LayoutRMAN Backup VerifyRMAN Save-Set GroupingRMAN-Relevant Profile ParametersThe SAP Tools with WindowsSAP Conventions (Windows)Naming Conventions for Files (Windows)ExecutablesStarting the SAP Utility ProgramsDatabase AnalysisBackup Strategy (Windows)NTBackupBRBACKUP/BRARCHIVEOther Backup ProgramsStructure-Retaining Database Copy or Restore on WindowsOffline Backup with Oracle Fail Safe for Cluster SystemsOracle Real Application ClusterRAC with BR*ToolsRAC with BRSPACERAC with BRBACKUPRAC with BRARCHIVERAC with BRRESTORE and BRRECOVERRAC with the init<DBSID>.sap Profile