Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to each.
- 5 Answers
- 22827 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
how can you communicate with operating system files from oracle?
What would you do with an "in-doubt" distributed transaction?
Where do you find the default index fill factor and how to change it? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
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
how can you enable flashback feature?
what is grd?
what functionality does oracle provide to secure sensitive information?
what is the role of dip user in our database?
What are the operating modes in which database mirroring runs? : sql server DBA
what are the types of connection load-balancing?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
