3 Replies Latest reply: Sep 6, 2013 6:33 AM by JohnWatson RSS

    Flash Recovery Area Setup

    Juhi

      what is the difference between, db_recovery_size and db_recovery_file_dest_size

        / and /

      db_recovery_dest and db_recovery_file_dest

      do both can be used or  been changed with newer release

       

      i found both been used to set up FRA at different places on web but  both doing same thing

       

      just a little confused

        • 1. Re: Flash Recovery Area Setup
          JohnWatson

          The difference is that some exist, and some don't

           

          orclz>

          orclz> sho parameter db_recovery

           

          NAME                                 TYPE       VALUE

          ------------------------------------ ---------- ------------------------------

          db_recovery_file_dest                string     c:\app\oracle\fast_recovery_ar

                                                          ea

          db_recovery_file_dest_size           big intege 4815M

                                               r

          orclz>

          • 2. Re: Flash Recovery Area Setup
            Juhi

            but  in RMAN Recipes for Oracle Database 11g    it says ,

            3. Issue the following commands to size and create the flash recovery area:

            alter system set db_recovery_size = 4G;

            alter system set db_recovery_dest = '/home/oracle/flasharea';

             

            i know the parameters are , what u showed me and i use that only but just for knowledge sake and clearing my doubts i asked this

            • 3. Re: Flash Recovery Area Setup
              JohnWatson

              Some publishers have better technical editing than others, but some mistakes always get through. I know - my books have mostly been published by Oracle Press, which has really good editing, but there are still mistakes that don't get caught. You should mail the publisher and tell them, so that the mistake can be included on the book's errata list.