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

What happens on checkpoint? : sql server DBA

1032

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2375

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1920

---

how can you schedule a job in database?

1043

---

what is the diffrence between core dba and apps dba?

2511

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2615

---

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?

3344

---

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

1011

---

what are the benefits of flashback feature?

954

---

What are statistics, under what circumstances they go out of date, how do you update them?

2195

---

what are the types of connection load-balancing?

938

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2135

---

Why would you use sql agent? : sql server DBA

1017

---

internal architecture

2141

---

what functionality does oracle provide to secure sensitive information?

942

---