Home » RDBMS Server » Server Utilities » Alter The Status of Redolog
Alter The Status of Redolog [message #488952] Wed, 12 January 2011 08:09 Go to next message
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 #488957 is a reply to message #488952] Wed, 12 January 2011 08:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Why the status values is null in the first select

Both do not show the same information and have different meanings.
See the documentation:
V$LOG
V$LOGFILE

Quote:
how i can update the status

You can't.

Regards
Michel

[Updated on: Wed, 12 January 2011 08:29]

Report message to a moderator

Re: Alter The Status of Redolog [message #488958 is a reply to message #488957] Wed, 12 January 2011 08:34 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: import with buffer parameter
Next Topic: Schema Export, table compares across schemas
Goto Forum:
  


Current Time: Thu Mar 28 10:57:59 CDT 2024