Export/Import Table using BRTOOLS

Case : I want to reorganize table and rebuild index offline for table SOFFCONT1. Table SOFFCONT1 contains SAP Business Workplace/SAPoffice objects which often grow rapidly in Netweaver based component. Procedure : Here’s the procedure to export/import tables and rebuild index using BRTOOLS, Export table SOFFCONT1 Drop index Import table SOFFCONT1 Run Update Statistics Optimizer Details [...]

New BR*Tools Feature in SAP Netweaver 7.1

In SAP Netweaver 7.1 you can find the following features of BR*Tools : Verification of database and archive log files with RMAN ( BR*Tools 7.00 patch 22 ) which affects : o BRARCHIVE -w|-verify use_rmv|first_rmv|only_rmv o BRBACKUP -w|-verify use_rmv|only_rmv o BRRESTORE -w|-verify use_rmv Support for Oracle Data Pump like export and import ( BRSPACE patch [...]

What happened with Linux clustering for SAP

Sometimes, when you fail over cluster in Linux using LifeKeeper, some user environment doesn’t set accordingly. This will make you unable to run some commands from SAP. In my case, I’m clustering he Central Instance and Database Instance into different nodes. For example in DB13, you will have an error when you schedule job like [...]

DB13 – errno 13: Permission Denied

Problem You found this error in DB13 Job Log : Job started Step 001 started (program RSDBAJOB, variant &0000000000053, user ID SAPBASIS) Execute logical command BRCONNECT On host sapdev00 Parameters: -u / -jid CHECK20090710123233 -c -f check BR0801I BRCONNECT 7.00 (18) BR0252W Function fopen() failed for ‘/oracle/DEV/102_64/dbs/initDEV.ora’ at location BrInitOraCopy-2 BR0253W errno 13: Permission denied [...]

Change Password of Database User

This is the command to change password of Oracle Database User : From BRTOOLS= BRTOOLS -> 8 – Additional functions -> 4 – Change password of database user -> continue, then you can type your new password as below (ex, SID = DEV): BR0801I BRCONNECT 7.00 (18) BR0280I BRCONNECT time stamp: 2009-07-14 01.52.04 BR0263I Enter [...]

Reorganize Table in SAP

Why do we need to reorganize table in SAP system ? This is the important question before we plan to reorganize table in SAP system. Since Data Management Strategy is the key factor to boost system performance and and to keep data accessibility more efficient, we need to maintain or oraganize the data itself. One [...]

BRTOOLS – BR0154E Error

Have you ever face error when executing BRTOOLS in a command prompt? Here is the example using brspace : C:\Documents and Settings\r3padm>brspace -f tbexport -t soffcont1 BR1001I BRSPACE 7.00 (38) BR0154E Unexpected option value ‘ûf’ found at position 1 BR0154E Unexpected option value ‘tbexport’ found at position 2 BR0154E Unexpected option value ‘ût’ found at [...]