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
- 24452 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
Why does Oracle not permit the use of PCTUSED with indexes?
What is a correlated sub-query? : sql server DBA
what is logical system in sap basis
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
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
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 difference between the 2 operating modes of database mirroring? : sql server DBA
What are the commands used in dcl? : sql server DBA
what are the differences of where and if in SAS?
What are the recovery models for a database? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
How would you extract DDL of a table without using a GUI tool?
What the different types of replication and why are they used? : sql server DBA
