regarding standby oracle DB bakcup

It is not possible to take offline backup on the standby node.

A 'standby' server does not have any Oracle resources, filesystems, etc.
All filesystems are mounted on the active node.

Offline backup can only be taken on a system where all Oracle resources exist (filesystems, etc.) with Oracle db in shutdown state.

Please talk to your Oracle dba and cluster administrator for further explanation and guidance.

Try login to rman connect to that db and see if you can execute the commands. Seems that your profile has issues.

Thanks Marriane

so , is it possible take online backup on the standby node.if not how can we save the DB releated part in standby server ( is the normal standard policy used for full BMR would be enogh ? )

 i am getting below message as i have tried to take bakcup of the standby DB using hot_database_backup.sh RMAN scrip.

 

com10:oracle # cat hot_database_backup.sh.out

Script /usr/openv/netbackup/ext/db_ext/oracle/samples/rman/hot_database_backup.s
==== started on Tue Aug 19 08:54:40 GMT 2014 ====

RMAN: /opt/PlexView/Oracle/ora01/app/oracle/product/11.2.0/bin/rman
ORACLE_SID: plxdb
ORACLE_USER: oracle
ORACLE_HOME: /opt/PlexView/Oracle/ora01/app/oracle/product/11.2.0

NB_ORA_FULL: 1
NB_ORA_INCR: 0
NB_ORA_CINC: 0
NB_ORA_SERV: vtcnb01
NB_ORA_POLICY: vzw-Oracle

Full backup requested
Last login: Tue Aug 19 08:54:17 UTC 2014

Recovery Manager: Release 11.2.0.1.0 - Production on Tue Aug 19 08:54:40 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PLXDB (DBID=3747984712)
using target database control file instead of recovery catalog

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 2
allocated channel: ch00
channel ch00: SID=605 device type=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.5 (2013061020)

allocated channel: ch01
channel ch01: SID=630 device type=SBT_TAPE
channel ch01: Veritas NetBackup for Oracle - Release 7.5 (2013061020)

Starting backup at 19-AUG-14
channel ch00: starting incremental level 0 datafile backup set
channel ch00: specifying datafile(s) in backup set
input datafile file number=00006 name=/opt/PlexView/Oracle/ora02/oradata/plxdb/c
input datafile file number=00008 name=/opt/PlexView/Oracle/ora02/oradata/plxdb/t
input datafile file number=00009 name=/opt/PlexView/Oracle/ora02/oradata/plxdb/t
input datafile file number=00010 name=/opt/PlexView/Oracle/ora02/oradata/plxdb/t
input datafile file number=00005 name=/opt/PlexView/Oracle/ora02/oradata/plxdb/a
channel ch00: starting piece 1 at 19-AUG-14
channel ch01: starting incremental level 0 datafile backup set
channel ch01: specifying datafile(s) in backup set
input datafile file number=00002 name=/opt/PlexView/Oracle/ora02/oradata/plxdb/s
input datafile file number=00003 name=/opt/PlexView/Oracle/ora02/oradata/plxdb/u
input datafile file number=00004 name=/opt/PlexView/Oracle/ora02/oradata/plxdb/u
input datafile file number=00001 name=/opt/PlexView/Oracle/ora02/oradata/plxdb/s
input datafile file number=00007 name=/opt/PlexView/Oracle/ora02/oradata/plxdb/t
channel ch01: starting piece 1 at 19-AUG-14
channel ch00: finished piece 1 at 19-AUG-14
piece handle=bk_6_1_855996882 tag=HOT_DB_BK_LEVEL0 comment=API Version 2.0,MMS V
channel ch00: backup set complete, elapsed time: 00:00:15
channel ch00: starting incremental level 0 datafile backup set
channel ch00: specifying datafile(s) in backup set
including current control file in backup set
channel ch00: starting piece 1 at 19-AUG-14
channel ch01: finished piece 1 at 19-AUG-14
piece handle=bk_7_1_855996897 tag=HOT_DB_BK_LEVEL0 comment=API Version 2.0,MMS V
channel ch01: backup set complete, elapsed time: 00:00:23
channel ch01: starting incremental level 0 datafile backup set
channel ch01: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ch01: starting piece 1 at 19-AUG-14
channel ch00: finished piece 1 at 19-AUG-14
piece handle=bk_8_1_855996912 tag=HOT_DB_BK_LEVEL0 comment=API Version 2.0,MMS V
channel ch00: backup set complete, elapsed time: 00:00:23
channel ch01: finished piece 1 at 19-AUG-14
piece handle=bk_9_1_855996936 tag=HOT_DB_BK_LEVEL0 comment=API Version 2.0,MMS V
channel ch01: backup set complete, elapsed time: 00:00:15
Finished backup at 19-AUG-14

sql statement: alter system archive log current
released channel: ch00
released channel: ch01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 08/19/2014 08:56:06
RMAN-11003: failure during parse/execution of SQL statement: alter system archiv
ORA-01109: database not open

RMAN> RMAN>

Recovery Manager complete.
Last login: Tue Aug 19 08:54:17 UTC 2014

Script /usr/openv/netbackup/ext/db_ext/oracle/samples/rman/hot_database_backup.s
==== ended in error on Tue Aug 19 08:56:06 GMT 2014 ====

com10:oracle #

 

regards,

Giri

Not sure how or why you are trying to take 'hot database backup' of the 'standby' db?

Surely in Active/Passive cluster there is only ONE db that is online on the Active node?

If this is Oracle Data Guard, have a look at these discussions:

Backing up Oracle databases configured using Data Guard 

Oracle Data-Guard restore issue

NetBackup for Oracle in Data guard (log shipping) environments