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
- 24450 Views
- I also Faced
- E-Mail Answers
Answer Posted / pv bhaskar
Archivelog mode : We can recover the database at any point
in time.
No Archivelog mode : There is no Recovery Process.
Because Online Redologs are overwritten. so there is no
Archives in this mode.
If there is Media Failure(loss of Disks or files) in this
mode we can restore from a backup but we will loss all
changes made to the database,After the backup was performed.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
which background process invoke at the time of upgradation tell me???
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What are the operating modes in which database mirroring runs? : sql server DBA
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.
what do you understand by flashback feature of oracle?
Why would you call update statistics? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
What is replication? : sql server DBA
What purpose does the model database server? : sql server DBA
internal architecture
What are the recovery models for a database? : sql server DBA
Query processing is slow(eg select query)how will u solve that
How would you best determine why your MVIEW couldn't FAST REFRESH?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
