Solved

difference

Posted on 2014-11-24
3
89 Views
Last Modified: 2014-12-03
What is the major difference between redolog and archivelog.
0
Comment
Question by:jeevan mathew
3 Comments
 
LVL 73

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

920 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now