cancel
Showing results for 
Search instead for 
Did you mean: 

BRTOOLS error while checking tabespace

Former Member
0 Kudos

Hi,

I am facing issue with brtools as

1. loged in using orasid and entered to BRTOOLS

2. selected option 2 for space management

3. selected option for 5 alter data file

4. selected option c for continue

then i am getting below error

BR0280I BRTOOLS time stamp: 2010-03-25 23.22.59

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0291I BRSPACE will be started with options '-p initBWQ.sap -s 20 -l E -f dfalter'

BR0280I BRTOOLS time stamp: 2010-03-25 23.22.59

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

BR0280I BRTOOLS time stamp: 2010-03-25 23.23.20

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR0280I BRTOOLS time stamp: 2010-03-25 23.23.22

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

###############################################################################

BR0200I BR_TRACE: location BrPipeOpen-1, command line:

'( /usr/sap/BWQ/SYS/exe/run/brspace -p initBWQ.sap -s 20 -l E -U -f dfalter ) 2>&1'

BR1001I BRSPACE 7.00 (34)

BR0248I BR_TRACE: level 0, function main entry with '/usr/sap/BWQ/SYS/exe/run/brspace -p initBWQ.sap -s 20 -l E -U -f dfalter'

BR1002I Start of BRSPACE processing: secwfzta.dfa 2010-03-25 23.23.22

BR0484I BRSPACE log file: /oracle/BWQ/sapreorg/secwfzta.dfa

BR0280I BRSPACE time stamp: 2010-03-25 23.23.22

BR0644I BR_TRACE: location BrDbaConnect-2, SQL statement:

'CONNECT / IN SYSDBA MODE'

BR0300I BR_TRACE: SQL code: 0, number of processed rows: 0

BR0644I BR_TRACE: location BrDbaConnect-3, SQL statement:

'ALTER SESSION SET SQL_TRACE = TRUE'

BR0300I BR_TRACE: SQL code: 0, number of processed rows: 0

BR0644I BR_TRACE: location BrDbaConnect-4, SQL statement:

'SELECT NVL(INSTANCE_NAME, ' '), NVL(INSTANCE_NUMBER, 0), NVL(STATUS, ' '), NVL(LOGINS, ' '), NVL(VERSION, ' '), NVL(ARCHIVER, ' '), NVL(PARALLEL, ' '), NVL(TO_NUMBER(TO_CHAR(STARTUP_TIME, 'YYYYMMDDHH24MISS')), 0) FROM V$INSTANCE WHERE ROWNUM = 1'

BR0300I BR_TRACE: SQL code: 0, number of processed rows: 1

BR0645I BR_TRACE: location BrDbaConnect-5, SQL output:

'BWQ', '1', 'OPEN', 'ALLOWED', '10.2.0.2.0', 'STARTED', 'NO', '20100319130106'

BR0644I BR_TRACE: location BrDbaConnect-6, SQL statement:

'SELECT NAME, CONTROLFILE_TYPE, NVL(RESETLOGS_CHANGE#, 0), NVL(TO_NUMBER(TO_CHAR(RESETLOGS_TIME, 'YYYYMMDDHH24MISS')), 0) NVL(TO_NUMBER(TO_CHAR(CREATED, 'YYYYMMDDHH24MISS')), 0), LOG_MODE FROM V$DATABASE WHERE ROWNUM = 1'

BR0300I BR_TRACE: SQL code: 0, number of processed rows: 1

BR0645I BR_TRACE: location BrDbaConnect-7, SQL output:

'BWQ', 'CURRENT', '1', '20070222234833', 20070222234833', 'ARCHIVELOG'

BR0644I BR_TRACE: location BrCurrRedoGet-3, SQL statement:

'SELECT NVL(MAX(SEQUENCE#), 0), NVL(MAX(FIRST_CHANGE#), 0), NVL(TO_NUMBER(TO_CHAR(MAX(FIRST_TIME), 'YYYYMMDDHH24MISS')), 0) FROM V$LOG WHERE THREAD# = 1'

BR0300I BR_TRACE: SQL code: 0, number of processed rows: 1

BR0645I BR_TRACE: location BrCurrRedoGet-4, SQL output:

'90465', '1709986290', '20100325225422'

BR0644I BR_TRACE: location BrDbaConnect-10, SQL statement:

'SELECT TO_NUMBER(VALUE) FROM V$PARAMETER WHERE NAME = 'db_block_size''

BR0300I BR_TRACE: SQL code: 0, number of processed rows: 1

BR0645I BR_TRACE: location BrDbaConnect-11, SQL output:

'8192'

BR0644I BR_TRACE: location BrDbaConnect-12, SQL statement:

'SELECT BLOCK_SIZE FROM V$ARCHIVED_LOG WHERE ROWNUM = 1'

BR0300I BR_TRACE: SQL code: 0, number of processed rows: 1

BR0645I BR_TRACE: location BrDbaConnect-13, SQL output:

'512'

BR0644I BR_TRACE: location ora_vers_get-1, SQL statement:

