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

what is the use of recording information about current session?

0 Answers   Oracle,

---

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

---

what is the use of ocr?

0 Answers   Oracle,

---

What are the different types of indexes available in sql server? : sql server DBA

0 Answers  

---

when does an alert gets signaled?

0 Answers   Oracle,

---

---

Give two methods you could use to determine what DDL changes have been made.

2 Answers  

---

Give two examples of referential integrity constraints.

2 Answers  

---

1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers  

---

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

---

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

0 Answers  

---

What happens on checkpoint? : sql server DBA

0 Answers  

---

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  

---