File level partial offline backup
Scope: Oracle 12c database; x86-64; Oracle Linux
Database organization: NOARCHIVELOG mode; several table-spaces holding data
Data: table-space A holds important data, table-spaces B holds temporary and junk data
Proposed backup strategy:
a) take database offline (stop DB server)
b) copy data files of both table-spaces A and B to safe location
c) start database
d) repeat process daily only for table-space A files
e) in case of data-loss restore current files of table-space A and initial files of table-space B
Question:
Will this work, or Oracle need that all files would be copied at the same time?
How to avoid creating daily copy's of table-space B?