Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

what is incremental checkpoint?

1 Answers   CTS,


Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,


how will you see when the database was started using sql prompt?

2 Answers   IBM,


Where in the Oracle directory tree structure are audit traces placed?

1 Answers  


What authentication modes does sql server support? : sql server DBA

0 Answers  


how can you connect from 10g user to 11g user??

0 Answers   HP,


Give the reasoning behind using an index.

2 Answers  


You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  


Explain materialized views and how they are used.

0 Answers  


Why would you use sql agent? : sql server DBA

0 Answers  


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

2 Answers   IBM,


i had backup last manday.now i need back monday to now ..how do get backup?

3 Answers   Infozech, Wipro,


Categories