• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 578
  • Last Modified:

redo archive

what is the difference between redo log and archive log?


location of redo log?
location of archive log?
0
tomvv
Asked:
tomvv
  • 2
2 Solutions
 
sdstuberCommented:
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%'
0
 
slightwv (䄆 Netminder) Commented:
In addition to the explaination above, the online docs are normally your best resource for things like this:

What Is the Redo Log?
http://docs.oracle.com/cd/E11882_01/server.112/e25494/onlineredo001.htm#i1006163

What Is the Archived Redo Log?
http://docs.oracle.com/cd/E11882_01/server.112/e25494/archredo001.htm#i1006148

Overview of the Online Redo Log
http://docs.oracle.com/cd/E11882_01/server.112/e25789/physical.htm#CNCPT11302

Archived Redo Log Files
http://docs.oracle.com/cd/E11882_01/server.112/e25789/physical.htm#autoId20
0
 
sdstuberCommented:
isn't a split in order?
0
 
tomvvAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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