what are the advantages of running a database in NO archive
log mode?

Answer Posted / manjeet kumar

NOARCHIVELOG mode protects a database from instance
failure. However it does not protect from media failue.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many types of tables supported by oracle?

578


How do you bind variables in oracle?

548


What is archive log in Oracle?

600


What is an external table?

588


What is transaction control statement and how many types of transaction control statement in Oracle?

565






How to pass parameters to procedures in oracle?

570


What privilege is needed for a user to insert rows to tables in another schema?

562


Is the After report trigger fired if the report execution fails ?

2404


Is rowid unique in oracle?

530


How to convert characters to numbers in oracle?

596


What is the difference between sharding and replication?

479


How many file formats are supported to export data?

659


How to define a variable to match a table column data type?

580


Where are the settings stored for each instance in oracle?

625


How would you go about verifying the network name that the local_listener is currently using?

1607