What is the use of NOARCHIEVELOG parameter in Database?
Answer / 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 |
How is view stored in database?
what are the advantages of GUI systems ?
What are the different types of data tables?
What do you understand by intension and extension?
How to improve query performance using index hunting?
Explain a tp monitor?
Explain the Difference Between OLTP and OLAP Databases.
What is a database in healthcare?
What is trigger in dbms?
What is delimiter in dbms?
What is the full meaning of dbms?
Explain the hierarchical database?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)