Answer / guest

online backup:

1.Inconsistent
2.database in open state.
3.Archive mode must set

offline:

1.consistent
2.db in close
3.No need archive mode

Answer / vishal sharna

offline backup is the traditional backup in which we cannot
take the backup untill the application is closed but its
quite consistent,but as we know its very cost effective to
close all the application and then take the backup,so we
will take the online backup.in this case we an take the
backup of running aplication but set the recovery log mod
to rollforward,with the help of it we can restore our
database to the most recent state.

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers   IBM,

---

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,

---

Explain the difference between a data block, an extent and a segment.

2 Answers  

---

What is RAID and what are different types of RAID configurations?

1 Answers  

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers  

---

---

wat is global index and local indes

1 Answers   Oracle,

---

What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

---

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---

How can you gather statistics on a table?

3 Answers  

---

How can we know the exact updation date of a particular database?

2 Answers   Satyam,

---

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  

---

what is the differnce between process and thread ?

1 Answers   IBM,

---