4 Replies Latest reply: Feb 23, 2011 1:38 AM by Lubiez Jean-Valentin RSS

    rman>list failure  -----is not working on 11g

    afzal
      Hi

      list failure -----------is not working

      RMAN> LIST FAILURE;


      using target database control file instead of recovery catalog
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of list command at 02/23/2011 12:14:27
      RMAN-05533: LIST FAILURE is not supported on STANDBY database
        • 1. Re: rman>list failure  -----is not working on 11g
          Lubiez Jean-Valentin
          Hello,


          It doesn't work on a Standby Database:
          RMAN-05533: string is not supported on string database
          Cause: The specified command is not supported on this type of database. The type of database can be STANDBY, CLONE, or RAC.
          Action: Do not use the specified command against this database.
          I don't know if you are in 11.1 or 11.2, but the following Note from MOS confirm that in 11.1 the Data Recovery Advisor cannot be used to diagnose or repair failures on a Standby Database.
          Data Recovery Advisor -Reference Guide. [ID 466682.1]
          Hope this help.
          Best regards,
          Jean-Valentin

          Edited by: Lubiez Jean-Valentin on Feb 23, 2011 8:11 AM
          • 2. Re: rman>list failure  -----is not working on 11g
            afzal
            HI
            rman error also says same thing such as you wrote


            but what is command or process for STANDBY, CLONE, or RAC DATABASE.



            THANKS
            • 3. Re: rman>list failure  -----is not working on 11g
              afzal
              i am working on databse 11.2.0.2.0
              • 4. Re: rman>list failure  -----is not working on 11g
                Lubiez Jean-Valentin
                Hello,


                DRA (Data Recovery Advisor) should be used on a single-instance database and not a physical standby.

                So for a RAC, you should mount the database in single-mode.

                For a Standby, it can work on a Logical Standby not a Physical. Except if you switch over and the Standby become the Primary.

                You may have more information on the following link and Note:

                http://download.oracle.com/docs/cd/E11882_01/backup.112/e10643/rcmsynta003.htm#CHDHBIAB
                RMAN 11G : Data Recovery Advisor - RMAN command line example [ID 762339.1]
                You have in fact the same kind of restrictions in 11.2.


                Hope this help.
                Best regards,
                Jean-Valentin

                Edited by: Lubiez Jean-Valentin on Feb 23, 2011 8:36 AM