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
- 24713 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
what is asm?
what is the role of dip user in our database?
how can you enable flashback feature?
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
Why does Oracle not permit the use of PCTUSED with indexes?
what do you understand by fine-grained auditing?
How would you extract DDL of a table without using a GUI tool?
Explain about your sql server dba experience? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
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?
what functionality does oracle provide to secure sensitive information?
What the different topologies in which replication can be configured? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
How do you open a cluster administrator? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
