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.

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

1 Answers  

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

---

What would you do with an "in-doubt" distributed transaction?

1 Answers  

---

Oracle 11g new features?

2 Answers  

---

which background process invoke at the time of upgradation tell me???

1 Answers   iGate,

---

What is the difference between online backup & offline backup?

3 Answers   CSC,

---

how to restore files with rman?

1 Answers  

---

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers  

---

What are the different ways you can create databases in sql server? : sql server DBA

1 Answers  

---

what is incremental checkpoint?

1 Answers   CTS,

---

How can you gather statistics on a table?

3 Answers  

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

1 Answers  

---