How to Turn On Archivelog Mode in Oracle11g－DanBrother的部落格

The following SQL statements demonstrates how to turn on Archivelog Mode in Oracle11g:

SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     298
Current log sequence           300

SQL> sho parameter log_archive_dest_1

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1                   string
log_archive_dest_10                  string
log_archive_dest_11                  string
log_archive_dest_12                  string
log_archive_dest_13                  string
log_archive_dest_14                  string
log_archive_dest_15                  string

alter system set log_archive_dest_1='LOCATION=/home/oracle/archivelog/mydb' scope=both;

SQL> sho parameter log_archive_dest_1

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------------
log_archive_dest_1 string LOCATION=/home/oracle/archivelog/mydb

SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount
ORACLE instance started.

Total System Global Area 2505338880 bytes
Fixed Size                  2215944 bytes
Variable Size            1325404152 bytes
Database Buffers         1157627904 bytes
Redo Buffers               20090880 bytes
Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /home/oracle/archivelog/mydb
Oldest online log sequence     298
Next log sequence to archive   300
Current log sequence           300

SQl> alter system switch logfile;