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
- 24493 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
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
how can a session indicate its interest in receiving alerts?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Why would you call update statistics? : sql server DBA
Where would you look for errors from the database engine?
how can you implement fine-grained auditing?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
when does an alert gets signaled?
What are statistics, under what circumstances they go out of date, how do you update them?
What is a system database and what is a user database? : sql server DBA
what are the performance views in an oracle rac environment?
what are the benefits of flashback feature?
What authentication modes does sql server support? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
