on 08-12-2008 6:15 AM
Hi,
If I run BRTools Offline Backup I get the following error message.
Oracle Version : 10.2.0.2
OS : HP Unix
EP 7.0 SP 14.
Only JAVA instance/stack.
Please help me to resolve this issue.
###############################################################################
BR0051I BRBACKUP 7.00 (24)
BR0055I Start of database backup: bdyomktx.aff 2008-08-12 07.43.25
BR0484I BRBACKUP log file: /oracle/RD1/sapbackup/bdyomktx.aff
BR0477I Oracle pfile /oracle/RD1/102_64/dbs/initRD1.ora created from spfile /ora cle/RD1/102_64/dbs/spfileRD1.ora
BR0613I Database instance RD1 is shut down
BR0329I Database instance RD1 will be opened now
BR0280I BRBACKUP time stamp: 2008-08-12 07.43.26
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:
c
BR0280I BRBACKUP time stamp: 2008-08-12 07.43.34
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0280I BRBACKUP time stamp: 2008-08-12 07.43.34
BR0304I Starting and opening database instance RD1 ...
BR0278E Command output of '/oracle/RD1/102_64/bin/sqlplus':
SQL*Plus: Release 10.2.0.2.0 - Production on Tue Aug 12 07:43:34 2008
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected to an idle instance.
SQL>
SQL> ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
Database mounted.
Database opened.
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
BR0280I BRBACKUP time stamp: 2008-08-12 07.43.42
BR0279E Return code from '/oracle/RD1/102_64/bin/sqlplus': 0
BR0302E SQLPLUS call for database instance RD1 failed
BR0306E Start and open of database instance RD1 failed
BR0056I End of database backup: bdyomktx.aff 2008-08-12 07.43.42
BR0280I BRBACKUP time stamp: 2008-08-12 07.43.43
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: 2008-08-12 07.43.43
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
BR0280I BRTOOLS time stamp: 2008-08-12 07.44.34
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
BR0280I BRTOOLS time stamp: 2008-08-12 07.46.08
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
BR0280I BRTOOLS time stamp: 2008-08-12 07.47.46
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
BR0280I BRTOOLS time stamp: 2008-08-12 07.50.35
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
BR0280I BRTOOLS time stamp: 2008-08-12 07.55.53
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
BR0280I BRTOOLS time stamp: 2008-08-12 08.06.47
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
Regards,
Karthick
hi,
You can find alert log in the following directory.
oracle/<sid>/saptrace/background/alert_sid.log
Karan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I shall look in to the SAP Help and will post if I am not able to find the solution.Thank you Guys for the help.I shall update the same here once completed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
ORA-32004: obsolete and/or deprecated parameter(s) specified
I am not sure but you check for One or more obsolete and/or parameters were specified in the SPFILE or the PFILE on the server side. See alert log for a list of parameters that are obsolete. or deprecated. Remove them from the SPFILE or the server side PFILE.
May be this is helpful for you
Karan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Karan Singh,
I am also sure that the error occurs because of Obsolete parameters specified.
I checked the Below SAP Note : 609430 - Error messages due to obsolete parameters
Solution
Delete all obsolete parameters specified in the ORA-25138-message or in the alert log from the Oracle profile.
Can you please tell me where can I find the SPFILE or the PFILE on the server side.
And let me know how to find the Obsolete parameters?
Please tell me where to check Alert Logs?
Appreciate your reply.
Regards,
Karthick
Edited by: Karthick Eswaran on Aug 12, 2008 1:59 AM
Hello
http://help.sap.com/saphelp_nw70/helpdata/EN/03/101549e4617146a670dcc62991ada9/content.htm
about oracle Pfile, SPfile and other
read Note 830576 - Parameter recommendations for Oracle 10g
Regards.
>
> Fidel, Where can I check Aler log?please explain.
>
> I do have only JAVA Stack, No ABAP Instance,So I can not use any Transaction.
O_o
It does not matter if it is JAVA stack or ABAP stack.
Oracle always generate an alert log. Any person trying to do anything with an oracle database should know that and you are trying to use BRTOOLS to do a backup !
By default, on a SAP system the alert log is located on the background directory
> /oracle/<SID>/saptrace/background.
Now I have another questions
1) as which user were you connected when you tried to do the backup?
2) what are the environment variables of that user?
3) what are the SAPSID and DBSID?
4) when you replied karan Singh, were you connected to the correct oracle system?
5) how do you start your database?
6) when you start your database, do you get any error?
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.