'SELECT INSTANCE_NAME, INSTANCE_NUMBER, VERSION, HOST_NAME, ARCHIVER, NVL(PARALLEL, ' ') FROM V$INSTANCE WHERE ROWNUM = 1'

BR0300I BR_TRACE: SQL code: 0, number of processed rows: 1

BR0645I BR_TRACE: location ora_vers_get-2, SQL output:

'BWQ', '1', '10.2.0.2.0', 'pl1ua132', 'STARTED', 'NO'

BR0644I BR_TRACE: location ora_vers_get-3, SQL statement:

'SELECT RESETLOGS_ID FROM V$DATABASE_INCARNATION WHERE STATUS = 'CURRENT''

BR0300I BR_TRACE: SQL code: 0, number of processed rows: 1

BR0645I BR_TRACE: location ora_vers_get-4, SQL output:

'615253713'

BR0644I BR_TRACE: location BrDbaSynCheck-1, SQL statement:

'SELECT COUNT(*) FROM SAP_SDBAH WHERE BEG = '00000000000000''

BR0300I BR_TRACE: SQL code: 0, number of processed rows: 1

BR0645I BR_TRACE: location BrDbaSynCheck-2, SQL output:

'0'

BR0644I BR_TRACE: location BrLicCheck-1, SQL statement:

'SELECT VERSION FROM SAP_SVERS WHERE ROWNUM = 1'

BR0300I BR_TRACE: SQL code: 0, number of processed rows: 1

BR0645I BR_TRACE: location BrLicCheck-2, SQL output:

'700'

BR0644I BR_TRACE: location BrLicCheck-3, SQL statement:

'SELECT TABLE_OWNER FROM DBA_SYNONYMS WHERE OWNER = 'PUBLIC' AND SYNONYM_NAME = 'SAP_SDBAH''

BR0300I BR_TRACE: SQL code: 0, number of processed rows: 1

BR0645I BR_TRACE: location BrLicCheck-4, SQL output:

'SAPSR3'

BR0644I BR_TRACE: location BrsDblogOpen-1, SQL statement:

'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20100325232322', 'dfa', 'BWQ', ' ', '9999', ' ', 'secwfzta', '7.00 (34) dfalter')'

BR0300I BR_TRACE: SQL code: 0, number of processed rows: 1

BR0644I BR_TRACE: location BrsDblogOpen-5, SQL statement:

'INSERT INTO SAP_DBATL (SYS_ID, OPER_ID, TASKNAME, JOB_NR, UPD_OP, TLOGNAME, STATUS, BEGIN_OP, END_OP, RC, INTERNAL) VALUES ('BWQ', '20100325232322', 'Alter data file', '0000000000', '20100325232323', '/oracle/BWQ/sapreorg/secwfzta.dfa', 'STARTED', '20100325232322', ' ', '0000', ' ')'

BR0300I BR_TRACE: SQL code: 0, number of processed rows: 1

BR0644I BR_TRACE: location BrsDblogOpen-6, SQL statement:

'INSERT INTO SAP_DBAML (SYS_ID, OPER_ID, TASKNAME, JOB_NR, TRIAL, UTIL_NR, FUNC_ID, UPD_OP, TOOLSET, PROGNAME, LOG_NAME, STATUS, BEGIN_OP, END_OP, RC, INTERNAL) VALUES ('BWQ', '20100325232322', 'Alter data file', '0000000000', '1', '0000000000', 'dfa', '20100325232323', 'SAP CCMS', 'BRSPACE', '/oracle/BWQ/sapreorg/secwfzta.dfa', 'STARTED', '20100325232322', ' ', '0000', 'secwfzta 7.00 (34) dfalter')'

BR0300I BR_TRACE: SQL code: 0, number of processed rows: 1

BR0644I BR_TRACE: location BrCurrRedoGet-3, SQL statement:

'SELECT NVL(MAX(SEQUENCE#), 0), NVL(MAX(FIRST_CHANGE#), 0), NVL(TO_NUMBER(TO_CHAR(MAX(FIRST_TIME), 'YYYYMMDDHH24MISS')), 0) FROM V$LOG WHERE THREAD# = 1'

BR0300I BR_TRACE: SQL code: 0, number of processed rows: 1

BR0645I BR_TRACE: location BrCurrRedoGet-4, SQL output:

'90465', '1709986290', '20100325225422'

BR0280I BRSPACE time stamp: 2010-03-25 23.23.23

BR0644I BR_TRACE: location BrDbaDisconnect-1, SQL statement:

'COMMIT RELEASE'

BR0300I BR_TRACE: SQL code: 0, number of processed rows: 0

BR0280I BRSPACE time stamp: 2010-03-25 23.23.23

BR1009I Name of database instance: BWQ

BR1010I BRSPACE action ID: secwfzta

BR1011I BRSPACE function ID: dfa

BR1012I BRSPACE function: dfalter

Please check and sugget me on this issue.

Thanks

Sha Kareem

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Agree with Joe, can't find any error. Could you make it readable and highlight where's the error?

Regards

Sourabh Majumdar

Former Member
0 Kudos

Which error?

I don't see any.

But maybe that's because of lack of coffee.