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

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

1406

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2053

---

What authentication modes does sql server support? : sql server DBA

792

---

What purpose does the model database server? : sql server DBA

709

---

what is grd?

724

---

---

how to restore files with rman?

1834

---

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

2013

---

What are the operating modes in which database mirroring runs? : sql server DBA

723

---

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

631

---

what do you understand by flashback feature of oracle?

646

---

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

676

---

what functionality does oracle provide to secure sensitive information?

645

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

785

---

what is the use of ocr?

683

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

1927

---