-
Hi! All
Is it possible to rename a logfile group.
Thanx
There Nothing You cannot Do, The problem is HOW.
-
Rename the individual members or rename the entire group?
Jeff Hunter
-
solution
Hi, 21st May 2001 18:25 hrs chennai
Padmam
[Edited by padmam on 05-21-2001 at 09:00 AM]
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
-
solution
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
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
-
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.
There Nothing You cannot Do, The problem is HOW.
-
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.
There Nothing You cannot Do, The problem is HOW.
-
solution
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
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
-
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
There Nothing You cannot Do, The problem is HOW.
-
Yes
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
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|