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"

Hot backup procedure?

2 Answers  

---

what is the use of recording information about current session?

0 Answers   Oracle,

---

what are the differences of where and if in SAS?

0 Answers  

---

what is a crs resource?

0 Answers   Oracle,

---

what is a user-defined lock?

0 Answers   Oracle,

---

How many packages we have in db

1 Answers   Tesco,

---

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

3 Answers  

---

how can you record information about current session?

0 Answers   Oracle,

---

internal architecture

0 Answers   CSC,

---

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,

---

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

---

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,

---