Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to each.
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 is the default port no on which sql server listens? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
how can a session indicate its interest in receiving alerts?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
what is the role of dip user in our database?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
what are the types of connection load-balancing?
How to start SQL Server in minimal configuration mode?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What is transparent data encryption? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
how can you initialize log miner?