Tuesday, February 26, 2013

Enable archivelog mode in Oracle 11g database


First lets check the current log mode:

SQL> archive log list

Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 67
Current log sequence 69
  or   SQL> select name, log_mode from v$database;
NAME LOG_MODE
--------- ------------
DEV NOARCHIVELOG

SQL> alter system set log_archive_start=TRUE scope=spfile;
SQL> alter system set log_archive_dest_1='location=/home/oracle/archivelog' scope=spfile;

SQL> shutdown immediate
SQL> startup mount;
SQL> alter database archivelog;
SQL> alter database open;

SQL> select name, log_mode from v$database;

NAME LOG_MODE
--------- ------------
DEV ARCHIVELOG

SQL> alter system switch logfile;

2 comments:

Anonymous said...

Thanks very nice blog!

My site; voyance

Anonymous said...

It is appropriate time to make a few plans for the long run and it's time to be happy. I've read this
publish and if I may just I desire to suggest
you some interesting issues or advice. Perhaps you can write next articles relating to this article.
I desire to read even more things approximately it!


my homepage voyance gratuite