2 Replies Latest reply on Jun 9, 2016 1:30 PM by BrianDwyer

    DBA View > RMAN settings

    BrianDwyer

      Hi, just noticed this.

       

      Using SQL Developer 4.1.3 or 3.2.20 I get the same issue when querying the RMAN settings on an oracle 12.1.0.2 database.

       

      When looking at the controlfile autobackup settings using SQL Developer it show a value of OFF.

      When I query the same setting using RMAN is shows as ON # default

      the only way to get SQL Developer to show ON is to give it a value.

       

      autobackup_controlfile.png

      You can reset back to default and the issue returns.

       

      Cheers

       

      Brian

        • 1. Re: DBA View > RMAN settings
          thatJeffSmith-Oracle

          view > log > statements

           

          clear the log

           

          refresh the rman page to get the query we use for this screen

           

          when running the query in a worksheet, what does the status show?

          • 2. Re: DBA View > RMAN settings
            BrianDwyer

            this is the SQL relating to the Controlfile Autobackup

            the NVL is defaulting it to OFF which i believe us to be the default pre 12c.

             

            SELECT

                          NVL(CA.AUTOBACKUP, 'OFF') as "Autobackup"

                        FROM

                        (

                          SELECT

                            'Policy Settings' AS GROUP_NAME

                          FROM

                            DUAL

                        ) G

                        NATURAL FULL OUTER JOIN

                        (

                          SELECT

                            TRIM(VALUE) AS AUTOBACKUP

                          FROM

                            gv$rman_configuration

                          WHERE

                            name = 'CONTROLFILE AUTOBACKUP'

                        ) CA

             

            Brian