Backup Error through db13

[Former Member]

Dear Experts,

We are taking backup through db13 ECC Deve Server but getting following error--

Job started

Step 001 started (program RSDBAJOB, variant &0000000000029, user ID BASIS)

Execute logical command BRBACKUP On host sapeccdev

Parameters:-u / -jid TAPIN20091130155408 -i force -c force -n 1 -v SCRATCH

BR0051I BRBACKUP 7.00 (32)

BR0055I Start of database backup: becaipbs.tib 2009-11-30 15.54.08

BR0484I BRBACKUP log file: /oracle/DEV/sapbackup/becaipbs.tib

BR0280I BRBACKUP time stamp: 2009-11-30 15.54.09

BR0301W SQL error -27140 at location BrDbConnect-2, SQL statement:

'CONNECT /'

ORA-27140: attach to post/wait facility failed

BR0310W Connect to database instance DEV failed

BR0205I Backup volume initialization

BR0058I BRBACKUP action ID: becaipbs

BR0059I BRBACKUP function ID: tib

BR0102I Following backup device will be used: /dev/rmt/2mn

BR0131I All volumes get the name SCRATCH

BR0129I Force option set - no label checking during initialization

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

BR0207I Volume in device: /dev/rmt/2mn will be initialized with name: SCRATCH

BR0280I BRBACKUP time stamp: 2009-11-30 15.54.09

BR0226I Rewinding tape volume in device /dev/rmt/2m ...

BR0202I Copying /oracle/DEV/sapbackup/.tape.hdr0

BR0203I to /dev/rmt/2mn ...

BR0209I Volume in device /dev/rmt/2mn has name SCRATCH

BR0280I BRBACKUP time stamp: 2009-11-30 15.54.16

BR0226I Rewinding tape volume in device /dev/rmt/2m ...

BR0280I BRBACKUP time stamp: 2009-11-30 15.54.18

BR0301E SQL error -27140 at location BrDbConnect-2, SQL statement:

'CONNECT /'

ORA-27140: attach to post/wait facility failed

BR0310E Connect to database instance DEV failed

BR0206I End of backup volume initialization

BR0280I BRBACKUP time stamp: 2009-11-30 15.54.18

BR0054I BRBACKUP terminated with errors

External program terminated with exit code 3

BRBACKUP returned error status E

Job finished

Kindly revert with helful suggestion.

Regards,

Ajit

[markus_doehr2 · Accepted solution]

> BR0301W SQL error -27140 at location BrDbConnect-2, SQL statement:

> 'CONNECT /'

> ORA-27140: attach to post/wait facility failed

did you somehow fiddle manually with filesystem permissions on $ORACLE_HOME/ bin? (such as chmod 777 * or things like that)?

Markus

[Former Member · Accepted solution]

Dear Markus,

Yes, we did that chmod 777 *, should we change back to earlier ?

Regards,

Ajit

[markus_doehr2 · Accepted solution]

> Yes, we did that chmod 777 *, should we change back to earlier ?

The binaries $ORACLE_HOME/bin have special permissions (s-bit, gid-bit set etc.).

To fix that I would

- stop SAP system

- shutdown database (shutdown immediate)

- shutdown listener (lsnrctl stop)

- relink the executables as ora<SID> doing "relink all"

Markus

[Former Member · Accepted solution]

Dear Markus,

As i understood, we need to set the permissions firts. would you pl guide how to set the correct permission for $ORACLE_HOME/bin ?

then

- stop SAP system

- shutdown database (shutdown immediate)

- shutdown listener (lsnrctl stop)

and finally relink executabales which is in $ORACLE_HOME/bin . am i right ?

Pl Guide ?

Ajit

[markus_doehr2 · Accepted solution]

> As i understood, we need to set the permissions firts. would you pl guide how to set the correct permission for $ORACLE_HOME/bin ?

The relink process will do this.

There are quite a set of different permissions, setting them manually is pretty tedious. So just relink.

Markus

[Former Member · Accepted solution]

Dear Markus,

after the relink all, this is the following log----

Job started

Step 001 started (program RSDBAJOB, variant &0000000000005, user ID BASIS)

Execute logical command BRBACKUP On host qserv

Parameters:-u / -jid TAPIN20091130174249 -i force -c force -n 1 -v SCRATCH

BR0051I BRBACKUP 7.00 (32)

BR0055I Start of database backup: becaiysn.tib 2009-11-30 17.42.49

BR0484I BRBACKUP log file: /oracle/QAS/sapbackup/becaiysn.tib

BR0477I Oracle pfile /oracle/QAS/102_64/dbs/initQAS.ora created from spfile /oracle/QAS/102_64/dbs/spfileQAS.ora

BR0205I Backup volume initialization

BR0058I BRBACKUP action ID: becaiysn

BR0059I BRBACKUP function ID: tib

BR0102I Following backup device will be used: /dev/rmt/2mn

BR0131I All volumes get the name SCRATCH

BR0129I Force option set - no label checking during initialization

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

BR0207I Volume in device: /dev/rmt/2mn will be initialized with name: SCRATCH

BR0280I BRBACKUP time stamp: 2009-11-30 17.42.49

BR0226I Rewinding tape volume in device /dev/rmt/2m ...

BR0278E Command output of 'LANG=C mt -f /dev/rmt/2m rew':

/dev/rmt/2m: No such device or address

BR0280I BRBACKUP time stamp: 2009-11-30 17.42.50

BR0279E Return code from 'LANG=C mt -f /dev/rmt/2m rew': 1

BR0213E Winding tape volume in device /dev/rmt/2mn failed

BR0219E Initialization of volume SCRATCH in device /dev/rmt/2mn failed

BR0206I End of backup volume initialization

BR0280I BRBACKUP time stamp: 2009-11-30 17.42.50

BR0054I BRBACKUP terminated with errors

External program terminated with exit code 3

BRBACKUP returned error status E

Job finished

Regards,

Ajit

[Former Member · Accepted solution]

Dear Markus,

we are trying on both server DEV and QAS as Isssue are same.

On DEV server users are loggin, so we tried to run relink all on QAS and then run db13.

For your Information on XI server tape get initialize, without any error.With brtools i am able to take online backup on DEV and QAS but not with db13.

Regards,

Ajit

[Former Member · Accepted solution]

further---

we have made a changes in initQAS.sap, from default tape_address /dev/rmt/0m to /dev/rmt/2m. do we need to again run relink all.

[markus_doehr2 · Accepted solution]

> we have made a changes in initQAS.sap, from default tape_address /dev/rmt/0m to /dev/rmt/2m. do we need to again run relink all.

No, this will be read when brtools start.

Did you also change permissions in the kernel directory? Execute saproot.sh <SID> in the kernel directory and try again.

Markus

[Former Member · Accepted solution]

Dear Markus,

Issue Resolved.

Thanks a lot from bottom of my heart, You made my day. I feel like, to give you point more than 10.

Warm Regards,

Ajit