STEP FOR ORACLE DATABASE IN ARCHIVE LOG MODE

SQL> startup mount
ORACLE instance started.

Total System Global Area  608174080 bytes
Fixed Size                  1220844 bytes
Variable Size             167776020 bytes
Database Buffers          436207616 bytes
Redo Buffers                2969600 bytes
Database mounted.
SQL>
SQL>
SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL>
SQL> select log_mode from v$database;

LOG_MODE
------------
ARCHIVELOG

SQL>



ARCHIVE LOG MULTIPLEXING
IN ORACLE 10g PROVIDE 10 DIFFERENT DESTINATION TO KEEP YOUR ARCHIVE LOG 

SQL>alter system set log_archive_dest_1='LOCATION=/oracle/archive';

for remove location
SQL>alter system set log_archive_dest_1='';

SQL>alter system archive log current;

v$archived_log



 

///DISABLE ARCHIVE LOG MODE

SQL> connect sys/chaya as sysdba
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database noarchivelog;

SQL> alter database open;