Solved

archivelogmode

Posted on 2014-04-04
5
163 Views
Last Modified: 2014-04-08
By default online redologs are recorded in flashback recovery area.

Then what is the purpose of setting database to archivelog mode.
0
Comment
Question by:tonydba
5 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
Comment Utility
As online redo logs fill up they are archived off in archive log mode.

This is necessary for point in time recovery.

If they are not archived off, the online redo logs are overwritten when it is their turn again.
0
 
LVL 23

Expert Comment

by:David
Comment Utility
Oracle has Concept material to help if you need this in-depth.  High level, data modification statements (DML) in Oracle are copied into a redo log.  When the statement is committed, the change is written into the physical datafile, and copied into one or more archive logs -- presuming the database instance is running in archivelog mode.

As slight points out, the redo mechanism is round-robin.  There is no long-term retention, except for the archive logs.

Also, by allowing multiple archivelog destinations, including to other hosts, Oracle provides redundancy.  Loss from a single backup medium is no longer catastrophic.
0
 
LVL 13

Expert Comment

by:Alexander Eßer [Alex140181]
Comment Utility
Loss from a single backup medium is no longer catastrophic.
As long as your Oracle DB runs with archivelog mode = on ;-)
This is/should be the default setting within productive environments. TEST, DEV and most other DB instances can be used without archivelog mode turned on.
At least this is how I/we used to work ;-)
0
 
LVL 23

Expert Comment

by:David
Comment Utility
Tony, we may have strayed from your question.  The "point" of archivelog mode is to enable the recovery of one's database to a system change event (SCN) or point in time. All data manipulation is recorded,  then replicated to provide multiple backups.  Archivelog mode is required for flashback.  Example, a user mistakenly drops a table.  With flashback enabled, the restoration of that table is quick and simple.

Many decision support / data warehouse systems, on the other hand, may not need to recover at will.  They might restore to a full backup point, then apply incremental changes -- or to re-run the extract/data/load (ETL) jobs that feed into the database.  It may be more practical to repeat a data import than to archive everything.

Does that help?
0
 

Author Closing Comment

by:tonydba
Comment Utility
Thank you...
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to take different types of Oracle backups using RMAN.

772 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

13 Experts available now in Live!

Get 1:1 Help Now