Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to each.
- 5 Answers
- 24704 Views
- I also Faced
- E-Mail Answers
Answer Posted / niraj chilka
In Archivelog mode we can perform both hot and cold
backup.In this mode we can restore+recover the data.There is
no need to worry about the losing the data.But all it comes
about the performance then we should place the redo log
files on faster disk to avoid performance loss.Try to put
archive on faster disk and also try to commit less.If you
write PL/SQL program that commits after every DML,then your
database will work slow.
In NON archivelog mode we cant recover the database when the
instance crash.Therefore upgrade database to 11g and there
are some has new feature called fast increment
backup.Because of this would loss some instance amount of
data.In non archivelog mode the performance of database is
high.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
what are the differences of where and if in SAS?
How would you extract DDL of a table without using a GUI tool?
Which autogrowth database setting is good? : sql server DBA
Where would you look for errors from the database engine?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What is transparent data encryption? : sql server DBA
how can you initialize log miner?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
what is the use of ocr?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
how can you record information about current session?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
