Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to each.
- 5 Answers
- 22834 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what functionality does oracle provide to secure sensitive information?
Why would you use sql agent? : sql server DBA
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?
how does an oracle clusterware manage crs resources?
How to start SQL Server in minimal configuration mode?
internal architecture
How do you trace the traffic hitting a sql server? : sql server DBA
what is a user-defined lock?
What the different topologies in which replication can be configured? : sql server DBA
how can you implement fine-grained auditing?
What is a system database and what is a user database? : sql server DBA
what are the differences of where and if in SAS?
What is dbcc? : sql server DBA
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.
What are the commands used in dcl? : sql server DBA
