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.

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

0 Answers  

---

what r the types of backup?

5 Answers   CSC,

---

any body know about orawaves do they really provide placements in their unique placement program

1 Answers   TCS,

---

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,

---

Describe what redo logs are.

1 Answers  

---

---

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

2 Answers   Mphasis,

---

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers  

---

Explain an ORA-01555

2 Answers  

---

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

2 Answers   Satyam,

---

What the different components in replication and what is their use? : sql server DBA

0 Answers  

---

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

---

Where would you look for errors from the database engine?

0 Answers   IBM,

---