| Alter The Status of Redolog [message #488952] |
Wed, 12 January 2011 08:09  |
raul33
Messages: 26
Registered: October 2008
Location: jordan
|
Junior Member |
|
|
Dear All
I have This output
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
1 ONLINE E:\orcl_FILES\orcl\REDO21.LOG NO
1 ONLINE E:\orcl_FILES\orcl\REDO11.LOG NO
1 ONLINE E:\orcl_FILES\orcl\REDO31.LOG NO
2 ONLINE F:\orcl_FILES\orcl\REDO12.LOG NO
2 ONLINE F:\orcl_FILES\orcl\REDO22.LOG NO
2 ONLINE F:\orcl_FILES\orcl\REDO32.LOG NO
3 ONLINE Q:\orcl_FILES\orcl\REDO23.LOG NO
3 ONLINE Q:\orcl_FILES\orcl\REDO13.LOG NO
3 ONLINE Q:\orcl_FILES\orcl\REDO33.LOG NO
GROUP# MEMBERS STATUS ARCHIVED
1 3 UNUSED YES
2 3 CURRENT NO
3 3 UNUSED YES
when perform this both select
SELECT GROUP#, MEMBERS, STATUS, ARCHIVED FROM V$LOG;
select * from v$logfile;
Why the status values is null in the first select and how i can update the status.
in the second select How I can Update the status of group 1 of redo log to current Value and i need to shutdown the database to update status.
Thanks In Advance
|
|
|
|
|
|
| Re: Alter The Status of Redolog [message #488958 is a reply to message #488957] |
Wed, 12 January 2011 08:34  |
raul33
Messages: 26
Registered: October 2008
Location: jordan
|
Junior Member |
|
|
Thanks Michel
but the status was inactive but when use this procedure for both
group 1 and group 3
ALTER DATABASE CLEAR LOGFILE GROUP 1;
ALTER DATABASE CLEAR LOGFILE GROUP 3;
the status changed from inactive to unused
|
|
|
|
| Re: Alter The Status of Redolog [message #488959 is a reply to message #488958] |
Wed, 12 January 2011 08:40 |
 |
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Which status are you talking about?
Do not say what you do, show us, use SQL*Plus and copy and paste your session.
Before, Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
