What is the difference between online backup & offline backup?
Answer Posted / 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
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What the different topologies in which replication can be configured? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
What purpose does the model database server? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Can you redefine a table online?
what is the use of recording information about current session?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What are the recovery models for a database? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?