Search This Blog

Loading...

Sunday, September 9, 2007

How to Enable ARCHIVELOG mode


My Signature Article


Tips:

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.


1. LOG_ARCHIVE_START=TRUE


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;
or
SQL> archive log list

10 comments:

Prasanthi said...

Hi,

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.

Thanks,
BN

Ahmd Faizal said...

how to esteemate FRA size?..

Anonymous said...

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

Anonymous said...

Greetings,

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


Cheers,
John

Anonymous said...

Hi,

I have a inquiry for the webmaster/admin here at dbataj.blogspot.com.

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

Thanks,
Mark

Anonymous said...

Hello,

This is a inquiry for the webmaster/admin here at dbataj.blogspot.com.

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

Thanks,
James

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!