BR0278E Command output of 'D:\oracle\PRD\102\BIN\sqlplus /nolog < G:\oracle

[Former Member]

Hi,

I am getting Error in offline backup while online backup is working fine.

OS - Windows 2008

DB - Oracle 10.2.0.4

BR0278E Command output of 'D:\oracle\PRD\102\BIN\sqlplus /nolog < G:\oracle\PRD\sapbackup\.befvsink.spi':

SQL*Plus: Release 10.2.0.4.0 - Production on Tue May 10 07:03:18 2011

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

SQL> SQL> ERROR:

ORA-12560: TNS:protocol adapter error

SQL>

SQL> ORA-12560: TNS:protocol adapter error

SQL>

BR0280I BRBACKUP time stamp: 2011-05-10 07.03.18

BR0279E Return code from 'D:\oracle\PRD\102\BIN\sqlplus /nolog < G:\oracle\PRD\sapbackup\.befvsink.spi': 0

BR0302E SQLPLUS call for database instance PRD failed

BR0306E Start and open of database instance PRD failed

BR0280I BRBACKUP time stamp: 2011-05-10 07.03.18

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

'CONNECT /'

ORA-12560: TNS:protocol adapter error

BR0310E Connect to database instance PRD failed

Kindly suggest me.

Thanks & Regards,

Darshan

[yogesh-garg]

Hi Darshan ,

I m facing same issue while offline backup in MSCS on windows server 2008.

Have you got the solution, Please share the solution.

Regards

Yogesh

[Former Member]

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

'CONNECT /'

ORA-12560: TNS:protocol adapter error

Please check your tnsnames.ora file and make sure all parameters maintained in that are correct. You may also need to look at SAP note 441518 .

Thanks..

Mohit

[Former Member]

Hi,

Thanks for reply,

Connect / is working.

Actually backup completed 100% & then I am getting this error, Also when I check my instance also got started automatiocally

Regards,

Darshan

[volker_borowski2]

Hi,

how is this backup started?

- From OS scheduler (which user runs the job?)

- From OS CMD.EXE (which user runs the job?)

- From DB13 ?

brbackup usually leaves the DB as it finds it, so in case of:

a) DB runs & offline backup: it shuts down, backs up and starts up the DB

b) DB down & online backup: it starts up, backs up and shuts down the DB

c) DB down & offline backup: it starts up (to get, what is to be backed up), shuts down, backs up, starts up (to log the result to the sdba-tables) and shuts down the DB.

Volker