RMAN and backup by user
550825Sep 25 2007 — edited Sep 26 2007I am not a DBA. I did some google searches on this. I know I can backup by tablespace and datafile. Can I pick which users to backup?
We want to use ASM with a bigfile tablespaces for simplicity, but we do not want ot backup the entire database. We cannot put certain users into read only since they get data loads. This data is non-mission critical and we drop it a few days later.
So we want to break out our mission critical data by schema and back that up. Can we do that with RMAN?