What is the difference between online backup & offline backup?

Answers were Sorted based on User's Feedback



What is the difference between online backup & offline backup?..

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

Is This Answer Correct ?    13 Yes 1 No

What is the difference between online backup & offline backup?..

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

Is This Answer Correct ?    7 Yes 2 No

What is the difference between online backup & offline backup?..

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"

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More DB Administration Interview Questions

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers  


what are the types of connection load-balancing?

0 Answers   Oracle,


How can we see the database version in os level

6 Answers   Oracle,


What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers  


hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  






What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

0 Answers  


what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,


What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,


What are the different ways you can create databases in sql server? : sql server DBA

0 Answers  


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

0 Answers  


How would you begin to troubleshoot an ORA-3113 error?

1 Answers  


Give two examples of referential integrity constraints.

2 Answers  


Categories