Skip to Content
avatar image
Former Member

Oracle backup Fails: RMAN-06171

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jul 11, 2012 at 07:37 AM

    Hi Amol,

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

    Best regards,

    Orkun Gedik

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 11, 2012 at 07:42 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 11, 2012 at 05:12 PM

    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

    Add comment
    10|10000 characters needed characters exceeded