Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to each.
- 5 Answers
- 22396 Views
- I also Faced
- E-Mail Answers
Answer Posted / basobdutta
Archivelog mode - In archivelog mode cold and hot backups
are possible. We can recover our database upto the last
point of failure.
Noarchivelog mode- Here we can only go for cold
backup.Generally in this mode complete recovery is not
possible
| Is This Answer Correct ? | 17 Yes | 3 No |
Post New Answer View All Answers
what is the role of dip user in our database?
what is logical system in sap basis
what are the differences of where and if in SAS?
Where do you find the default index fill factor and how to change it? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
what are the benefits of flashback feature?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
What is the difference between clustered and non-clustered index? : sql server DBA
how to restore files with rman?
how can you enable flashback feature?
how can you connect from 10g user to 11g user??
What are the steps you will take to improve performance of a poor performing query?
what do you understand by flashback feature of oracle?
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?
