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
- 24488 Views
- I also Faced
- E-Mail Answers
Answer Posted / sampath
archivelog mode:
archivelog mode means that online redlogfile
copied to another location before overwritten.mainly it use
for recover purpose.
noarchivelog mode:
noarchive logmode means online redlogfile
not copied to another location each time overwritten by lgwr.
| Is This Answer Correct ? | 42 Yes | 1 No |
Post New Answer View All Answers
what are the benefits of flashback feature?
what do you understand by fine-grained auditing?
what is logical system in sap basis
how can you process messages in order asynchronously?
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
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What are the different types of indexes available in sql server? : sql server DBA
what is grd?
What authentication modes does sql server support? : sql server DBA
what is the use of ocr?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What is the difference between clustered and non-clustered index? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
