********************************************************* * 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