Many of my clients use storage backup (snapshots, etc.) to backup their databases. The right and supported way to do that is like any hot backup: place the database in backup mode, take the snapshot, take the database out of backup mode, archive the current logfile and backup the archives, right?
Some clients use the unsupported way of just taking the snapshot, as it is a consistent copy (exactly like a server crash). From my experience it works, but you can only restore the database to the snapshot time and you cannot apply archives.
Well, not any more! In Oracle 12c, as long as the snapshot mechanism meets several requirements (the database is crash consistent, write order is preserved and the snapshot stores the time of completion) you can take a snapshot without putting the database into backup mode. To perform the recovery, you will need to add the new “snapshot time” clause. Much easier than before!
Did You Know #13 – Storage Backup
Categories:
2 thoughts on “Did You Know #13 – Storage Backup”
Leave a Reply
Related Post
Using DBCA in Silent ModeUsing DBCA in Silent Mode
One of my customers is a software company and they use Oracle database for their product. One of the things we need to do when they certify an Oracle version
How to Install OEM 13.4 on OL8How to Install OEM 13.4 on OL8
In this post I’ll review all the steps required to install OEM 13.4 including its repository database. The versions I’m going to install are OEM 13.4 and database 19.8 on
Testing Oracle Standard Edition High AvailabilityTesting Oracle Standard Edition High Availability
In this post I’ll continue discussing SEHA. If you don’t know what it is or you would like to read more about it, look at my previous post. I will
Hi Liron,
Thanks for this post!
“From my experience it works, but you can only restore the database to the snapshot time and you cannot apply archives.
Well, not any more! In Oracle 12c, as long as the snapshot mechanism meets several requirements (the database is crash consistent, write order is preserved and the snapshot stores the time of completion)”
Actually, it was supported also before Oracle 12c. In my previous job (in the IDF) we used
Netapp crash consistent backups. See: http://www.netapp.com/us/media/tr-3858.pdf
“A crash-consistent image, just like a regular backup image, can be restored and rolled forward by
applying current online redo logs and archived logs.”
See also My Oracle Support (MOS) note 604683.1
Thanks for the comment Pini,
I haven’t tried that lately, and I don’t remember which version I had back then (10g? Maybe even 9i), but I definitely didn’t manage to roll archives forward…
Anyway, good to know.