difference between offline and online backup

[#1]

Dear all,

I have some confusion regrding online and offline backup.I want to what is the basic difference between them in terms of database.

Thanks in advance

Thanks and Regards

Amit Saini

9818003621

[Former Member]

Dear Amit,

From the database point of view:

online backups are by definition inconsistent backups because user changes are

written to files while backup is running and need some recovery from the archives

if you have to restore the backup. With the underlying RMAN tool you can even make

the time for restore really short.

why you ever would consider an offline backup of the database? Why have downtimes ?

While you can do an offline backup I don't see any advantage:

If you are in 24x7 you do online backups while the database is in archivelog mode , point.

bye

yk