6 Replies Latest reply: Nov 2, 2010 10:46 AM by 746586 RSS

    Questions regarding *dump_dest parameters and fast_recovery_area

    746586
      Hello,

      I just installed a fresh new 11.2.0.2 Database on Solaris 10.

      Everything straightforward on the parameter side!!! I tried custom install as well as general purpose template. When installing with DBCA, I set every parameters around DB Name in lowercase name.

      With this, questions are popping in my mind regarding some parameters after installation.

      First, %dump_dest parameters contains in path, two times the db name (ocpdb in my case):
      background_dump_dest       /u01/app/oracle/diag/rdbms/ocpdb/ocpdb/trace
      user_dump_dest                 /u01/app/oracle/diag/rdbms/ocpdb/ocpdb/trace
      core_dump_dest                 /u01/app/oracle/diag/rdbms/ocpdb/ocpdb/cdump
      Is it normal to have ..../rdbms/dbname/dbname/..... as path, with dbname/dbname ??? Why?

      Second, the question regarding the directory structure under fast_recovery_area (new term for flash_recovery_area). The directory structure:
      oracle@enalab13:/u01/app/oracle/fast_recovery_area$ ls -l 
      total 2
      drwxr-x--- 2 oracle oinstall 512 2010-10-28 19:53 ocpdb
      drwxr----- 5 oracle oinstall 512 2010-10-29 07:44 OCPDB
      
      oracle@enalab13:/u01/app/oracle/fast_recovery_area$ ls -l ocpdb
      total 9528
      -rw-r----- 1 oracle oinstall 9748480 2010-10-31 21:09 control02.ctl
      
      oracle@enalab13:/u01/app/oracle/fast_recovery_area$ ls -l OCPDB/
      total 3
      drwxr----- 5 oracle oinstall 512 2010-10-31 03:48 archivelog
      drwxr----- 3 oracle oinstall 512 2010-10-29 07:44 autobackup
      drwxr----- 3 oracle oinstall 512 2010-10-29 07:43 backupset
      Why am I having a subdir with dbname in uppercase AND in lowercase? Should I specify dbname in uppercase at db creation to have all files under the same directory, or in lowercase? Or, is it normal?

      I want to know how to do it well before reinstalling a fresh database.

      Thanks
      Bruno

      Edited by: blavoie on Oct 31, 2010 6:18 PM

      Edited by: blavoie on Oct 31, 2010 6:20 PM
        • 1. Re: Questions regarding *dump_dest parameters and fast_recovery_area
          Salman Qureshi
          hi,
          Is it normal to have ..../rdbms/dbname/dbname/..... as path, with dbname/dbname ??? Why?
          Yes it is normal. Second one is not "dbname", its instance name. For example, if dbname is DB and instance name is INST1 then path would be .../rdbms/DB/INST1. In a RAC environment, it will be when more clearer for you when instances names are different then DB names.
          Second, the question regarding the directory structure under fast_recovery_area (new term for flash_recovery_area). The directory structure:
          Can you show us the output of following
          archive log list
          
          show parameter recovery
          
          show parameter control_files
          I presume you have mentioned directory name in capital letters in the parameter "db_recovery_file_dest" and in small letters in "control_files"

          Salman
          • 2. Re: Questions regarding *dump_dest parameters and fast_recovery_area
            746586
            Thanks Salman,

            I clearly understand with the response for my first question.

            Here are de details of the 2nd one:
            SQL> archive log list
            Database log mode              Archive Mode
            Automatic archival             Enabled
            Archive destination            USE_DB_RECOVERY_FILE_DEST
            Oldest online log sequence     43
            Next log sequence to archive   45
            Current log sequence           45
            
            SQL> show parameter recovery
            
            NAME                                 TYPE        VALUE
            ------------------------------------ ----------- ------------------------------
            db_recovery_file_dest                string      /u01/app/oracle/fast_recovery_area
            db_recovery_file_dest_size           big integer 4G
            recovery_parallelism                 integer     0
            
            SQL> show parameter control_files
            
            NAME                                 TYPE        VALUE
            ------------------------------------ ----------- ------------------------------
            control_files                        string      /u01/app/oracle/oradata/ocpdb/control01.ctl, 
                                                                 /u01/app/oracle/fast_recovery_area/ocpdb/control02.ctl
            If I remember correctly, everything was set in lowercase when installing with DBCA...

            Another point that I don't think it's a problem: dbca was run with remote X to my CygwinX on my laptop.

            Thanks
            Bruno
            • 3. Re: Questions regarding *dump_dest parameters and fast_recovery_area
              Salman Qureshi
              hi,
              If I remember correctly, everything was set in lowercase when installing with DBCA
              Seems weird then. You should not see directory name in capitals. Perhaps you set ORACLE_SID in capital letters and during DBCA steps you supplied it with the small letters. Please also provide following information
              show parameter instance_name
              show parameter db_name
              show parameter log_archive_dest_1
              Salman
              • 4. Re: Questions regarding *dump_dest parameters and fast_recovery_area
                746586
                Hi Salman,

                I thought that the problem is the $ORACLE_SID environment variable, but when I echo this values, it's lowercase too:
                oracle@enalab12:~$ echo $ORACLE_SID 
                labb11
                I tried a few days ago to deinstall/reinstall a database all in uppercase but forgot the ORACLE_SID environement variable in lower case. After this reinstall, there is a single upper case directory for the sid under fast_recovery area.

                But, another glitch is that *dump_dest has a part in upper and other one in lower case:
                SQL> show parameter %dump_dest     
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                background_dump_dest                 string      /u01/app/oracle/diag/rdbms/labb11/LABB11/trace
                core_dump_dest                       string      /u01/app/oracle/diag/rdbms/labb11/LABB11/cdump
                user_dump_dest                       string      /u01/app/oracle/diag/rdbms/labb11/LABB11/trace
                This because sid environment variable was in lowercase and that I installed in uppercase with dbca.

                Here output of what you asked:
                SQL> show parameter instance_name
                show parameter db_name
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                instance_name                        string      ocpdb
                SQL> 
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                db_name                              string      ocpdb
                SQL> show parameter log_archive_dest_1
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                log_archive_dest_1                   string
                log_archive_dest_10                  string
                log_archive_dest_11                  string
                log_archive_dest_12                  string
                log_archive_dest_13                  string
                log_archive_dest_14                  string
                log_archive_dest_15                  string
                log_archive_dest_16                  string
                log_archive_dest_17                  string
                log_archive_dest_18                  string
                log_archive_dest_19                  string
                SQL> 
                I think that i need to do another tests with everything coherent regarding ORACLE_SID environment variable and DBNAME during installation. I forgot oracle_sid in lower case! :(

                Generally speaking, is there some guidelines to create everything in lower or upper case?

                Thanks again.
                • 5. Re: Questions regarding *dump_dest parameters and fast_recovery_area
                  746586
                  Hi Salman,

                  I thought that the problem is the $ORACLE_SID environment variable, but when I echo this values, it's lowercase too:
                  oracle@enalab13:~$ echo $ORACLE_SID
                  ocpdb
                  I tried a few days ago to deinstall/reinstall another database all in uppercase but forgot the ORACLE_SID environement variable in lower case. After this reinstall, there is a single upper case directory for the sid under fast_recovery area.

                  But, another glitch is that *dump_dest has a part in upper and other one in lower case:
                  SQL> show parameter %dump_dest     
                  
                  NAME                                 TYPE        VALUE
                  ------------------------------------ ----------- ------------------------------
                  background_dump_dest                 string      /u01/app/oracle/diag/rdbms/labb11/LABB11/trace
                  core_dump_dest                       string      /u01/app/oracle/diag/rdbms/labb11/LABB11/cdump
                  user_dump_dest                       string      /u01/app/oracle/diag/rdbms/labb11/LABB11/trace
                  This because sid environment variable was in lowercase and that I installed in uppercase with dbca.

                  Here output of what you asked:
                  SQL> show parameter instance_name
                  show parameter db_name
                  
                  NAME                                 TYPE        VALUE
                  ------------------------------------ ----------- ------------------------------
                  instance_name                        string      ocpdb
                  SQL> 
                  NAME                                 TYPE        VALUE
                  ------------------------------------ ----------- ------------------------------
                  db_name                              string      ocpdb
                  SQL> show parameter log_archive_dest_1
                  
                  NAME                                 TYPE        VALUE
                  ------------------------------------ ----------- ------------------------------
                  log_archive_dest_1                   string
                  log_archive_dest_10                  string
                  log_archive_dest_11                  string
                  log_archive_dest_12                  string
                  log_archive_dest_13                  string
                  log_archive_dest_14                  string
                  log_archive_dest_15                  string
                  log_archive_dest_16                  string
                  log_archive_dest_17                  string
                  log_archive_dest_18                  string
                  log_archive_dest_19                  string
                  SQL> 
                  I think that i need to do another tests with everything coherent regarding ORACLE_SID environment variable and DBNAME during installation. I forgot oracle_sid in lower case! :(

                  Generally speaking, is there some guidelines to create everything in lower or upper case?

                  Thanks again.
                  • 6. Re: Questions regarding *dump_dest parameters and fast_recovery_area
                    746586
                    Hi,

                    I just reinstalled all from scratch, everything in lowercase as well in environment variables and dbname in dbca:
                    oracle@enalab13:~$ echo $ORACLE_SID
                    ocpdb
                    Fast recovery area directories, dates prove that it's my fresh install:
                    oracle@enalab13:/u01/app/oracle$ ll fast_recovery_area/
                    total 2
                    drwxr-x--- 2 oracle oinstall 512 2010-11-02 11:06 ocpdb
                    drwxr-x--- 4 oracle oinstall 512 2010-11-02 11:24 OCPDB
                    oracle@enalab13:/u01/app/oracle$ ll -R fast_recovery_area/
                    fast_recovery_area/:
                    total 2
                    drwxr-x--- 2 oracle oinstall 512 2010-11-02 11:06 ocpdb
                    drwxr-x--- 4 oracle oinstall 512 2010-11-02 11:24 OCPDB
                    
                    fast_recovery_area/ocpdb:
                    total 9528
                    -rw-r----- 1 oracle oinstall 9748480 2010-11-02 11:34 control02.ctl
                    
                    fast_recovery_area/OCPDB:
                    total 2
                    drwxr-x--- 3 oracle oinstall 512 2010-11-02 11:24 archivelog
                    drwxr-x--- 2 oracle oinstall 512 2010-11-02 11:06 onlinelog
                    
                    fast_recovery_area/OCPDB/archivelog:
                    total 1
                    drwxr-x--- 2 oracle oinstall 512 2010-11-02 11:24 2010_11_02
                    
                    fast_recovery_area/OCPDB/archivelog/2010_11_02:
                    total 47032
                    -rw-r----- 1 oracle oinstall 48123392 2010-11-02 11:24 o1_mf_1_5_6f0c9pnh_.arc
                    
                    fast_recovery_area/OCPDB/onlinelog:
                    total 0
                    Some interresting output asked earlier in post:
                    SQL> archive log list
                    Database log mode              Archive Mode
                    Automatic archival             Enabled
                    Archive destination            USE_DB_RECOVERY_FILE_DEST
                    Oldest online log sequence     4
                    Next log sequence to archive   6
                    Current log sequence           6
                    
                    SQL> show parameter recovery
                    NAME                                 TYPE        VALUE
                    ------------------------------------ ----------- ------------------------------
                    db_recovery_file_dest                string      /u01/app/oracle/fast_recovery_area
                    db_recovery_file_dest_size           big integer 4032M
                    recovery_parallelism                 integer     0
                    
                    SQL> show parameter control_files
                    NAME                                 TYPE        VALUE
                    ------------------------------------ ----------- ------------------------------
                    control_files                        string      /u01/app/oracle/oradata/ocpdb/control01.ctl, 
                                                                         /u01/app/oracle/fast_recovery_area/ocpdb/control02.ctl
                    
                    SQL> show parameter instance_name
                    NAME                                 TYPE        VALUE
                    ------------------------------------ ----------- ------------------------------
                    instance_name                        string      ocpdb
                    
                    SQL> show parameter db_name
                    NAME                                 TYPE        VALUE
                    ------------------------------------ ----------- ------------------------------
                    db_name                              string      ocpdb
                    
                    SQL> show parameter log_archive_dest_1
                    NAME                                 TYPE        VALUE
                    ------------------------------------ ----------- ------------------------------
                    log_archive_dest_1                   string
                    log_archive_dest_10                  string
                    log_archive_dest_11                  string
                    log_archive_dest_12                  string
                    log_archive_dest_13                  string
                    log_archive_dest_14                  string
                    log_archive_dest_15                  string
                    log_archive_dest_16                  string
                    log_archive_dest_17                  string
                    log_archive_dest_18                  string
                    log_archive_dest_19                  string
                    
                    SQL> show parameter %dump_dest  
                    
                    NAME                                 TYPE        VALUE
                    ------------------------------------ ----------- ------------------------------
                    background_dump_dest                 string      /u01/app/oracle/diag/rdbms/ocpdb/ocpdb/trace
                    core_dump_dest                       string      /u01/app/oracle/diag/rdbms/ocpdb/ocpdb/cdump
                    user_dump_dest                       string      /u01/app/oracle/diag/rdbms/ocpdb/ocpdb/trace
                    I think, next time, I'll install everything regarding oracle SID in upper case...
                    Maybe it's details that I don't need to care about... I seems that something is happening bad with the management of fast_recovery_area...


                    Thanks
                    Bruno