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

How to determine who is and change the owner of database?

523


What is the role of database management system?

478


Define and explain about progress?

534


What is the difference between a database and a spreadsheet?

469


what are the two integrity rules used in DBMS?

625






How can I join two tables in database?

512


What is the difference between multiload and fastload interms of performance?

486


What does a database contain?

462


What are the characteristics of data in the database?

468


Define a relation schema and a relation.

537


Which database is best for large data?

489


Define the relationship between ‘view’ and ‘data independence’.

608


What is a Federated Query ?

584


What is database or database management systems (dbms)? And what's the difference between file and database? Can files qualify as a database?

469


What is a Built_in subprogram ?

3478