Visit our Google Group Way 2 SAP BASIS

online and offline backup

Moderators: BASIS24x7, Rashed

online and offline backup

Postby raghucharan v »

can anyone say the difference between online and offline backup?
raghucharan v
Posts: 17

Re: online and offline backup

Postby vmk4u »

Logs do require for any activity((Like Insert, Delete, Update etc.,)) on database
Online backup - Logs will be retained
Offline backup - Logs will be reused

Offline backup --
When you take a offline backup, you will have to force all the users who are connect to the database. this is called as Offline... This mean no activity on the database end execpt backup engine
using offline backup you can only restore the DB till the last full offline backup
Offline backup are also called full backup.

Online Backup --
Users are connect to database and doin DB activties(Insert, update, delete etc.,). At this situtaion if you want to take a backup without distrubing their activity on the database is called online.
You will be able to take Incremental/Delta backups only when your DB marked for online backups
Online backups are used for point in time recovery (With the retained logs)

To take online backups on any database, you will have to mark your database to allow online backups. To make database online there are different procedures for dirrent RDBMS(MS-SQL, ORACLE, DB2 etc.,) . Based on the RDBMS you will have to consult your DBA to setup online backups for your environment.
Usually online backups will be taken for production environments.

Hope this helps, if you need more let me know ...
Posts: 4

Re: online and offline backup

Postby rukku »

Offline Backup------All Components are stopped and their files can be copied easily.Consistant restore should be sucessful every time.Downtime necessary
Online Backup-------All Compnents are up and running.Online backup procedures are vendor specific.No Down time Required.Consistancy of some administration data needs to be ensured organizationally.
Posts: 39

Return to SAP DBA Forum

Who is online

Users browsing this forum: No registered users and 1 guest

Visit our Google Group Way 2 SAP BASIS