| Oracle Administrative Tasks [message #55965] |
Wed, 26 February 2003 19:49  |
Rupak Basak
Messages: 9
Registered: December 2002
|
Junior Member |
|
|
Hello,
I wish to know the following. Issuing the following 3 SQL commands displays this way :
SQL> select group#, members, status from v$log;
GROUP# MEMBERS STATUS
---------- ---------- ----------------
1 1 INACTIVE
2 1 INACTIVE
...
9 1 INACTIVE
14 1 INACTIVE
15 1 INACTIVE
16 1 INACTIVE
16 rows selected.
SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.
SQL> select group#, members, status from v$log;
GROUP# MEMBERS STATUS
---------- ---------- ----------------
1 1 INACTIVE
2 1 INACTIVE
3 1 INACTIVE
4 1 INACTIVE
5 1 INACTIVE
6 1 INACTIVE
7 1 INACTIVE
8 1 INACTIVE
9 1 INACTIVE
10 1 INACTIVE
11 1 ACTIVE
12 1 CURRENT
13 1 INACTIVE
14 1 INACTIVE
15 1 INACTIVE
16 1 INACTIVE
16 rows selected.
What's "ACTIVE", as compared to "CURRENT" and "INACTIVE"?
Could anybody explain me a bit?
Regards
/Bappa
|
|
|
|
| Re: Oracle Administrative Tasks [message #55967 is a reply to message #55965] |
Thu, 27 February 2003 01:44  |
Garouppa
Messages: 27
Registered: February 2003
|
Junior Member |
|
|
I bet Inactive is clear enough, means you can do (Almost) any crazy thing on them, current is the one being used by Oracle for redo informationIE, the one that is at the moment being wrote on, it is normally held in exclusive mode, the active is the one that is just left by Oracle, and left to the archiver, (if archive log is on), it is being copied.
Hope this is clear ... and ..... not wrong ...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
