Oracle Version : 12.2
My current DB size is 30 TB. I am using Exadata on oracle cloud. I need to plan backup strategy using cloud storage.
The data inside the database is already compressed(Hybrid columnar compression).
I am using Table partitions(quarterly). After every 3 months I am going to make the partition Read only & move the partition to read only tablespace by making the tablespace RW & again RO.
so that the every quarterly the Read only tablespace will be backed up once.
Currently Data change size is 1.5 GB per day.
The physical standby database is also configured.
What will be best strategy ?
please assist.
Thanks,
DJ