Search This Blog

Sunday, September 9, 2007

How to Enable ARCHIVELOG mode

My Signature Article


Oracle Certification - Tips

DBA Preparation - Tips

Practical DBA - Tips

Benefits of ARCHIVELOG mode.

1. We can able to take database backup ONLINE.
2. No Need to Down Oracle DB Server
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

How can enable ARCHIVELOG MODE in 9iR1.

When we create new database then database is created NOARCHIVELOG mode by default.

shutdown database

SQL>shutdown immediate;

Edit below parameters in pfile(init.ora) file.


Create New SPFILE from Modified pfile(init.ora)

SQL> create SPFILE from PFILE;

Startup Database in Mount Mode

SQL> startup mount;

Change Database log mode from NOARCHIVELOG to ARCHIVELOG

SQL> alter database archivelog;

Open DB for normal use

SQL> alter database open;

check archive log status

Database log mode Archive Mode
Automatic archival Enabled
Archive destination C:\Oracle\product\RDBMS
Oldest online log sequence 0
Next log sequence to archive 1
Current log sequence 1

Default Archivelog destination is :$ORACLE_HOME/rdbms.

How can enable ARCHIVELOG MODE in 10gr1

In 10g Archivelog mode enabling is easy becuase we need to just turn DB log mode and archive log is automatic start.

shutdown database

SQL> shutdown immediate;

startup database in mount mode

SQL> startup mount;

Change DB log mode

SQL> alter database archivelog;

Open DB for normal use

SQL> alter database open;

check archivelog status

SQL> archive log list

Default Archive log destination.

1. 10g introduce new feature called FRA (flashback recovery area) so all archivelog files created in FRA.

2. If your not using FRA then all files created in $ORACLE_HOME/database

We can check database archivelog mode through below query

SQL> select log_mode from v$database;
SQL> archive log list


Prasanthi said...


In oracle 10g whicle changing from noarchivelog mode to archivelog mode, from where does it read the archive_log_dest to store the archived files? Should this be included in the init.ora file? Pls help with the whole procedure.


Ahmd Faizal said...

how to esteemate FRA size?..

Anonymous said...

Top blog, I hadn't noticed before during my searches!
Keep up the fantastic work!

Anonymous said...


Thanks for sharing the link - but unfortunately it seems to be down? Does anybody here at have a mirror or another source?


Anonymous said...


I have a inquiry for the webmaster/admin here at

Can I use part of the information from this post right above if I provide a link back to your website?


Anonymous said...


This is a inquiry for the webmaster/admin here at

Can I use some of the information from your post right above if I provide a backlink back to this site?


Anonymous said...

Hi - I am really glad to discover this. Good job!

Anonymous said...

Hey - I am definitely glad to find this. great job!

Anonymous said...

what I was looking for, thanks

Anonymous said...

Good day! I know this is kind of off topic but I was wondering if you knew where I could get a captcha plugin for my comment form? I'm using the same blog platform as yours and I'm having difficulty finding one? Thanks a lot!