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
- 24503 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 new features in sql server 2005 when compared to sql server 2000? : 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 commands used in dcl? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
Why would you use sql agent? : sql server DBA
What are the recovery models for a database? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
what is a user-defined lock?
How can you control the amount of free space in your index pages? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
who owns the operating system files created by the utl_file package?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
How do you trace the traffic hitting a sql server? : sql server DBA
