Solved

difference

Posted on 2014-11-24
3
92 Views
Last Modified: 2014-12-03
What is the major difference between redolog and archivelog.
0
Comment
Question by:jeevan mathew
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 500 total points
ID: 40463068
simple definition: archivelogs are redologs that have been saved.

more verbose:
If your database is not running in archive log mode, then you will not generate archive logs, but you will still have online redo logs.

If your databse is running in archive log mode and you fill your redo logs, then, when your database needs to reuse one of the online logs it will copy the old redo file to an archive log file and then reuse the online file for new transaction records.


to further elaborate, I recommend the Concepts manual

https://docs.oracle.com/cd/E11882_01/server.112/e40540/physical.htm#CNCPT11302
0
 
LVL 23

Expert Comment

by:David
ID: 40463089
Oracle uses a two-stage write-to-database.  Changed rows are written into a redo log, and periodically a log segment is written to the physical storage (datafile).  Assuming the database is running in archive log mode, the saved redo log is copied to an archive log, after which the redo log may be re-used.  

Copies of an archive log may be written concurrently to one or more directories, on multiple hosts, for redundancy.
0
 

Author Closing Comment

by:jeevan mathew
ID: 40478926
Got it the difference.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question