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

What is building blocks of client/server?

611


What is the quickest sorting method to use?

628


What is field record and table in database?

549


How to do replication of firebird databases?

561


What is file manager?

577






What is the difference between horizontal and vertical partitioning?

634


What is database connection pool size?

536


Explain the types of database normalization?

551


What is dbms pdf?

684


How do you create a blank database?

548


What is environment of openedge?

577


Can you explain insert, update and delete query?

627


Explain the concept of acid properties in dbms?

687


What is indexing in database with example?

574


Briefly describe the three types of sql commands.

575