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

how can you record information about current session?

0 Answers   Oracle,

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers   Patni,

---

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

---

What happens on checkpoint? : sql server DBA

0 Answers  

---

what is meant by gateway

1 Answers   IBM,

---

How would you determine the time zone under which a database was operating?

2 Answers  

---

How would you begin to troubleshoot an ORA-3113 error?

1 Answers  

---

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers  

---

What are the different ways you can create databases in sql server? : sql server DBA

0 Answers  

---

which background process invoke at the time of upgradation tell me???

0 Answers   iGate,

---

what do you understand by fine-grained auditing?

0 Answers   Oracle,

---

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

0 Answers  

---