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
- 24494 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / neha
in nonarchivelog mode the online redo log file are
overwritten each time a log switch occurs.LGWR does not
overwrite an online redo file group until the checkpoint
for that group is completed.ex-operating system crash
causes an instance crash.
| Is This Answer Correct ? | 12 Yes | 5 No |
Answer / pv bhaskar
Archivelog mode : We can recover the database at any point
in time.
No Archivelog mode : There is no Recovery Process.
Because Online Redologs are overwritten. so there is no
Archives in this mode.
If there is Media Failure(loss of Disks or files) in this
mode we can restore from a backup but we will loss all
changes made to the database,After the backup was performed.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / niraj chilka
In Archivelog mode we can perform both hot and cold
backup.In this mode we can restore+recover the data.There is
no need to worry about the losing the data.But all it comes
about the performance then we should place the redo log
files on faster disk to avoid performance loss.Try to put
archive on faster disk and also try to commit less.If you
write PL/SQL program that commits after every DML,then your
database will work slow.
In NON archivelog mode we cant recover the database when the
instance crash.Therefore upgrade database to 11g and there
are some has new feature called fast increment
backup.Because of this would loss some instance amount of
data.In non archivelog mode the performance of database is
high.
| Is This Answer Correct ? | 0 Yes | 1 No |
Give two examples of how you might determine the structure of the table DEPT.
How would you determine who has added a row to a table?
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
How can you enable a trace for a session?
How would you begin to troubleshoot an ORA-3113 error?
What are the recovery models for a database? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?
If we issue alter database begin backup. What happens to database?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How do you tell what your machine name is and what is its IP address?
hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
