Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to each.
- 5 Answers
- 22835 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
which background process invoke at the time of upgradation tell me???
what is the use of recording information about current session?
what do you understand by flashback feature of oracle?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
what is ora 24313?what is the procedure to exclude that error?
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 initialize log miner?
How would you go about verifying the network name that the local_listener is currently using?
What types of replication are supported in sql server? : sql server DBA
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
What are the recovery models for a database? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
how can you communicate with operating system files from oracle?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
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?
