What is the use of NOARCHIEVELOG parameter in Database?
- 1 Answers
- 4807 Views
- I also Faced
- E-Mail Answers
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 |
Mention a query to add email validation to your database
Explain the difference between a primary key and a unique key?
What is 2nf in database?
When do you get a .PLL extension ?
Can we assign Explicitly transaction to a rollback segment
How to connect Silverlight application to database?
Define identity and uniqueidentifier property of column?
Explain relational algebra?
What is ordbms with example?
What are the different modes of mounting a Database with the Parallel Server ?
Why normalisation is required?
What is the use of Snapshot?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
