This discussion is archived
4 Replies Latest reply: Jan 24, 2013 7:59 AM by karan RSS

RMAN error

$phinx19 Newbie
Currently Being Moderated
Hi All,

OS:Solaris
DB:10.2.0.4

I am trying to backup my database using Rman as:
backup database plus archivelog;
I am getting the below mentioned error.

Starting backup at 24-JAN-13
current log archived
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 01/24/2013 21:11:20
ORA-01775: looping chain of synonyms


Regards,
Sphinx
  • 1. Re: RMAN error
    karan Pro
    Currently Being Moderated
    look for same error here ORA-01775: looping chain of synonyms
  • 2. Re: RMAN error
    sb92075 Guru
    Currently Being Moderated
    $phinx19 wrote:
    Hi All,

    OS:Solaris
    DB:10.2.0.4

    I am trying to backup my database using Rman as:
    backup database plus archivelog;
    I am getting the below mentioned error.

    Starting backup at 24-JAN-13
    current log archived
    using channel ORA_DISK_1
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of backup plus archivelog command at 01/24/2013 21:11:20
    ORA-01775: looping chain of synonyms


    Regards,
    Sphinx
    problem is not specific to RMAN

    you need to find & break synonym loop.
  • 3. Re: RMAN error
    karan Pro
    Currently Being Moderated
    check out http://www.dba-oracle.com/sf_ora_01775_looping_chain_of_synonyms_bc1.htm
  • 4. Re: RMAN error
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Enable Trace to check which Synonym
    SQL> connect / as sysdba
    SQL> alter system set events '1775 trace name ERRORSTACK level 3';
    re-run the command and check the trace file.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points