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.

what is incremental checkpoint?

1 Answers   CTS,

---

How would you extract DDL of a table without using a GUI tool?

0 Answers  

---

What is transparent data encryption? : sql server DBA

0 Answers  

---

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

---

How to determine the service pack currently installed on SQL Server?

1 Answers  

---

what is difference between user managed backup and rman backup?

1 Answers   CTS,

---

Explain materialized views and how they are used.

0 Answers  

---

What is the difference between online backup & offline backup?

3 Answers   CSC,

---

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

---

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

---

What is the difference between Datapump & export/import?

2 Answers  

---

How would you determine who has added a row to a table?

4 Answers  

---