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.

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

---

Explain the use of table functions.

1 Answers  

---

What purpose does the model database server? : sql server DBA

0 Answers  

---

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

2 Answers   CSC,

---

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers  

---

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

---

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

---

You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

0 Answers  

---

What is the importance of a recovery model? : sql server DBA

0 Answers  

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers  

---

What does coalescing a tablespace do?

1 Answers  

---

what is difference between user managed backup and rman backup?

1 Answers   CTS,

---