4 Replies Latest reply: Jan 24, 2013 9:59 AM by Karan RSS

    RMAN error

    $phinx19
      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
          look for same error here ORA-01775: looping chain of synonyms
          • 2. Re: RMAN error
            sb92075
            $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
              check out http://www.dba-oracle.com/sf_ora_01775_looping_chain_of_synonyms_bc1.htm
              • 4. Re: RMAN error
                Osama_Mustafa
                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.