Oracle DB schedules

Question

Hi Community,

Hope everyone is doing well.

While integrating our newly installed ORACLE DB server, we came through some concerns regarding the appropriate schedule that will be assigned to the server.

The DB backup will have two subclients : DATA + Archive Logs.

Our intentions are to perform FULLs of the DATA and frequent ArchiveLog backup (each hour).

The concern is about the Archive logs, has the backup to be run each hour to be a FULL or Incremental, or should we create a specific schedule policy for the archive logs and set inside it two schedule patterns (for example one full daily and other Incrementals the rest of the day) ?

Recommendations regarding the scheduling of the backups would be appreciated.

Regards.

icon

Best answer by Chris Hollis 16 January 2024, 23:16

View original

Chris Hollis · Accepted Answer

Hi @Commvault EngineerArchive logs can only be FULL backups, so you would either use one schedule policy and have two schedules within it (one schedule to trigger the ‘DATA’ Subclient FULL backup for the frequency you desire, another for the hourly ‘ARCHIVE LOGS’ subclient).Or you can just create individual schedules per subclient. Regardless of the job type you specify for the ARCHIVE Logs subclient, the backup type will be FULL.Hopefully this helps.Regards,​​​​​​​Chris

Commvault Engineer · Answer

Hi@Commvault EngineerArchive logs can only be FULL backups, so you would either use one schedule policy and have two schedules within it (one schedule to trigger the ‘DATA’ Subclient FULL backup for the frequency you desire, another for the hourly ‘ARCHIVE LOGS’ subclient).Or you can just create individual schedules per subclient. Regardless of the job type you specify for the ARCHIVE Logs subclient, the backup type will be FULL.Hopefully this helps.Regards,ChrisThanks a lot for the clarifications, Chris.That’s what we were searching for.Have a nice day ahead.Regards.

Oracle DB schedules

2 replies

Reply

Reply

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded