Oracle 11g ARCHIVELOG mode overview and Configuration

Benefits  of ARCHIVELOG mode.

1. We can able to take database backup ONLINE.
2. No Need to Down Oracle DB

3. We can better manage our Backup Policy through RMAN
4. Limited DBA task
5. We can able to RECOVER our database point-in-time

Default oracle database running NOARCHIVELOG mode

Oracle Database enable Archive log mode 

SQL> shutdown immediate;

SQL> startup mount;

SQL> alter database archivelog;

SQL> alter database open;

Check archive log mode
Command1 

SQL> archive log list

Output

LOG_MODE

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

ARCHIVELOG

Command 2 

SQL> archive log list

Output

Database log mode            Archive Mode

Automatic archival             Enabled

Archive destination            /u01/finsys/db/tech_st/archivelog

Oldest online log sequence     16

Next log sequence to archive   17

Current log sequence           17

Command 3

SQL>select log_mode from v$database;

LOG_MODE

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

ARCHIVELOG

Switch archive logs


SQL> alter system switch logfile;

SQL> alter system switch logfile; 

SQL>alter system archive log current;

Change archive log destination location 

SQL> shutdown immediate

SQL>startup mount

Run following syntax

SQL>alter system set log_archive_dest_1='LOCATION=/…………/;

Ex:-

SQL>alter system set log_archive_dest_1='location=/u01/finsys/db/tech_st/flash_recovery_area/PROD/archivelog’;

SQL>alter system set log_archive_dest_1='location=/u01/app/oracle/flash_recovery_area/DB11G/archivelog’;

SQL>alter database open;

SQL> alter system archive log current;