cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

BRTOOLS on Oracle

Go to solution
Former Member

on ‎09-08-2010 8:05 AM

0 Kudos

Hi,

Were using ECC6 on Oracle 10g database. Im trying to backup my database using BRTOOLS but Im having an error. Please see below:

>>> TNVT - to host 121.121.121.251

brtools

BR0651I BRTOOLS 7.00 (18)

BR0280I BRTOOLS time stamp: 2010-09-08 15.03.52

BR0656I Choice menu 1 - please make a selection

-

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

-

BR0662I Enter your choice:

4

BR0280I BRTOOLS time stamp: 2010-09-08 15.03.57

BR0663I Your choice: '4'

BR0280I BRTOOLS time stamp: 2010-09-08 15.03.57

BR0656I Choice menu 9 - please make a selection

-

Backup and database copy

1 = Database backup

2 - Archivelog backup

3 - Database copy

4 - Non-database backup

5 - Backup of database disk backup

6 - Verification of database backup

7 - Verification of archivelog backup

8 - Additional functions

9 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

BR0662I Enter your choice:

1

BR0280I BRTOOLS time stamp: 2010-09-08 15.03.59

BR0663I Your choice: '1'

BR0280I BRTOOLS time stamp: 2010-09-08 15.03.59

BR0657I Input menu 15 - please check/enter input values

-

BRBACKUP main options for backup and database copy

1 - BRBACKUP profile (profile) ....... [initUAT.sap]

2 - Backup device type (device) ...... [disk]

3 # Tape volumes for backup (volume) . []

4 # BACKINT/Mount profile (parfile) .. []

5 - Database user/password (user) .... [/]

6 - Backup type (type) ............... [online]

7 # Disk backup for backup (backup) .. [no]

8 # Delete disk backup (delete) ...... [no]

9 ~ Files for backup (mode) .......... [all]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2010-09-08 15.04.01

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRTOOLS time stamp: 2010-09-08 15.04.01

BR0657I Input menu 16 - please check/enter input values

-

Additional BRBACKUP options for backup and database copy

1 - Confirmation mode (confirm) ....... [yes]

2 - Query mode (query) ................ [no]

3 - Compression mode (compress) ....... [no]

4 - Verification mode (verify) ........ [no]

5 - Fill-up previous backups (fillup) . [no]

6 - Parallel execution (execute) ...... [0]

7 - Additional output (output) ........ [no]

8 - Message language (language) ....... [E]

9 - BRBACKUP command line (command) ... [-p initUAT.sap -d disk -t online -m all -k no -e 0 -l E]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2010-09-08 15.04.05

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0291I BRBACKUP will be started with options '-p initUAT.sap -d disk -t online -m all -k no -e 0 -l E'

BR0280I BRTOOLS time stamp: 2010-09-08 15.04.05

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

c

BR0280I BRTOOLS time stamp: 2010-09-08 15.04.06

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

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

BR0051I BRBACKUP 7.00 (18)

BR0055I Start of database backup: beebsvdu.and 2010-09-08 15.04.06

BR0280I BRBACKUP time stamp: 2010-09-08 15.04.06

BR0301E SQL error -942 at location BrDbConnect-4, SQL statement:

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

ORA-00942: table or view does not exist

BR0310E Connect to database instance UAT failed

BR0280I BRBACKUP time stamp: 2010-09-08 15.04.06

BR0301E SQL error -942 at location BrDbConnect-4, SQL statement:

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

ORA-00942: table or view does not exist

BR0310E Connect to database instance UAT failed

BR0056I End of database backup: beebsvdu.and 2010-09-08 15.04.06

BR0280I BRBACKUP time stamp: 2010-09-08 15.04.06

BR0054I BRBACKUP terminated with errors

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

BR0292I Execution of BRBACKUP finished with return code 3

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action

BR0280I BRTOOLS time stamp: 2010-09-08 15.04.06

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

s

BR0280I BRTOOLS time stamp: 2010-09-08 15.04.13

BR0257I Your reply: 's'

BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:

y

BR0280I BRTOOLS time stamp: 2010-09-08 15.04.14

BR0257I Your reply: 'y'

BR0260E BRTOOLS cancelled by user

BR0280I BRTOOLS time stamp: 2010-09-08 15.04.14

BR0654I BRTOOLS terminated with errors

AMC-ERP-UAT:uatadm 3>

Hope anybody can help me please.

Thanks

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎09-08-2010 8:08 AM
0 Kudos

Hi,

Sorry about my post since its distorted. Anyway, I searched for the part where errors are encountered and I see the following:

