I'm having trouble on configuring selective copy for my site.
A brief description of what I'm having on my site.
My client is an Oracle database, it is being configured with 2 subclients, one being the default & another is the archive log subclients.
For the default backups, it's a normal online backups. Full backups will be done every week & incremental everyday.
The archivelog subclients only backed up the archive logs only & run every 4 hours.
So due to compliance purposes I'm requested to have a secondary copy of my backups located in another datacenter. To do this, I create a new selective copy from my primary storage policy. After multiple tries the aux copy failed to work & checking with support actually mention that in order for the selective copy to work, my full backups need to be selective online fulls.
Their advice is to change my current full backups to selective online fulls.
Now, I basically understand that selective online fulls will take backups of all my database including the archive logs. If I switch my normal full backups to selective online fulls, it'll definitely takes up huge space of my disk since the backups will be larger.
My question is, how do I go about or what's the best practise for this? Should I just create a new backup jobs which is only doing selective online fulls while letting my existing backups run normally? Or should I change my existing full backups to selective online fulls? By doing this, how about my archivelog backups? Are they still needed if selective onlilne fulls backing up the archive logs as well?