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
- 24474 Views
- I also Faced
- E-Mail Answers
Answer Posted / neha
in nonarchivelog mode the online redo log file are
overwritten each time a log switch occurs.LGWR does not
overwrite an online redo file group until the checkpoint
for that group is completed.ex-operating system crash
causes an instance crash.
| Is This Answer Correct ? | 12 Yes | 5 No |
Post New Answer View All Answers
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the commands used in dcl? : sql server DBA
how can you record information about current session?
how can you communicate with operating system files from oracle?
What is dcl? : sql server DBA
Why would you call update statistics? : sql server DBA
What is fill factor? : sql server DBA
what do you understand by flashback feature of oracle?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
how can you enable flashback feature?
who owns the operating system files created by the utl_file package?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
what are the differences of where and if in SAS?
What is the default fill factor value? : sql server DBA
