commvault.com commvault.com
Solved

SAP for Oracle - Selective Online vs. Full Online

  • 13 January 2023
  • 4 replies
  • 348 views
I
Rank
Badge +1

I’m fairly new to Commvault, and I’m responsible for our SAP for Oracle backups.  I am going through our systems and I’m trying to determine what the benefits/tradeoffs of a “Selective Online” vs Full Online backups.  There isn’t much data about what is/isn’t backed-up between the two options, if any. We currently run one full backup per week and arclogs run every 15 min to 1 hour depending on the data/usage.  We backup to disk with a secondary offsite disk aux copy and Metallic aux copy.  No tapes.

Thanks!

icon

Best answer by Gowri Shankar 13 January 2023, 19:26

View original

4 replies

G
Rank
Userlevel 4
Badge +12

Hi @Ike 

Selective copy is a self content backup used for longer retention. All the data and logs are retained together while using a selective copy with extended retention 

 

Additional information could be found @ https://intdocresource2.gp.cv.commvault.com/2022e/expert/11727_selective_online_full_backups.html

 

Let me know in case of any other questions.

 

Regards,

 

 

I
Rank
Badge +1

So are Selective Online and Online Full the same with the exception of what you say below?

i.e. Datafiles, Tablespaces, etc...

Hi @Ike 

Selective copy is a self content backup used for longer retention. All the data and logs are retained together while using a selective copy with extended retention 

 

Additional information could be found @ https://intdocresource2.gp.cv.commvault.com/2022e/expert/11727_selective_online_full_backups.html

 

Let me know in case of any other questions.

 

Regards,

 

 

 

G
Rank
Userlevel 4
Badge +12

Yes, SOF and regular full protects the entire database ctrl file + Datafiles (Tablespaces) and archive logs

I
Rank
Badge +1

Thanks!

Reply


Terms & ConditionsCookie settings