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

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---

Name three advisory statistics you can collect.

1 Answers  

---

What is transparent data encryption? : sql server DBA

0 Answers  

---

Explain the use of table functions.

1 Answers  

---

what is the use of ocr?

0 Answers   Oracle,

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

---

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  

---

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

0 Answers  

---

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

---

What is RAID and what are different types of RAID configurations?

1 Answers  

---

What command would you use to encrypt a PL/SQL application?

1 Answers  

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers  

---