DBA Hub

📋Steps in this guide1/1

Get standby redo log info

set lines 100 pages 999 col member format a70 select st.group# , st.sequence# , ceil(st.bytes / 1048576) mb , lf.member from v$standby_log st , v$logfile lf where st.group# = lf.group# /

oracle configurationintermediate
by OracleDba
10 views
1

Get standby redo log info

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
set lines 100 pages 999
col member format a70
select st.group#
, st.sequence#
, ceil(st.bytes / 1048576) mb
, lf.member
from v$standby_log st
, v$logfile lf
where st.group# = lf.group#
/

Comments (0)

Please to add comments

No comments yet. Be the first to comment!