Symptom
BR*Tools Version 6.40 contains a new tool for managing Oracle databases in the SAP environment: BRSPACE.
BRSPACE replaces the remaining SAPDBA functions that were not previously performed by BR*Tools (see notes 403704 and 602497).
The main functions of BRSPACE are as follows:
* Instance management
-------------------
- Start up database
- Shut down database
- Alter database instance
- Alter database parameters
- Show instance status
- Show database parameters
* Space management
----------------
- Extend tablespace
- Create tablespace
- Drop tablespace
- Alter tablespace
- Alter data file
- Move data file
- Show tablespaces
- Show data files
- Show redolog files
- Show control files
- Show disk volumes
* Segment management
------------------
- Reorganize tables (online)
- Rebuild indexes (online)
- Export tables
- Import tables
- Alter tables
- Alter indexes
- Show tables
- Show indexes
- Show table partitions
- Show index partitions
- Show segments
- Show segment extents
- Show free extents
You can use the following call to access the new BRSPACE functions:
brgui/brtools -> Instance management
-> Space management
-> Segment management
Caution 1:
----------
To restrict the number of user interactions, you can use the "-c" option ("brtools -c") to start BRTOOLS. The BR*Tools will then only ever stop after a menu is displayed.
BRSPACE can only be called with the ora<dbsid> user on UNIX or the <dbsid>adm user on Windows. BRSPACE then connects to the database with SYSDBA authorization. Since this authorization is derived from the dba group to which this user belongs, you do not usually have to specify the database user and password ("-u" option) when you call BRSPACE.
For detailed information on BRSPACE, refer to the excerpt from the Web AS 6.40 online documentation that is available in SAP SDN:
https://www.sdn.sap.com/irj/sdn/ora -> BRSPACE
We also recommend that you attend the new Oracle database administration course ADM505, where the new BR*Tools 6.40 are described in detail.
For more information on BRGUI (graphical user interface for BR*Tools), see Note 611493.
BRGUI is the recommended user interface for BR*Tools 6.40.
The BRTOOLS character-user interface is a fallback solution.
SAPDBA is no longer delivered for Web AS 6.40. You can still use SAPDBA 6.20 (linked to Oracle 9.2) with Web AS 6.40. However, we recommend that you only use BR*Tools.
You can use BR*Tools 6.40 for all SAP releases, provided that the database is based on Oracle 9.2.
Backups that were made with BRBACKUP/BRARCHIVE 6.40 can only be restored with BRRESTORE/BRRECOVER 6.40.
You cannot use BRRESTORE/BRRECOVER 6.40 to restore backups of older BRBACKUP/BRARCHIVE versions.
BRRECOVER is able to execute the recovery procedure even after structural changes to the database. This means that it is no longer necessary to start a database backup immediately after such structure changes. Regular database backups are sufficient.
SAP/CCMS transaction DB14, which allows you to display entire BRSPACE logs, is enhanced as of the following Support Packages:
SAP Basis Release 4.6B: SAPKB46B55
SAP Basis Release 4.6C: SAPKB46C46
SAP Basis Release 4.6D: SAPKB46D35
SAP Basis Release 6.10: SAPKB61038
SAP Basis Release 6.20: SAPKB62031
You can find more information in Note 668640.
Caution 2:
----------
When using locally managed tablespaces (LMTS) and automatic segment space management (ASSM), it is essential that you read notes: 214995, 662900 and 620803.
BRSPACE replaces the remaining SAPDBA functions that were not previously performed by BR*Tools (see notes 403704 and 602497).
The main functions of BRSPACE are as follows:
* Instance management
-------------------
- Start up database
- Shut down database
- Alter database instance
- Alter database parameters
- Show instance status
- Show database parameters
* Space management
----------------
- Extend tablespace
- Create tablespace
- Drop tablespace
- Alter tablespace
- Alter data file
- Move data file
- Show tablespaces
- Show data files
- Show redolog files
- Show control files
- Show disk volumes
* Segment management
------------------
- Reorganize tables (online)
- Rebuild indexes (online)
- Export tables
- Import tables
- Alter tables
- Alter indexes
- Show tables
- Show indexes
- Show table partitions
- Show index partitions
- Show segments
- Show segment extents
- Show free extents
You can use the following call to access the new BRSPACE functions:
brgui/brtools -> Instance management
-> Space management
-> Segment management
Caution 1:
----------
To restrict the number of user interactions, you can use the "-c" option ("brtools -c") to start BRTOOLS. The BR*Tools will then only ever stop after a menu is displayed.
BRSPACE can only be called with the ora<dbsid> user on UNIX or the <dbsid>adm user on Windows. BRSPACE then connects to the database with SYSDBA authorization. Since this authorization is derived from the dba group to which this user belongs, you do not usually have to specify the database user and password ("-u" option) when you call BRSPACE.
For detailed information on BRSPACE, refer to the excerpt from the Web AS 6.40 online documentation that is available in SAP SDN:
https://www.sdn.sap.com/irj/sdn/ora -> BRSPACE
We also recommend that you attend the new Oracle database administration course ADM505, where the new BR*Tools 6.40 are described in detail.
For more information on BRGUI (graphical user interface for BR*Tools), see Note 611493.
BRGUI is the recommended user interface for BR*Tools 6.40.
The BRTOOLS character-user interface is a fallback solution.
SAPDBA is no longer delivered for Web AS 6.40. You can still use SAPDBA 6.20 (linked to Oracle 9.2) with Web AS 6.40. However, we recommend that you only use BR*Tools.
You can use BR*Tools 6.40 for all SAP releases, provided that the database is based on Oracle 9.2.
Backups that were made with BRBACKUP/BRARCHIVE 6.40 can only be restored with BRRESTORE/BRRECOVER 6.40.
You cannot use BRRESTORE/BRRECOVER 6.40 to restore backups of older BRBACKUP/BRARCHIVE versions.
BRRECOVER is able to execute the recovery procedure even after structural changes to the database. This means that it is no longer necessary to start a database backup immediately after such structure changes. Regular database backups are sufficient.
SAP/CCMS transaction DB14, which allows you to display entire BRSPACE logs, is enhanced as of the following Support Packages:
SAP Basis Release 4.6B: SAPKB46B55
SAP Basis Release 4.6C: SAPKB46C46
SAP Basis Release 4.6D: SAPKB46D35
SAP Basis Release 6.10: SAPKB61038
SAP Basis Release 6.20: SAPKB62031
You can find more information in Note 668640.
Caution 2:
----------
When using locally managed tablespaces (LMTS) and automatic segment space management (ASSM), it is essential that you read notes: 214995, 662900 and 620803.
Other Terms
BR*Tools, BRSPACE
Reason and Prerequisites
This is an advance development.
Solution
BR*Tools 6.40 is released for use on production systems as of patch level 6. Do not continue to use earlier patches.
Download the most recent BR*Tools patch from the SAP Service Marketplace. The precise procedure is described in Notes 12741 and 19466.
Download the most recent BR*Tools patch from the SAP Service Marketplace. The precise procedure is described in Notes 12741 and 19466.
Header Data
| Released On | 09.08.2007 13:47:49 |
| Release Status | Released for Customer |
| Component | BC-DB-ORA-DBA Database Administration with Oracle |
| Priority | Recommendations / Additional Info |
| Category | Advance development |
Validity
This document is not restricted to a software component or software component version
References
This document refers to:
SAP Notes
No comments:
Post a Comment