SGEN & database archive log mode

[Former Member]

Hi Experts,

To apply ABAP support packs, I disabled archive log mode of databse and successfully applied support packs.

As post processing, I kicked off SGEN.

Is it required that database be in "NO Archive log mode" while SGEN is running or can I enable it.

Thanks

Putla

[Former Member]

Not sure what database it is.. but if it is ORACLE...

$sqlplus / as sysdba

SQL> shutdown immediate;

SQL> startup mount;

SQL> Alter database noarchivelog;

SQL> alter database open;

After the completion of SGEN.....

$sqlplus / as sysdba

SQL> shutdown immediate;

SQL> alter database mount;

SQL> alter database archivelog;

SQL> alter database open;

[Former Member]

Hello Sudha,

You can turn of Archive Log using SAPDBA or BRTOOLS.

Both SAPDBA and BRTOOLS provide you with options to turn off archiving.

Which will turnoff the logging. Then you need to restart the instace.

Continue with SGEN. Once SGEN is completed then turn on Archive restart the instance.

Thanks & Regards

Vivek

[Former Member]

You can turn it on but it will create log of archive logs though .. Monitor the archive directory closely .. Are you doing it on Prod system with archiving disabled !!

Thanks

Prince Jose

[Former Member]

Hi,

This is in Production. Backups are taken out of schedule. The SGEN is running over 10 hours now.

Thanks

[Former Member]

Its not good idea to run Production system with archiving turned off ....

Thanks

Prince Jose

[Former Member]

can we apply both ABAP and JAVA support packs simultaneously? i..e run both SPAM from ABAP and JSPM?

Thanks

[Former Member]

Its not recommended. Usually, applying Java Support Pack Stack takes lot of memory consumption, which may affect the processing of your abap support packages. You need to do that seperately. Best advisable is, first do your abap support pack and then your java.

Thanks and Regards,

Sailesh K