Answer / suman

we have two types of backups that is inconsist backup and
consistent backup
online backup is inconsistent backup
offline backup is consistent backuup
1.when the database is up on running at that time we have to
take the online backup it means hot backup
2.when the database is shutdown stage at that time we have
to take the offline backup it means cold backup this is the diff

Answer / kittu_chintu2005

online backup: 1) inconsistent backup 2) database must be in archive log mode 3) database should be in upon running

offline backup: 1) consistent backup 2)database may be or may not be in archive log mode 3)database should in shut down state

Answer / mogal

as said above every thing is same but one more point. i.e
" in a hot backup it have fractured blocks and where as in
cold backup there is no fractured blocks"

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

---

What view would you use to determine free space in a tablespace?

3 Answers  

---

Give the reasoning behind using an index.

2 Answers  

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers   Patni,

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  

---

what are the performance views in an oracle rac environment?

0 Answers   Oracle,

---

what r the types of backup?

5 Answers   CSC,

---

What are the recovery models for a database? : sql server DBA

0 Answers  

---

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

---

what is ora 600?

1 Answers  

---

what are the benefits of flashback feature?

0 Answers   Oracle,

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  

---