Set Archive log mode

Set Archive log

SQL> select startup_time from  v$instance;

STARTUP_Time

---------

19-DEC-12

SQL> select dbid,name,log_mode,flashback_on from  v$database;

      DBID        NAME       LOG_MODE          FLASHBACK_ON

----------          ---------      ------------               ------------------

1272537938 ORCL        NOARCHIVELOG   NO

SQL>  archive log list;

Database log mode              No Archive Mode

Automatic archival             Disabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     6

Current log sequence           8

  

SQL>  alter system  switch logfile;

 System altered.

SQL>  archive log list;

Database log mode              No Archive Mode

Automatic archival             Disabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     8

Current log sequence           10

SQL> shut immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area  577511424 bytes

Fixed Size                  1338000 bytes

Variable Size             364905840 bytes

Database Buffers          205520896 bytes

Redo Buffers                5746688 bytes

Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> archive log list;

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     10

Next log sequence to archive   12

Current log sequence           12

SQL> alter database open;

Database altered.

SQL> select dbid,name,log_mode,flashback_on from  v$database;

      DBID         NAME                              LOG_MODE     FLASHBACK_ON

----------           ------------------------------ ------------          ------------------

1272537938  ORCL                                ARCHIVELOG   NO