Enable Archive Log Mode

SQL> conn sys/sy123@safi as sysdba

Connected.


SQL> create pfile from spfile;

File created.


SQL> alter system set log_archive_dest='/ora/archive1/' scope=spfile;

System altered.
　


SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.



SQL> startup mount

ORACLE instance started.

Total System Global Area 352321536 bytes

Fixed Size 2040600 bytes

Variable Size 234888424 bytes

Database Buffers 109051904 bytes

Redo Buffers 6340608 bytes

Database mounted.



SQL> alter database archivelog;

Database altered.



SQL> alter database open;

Database altered.


SQL> alter system switch logfile;

System altered.


SQL> select name, log_mode from v$database;

NAME      LOG_MODE
--------- ------------
SAFI      ARCHIVELOG