" No archivelog mode" before running sgen.

[Former Member]

Hi People

I am new to sap. i want to run sgen tcode but before that i want to disable archiving log from BR tool.

Thanks

Romil

[Reagan · Accepted solution]

Hello

If you want to run SGEN after switching the database to No-Archive log mode using BRTools then do this:

su - orasid

brspace -c force -f dbalter -a noarchlog

exit

Regards

RB

[Former Member]

Thanks RB,

it did great help

one more help

what command to use for re-enable the same.

[Reagan]

Here it is

su - orasid

brspace -c force -f dbalter -a archlog

exit

Regards

RB

[Former Member]

Hi,

Usually if you have good backup infrastructure then you should run the archive logs backup while sgen is running . But then its an overhead as if the backup infrastructure cant keep up to the performance with the same rate archive logs are created then its an issue and the database will come to hold state.

So an easier term fix we usually turn off the archive log. But we need to be aware that if we dont have archive logs backup and the system crashes we will not be able to meet the point and time recovery.

To disable archive log backup.

shutdown

startup mount

alter database noarchivelog;

alter database open;

Thanks

Rishi abrol

[marcosmata]

Great, that's a recommendation from SAP.

In order to change to Archive Mode OFF you must set the database in MOUNT Mode.

Hope it helps..