Brtools for Resizing Redo logs

[Former Member]

Hi All,

We wanted to incresase the size of Redo log size in our oracle DB using BRTOOLS utility. As this is a windows server on Cluster we cannot bring DB to mount mode very easily as we need to move DB out of cluster to do such activities.

We decided to use Brtools for the same.

The process which we are planning is:

1. Complete Backup of system.

2. Bring Db to No archive Mode

3. Execute Command - brspace -f moredo -a resize -f all_rf -s 200

Will above command safe for PRD landscape and will increase size of all redo log file available in different drives?

4. Bring DB to Archivelog mode.

5. DB backup again.

Is the process enough for increasing the size of redo log or need to do any other activity.

Need your advice.

Thanks,

Rableen

[Former Member · Accepted solution]

As per below note you should be able to perform this activity online..

1259767 - Management of online redo log files using BRSPACE

[Former Member · Accepted solution]

Hi Sunil,

We have already gone through this SAP  note and not sure if it has to be done in archivelog or noarchive log mode.

1647272 - Note says to bring DB to NOARCHIVE log mode.

Thanks.

Rableen

[Former Member · Accepted solution]

i think you are confused, the note 1647272 you mentioned is that From Patch 27 of BRSPACE 7.20 you can also re-size the log size even DB is in NOARCHIVE mode.

[Former Member]

HI,

Refer to the following links.

http://scn.sap.com/thread/1518679

Also sap note 309526 - Enlarging redo log files has more details.

Managing the Redo Log

Kind Regards,

Johan

[former_member375763]

Hello Experts,

I am trying to resize Redo Log File Size from standard 50 MB to 100 MB by using BrTools, while the SAP System is online.

I need assistance with the procedure.

Regards

Umar

[former_member207186]

Hi Umar,

Please also refer to SAP KBA 1961509 - "How to manually modify size of ONLINE redo log files".

At the bottom of the KBA you can also find the BR*Tools procedure.

Regards,
Bíborka