How does sql view the location of archive logs

This article mainly shows you "how sql views the location of archived logs", which is easy to understand and well-organized. I hope it can help you solve your doubts. Let me lead you to study and learn this article "how to view archived logs by sql".

SQL > show parameter db_recovery_file_dest

NAME TYPE VALUE

-

Db_recovery_file_dest string / u01/

Db_recovery_file_dest_size big integer 1028M

SQL > select name from v$archived_log

NAME

/ u01/ORACLE/archivelog/2010_09_17/o1_mf_1_40_6960yp2w_.arc

/ u01/ORACLE/archivelog/2010_09_19/o1_mf_1_41_69bwmbrr_.arc

/ u01/ORACLE/archivelog/2010_09_19/o1_mf_1_42_69c0xz6s_.arc

/ u01/ORACLE/archivelog/2010_09_19/o1_mf_1_43_69c3r3rd_.arc

The above is all the contents of the article "how to view the location of archived logs by sql". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!