Monday, May 8, 2017

BRTOOLS & ERRORS


1. Tablespace over flow (ORA-1653, 1654
2. BR0301E SQL error -1031 at location BrInitOraCreate-2
3. BRBACKUP/BRARCHIVE failed with warning ORA-28011: the account will expire soon
4. ORA-01031 with error "SAP_MLICHECK WHERE EXPIRATION_DATE
5. ORA-01031:'SELECT TABART FROM "SAPR3".DDART ORDER BY TABART

6. Max Extents reached  (ORA-1631, 1632)
7. Archive Stuck (ORA-255, ORA-272)
8. Datablock corruption (ORA-1578)... restore from old backup
9. Missing end backup while performing a backup
10. stats out dated - run brconnect -f stats
11. Oracle listener, Tnsnames port issues
12. Oracle DLL Compatibility issues (Patch Oracle)
13. International hardware errors ORA-600 (Refer to SAP and Oracle)
14. OPS$ issues related to authentication while logging
15. Connection issues between R/3 WP: Oracle Shadow with error ORA-12560
16. Oracle is corrupted or Disk corrupted, External disk not available, datafile missing, Space issues.
17. Missing Indexes in DB02
18. Database backup not successful due to space issues, tape issues
19. Control file missing - Recreate control file
20. Oracle shared memory not available issue with SGA
21. If buffer hit ration below 94% (Increase block buffer size)

Messages and Return Codes for BR*Tools:


BR*Tools issues messages in the following form:

BR<NNNN><X> Message text

NNNN: sequential number of the message

X: type of message:

I: information
W: warning
E: error message
The text of the message contains the following variables:

%s: string
%d: integer
%f: real number in floating-point format


Return Codes:

The following return codes are possible:

Code

Meaning

0: Successful

1: Successful with warnings - all files were processed (for example, backed up or restored)

2: Canceled during the initialization phase by a user or other signal

3: Errors occurred during the initialization phase, processing was not started

4: Canceled by a user or other signal during processing

5: Failed because errors occurred during processing

6: Internal termination

9: Successful but not finished yet (can be seen in summary logs copied to backup media)

1 comment: