Where should you place Archive logfiles, in the same disk where DB is or another disk ?

Questions by shanthiavari

Showing Answers 1 - 9 of 9 Answers

dbashashi

  • Jan 12th, 2009
 

It is recomended that Archivelog be placed at different location than the actual database location. Simple reason could be cited as in the event of Database crash due to any reason, you have the archive logs already.Later you can make the database if you have backup with the help of archivelog files.

dhs01

  • Apr 15th, 2009
 

In addition to the previously stated reason that if there is a disk problem, not having them on that disk is a good idea, another issue might be contention. Putting them on the same disk would keep them togethere for disk backup purposes but I would go with safety and performance over convience.  

poojap

  • Oct 6th, 2010
 

Yes, Archive log files should be on different disk because in case of database failure we can get  the data from the Archive logfiles.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions