Oracle backup Fails: RMAN-06171

[Former Member]

Hello All,

We have shifted our Database backup from TAPE to DISK due to TAPE Failure.

After shifting we have made the necessary changes in iniSID.SAP file

ex. 1.  backup_type = online

      2.  backup_dev_type = disk

      3.  backup_root_dir = /mnt/iscsi/onlinebackup12  etc.

Backup Seems to be successfully completed but after 100% completion it automatically starts RMAN for redo log backup but ended with error mesage.

here is the RMAN log:

RMAN>

RMAN> connect target *

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

ORA-01031: insufficient privileges

RMAN> **end-of-file**

RMAN>

host command complete

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> 34

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of catalog command at 07/11/2012 10:04:35

RMAN-06171: not connected to target database

RMAN>

Recovery Manager complete.

BR0280I BRBACKUP time stamp: 2012-07-11 10.04.35

BR0279E Return code from 'SHELL=/bin/sh /oracle/MHP/102_64/bin/rman nocatalog': 1

BR0536E RMAN call for database instance MHP failed

BR0280I BRBACKUP time stamp: 2012-07-11 10.04.35

BR0532E Cataloging backups of all database files failed

BR0056I End of database backup: beiyqzth.fnd 2012-07-11 10.04.35

BR0280I BRBACKUP time stamp: 2012-07-11 10.04.35

BR0054I BRBACKUP terminated with errors

External program terminated with exit code 5

BRBACKUP returned error status E

Job finished

Please help me to get out of this.

Best regards,

Amol Dounde

[Former Member]

Hi .

check one's ORADBUSER.sql ( ORA-1031/1017 invalid User ID and Password logon failed )

change the password in two table ( dba_user , SAPUSR table)

->sqlplus /as sysdba

->sql>alter user SAPSR3 identified by <password>;

regards

Bhasker.T

[Former Member]

What operating system you are using? You need to check rights to br* files on OS level. On Linux you need s-bit for brbackup, brarchive. See Note 776505: BR*Tools fail with ORA-01017 / ORA-01031 on Linux

Regards

Roman

[Former Member]

Hi Amol,

Check the Note 776505 - BR*Tools fail with ORA-01017 / ORA-01031 on Linux

Best regards,

Orkun Gedik