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
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
Why is maintaining a database important?
Define fragmentation.
Can files be stored in a database?
What is the main purpose of a database?
describe and contrast a trigger and a procedure.
How to disconnect the user connection?
Is access a database?
What is data sublanguage?
What is a database in a website?
What is data model in dbms?
How is the pattern matching done in the sql?
What is file manager?
How can I join two tables in database?
What is cold backup, hot backup, warm backup recovery?