db13 offline backup error

[former_member633852]

Hi Experts,

DB13 offline db backup schedules getting following error ;

Oracle Release : 10.2.0.4.0

Operating System : Aix

How can we fix these errors;

Regards

BR0278E Command output of '/oracle/CDP/102_64/bin/sqlplus /nolog < /oracle/CDP/sapbackup/.beajsfay.spi':

700946 : map : Permission Denied

700946 : map : Permission Denied

700946 : map : Permission Denied

SQL*Plus: Release 10.2.0.4.0 - Production on Sun Apr 19 02:01:01 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

SQL> Connected.

SQL>

SQL> ORA-01013: user requested cancel of current operation

Full Log

BR0051I BRBACKUP 7.00 (32)

BR0055I Start of database backup: beajsfay.aff 2009-04-19 02.01.00

BR0484I BRBACKUP log file: /oracle/CDP/sapbackup/beajsfay.aff

BR0477I Oracle pfile /oracle/CDP/102_64/dbs/initCDP.ora created from spfile /oracle/CDP/102_64/dbs/spfileCDP.ora

BR0101I Parameters

Name Value

oracle_sid CDP

oracle_home /oracle/CDP/102_64

oracle_profile /oracle/CDP/102_64/dbs/initCDP.ora

sapdata_home /oracle/CDP

sap_profile /oracle/CDP/102_64/dbs/initCDP.sap

backup_mode ALL

backup_type offline_force

backup_dev_type util_file

util_par_file /oracle/CDP/102_64/dbs/initCDP.utl

system_info cdpadm/oracdp cdsprod AIX 3 5 0004E6B2D900

oracle_info CDP 10.2.0.4.0 8192 6256 77958388 cdsprod UTF8 UTF8

sap_info 700 SAPSR3 0002LK0003CDP0011N07632717560013NetWeaver_ORA

make_info rs6000_64 OCI_102 Feb 6 2008

command_line brbackup -u / -jid ALLOF20081102020100 -c force -t offline_force -m all -p initCDP.sap

BR0116I ARCHIVE LOG LIST before backup for database instance CDP

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /oracle/CDP/oraarch/CDParch

Archive format %t_%s_%r.dbf

Oldest online log sequence 6253

Next log sequence to archive 6256

Current log sequence 6256 SCN: 77958388

Database block size 8192 Thread: 1

Current system change number 77961112 ResetId: 665615187

..

...

.....

BR0061I 46 files found for backup, total size 117231.057 MB

BR0143I Backup type: offline_force

BR0130I Backup device type: util_file

BR0109I Files will be saved by backup utility

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0280I BRBACKUP time stamp: 2009-04-19 02.01.01

BR0307I Shutting down database instance CDP ...

BR0278E Command output of '/oracle/CDP/102_64/bin/sqlplus /nolog < /oracle/CDP/sapbackup/.beajsfay.spi':

700946 : map : Permission Denied

700946 : map : Permission Denied

700946 : map : Permission Denied

SQL*Plus: Release 10.2.0.4.0 - Production on Sun Apr 19 02:01:01 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

SQL> Connected.

SQL>

SQL> ORA-01013: user requested cancel of current operation

SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Data Mining and Real Application Testing options

BR0280I BRBACKUP time stamp: 2009-04-19 03.01.00

BR0279E Return code from '/oracle/CDP/102_64/bin/sqlplus /nolog < /oracle/CDP/sapbackup/.beajsfay.spi': 0

BR0302E SQLPLUS call for database instance CDP failed

BR0309E Shutdown of database instance CDP failed

BR0056I End of database backup: beajsfay.aff 2009-04-19 03.01.00

BR0280I BRBACKUP time stamp: 2009-04-19 03.01.00

BR0054I BRBACKUP terminated with errors

[Former Member · Accepted solution]

Hi,

Please check the oracle alert log (alert<SID>.log) or you can run it after upgrading the

kernel. ./shroot <SID> . It will check all the permissions of kernel.\

Regards,

Pankaj

[abhimanyu_pandey]

Hi..

First you shouls execute sql with user ora<SID> like--

#sqlplus /nolog

if it execute successfully, then problem may be with saptools.

If it does not success then post the error msg.

Regards,

Abhimanyu

[former_member633852]

Thaks for quick response, i'll check the file permission, but we did not change

Now i've found folloowing notes, our brtools version is 32, may be this is the problem

Note 1261142 - Warning in BRBACKUP: "<number> : map : Permission Denied"

[Former Member]

Hi,

Please could you check if your directory "/oracle/<SID>/sapcheck" is available.

Because the BR*Tools need to create temporary applications in this directory and can

issue this errors if this directory has no permission.

I hope this way will help you!

best regards

Rafik Mazouz

[Former Member]

Hi,

Have you did any kernel upgrades? or any oracle file system changes recently.

I guess Some files systems permissions got changes.

Please check for alert log also.

Run saproot.sh to set proper file prmissions of oracle

Regards,

Nitin Salunkhe

[former_member633852]

I've found similar problem from oracle forums,