Answer / iliyas ali

1.To take both the bkp the db should be in Archive log
2.Rman doesn't put tablespace in bkp mode.
3.the biggest advantage of Rman is that it takes the bkp of the used space/blocks of database.where user managed bkp takes the bkp of complete data file.
4.Rman will automatically detect block corruption,which is not possible in Hot bkp.
5.In Rman we can take incremental bkp,which is not possible in User managed bkp.
6.Rman is FRA aware.We can perform table space point in time recovery,as block change tracking also which is not possible in user managed backup.
7.Most importantly,Rman will re-read the data block until it gets the consistent image of it.

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  

---

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

0 Answers  

---

why we use cursors

1 Answers  

---

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

0 Answers  

---

What command would you use to encrypt a PL/SQL application?

1 Answers  

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers  

---

Which autogrowth database setting is good? : sql server DBA

0 Answers  

---

How do you tell what your machine name is and what is its IP address?

4 Answers  

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

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

2 Answers  

---

What is the difference between clustered and non-clustered index? : sql server DBA

0 Answers  

---

what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,

---