Solved

archivelogmode

Posted on 2014-04-04
5
167 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
ID: 39978199
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
ID: 39978299
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]
ID: 39978875
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
ID: 39979071
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
ID: 39986477
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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Queries 15 41
Oracle - Query link database loop 8 39
make null the repeated levels 2 25
Fill Null values 5 7
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

831 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