Answer Posted / amsu

4. No you can't take online backup while database in
NOARCHIVELOG mode.

5. shutdown immediate
startup mount
alter database archivelog;
alter database open;
6. Best way is keep the database in archive log mode.
That will help to recover the database up to last
committed transaction. Oracle recommendation is keep
the database in archive log mode.

What is replication? : sql server DBA

1182

---

how can you create a user-defined lock?

1022

---

what functionality does oracle provide to secure sensitive information?

1001

---

what is the use of recording information about current session?

1056

---

what is the diffrence between core dba and apps dba?

2575

---

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1051

---

what are the types of connection load-balancing?

1002

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2446

---

when does an alert gets signaled?

1060

---

What is the default fill factor value? : sql server DBA

1135

---

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

1979

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1108

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1119

---

Which autogrowth database setting is good? : sql server DBA

1163

---

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

2438

---