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.
|