1. Access to the operating system as oraSID and then, perform BRTOOLS command.
> brtools
2. Select 2 – Space management.
------------------------------------------------------------------------------- BR*Tools main menu 1 = Instance management 2 - Space management 3 - Segment management 4 - Backup and database copy 5 - Restore and recovery 6 - Check and verification 7 - Database statistics 8 - Additional functions 9 - Exit program Standard keys: c - cont, b - back, s - stop, r - refr, h - help -------------------------------------------------------------------------------
3. Select 7 – Additional space functions.
------------------------------------------------------------------------------- Database space management 1 = Extend tablespace 2 - Create tablespace 3 - Drop tablespace 4 - Alter tablespace 5 - Alter data file 6 - Move data file 7 - Additional space functions 8 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help -------------------------------------------------------------------------------
4. Select 4 – Show control files.
------------------------------------------------------------------------------- Additional database space functions 1 = Show tablespaces 2 - Show data files 3 - Show redolog files 4 - Show control files 5 - Show disk volumes Standard keys: c - cont, b - back, s - stop, r - refr, h - help -------------------------------------------------------------------------------
5. Select “c” to continue.
------------------------------------------------------------------------------- BRSPACE main options for showing database information 1 - BRSPACE profile (profile) ........ [initSID.sap] 2 - Database user/password (user) .... [/] 3 # Database instance (instance) ..... [] 4 # Database parameter (parameter) ... [] 5 # Database tablespace (tablespace) . [] 6 ~ Database file (file) ............. [] 7 # Database owner (owner) ........... [] 8 # Database tables (table) .......... [] 9 # Database indexes (index) ......... [] 10 # Table partitions (tabpart) ....... [] 11 # Index partitions (indpart) ....... [] Standard keys: c - cont, b - back, s - stop, r - refr, h - help -------------------------------------------------------------------------------
6. Select “c” again to continue.
------------------------------------------------------------------------------- Additional BRSPACE options for showing database information 1 - Create log file (log) .......... [no] 2 - Confirmation mode (confirm) .... [yes] 3 # Extended output (output) ....... [no] 4 - Scrolling line count (scroll) .. [20] 5 - Message language (language) .... [E] 6 - BRSPACE command line (command) . [-p initSID.sap -s 20 -l E -f dbshow -c cfinfo] Standard keys: c - cont, b - back, s - stop, r - refr, h - help -------------------------------------------------------------------------------
7. Again, select “c” to continue.
BR0291I BRSPACE will be started with options '-p initSID.sap -s 20 -l E -f dbshow -c cfinfo' BR0280I BRTOOLS time stamp: 2013-07-19 02.46.44 BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
8. You can get the control files list and locations as below.
------------------------------------------------------------------------------- List of database control files Pos. Size[KB] Device Type File 1 - 36976 72 FILE /oracle/SID/sapdata1/cntrl/cntrlSID.dbf 2 - 36976 69 FILE /oracle/SID/saparch/cntrl/cntrlSID.dbf 3 - 36976 84 FILE /oracle/SID/origlogA/cntrl/cntrlSID.dbf Standard keys: c - cont, b - back, s - stop, r - refr, h - help -------------------------------------------------------------------------------
