SQL:查询联机日志文件状态
Log:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
SQL> select a.group#,a.member,b.status,b.archived,sum(b.bytes)/1024/1024 mbytes from v$logfile a,v$log b where a.group#=b.group# group by a.group#,a.member,b.status,b.archived order by 1,2; GROUP# MEMBER STATUS ARC MBYTES ---------- -------------------------------------------------------------------- ---------------- --- ---------- 1 /oradata/ATLAS/onlinelog/o1_mf_1_b5cyjr0s_.log ACTIVE NO 50 1 /oradata/fast_recovery_area/ATLAS/onlinelog/o1_mf_1_b5cyjrgf_.log ACTIVE NO 50 2 /oradata/ATLAS/onlinelog/o1_mf_2_b5cyjs6t_.log ACTIVE NO 50 2 /oradata/fast_recovery_area/ATLAS/onlinelog/o1_mf_2_b5cyjsoj_.log ACTIVE NO 50 3 /oradata/ATLAS/onlinelog/o1_mf_3_b5cyjt8v_.log ACTIVE NO 50 3 /oradata/fast_recovery_area/ATLAS/onlinelog/o1_mf_3_b5cyjvkg_.log ACTIVE NO 50 4 /oradata/ATLAS/onlinelog/redo04a.log CURRENT NO 50 4 /oradata/fast_recovery_area/ATLAS/onlinelog/redo04b.log CURRENT NO 50 8 rows selected. SQL> |
————————————————
Ending。[……]