cancel
Showing results for 
Search instead for 
Did you mean: 

" No archivelog mode" before running sgen.

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Reagan
Advisor
Advisor
0 Kudos

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

Answers (3)

Answers (3)

Former Member
0 Kudos

Thanks RB,

it did great help

one more help

what command to use for re-enable the same.

Reagan
Advisor
Advisor
0 Kudos

Here it is

su - orasid

brspace -c force -f dbalter -a archlog

exit

Regards

RB

Former Member
0 Kudos

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
Participant
0 Kudos

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..