How to trigger Offline backup in standby mode.

124 Views

Dear All,

OS: AIX

Database used: Oracle 11g

Please tel the steps to trigger an Offline backup in standby mode .

Primary_db = SID and backup Type = offline_standby has been maintained in initKBP.sap File and we triggerd the backup.

******************************************************************

1 - BRBACKUP profile (profile) ....... [initKBP.sap]
2 - Backup device type (device) ...... [util_file]
3 # Tape volumes for backup (volume) . []
4 ~ BACKINT/Mount profile (parfile) .. [/oracle/KBP/112_64/dbs/initKBP.utl]
5 - Database user/password (user) .... [/]
6 - Backup type (type) ............... [offline_standby]
7 # Disk backup for backup (backup) .. [no]
8 # Delete disk backup (delete) ...... [no]
9 ~ Files for backup (mode) .......... [all]

*******************************************************************************

We are getting Error for Offline standby Backup as shown below

**********************************************************************************************

BR0280I BRBACKUP time stamp: 2014-02-25 14.53.39
BR0301E SQL error -1017 at location BrDbConnect-2, SQL statement:
'CONNECT /@KBP'
ORA-01017: invalid username/password; logon denied
BR0310E Connect to database instance KBP/PRIMARY failed
BR0280I BRBACKUP time stamp: 2014-02-25 14.53.39
BR0301E SQL error -1017 at location BrDbConnect-2, SQL statement:
'CONNECT /@KBP'
ORA-01017: invalid username/password; logon denied
BR0310E Connect to database instance KBP/PRIMARY failed

**************************************************************************************************************

Please tel me the parameters to be maintained for trigerring an Offline backup in STANDBY MODE.

Please tel the steps to trigger an Offline backup in standby mode

Thanks and Regards,

Gayathri.K