Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the b

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

Question Posted / guest

1 Answers
8179 Views
HCL, I also Faced
E-Mail Answers

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvan..

Answer / 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

More Oracle AllOther Interview Questions

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

0 Answers jusco,

A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?

7 Answers TCS,

Explain materialized views and how they are used.

2 Answers

the user should know to which database he is connected currently in oracle

3 Answers

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

0 Answers Pathway Technologies,

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers

Compare and contrast TRUNCATE and DELETE for a table.

3 Answers

Describe the P2P cycle ?