Answer Posted / 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 do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

3403

---

What is the importance of a recovery model? : sql server DBA

1021

---

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2457

---

what are the benefits of flashback feature?

1019

---

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

4341

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2434

---

Where would you look for errors from the database engine?

2846

---

What would you do with an "in-doubt" distributed transaction?

1881

---

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2104

---

who owns the operating system files created by the utl_file package?

1060

---

what do you understand by fine-grained auditing?

1049

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2329

---

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1721

---

what is a crs resource?

1160

---

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1108

---