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

What is a initialization parameter file in oracle?

586


How to change program global area (pga) in oracle?

592


How to insert a new row into a table in oracle?

593


How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

1619


What is tns name?

547






What is raw datatype?

595


how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

1832


From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

596


Where are the settings stored for each instance in oracle?

633


What happens if variable names collide with table/column names?

587


How to run create database statement?

579


what are the default admin accounts in Oracle 10g ?

512


What is a connect identifier?

543


When system tablespace is created?

608


Does oracle partitioning improve performance?

555