Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to each.
- 5 Answers
- 22395 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
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
how to restore files with rman?
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 you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
What the different types of replication and why are they used? : sql server DBA
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?
What are the different types of indexes available in sql server? : sql server DBA
Why would you use sql agent? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What is transparent data encryption? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
when does an alert gets signaled?
