RMAN Read Only Tablespace
I have a 10.2.0.3 database on Solaris. I have an RMAN script that does a Hot Backup every day. It takes 9 hrs.
I was thinking about putting about 50% of the tablespaces in READ ONLY mode. The data never changes. It is part of a partitioned historical table.
After I put them in read only I take a hot backup and then the next time I add the skip readonly clause in my rman script. That is what I read.
My question is about retention. I have redundancy = 2. I am assuming it will never delete the read only tablespace backupset. Is that correct? Does anyone else use this read only skip feature?
Not answering your question directly but still here are my thoughts which might be helpful.
In my opinion
This would be a very difficult task to do.
I was thinking about putting about 50% of the tablespaces in READ ONLY mode.
Have you looked at Block Change Tracking in 10g and doing incremental backups ?
Also look at the documentation
for the answer to your question
Last edited by hrishy; 08-12-2008 at 10:56 AM.
Why would that be difficult? If the data is truly read-only and the table partitions do not change, and that is true of the entire tablespace, then it should work.
Granted, BCT and incremental backups are a very useful tool to reducing backup size and times.
I am not 100% sure, but I think if you configure your retention policy to the redundancy 1(?) your will always have a backup of the read only tablespaces available.
One, who thinks that the other one who thinks that know and does not know, does not know either!
Most of the databases that i have come across its very difficult to isolate true read only tablespaces.
Originally Posted by jhmartin
yes you are right if the verbatim from docs is to be beleived
Originally Posted by BV1963
from the docs
Assume that you configure a retention policy for redundancy.
In this case, RMAN only skips backups of offline
or read-only datafiles to SBT
when there are r + 1 backups of the files,
where r is set in
CONFIGURE RETENTION POLICY TO REDUNDANCY r.
The important aspect is to set OPTIMIZATION ON.
Click Here to Expand Forum to Full Width