Information from V$Logfile and V$Log

V$Logfile

Group # Status Member
1 Null value /pcard13/oradata/pcard/redopcard01.log
1 Null value /pcard14/oradata/pcard/redopcard01_1.log
2 Null value /pcard13/oradata/pcard/redopcard02_1.log
2 Null value /pcard14/oradata/pcard/redopcard02.log
3 Null value /pcard13/oradata/pcard/redopcard03.log
3 Null value /pcard14/oradata/pcard/redopcard03_1.log
4 Null value /pcard13/oradata/pcard/redopcard04_1.log
4 Null value /pcard14/oradata/pcard/redopcard04.log
5 Null value /pcard13/oradata/pcard/redopcard05.log
5 Null value /pcard14/oradata/pcard/redopcard05_1.log
6 Null value /pcard13/oradata/pcard/redopcard06_1.log
6 Null value /pcard14/oradata/pcard/redopcard06.log
7 Null value /pcard13/oradata/pcard/redopcard07.log
7 Null value /pcard14/oradata/pcard/redopcard07_1.log
8 Null value /pcard13/oradata/pcard/redopcard08_1.log
8 Null value /pcard14/oradata/pcard/redopcard08.log
9 Null value /pcard13/oradata/pcard/redopcard09.log
9 Null value /pcard14/oradata/pcard/redopcard09_1.log
10 Null value /pcard13/oradata/pcard/redopcard10_1.log
10 Null value /pcard14/oradata/pcard/redopcard10.log

Back to top

V$Log

Group # Thread # Sequence # Bytes Members Archived Status First Change # First Time
1 1 1891 52428800 2 YES INACTIVE 13622644 21-Jun-2011 13:00:02
2 1 1892 52428800 2 YES INACTIVE 13625298 21-Jun-2011 14:00:04
3 1 1893 52428800 2 NO CURRENT 13627793 21-Jun-2011 15:00:04
4 1 1884 52428800 2 YES INACTIVE 13602566 21-Jun-2011 06:00:03
5 1 1885 52428800 2 YES INACTIVE 13608775 21-Jun-2011 07:00:03
6 1 1886 52428800 2 YES INACTIVE 13610935 21-Jun-2011 08:00:03
7 1 1887 52428800 2 YES INACTIVE 13613039 21-Jun-2011 09:00:03
8 1 1888 52428800 2 YES INACTIVE 13615196 21-Jun-2011 10:00:03
9 1 1889 52428800 2 YES INACTIVE 13617489 21-Jun-2011 11:00:04
10 1 1890 52428800 2 YES INACTIVE 13620130 21-Jun-2011 12:00:03

Back to top