Answer / suman

we have two types of backups that is inconsist backup and
consistent backup
online backup is inconsistent backup
offline backup is consistent backuup
1.when the database is up on running at that time we have to
take the online backup it means hot backup
2.when the database is shutdown stage at that time we have
to take the offline backup it means cold backup this is the diff

Answer / kittu_chintu2005

online backup: 1) inconsistent backup 2) database must be in archive log mode 3) database should be in upon running

offline backup: 1) consistent backup 2)database may be or may not be in archive log mode 3)database should in shut down state

Answer / mogal

as said above every thing is same but one more point. i.e
" in a hot backup it have fractured blocks and where as in
cold backup there is no fractured blocks"

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers  

---

I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers  

---

Datapump backup steps?

1 Answers  

---

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

2 Answers  

---

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers  

---

---

what is the use of recording information about current session?

0 Answers   Oracle,

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

0 Answers  

---

How do you open a cluster administrator? : sql server DBA

0 Answers  

---

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

---

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

---

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

---