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
- 24198 Views
- I also Faced
- E-Mail Answers
Answer Posted / sampath
archivelog mode:
archivelog mode means that online redlogfile
copied to another location before overwritten.mainly it use
for recover purpose.
noarchivelog mode:
noarchive logmode means online redlogfile
not copied to another location each time overwritten by lgwr.
| Is This Answer Correct ? | 42 Yes | 1 No |
Post New Answer View All Answers
how can a session indicate its interest in receiving alerts?
What is dcl? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
how can you schedule a job in database?
how can you process messages in order asynchronously?
what do you understand by flashback feature of oracle?
What are statistics, under what circumstances they go out of date, how do you update them?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is a user-defined lock?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What is a system database and what is a user database? : sql server DBA
internal architecture
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
