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

i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

1611


Why is maintaining a database important?

697


Define fragmentation.

704


Can files be stored in a database?

732


What is the main purpose of a database?

677


describe and contrast a trigger and a procedure.

747


How to disconnect the user connection?

706


Is access a database?

681


What is data sublanguage?

770


What is a database in a website?

758


What is data model in dbms?

698


How is the pattern matching done in the sql?

938


What is file manager?

705


How can I join two tables in database?

803


What is cold backup, hot backup, warm backup recovery?

647