Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to
each.
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 |
Explain the difference between a hot backup and a cold backup and the benefits associated with each
Is it possible to drop a column in a table which contains only one column? How?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
Give two methods you could use to determine what DDL changes have been made.
What Are Cross Validation & Adi?
please explain about oracle
What is the mandatory setup in cyclecount ?
can we drop dual table
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
How would you go about increasing the buffer cache hit ratio?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is auto invoicing? : oracle accounts receivable