on 08-08-2006 3:03 AM
All,
I am getting the following error when trying to run brbackup (700) on a Oracle 10.2.0.2 system:
C:\Documents and Settings\bwdadm>brbackup -q
BR0051I BRBACKUP 7.00 (15)
BR0055I Start of database backup: bdtfmrbc.qub 2006-08-08 11.33.04
BR0280I BRBACKUP time stamp: 2006-08-08 11.33.06
BR0301E SQL error -604 at location BrInitOraCreate-2, SQL statement:
'CONNECT system/******* AT PROF_CONN IN SYSOPER MODE'
ORA-00604: error occurred at recursive SQL level 1
ORA-01438: value larger than specified precision allowed for this column
ORA-06512: at line 2
BR0303E Determination of Oracle version failed
BR0056I End of database backup: bdtfmrbc.qub 2006-08-08 11.33.06
BR0280I BRBACKUP time stamp: 2006-08-08 11.33.06
BR0054I BRBACKUP terminated with errors
I have previously done a successful backup of this database using brbackup, but since this time I have installed a J2EE instance, and EP. I have also done a db reorg (using brspace) to release free space from some tablespaces.
I am using the latest available version of brbackup.
Any suggestions?
Regards,
Jason
My original problem was caused by a custom database trigger that had been created for logging purposes (when debugging another issue). The trigger allowed a connect to the database (as / as sysdba) and for the R/3 work processes, but for some reason prevented brbackup from connecting properly.
Removing the trigger resolved the issue.
The similiar sounding error mentioned in a reply is a completely different problem. You should never edit a spfile directly - settings need to be updated using the "alter system" command from sqlplus. There is an OSS note that says how to correct the problem if you have manually edited the spfile.
Regards,
Jason
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I got a similar error recently when I changed a parameter in the spfile, but misstyped it. Next time I tried to start Oracle, it would not start and the error messages were the same, or similar to those you are getting.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry,
but i have the same problem.
double stack, Oracle upgrade to 10.2.0.2 and brtools (700) 15
Any suggestions?
Regards,
Jörg
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
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.