Run pre/post script without Application Aware processing

[mario.orefice]

Good morning experts,
is there a way to run pre and post script without performing application aware tasks?
The reason is I want to run a particular script before the backup on an Oracle server and want to avoid the "begin/end backup" tasks on the database at every run of the Veeam backup job.
In the job the option the add pre/post script is available only after enabling Application aware

Thank you
Mario

[Mildur]

Hi Mario

Are you managing your agents with a VBR? If yes, I will move this topic to the correct sub forum.

Can you elaborate on why you can't use application aware processing for your oracle server? Application aware processing is required when you need to run pre-freeze/pre-thaw scripts in a backup job/policy.

As an alternative to agent jobs and AAIP, have you checked out our Plug-in for Oracle RMAN? It allows you to do RMAN backups with your own scripts to a Veeam backup repository target.

Best,
Fabian

[mario.orefice]

Hi Fabian.

Are you managing your agents with a VBR? If yes, I will move this topic to the correct sub forum.

yes

Can you elaborate on why you can't use application aware processing for your oracle server? Application aware processing is required when you need to run pre-freeze/pre-thaw scripts in a backup job/policy.

Customer is simply asking to automate oracle shutdown - backup of machine volumes - oracle startup.
Doing it with AAIP+scripts, the start up script fails because the db files are placed in backup mode before the shutdown database script by AAIP task

[Mildur]

Hi Mario

Moved the topic then.

Customer is simply asking to automate oracle shutdown - backup of machine volumes - oracle startup.

You don't have to shutdown the database for having a consistent backup of the oracle server.
AAIP or Plug-in for Oracle RMAN would provide application consistent backups of your oracle databases.

But if you still want to backup your oracle server this way, I see two options:
- Use windows scheduler to stop the oracle services a few minutes before the agent backup is scheduled. Then use Windows Scheduler to start them again 10-15min (after VSS Snapshot was created) after the backup has started. DB Files should still be consistent, because they were shutdown when the VSS snapshot was processed.
- Use Backup Job Scripts instead of AAIP Guest Scripts. This option is available if you have selected "Managed by backup server" mode for the agent backup job.
Backup Job scripts are processed on the backup server. But you could use them to connect to the Oracle Server to start and stop the service before backup processing starts.

Please run a backup and test recovery before using it in production.

Best,
Fabian