1 Answer - Sort by: Date | Rating
Oracle Database lets you save filled groups of redo log files to one or more offline
destinations, known collectively as the archived redo log, or more simply the archive
log. The process of turning redo log files into archived redo log files is called
archiving. This process is only possible if the database is running in ARCHIVELOG
mode. You can choose automatic or manual archiving.
An archived redo log file is a copy of one of the filled members of a redo log group. It
includes the redo entries and the unique log sequence number of the identical member
of the redo log group. For example, if you are multiplexing your redo log, and if group
1 contains identical member files a_log1 and b_log1, then the archiver process
(ARCn) will archive one of these member files. Should a_log1 become corrupted,
then ARCn can still archive the identical b_log1. The archived redo log contains a
copy of every group created since you enabled archiving.
When the database is running in ARCHIVELOG mode, the log writer process (LGWR)
cannot reuse and hence overwrite a redo log group until it has been archived. The
background process ARCn automates archiving operations when automatic archiving is enabled. The database starts multiple archive processes as needed to ensure that the
archiving of filled redo logs does not fall behind.
destinations, known collectively as the archived redo log, or more simply the archive
log. The process of turning redo log files into archived redo log files is called
archiving. This process is only possible if the database is running in ARCHIVELOG
mode. You can choose automatic or manual archiving.
An archived redo log file is a copy of one of the filled members of a redo log group. It
includes the redo entries and the unique log sequence number of the identical member
of the redo log group. For example, if you are multiplexing your redo log, and if group
1 contains identical member files a_log1 and b_log1, then the archiver process
(ARCn) will archive one of these member files. Should a_log1 become corrupted,
then ARCn can still archive the identical b_log1. The archived redo log contains a
copy of every group created since you enabled archiving.
When the database is running in ARCHIVELOG mode, the log writer process (LGWR)
cannot reuse and hence overwrite a redo log group until it has been archived. The
background process ARCn automates archiving operations when automatic archiving is enabled. The database starts multiple archive processes as needed to ensure that the
archiving of filled redo logs does not fall behind.
0
0
- What's Mean By Redo Log?
- How Oracle Database Writes To The Redo Log?
- What Is Written In Redo Log Files In Oracle?
- I'm Looking For Log-log Paper Or Quad Log Paper With 8 Cycles Per Axis, Can You Help?
- Why Isnt Log(ab)=log(a)*log(b) A True Statement?
- Is Log (ab)=log(a)*log(b) A True Statement?
- Is Log(ab)=log(a)*log(b) A True Statement?
- What Is The Correct Formula For Log(ab) =log(a)*log(b) Or Log(a) + Log(b)?
- Is Log(ab)=log(a)*log(b) Is A True Statement?
- What Is Oracle 9i?
- How To Minimize The Load On Pc During Startup When Oracle 10g Is Installed In It?
- Enter A How Do You Control Number Of Datafiles One Can Have In An Oracle Database?Question Or Search…
- How Can I Connect Vb6 With Oracle 10g?
- Hi What's The Main Difference Between Oracle 10g & 11i?
- Which Types Of Backups You Can Take In Oracle?
- How We Uninstall Oracle?
- How To Increase Sga Size Dynamically In Oracle 10g?
- Pls Advice Good Oracle DBA Course Centres In Bangalore With Good Trainer And Less Fees?
- What Are The Ways Of Connecting To The Net?
- What Is Online Redo Log Files?
- What Is The Diff Between Oracle 8i,9i,10g From Developer Point Of View?
- Difference Between Looping Statements In C And Oracle?
- Which Is The Best Institute For Oracle In Chennai?
- How Can I Connect Vb With Oracle Through Properties Connectivity And Coding Both?
- Through Properties Connectivity How We Connect Vb With Oracle?
- What Is A Redo Logfile?
- Is Oracle Course Iis Necessary For To Get A Better Job?
- How Can I Connect Oracle Database From VB6 Code Using ADO DB Connection?
- Who Or What Is The Oracle At Delphi And Why Do The The Bans Hope This Oracle Can Help Them?
- How Do I Move A Database From My Pc To The Server?
- Which King Consulted The God Through The Use Of Oracle Bones?
- What Is Mean By Citect Scada Cluster?
- How To Find The Setup Of Oracle 9i?
- How Can You Upgrade Your Apps If You Don't Have The Money?

New Comment - Comments are editable for 5 min.