What is the difference between online and offline backups?

Post Reply
santosh
Posts: 1311
Joined: Wed Sep 07, 2016 4:43 pm

What is the difference between online and offline backups?

Postby santosh » Sat Nov 12, 2016 3:01 pm

What is the difference between online and offline backups?
Top
raoneel2016
Posts: 824
Joined: Wed Oct 05, 2016 2:40 pm

Re: What is the difference between online and offline backups?

Postby raoneel2016 » Sat Nov 12, 2016 3:01 pm

A online/hot/open database backup is a backup performed while the database is online and available for read/write. This can only be done if your database is in ARCHIVELOG mode. A offline/cold/closed database backup is a backup performed while the database is off-line/shutdown.
Top
Post Reply

Return to “Oracle”

Who is online

Users browsing this forum: No registered users and 2 guests