Oracle数据恢复情景2-模拟redo log丢失(1)(二)
E,t2.STATUS,t2.bytes from v$logfile t1,v$log t2 where t1.GROUP#=t2.GROUP#;
08 www.2cto.com
GROUP# MEMBER TYPE STATUS BYTES
09
------ ---------------------------------------- -------- -------- ----------
10
3 /opt/oracle/oradata/oraddim/redo03.log ONLINE CURRENT 52428800
11
2 /opt/oracle/oradata/oraddim/redo02.log ONLINE ACTIVE 52428800
12
1 /opt/oracle/oradata/oraddim/redo01.log ONLINE INACTIVE 52428800
作者 旺仔的钥匙