Database

1. how to set oracle archive parameter to off ?


Oracle 10g


 In order to put database in noarchive log mode, first stop your sap system.
login as ora<sid>

shell> sqlplus "/ as sysdba"
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database noarchivelog;
SQL> alter database open;

You can also verify that whether your databse is in archive log mode or noarchive log mode by below command:

SQL> select log_mode from v$database;

LOG_MODE
------------
NOARCHIVELOG