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 can we tune a oracle database if log file sync issue comes
Can we pass RECORD GROUP between FORMS ?
Is it good to save image in database?
What do you understand by e-r model?
Is a database a file?
What are five types of database models?
What is first normal form in dbms?
What is data in dbms?
What is metadata and why should I use it?
Why normalisation is required?
what are the advantages of a client or server model ?
What is database partition key?
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)