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 are the recovery models for a database? : sql server DBA

0 Answers  

---

what are the differences of where and if in SAS?

0 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?

0 Answers  

---

What is checkpoint?

3 Answers   Accenture,

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers  

---

What command would you use to encrypt a PL/SQL application?

1 Answers  

---

What is replication? : sql server DBA

0 Answers  

---

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

4 Answers  

---

Explain materialized views and how they are used.

0 Answers  

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers  

---

How do you tell what your machine name is and what is its IP address?

4 Answers  

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers  

---