SAP Security Online!
 
Web SAPSecurityOnline.com
 
   
 
 
 

 
 
Database Administration Tools


Database administration can be done with the Oracle tool SQL*Plus like

• Start up and shut down a database
• Connect to a database
• Perform database administration
• Enter SQL*Plus commands to configure an SQL*Plus environment
• Enter, edit, store, retrieve, and run SQL commands and SQL scripts
• Redirect the output of query results to text files

However, in SAP Oracle database can be administrated using BR*Tools. They are installed while installation on the database server in the directory /usr/sap/<SID>/SYS/exe/

Note: BR*Tools is the program package containing BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRSPACE, BRCONNECT, and BRTOOLS.

BRTOOLS is the interactive program that displays menus from which the other BR.. programs are called.

BRTOOLS is an interactive tool for calling tools listed below. BRTOOLS provided as a character-based user interface for the functional programs listed below

BRBACKUP - Backup of data files, online redo log files, and control files.

BRARCHIVE- Backup of offline redo logs.

BRRESTORE - Restore of data files, online redo log files, offline redo logs and control files.

BRRECOVER - Tool for database recovery and restore.

BRSPACE- Tool for instance and space management and also reorg.

BRCONNECT- Database check, update statistics, changing user password.

 

 

 



 
Copyright © 2005 - 2007 SAP Security Online.com All Rights Reserved.