What is the use of NOARCHIEVELOG parameter in Database?

Answer Posted / guest

NOARCHIEVELOG parameter is used to enable the database in
Achive mode as True or false.
If you need to check database is in which mode use this
command:

1.select log_mode from v$database.
IF database needs to be set in Archivelog Mode
2. Shutdown immediate
3. Startup mount
4. alter database archivelog
5. alter database open

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which database is best for storing images?

685


What is normalization in dbms?

674


What does clipper stand for?

710


What is dbms introduction?

687


Write a query to create a duplicate table with and without data present?

643


what are the differences between an exclusive lock and a shared lock?

755


How to write udf s in delphi?

724


Which database is faster?

668


What do you understand by ‘database’?

739


What is difference between database and schema?

692


Explain by listing some of dbms major advantages.

637


What are different types of data models?

709


How to do replication of firebird databases?

691


Mention the types of join?

677


How do databases help businesses?

671