Solution manager backup via brtools

[Former Member]

Dear experts,

I have fresh instaaled solution manager with oracle on windows 2003.

Now I want to take full offline backup via BRTOOLS.

It give below error.

D:\Documents and Settings\saladm>brtools

BR0651I BRTOOLS 7.00 (22)

BR0280I BRTOOLS time stamp: 2010-12-04 11.40.22

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-12-04 11.40.31

BR0663I Your choice: '4'

BR0280I BRTOOLS time stamp: 2010-12-04 11.40.31

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-12-04 11.41.36

BR0663I Your choice: '1'

BR0280I BRTOOLS time stamp: 2010-12-04 11.41.36

BR0657I Input menu 15 - please check/enter input values

-

---

BRBACKUP main options for backup and database copy

1 - BRBACKUP profile (profile) ....... [initSAL.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) ............... [offline]

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-12-04 11.41.38

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRTOOLS time stamp: 2010-12-04 11.41.38

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 initSAL.sap -d disk -t offline -m a

ll -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-12-04 11.41.40

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0291I BRBACKUP will be started with options '-p initSAL.sap -d disk -t offline

-m all -k no -e 0 -l E'

BR0280I BRTOOLS time stamp: 2010-12-04 11.41.40

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

c

BR0280I BRTOOLS time stamp: 2010-12-04 11.41.41

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

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

BR0051I BRBACKUP 7.00 (22)

BR0055I Start of database backup: beesbquo.afd 2010-12-04 11.41.42

BR0484I BRBACKUP log file: F:\oracle\SAL\sapbackup\beesbquo.afd

BR0613I Database instance SAL is shut down

BR0329I Database instance SAL will be opened now

BR0280I BRBACKUP time stamp: 2010-12-04 11.41.44

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:

c

BR0280I BRBACKUP time stamp: 2010-12-04 11.41.47

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRBACKUP time stamp: 2010-12-04 11.41.47

BR0304I Starting and opening database instance SAL ...

BR0280I BRBACKUP time stamp: 2010-12-04 11.42.07

BR0305I Start and open of database instance SAL successful

BR0925I Public synonym SAP_SDBAH created successfully for table SAPSR4DB.SDBAH

BR0925I Public synonym SAP_SDBAD created successfully for table SAPSR4DB.SDBAD

BR0280I BRBACKUP time stamp: 2010-12-04 11.42.13

BR0301W SQL error -980 at location BrbDbLogOpen-5, SQL statement:

'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('

20101204114142', 'afd', 'SAL', ' ', '9999', ' ', 'beesbquo', ' ')'

ORA-00980: synonym translation is no longer valid

BR0324W Insertion of database log header failed

BR0280I BRBACKUP time stamp: 2010-12-04 11.42.15

BR0301W SQL error -980 at location BrDbfInfoGet-32, SQL statement:

'DELETE FROM SAP_SDBAH WHERE BEG > '10000000000000' AND BEG < '20091030000000''

ORA-00980: synonym translation is no longer valid

BR0280I BRBACKUP time stamp: 2010-12-04 11.42.15

BR0301W SQL error -980 at location BrDbfInfoGet-33, SQL statement:

'DELETE FROM SAP_SDBAD WHERE BEG > '10000000000000' AND BEG < '20091030000000''

ORA-00980: synonym translation is no longer valid

BR0280I BRBACKUP time stamp: 2010-12-04 11.42.15

BR0301E SQL error -980 at location BrComprDurGet-1, SQL statement:

'OPEN curs_6 CURSOR FOR'

'SELECT FUNCT, POS, LINE FROM SAP_SDBAD WHERE BEG = '00000000000001' AND (FUNCT

= 'CMP' OR FUNCT = 'CMP' OR FUNCT = 'DUS' OR FUNCT = 'DUM') ORDER BY FUNCT'

ORA-00980: synonym translation is no longer valid

BR0314E Collection of information on database files failed

BR0280I BRBACKUP time stamp: 2010-12-04 11.42.15

BR0301W SQL error -980 at location BrbDbLogOpen-5, SQL statement:

'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('

20101204114142', 'afd', 'SAL', ' ', '9999', ' ', 'beesbquo', ' ')'

ORA-00980: synonym translation is no longer valid

BR0324W Insertion of database log header failed

BR0280I BRBACKUP time stamp: 2010-12-04 11.42.15

BR0307I Shutting down database instance SAL ...

BR0280I BRBACKUP time stamp: 2010-12-04 11.42.24

BR0308I Shutdown of database instance SAL successful

BR0056I End of database backup: beesbquo.afd 2010-12-04 11.42.15

BR0280I BRBACKUP time stamp: 2010-12-04 11.42.24

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-12-04 11.42.24

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

c

BR0280I BRTOOLS time stamp: 2010-12-04 11.43.01

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRTOOLS time stamp: 2010-12-04 11.43.01

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:

b

BR0280I BRTOOLS time stamp: 2010-12-04 11.43.46

BR0663I Your choice: 'b'

BR0673I Going back to the previous menu...

[Paul_Babier · Accepted solution]

Hello,

Have you taken a look at SAP Note 651812 - FAQ: BR*TOOLS and SAPDBA?

You must also look at SAP Note 113747 - Permissions for DBA tools BR*Tools and SAPDBA

Please have a look at the manual to BR*Tools(SAP Database Guide: Oracle)

and "Oracle Restore and Recovery" (http://www.sdn.sap.com/irj/sdn/go/por

tal/prtroot/docs/library/uuid/97a4f439-0d01-0010-d488-d29b45e2f5ab).

These resources should be helpful.

Reagrds,

Paul