Hi! All
Is it possible to rename a logfile group.
Thanx
Printable View
Hi! All
Is it possible to rename a logfile group.
Thanx
Rename the individual members or rename the entire group?
Hi, 21st May 2001 18:25 hrs chennai
Padmam
[Edited by padmam on 05-21-2001 at 09:00 AM]
Hi, 21st May 2001 18:25 hrs chennai
Here is link which explains you in very precise how to rename a log file .
http://oradb1.jinr.ru/oracle/srvr/se...m#renameonline
Note:A log group consist of log file members.
A group is a logical entity.
If you read the link you will understand why you canot move a group.A group is not a Physical file to move at o/s level and then rename (rename i.e update the controlfile of the new path of the log file) the same.
Cheers
Padmam
Actually What I have done is as follows
I had 8 logfiles with 1 member each of 512k size each. Now it was causing some contentions. So I added 8 more groups with one member each of size 5m. After that I dropped the old 512k groups. Now I have groups named as group08 to group16. And now I want to rename them from group1 to group8.
Sudip,
Is this a production DB?
If so, I recommend that you add an extra set of members to your redo groups to increase resilience?
No, Absolutely Not.
It is a test instance. Thanx anyway.
Hi , 21st May 2001 18:59 hrs chennai
In the link it has also given how to rename the log files..Instead of renaming to different disk rename it in the same path or disk as per your requirement.
Rename the existing files as new and then drop the old ones physically.
Eg:
ALTER DATABASE
RENAME FILE 'log1a'
TO 'log1c' ;
Did you try like this ?
Cheers
Padmam
Well, May be I am confusing myself,
Well I deleted group1 to group8 now is it possible to recreate a group with name group1 OR rename a existing group not log member to group1?
thanx for yr patience
Hi, 21st May 2001 20:00 hrs chennai
Why dont you create a new log groups as the name you require and drop the old ones.
I have not come across renaming a log group.I think that is not possible or available in oracle.If some ones tells well and good to know.
Cheers
Padmam
You can create a logfile group with group# 1 by:
alter database add logfile group 1 ('/logdir/logfile1_01.dbf','/logdir2/logfile1_02.dbf') size 1M;
AFAIK, you can't rename an existing group...
Thanx a lot. I did all my experiments (as per yr reccomendation) on my Personal Oracle and am now confident. My consepts are clear now.
Thanx a lot guys.