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 to restore files with rman?

0 Answers  

---

Explain an ORA-01555

2 Answers  

---

what are the performance views in an oracle rac environment?

0 Answers   Oracle,

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  

---

what is the difference between db2start command and start database manager command?

1 Answers  

---

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

0 Answers  

---

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

---

Which environment variables are absolutely critical in order to run the OUI?

2 Answers  

---

what do you understand by flashback feature of oracle?

0 Answers   Oracle,

---

what are the differences of where and if in SAS?

0 Answers  

---

why do we give pctfree and pctused in create table statement?

1 Answers   CTS,

---

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,

---