* Description: Find Oracle database archive log location 
* Date: 02:52 PM EST, 03/26/2020                         

<1> Sometimes, when searching Oracle archive log location, "show parameter log_archive_dest" did not return any location:
     |__ o. One possible, it goes into Flash Recovery Area by default.
     |__ o. If did not find the archive log within FRA, following command would show detail of archive log setting:
         |__ SQL> archive log list;
                     Database log mode              No Archive Mode
                     Automatic archival             Disabled
                     Archive destination            /u03/database/archivelog
                     Oldest online log sequence     69397
                     Current log sequence           69399



Your Comments