on 03-26-2010 6:25 AM
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
Agree with Joe, can't find any error. Could you make it readable and highlight where's the error?
Regards
Sourabh Majumdar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Which error?
I don't see any.
But maybe that's because of lack of coffee.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.