Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 96
  • Last Modified:

difference

What is the major difference between redolog and archivelog.
0
jeevan mathew
Asked:
jeevan mathew
1 Solution
 
sdstuberCommented:
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
 
DavidSenior Oracle Database AdministratorCommented:
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
 
jeevan mathewAuthor Commented:
Got it the difference.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now