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 a system database and what is a user database? : sql server DBA

0 Answers  

---

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

2 Answers  

---

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

---

what do you understand by flashback feature of oracle?

0 Answers   Oracle,

---

What view would you use to look at the size of a data file?

3 Answers  

---

what are the differences of where and if in SAS?

0 Answers  

---

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

0 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  

---

how can you create a user-defined lock?

0 Answers   Oracle,

---

what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers  

---

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  

---