Answer / azhar

No.We cannot take Online Backups if the database is running in NOARCHIVELOG mode.

Steps To bring database in ArchiveLog Mode.

1)Shut down the database if running.
2)Open Parameter file and set the following parameter
LOG_ARCHIVE_DEST='Path to where Archivelog has to be stored'

Then Save the parameter file

3)Now open the database in Mount Stage

To Check the mode of database:
SQL>select log_mode from v$database;

NoArchiveLog

Now to Enable ArchiveLog

SQL>alter database archivelog;
SQL>Select log_mode from v$database;
4)Open the database .

To know the archive log destination and Status of RedoLogs,
SQL>archive log list

Explain the use of table functions.

1 Answers  

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  

---

How can we see the database version in os level

6 Answers   Oracle,

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers  

---

what is ora 24313?what is the procedure to exclude that error?

0 Answers  

---

---

what is rebuild index??

2 Answers   IBM, Sapient,

---

What is the default port no on which sql server listens? : sql server DBA

0 Answers  

---

Why would you call update statistics? : sql server DBA

0 Answers  

---

why do we give pctfree and pctused in create table statement?

1 Answers   CTS,

---

What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

---

what is the difference between db2start command and start database manager command?

1 Answers  

---

What is the difference between LMT & DLT?

1 Answers   CTS,

---