Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> redo log group resize
rokyj055
post Mar 20 2012, 04:23 AM
Post #1


Advanced Member
***

Group: Members
Posts: 75
Joined: 23-January 12
Member No.: 46,637



Hi All ,

I want to re-size redo log group on my production database .
i have 10 redo log groups of 50mb each having 2 members.

i want 4 redo groups to be of 250 mb each having 2 members and then i will drop that old 10 redo log group(50 mb ) , so that i will have only 4 redo log group of 250MB each having 2 members.

But i have physical standby and logical standby configured on production database .


Please find attached file for redo log configuration of production database(CBSPROD),Logical standby database(CBSMIS), Physical standby database(CBSDR)


Attached File(s)
Attached File  redo_resize_detais.zip ( 3.84K ) Number of downloads: 3
 
Go to the top of the page
 
+Quote Post
burleson
post Mar 20 2012, 05:31 AM
Post #2


Advanced Member
***

Group: Members
Posts: 11,634
Joined: 26-January 04
Member No.: 13



Hi,

Is there a question in here sonewhere?

See here, how to size your redo:

http://dba-oracle.com/googlesearchsite_pro...p;q=redo+sizing


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 30th October 2014 - 07:57 AM