BR0055I Start of database backup: beebsvdu.and 2010-09-08 15.04.06 BR0280I BRBACKUP time stamp: 2010-09-08 15.04.06 BR0301E SQL error -942 at location BrDbConnect-4, SQL statement: 'SELECT NAME, NVL(RESETLOGS_CHANGE#, 0), NVL(TO_NUMBER(TO_CHAR(RESETLOGS_TIME, 'YYYYMMDDHH24MISS')), 0), NVL(TO_NUMBER(TO_CHAR(CREATED, 'YYYYMMDDHH24MISS')), 0) FROM V$DATABASE WHERE ROWNUM = 1' ORA-00942: table or view does not exist BR0310E Connect to database instance UAT failed BR0280I BRBACKUP time stamp: 2010-09-08 15.04.06 BR0301E SQL error -942 at location BrDbConnect-4, SQL statement: 'SELECT NAME, NVL(RESETLOGS_CHANGE#, 0), NVL(TO_NUMBER(TO_CHAR(RESETLOGS_TIME, 'YYYYMMDDHH24MISS')), 0), NVL(TO_NUMBER(TO_CHAR(CREATED, 'YYYYMMDDHH24MISS')), 0) FROM V$DATABASE WHERE ROWNUM = 1' ORA-00942: table or view does not exist BR0310E Connect to database instance UAT failed BR0056I End of database backup: beebsvdu.and 2010-09-08 15.04.06 BR0280I BRBACKUP time stamp

But I dont know what's causing it. Can anybody help please?

Thanks

Show replies
Show replies
Former Member
‎09-08-2010 8:15 AM
0 Kudos

Hi,

Connect to database instance UAT failed

Check whether database is up and running. Try to execute R3trans -x as <SID>adm user and post us the trans.log.

I hope u r executing the backup as the <SID>adm user.

Regards,

Varadharajan M

Former Member
‎09-08-2010 8:32 AM
0 Kudos

Hi Varadharajan M

Thanks for the immediate reply. Im sure my database is up when I run brtools because Im actually logged in to the SAP system. Anyway, below is the trans.log file. I run the backup using uatadm user.

4 ETW000 R3trans version 6.14 (release 700 - 03.11.09 - 14:15:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 08.09.2010 - 15:30:19

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Wed Sep 8 15:30:19 2010

64 0.000064

4 ETW000 [dev trc ,00000] db_con_init called

19 0.000083

4 ETW000 [dev trc ,00000] create_con (con_name=R/3)

34 0.000117

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/UAT/SYS/exe/run/dbo

raslib.o' ... 27 0.000144

4 ETW000 [dev trc ,00000] DlLoadLib() success: dlopen("/usr/sap/UAT/SYS/ex

e/run/dboraslib.o"), hdl 0

4 ETW000

3394 0.003538

4 ETW000 [dev trc ,00000] Library '/usr/sap/UAT/SYS/exe/run/dboraslib.o' l

oaded 20 0.003558

@

Edited by: Aurelio Tadlas on Sep 8, 2010 9:33 AM

Former Member
‎09-08-2010 9:43 AM
0 Kudos

Hi,

Please post the complete trans.log after executing R3trans -d.

Regards,

Varadharajan M

Former Member
‎09-08-2010 10:13 AM
0 Kudos

Hi,

Im trying to post the complete trans.log but its returning the message 'Your message exceeds the maximum length of 15000 characters. ' Is there a way for me to upload the file itself?

Also, Ive read from OSS to run 'sqlplus /nolog @sapdba_role <SAPSCHEMA_ID>' How do I determine the SAPSCHEMA_ID?

Thanks

Edited by: Aurelio Tadlas on Sep 8, 2010 11:13 AM

Former Member
‎09-08-2010 10:23 AM
0 Kudos

Under the ora<SID> user id there would be a environment variable dbs_ora_schema.

Under the assumption that your OS is unix or linux.

Log in as ora<SID> then execute the below command under the default shell of the user.Mine was c shell.

env | grep sche

Have pasted the output from my system.

env | grep sche

dbs_ora_schema=SAPSR3

Former Member
‎09-08-2010 11:05 AM
0 Kudos

Hi,

I determined SAPSCHEMA_ID to be SAPSR3. Thanks for the tip. Will try running the sapdba_role script and see if it solves the problem. Will post the outcome later.

Thanks guys!

Answers (1)

Answers (1)

Former Member
‎09-08-2010 8:18 AM
0 Kudos

1. Use a more updated BRTOOLS version

2. Run the SQL scripts supplied with DBATOOLS (sapdba_role.sql and sapconn_role.sql)

3. Try the BRBACKUP again.

Show replies
Show replies
Ask a Question