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 |
What are indexes? Mention the differences between the clustered and non-clustered index?
What are the advantages of database software?
What is database schema in dbms?
How many types of database language exist?
How do you pass values from one form to another form ?
What is the use of IGNORE option in IMP command ?
How the SMON process is used to write into LOG files ?
What is database in simple language?
What is rdbms architecture?
What are the benefits of modeling?
What is the purpose of a model?
How to Optimize Database Queries for Performance?
Oracle (3259)
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)