SAP - Systems Applications and Products in Data Processing

To Change Oracle database archive log mode

To check archive log mode of Oracle Database trigger the following command
in SQL Prompt.

SQL> select log_mode from v$database;

1) Turn Archive Log Mode ON:

Login to Database host
SQL> sqlplus "/as sysdba"
SQL> shutdown immediate
SQL> startup mount
SQL> alter database archivelog;
SQL> alter database open;

2) Turning OFF Archive Log Mode:

SQL> shutdown immediate
SQL> startup mount;
SQL> alter database noarchivelog;
SQL> alter database open;