Skip to Main Content
  • Questions

  • Huge Read Only Data Protection and H.A, Best Practice

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, ery.

Asked: December 18, 2018 - 1:45 pm UTC

Last updated: January 16, 2019 - 2:53 am UTC

Version: 11.2.0.4

Viewed 1000+ times

You Asked

Hi TOM,

Suppose we have a VLDB with partitioned tables on distinct tablespaces per partition.
Data on partitions (Tablespaces) can be read-only after a few months.
Now we have huge (RMAN) backups from this read-only tablesapces.
We want to setup Datauard for this database.

Question:
- Is this a good practice that we rely to physical standby database on read-only tablespaces and release backup media used for keeping read-only tablespaces backup? (means that we will not take backup from read-only tablespace)

- If this practice is possible, Is there any effect or consideration on our Backup/Recovery scenarios?

Thanks,
Erfan

and Connor said...

Whether you have dataguard or not, one of the benefits of read only tablespaces is that you never have to back them up (once you have backed them up at least once).

Once your tablespaces are read only

- take a final backup of them
- mark those backups are never to expire
- take one or more copies of them (just in case)

and then you never have to back them up again. Your backup commands just include "skip read only"

Alternatively, use block change tracking and the database will simply bypass any data that has not changed (which will include the read only tablespaces).

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Physical Standby Instead of Backup (On Read Only tablespaces)

ery am, January 14, 2019 - 9:53 am UTC

Hi,
Happy new year and very thanks to your answer.

My more cleared question is that:
Is it true/safe that we have No backup from Read only tablespaces, if we have their duplicates via Physical Standby?

Thanks again
Erfan
Connor McDonald
January 16, 2019 - 2:53 am UTC

Notice that I said:

once you have backed them up at least once


I would not rely on a physical standby, because what if someone runs

drop tablespace XXX;

on your primary
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Backup/Recovery

Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.