Oracle DB backup failing with errors.
1010111May 28 2013 — edited May 28 2013Hi All,
My oracled backup via Netbackup failing with error 6 (Netbackup) and i have checked the logs please find the RMAN log file as well.
Please help me to troubleshoot this error.
Script /opt/rman_script/st72_oracle_full.sh
==== started on Tue May 28 15:27:46 SGT 2013 ====
RMAN: /OraBase/V10203/bin/rman
ORACLE_SID: ST72
ORACLE_USER: oracle
ORACLE_HOME: /OraBase/V10203
NB_ORA_FULL: 1
NB_ORA_INCR: 0
NB_ORA_CINC: 0
NB_ORA_SERV: zsswmasb
NB_ORA_POLICY: bsswst72_oracle_daily
Full backup requested
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
You have new mail.
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> RMAN> ed.
connected to target database: ST72 (DBID=990954548)
connected to recovery catalog database
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33>
allocated channel: ch00
channel ch00: sid=149 devtype=SBT_TAPE
channel ch00: VERITAS NetBackup for Oracle - Release 6.0 (2007070504)
sent command to channel: ch00
Starting backup at 28-MAY-13
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 05/28/2013 15:27:51
RMAN-03014: implicit resync of recovery catalog failed
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20035: invalid high recid
RMAN>
Recovery Manager complete.
Script /opt/rman_script/st72_oracle_full.sh
==== ended in error on Tue May 28 15:27:51 SGT 2013 ====
=========================================================== ==================================================
Script /opt/rman_script/st72_oracle_full.sh
==== started on Tue May 28 15:24:28 SGT 2013 ====
RMAN: /OraBase/V10203/bin/rman
ORACLE_SID: ST72
ORACLE_USER: oracle
ORACLE_HOME: /OraBase/V10203
NB_ORA_FULL: 1
NB_ORA_INCR: 0
NB_ORA_CINC: 0
NB_ORA_SERV: zsswmasb
NB_ORA_POLICY: bsswst72_oracle_daily
Full backup requested
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
You have new mail.
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> RMAN> ed.
connected to target database: ST72 (DBID=990954548)
connected to recovery catalog database
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33>
allocated channel: ch00
channel ch00: sid=143 devtype=SBT_TAPE
channel ch00: VERITAS NetBackup for Oracle - Release 6.0 (2007070504)
sent command to channel: ch00
Starting backup at 28-MAY-13
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 05/28/2013 15:24:34
RMAN-03014: implicit resync of recovery catalog failed
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20035: invalid high recid
RMAN>
Recovery Manager complete.
Script /opt/rman_script/st72_oracle_full.sh
==== ended in error on Tue May 28 15:24:34 SGT 2013 ====
=========================================================== ===================================================
Script /opt/rman_script/st72_oracle_full.sh
==== started on Tue May 28 14:59:30 SGT 2013 ====
RMAN: /OraBase/V10203/bin/rman
ORACLE_SID: ST72
ORACLE_USER: oracle
ORACLE_HOME: /OraBase/V10203
NB_ORA_FULL: 1
NB_ORA_INCR: 0
NB_ORA_CINC: 0
NB_ORA_SERV: zsswmasb
NB_ORA_POLICY: bsswst72_oracle_daily
Full backup requested
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
You have new mail.
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> RMAN> ed.
connected to target database: ST72 (DBID=990954548)
connected to recovery catalog database
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33>
allocated channel: ch00
channel ch00: sid=136 devtype=SBT_TAPE
channel ch00: VERITAS NetBackup for Oracle - Release 6.0 (2007070504)
sent command to channel: ch00
Starting backup at 28-MAY-13
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 05/28/2013 14:59:36
RMAN-03014: implicit resync of recovery catalog failed
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20035: invalid high recid
RMAN>
Recovery Manager complete.
Script /opt/rman_script/st72_oracle_full.sh
==== ended in error on Tue May 28 14:59:36 SGT 2013 ====
===============================================================================================================
Thanks,
Nayab