how to delete second group of redo log ( and recreate it with other sizes )

[code language=»sql»]
select ‘alter database drop logfile member »’|| member ||»’;’ from ( select rank ()over ( partition by group# order by member) as rnk ,member from v$logfile ) where rnk=2 ;
[/code]

valid for standby database:
[code language=»sql»]
alter system set standby_file_management=manual;
[/code]

[code language=»sql»]
alter database add logfile thread 1
group 11 (‘+REDO’) size 1G,
group 12 (‘+REDO’) size 1G,
group 13 (‘+REDO’) size 1G,
group 14 (‘+REDO’) size 1G,
group 15 (‘+REDO’) size 1G;

alter database add logfile thread 2
group 21 (‘+REDO’) size 1G,
group 22 (‘+REDO’) size 1G,
group 23 (‘+REDO’) size 1G,
group 24 (‘+REDO’) size 1G,
group 25 (‘+REDO’) size 1G;

alter database add logfile thread 3
group 31 (‘+REDO’) size 1G,
group 32 (‘+REDO’) size 1G,
group 33 (‘+REDO’) size 1G,
group 34 (‘+REDO’) size 1G,
group 35 (‘+REDO’) size 1G;

alter database add standby logfile thread 1
group 111 (‘+REDO’) size 1G,
group 112 (‘+REDO’) size 1G,
group 113 (‘+REDO’) size 1G,
group 114 (‘+REDO’) size 1G,
group 115 (‘+REDO’) size 1G,
group 116 (‘+REDO’) size 1G;

alter database add standby logfile thread 2
group 121 (‘+REDO’) size 1G,
group 122 (‘+REDO’) size 1G,
group 123 (‘+REDO’) size 1G,
group 124 (‘+REDO’) size 1G,
group 125 (‘+REDO’) size 1G,
group 126 (‘+REDO’) size 1G;

alter database add standby logfile thread 3
group 131 (‘+REDO’) size 1G,
group 132 (‘+REDO’) size 1G,
group 133 (‘+REDO’) size 1G,
group 134 (‘+REDO’) size 1G,
group 135 (‘+REDO’) size 1G,
group 136 (‘+REDO’) size 1G;
[/code]

valid for standby database:
[code language=»sql»]
alter system set standby_file_management=auto;
[/code]

Оставьте комментарий

Ваш e-mail не будет опубликован. Обязательные поля помечены *

Этот сайт использует Akismet для борьбы со спамом. Узнайте как обрабатываются ваши данные комментариев.