redo archive

Posted on 2012-09-02
Medium Priority
Last Modified: 2012-09-19
what is the difference between redo log and archive log?

location of redo log?
location of archive log?
Question by:tomvv
  • 2
LVL 74

Assisted Solution

sdstuber earned 1000 total points
ID: 38359937
they are the same thing, except the online redo logs are "active" and archive logs are not

when your database is in archive log mode and your online redo logs fill up, the oldest one is copied and the online file is cleared to be reused.  That copy is your archive log.

when your data is not in archive log mode, the copy doesn't happen, the old logs simply get cleared.  This is why databases that are not in archive log mode can not be reliably restored.

to see your online redo logs...

select * from v$logfile

to see where the archives are generated...

select * from v$parameter where name like 'log_archive_dest%'
LVL 78

Accepted Solution

slightwv (䄆 Netminder) earned 1000 total points
ID: 38363386
In addition to the explaination above, the online docs are normally your best resource for things like this:

What Is the Redo Log?

What Is the Archived Redo Log?

Overview of the Online Redo Log

Archived Redo Log Files
LVL 74

Expert Comment

ID: 38411114
isn't a split in order?

Author Closing Comment

ID: 38415851

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

850 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