1. Categories >> Software >> Databases >> Oracle >> Oracle AllOther
  2. Suggest New Category

Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to
each.

Question Posted / vivek tiwari

Answer Posted / vivek tiwari

Noarchivelog Mode
By default, a database is created in Noarchivelog mode. The
characteristics of operating a
database in Noarchivelog mode are as follows:
• Redo log files are used in a circular fashion.
• A redo log file can be reused immediately after a
checkpoint has taken place.
• After redo logs are overwritten, media recovery is only
possible to the last full backup.
Archivelog Mode
A filled redo log file cannot be reused until a checkpoint
has taken place and the redo log file
has been backed up by the ARCn background process. An entry
in the control file records the
log sequence number of the archived log file.
The most recent changes to the database are available at
any time for instance recovery, and
the archived redo log files can be used for media recovery.

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an Oracle database Partial Backup?

693

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

645

What is the difference between oracle media recovery and crash recovery?

671

What is the difference between recovery and restoring of the oracle database?

659

What is the disk migration? what is the steps involved in oracle disk migration?

717




as a technical developer in oracle applications which type errors feced in your experience sofar

1769

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

641

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

1585

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

685

Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

668

Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

7439

What is Restricted Mode of Instance Startup in Oracle?

673

What is supporting issues GL AP and AR?

1984

can we use lexical perameter in oracle plsql if yes how

1824

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

2829