DG: Resizing ORL and SRL on a standby

To resize redo logs on a standby

Use dgmgrl to halt the apply process on the standby:

edit database emdev13t set state='APPLY-ON';

Now connect on the standby and

ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=MANUAL;
<create or recreate ORL or SRL>
ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO

Advertisements