Oracle Database - Mode Archive Log / Archiving

Card Puncher Data Processing

About

Oracle Database lets you save filled groups of Oracle Database - Redo Log (Transaction Log Files) files to one or more offline destinations, known collectively as the archived Oracle Database - Redo Log (Transaction Log Files), 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.

You can use archived redo logs to:

  • Recover a database
  • Get information about the history of a database using the LogMiner utility

A database is CREATED in noarchivelog to avoid the generation of tons of archives from the create itself.

Article

Development/ production environment

In development, our bulk inserts work very fast and generate very little redo. When we move into production, our Oracle Database - Direct (path insert|load) (/*+ APPEND */) statements work much slower and generate many gigabytes of Oracle Database - Redo Log (Transaction Log Files), filling up our Oracle Database - Mode Archive Log / Archiving destination. What's going wrong ?

It is not that anything is going wrong. It is that many people run the development and test machines in Oracle Database - NOARCHIVELOG mode and production in Oracle Database - ARCHIVELOG mode.

Reference





Discover More
Card Puncher Data Processing
Oracle Database - ARCHIVELOG

Oracle Database lets you save filled groups of files to one or more offline destinations, known collectively as the archived , or more simply the . The process of turning redo log files into archived...
Card Puncher Data Processing
Oracle Database - ASM (Automatic Storage Management)

Starting with Oracle Database 10g (10.1.0.3 or later), Automatic Storage Management is a high-performance storage management solution. For Oracle Database files, it simplifies the management of a dynamic...
Install 10g 8 End Of Installation
Oracle Database - Installation Oracle Database 10gR2 on Windows

Installation of the database software Installation of the software patch Configuration of the listener Creation of a database instance Download the installation file : Oracle...
Card Puncher Data Processing
Oracle Database - Internal Locks

Internal locks are higher-level, more complex mechanisms than latches and mutexes and serve various purposes. The database uses the following types of internal locks: These locks are of very short...
Card Puncher Data Processing
Oracle Database - Mode Archive Log / Archiving

Oracle Database lets you save filled groups of files to one or more offline destinations, known collectively as the archived , or more simply thearchive log. The process of turning redo log files into...
Card Puncher Data Processing
Oracle Database - NOLOGGING

A table of a statement marked as NOLOGGING will bypass the generation. direct path insert The operation will not be logged and then you prevent the redo log to be generated. It's not in the...



Share this page:
Follow us:
Task Runner