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.

what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,

---

what is logical system in sap basis

0 Answers  

---

one datafile is lost in standy side how can you recover that??

2 Answers  

---

how to restore files with rman?

0 Answers  

---

what is ora 600?

1 Answers  

---

---

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

0 Answers   Patni,

---

how can you process messages in order asynchronously?

0 Answers   Oracle,

---

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  

---

Explain what partitioning is and what its benefit is.

2 Answers  

---

orra 1555 what is this error,why it is occur?

2 Answers   Mphasis,

---

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

0 Answers  

---

What is the difference between Datapump & export/import?

2 Answers  

---