Deactivate Archive mode

[Former Member]

Hello!

How to deactivate archive mode of Oracle with SQL-commandos?

I use SAP Solution Manager and do not need archive mode.

Thank you very much!

Thom

[Former Member · Accepted solution]

Hi

sqlplus /nolog

conn /as sysdba;

startup mount ; or if the db is started

alter database nomount; or

alter database noarchivelog;

alter database open;

Regards

[Former Member]

hi,

login with <sid>adm.go to below directory

<Install drive>:\usr\sap\S11\SYS\exe\uc\NTI386

there is 3 BATCH files like

ARCHIVE_OFF.BAT

ARCHIVE_ON.BAT

ARCHIVE_TST.BAT

you want archive off click on then click on ARCHIVE_OFF.BAT.

regards

ajai

[Former Member]

Thom,

The one suggested by Manas should also work. If incase it doesnot then you can try this,

Although I havenot done this. Here is the process,

1.Shut the database

2.Backup the database(to be safe)

3.Modify/Include LOG_ARCHIVE_START=FALSE in init<SID>.ora(Please clarify from a dba whether to modify directly in initSID.ora or to modify in spfileof initSID.ora which exist in the same directory as initSID.ora and then generate a new initSID.ora).

OR

you can change this paramter directly in initSID.ora and check if it is working or not. If it doesnot work that means you will have to change it in spfile.

4.Start up the database.

[former_member193294]

@ Bidwan:

I do not think that it is recommended to touch the spfile at all. Normaly Upon startup, the instance first searches for the server parameter file named spfile$ORACLE_SID.ora, and if not found, searches for spfile.ora.

If neither server parameter file is found, the instance searches for the

text initialization parameter file init$ORACLE_SID.ora.

To correct you a bit, you export the spfile to pfile, make the change in a text editor and then import pfile to spfile back and startup DB

Here are the steps:

$ sqlplus /nolog

SQL> CONNECT / AS SYSDBA

SQL> CREATE PFILE='/home/oracle/dev10ee-params.txt'

2 FROM SPFILE;

SQL> SHUTDOWN IMMEDIATE

Now convert the pfile that you edited back into an spfile that Oracle can use with the following commands:

$ sqlplus /nolog

SQL> CONNECT / AS SYSDBA

SQL> CREATE SPFILE='$ORACLE_BASE/admin/$ORACLE_SID/pfile/spfile$ORACLE_SID.ora'

2 FROM PFILE='/home/oracle/dev10ee-params.txt';

Rgds,

Loukas