本文介绍了如何使用Oracle数据库中的v$archived_log视图来查询归档日志的相关信息，包括序列号及日志文件路径。
归档相关的数据字典： v$archived_log;
SYS@orcl11g> desc v$archived_log;
![file://C:\Users\ADMINI~1\AppData\Local\Temp\ct_tmp/1.png]()
SYS@orcl11g> select sequence#,name from v$archived_log order by 1;
SEQUENCE# NAME
----------------- --------------------------------------------------------------------------------------------------------------------------------
29 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2013_06_17/o1_mf_1_29_8vwxglwq_.arc
30 /u01/app/oracle/arch/1_30_816622368.dbf
SYS@orcl11g> desc v$archived_log;
SYS@orcl11g> select sequence#,name from v$archived_log order by 1;
SEQUENCE# NAME
----------------- --------------------------------------------------------------------------------------------------------------------------------
29 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2013_06_17/o1_mf_1_29_8vwxglwq_.arc
30 /u01/app/oracle/arch/1_30_816622368.dbf
扫一扫
864
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
