API Explorer
API Explorer
Introduction
What's New
Appliance Management
Application Data Management
Asset Management
Asset Metadata
Authentication and Authorization
Cloud Disaster Recovery
Compliance
Copy Management
Credentials Management
Discovery
File Level Restore
Installation
Inventory Source Management
Kubernetes Data Management
Licenses Management
Location Management
Log Management
Monitoring
Protection Policies
Recovery and Reuse Management
Remote Service
Search Clusters
Secrets Manager
Server Disaster Recovery
Storage Management
Telemetry Setting
Upgrade
User Security Management
Virtual Machine Data Management
Whitelist Management

Create protection policy for Oracle

Create a protection policy to back up Oracle database

To back up Oracle, SQL, and SAP HANA databases, you can set up backup schedules for different backup types. For example, you could have a full backup that starts on Sunday at 11 PM, a differential backup from Monday to Saturday at 9 PM, and a log backup that occurs 24 hrs * 7 days.

To enable different backup schedules in the protection policy, use this API call:

PUT /api/v2/protection-policies/{id}

The {id} is the protection policy ID that you obtained from the create protection policy call. The PUT body contains a protection stage with “Operations”. It looks similar to this example:

{
    "id": "01328eaa-8a30-4b8f-a191-292899ace9b3",
    "name": "oracle-sample",
    "description": "",
    "assetType": "ORACLE_DATABASE",
    "type": "ACTIVE",
    "targetStorageProvisionStrategy": "AUTO_PROVISION",
    "enabled": true,
    "passive": false,
    "forceFull": false,
    "priority": 1,
    "credentials": {
        "type": "OS",
        "id": "40f0b7b7-9918-4776-ad71-08b985edd144"
    },
    "encrypted": false,
    "dataConsistency": "APPLICATION_CONSISTENT",
    "complianceInterval": null,
    "details": {
        "oracle": {
            "dbConnection": {
                "tnsName": "",
                "tnsAdmin": ""
            }
        }
    },
    "summary": {
        "numberOfAssets": 1,
        "totalAssetCapacity": 2.490368E9,
        "totalAssetProtectionCapacity": 4.622123008E9,
        "numberOfJobFailures": 0,
        "numberOfSlaFailures": 0,
        "numberOfSlaSuccess": 0,
        "lastExecutionStatus": "SUCCEEDED"
    },
    "stages": [
        {
            "id": "f2f94a91-3aba-37e9-486f-c503de0de9ab",
            "type": "PROTECTION",
            "passive": false,
            "retention": {
                "interval": 1,
                "unit": "DAY",
                "storageSystemRetentionLock": false
            },
            "target": {
                "storageSystemId": "53aa4eac-401c-4427-9338-61e997dbf67b",
                "dataTargetId": "8ed105ee-ead7-4b37-8d63-7f40e961ed5a",
                "softStreamQuotaLevel": 10,
                "hardStreamQuotaLevel": 12,
                "softCapacityQuotaLevel": 21474836480,
                "hardCapacityQuotaLevel": 32212254720,
                "preferredInterface": "10.124.29.49"
            },
            "attributes": {
                "oracle": {
                    "archiveLogDeletionDays": 1,
                    "troubleShootingOption": "debugEnabled=false"
                },
                "protection": {}
            },
            "operations": [
            {
                "type": "FULL",
                "schedule": {
                    "frequency": "WEEKLY",
                    "startTime": "2020-11-27T00:00:00Z",
                    "duration": "PT10H",
                    "interval": 6,
                    "weekDays":["SUNDAY"]
                },
                "backupType": "FULL"
            },
						{
                "type": "DIFFERENTIAL",
                "schedule": {
                    "frequency": "DAILY",
                    "startTime": "2020-11-27T00:00:00Z",
                    "duration": "PT5H",
                    "interval": 20
                },
                "backupType": "DIFFERENTIAL"
            },
            {
                "type": "LOG",
                "schedule": {
                    "frequency": "MINUTELY",
                    "startTime": "2020-11-28T18:00:00Z",
                    "duration": "PT6H",
                    "interval": 30
                },
                "backupType": "LOG"
            }]
        }
    ],
    "filterIds": [],
    "createdAt": "2020-11-27T01:37:38.397Z",
    "updatedAt": "2020-11-27T01:37:38.561Z",
    "slaId": ""
}

The response of the API call:

200(OK)
{
    "id": "01328eaa-8a30-4b8f-a191-292899ace9b3",
    "name": "oracle-sample",
    ...
}