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 view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  

---

how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,

---

Name two files used for network connection to a database.

5 Answers  

---

what is meant by gateway

1 Answers   IBM,

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

Can you redefine a table online?

0 Answers   Oracle,

---

What is blocking and how would you troubleshoot it?

1 Answers  

---

When a user process fails, what background process cleans up after it?

1 Answers  

---

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,

---

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

2 Answers  

---

what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,

---