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
Describe reporting lifecycle?
Mention how deadlock can be resolved?
What is the purpose of using a model?
What are databases what are the uses of databases?
Explain what are super servers?
Define cursor and its types.
Explain 3nf?
What is the most used database?
What is unique key in dbms?
Where is data stored in database?
Who is the founder of database?
What is the difference between horizontal and vertical partitioning?
What is data modelling techniques?
What are the advantages of a database?
Why rdbms is called relational?