Jump to

• Request
• Response

get all snapshots of the current pluggable databases

get

/database/snapshots/

Returns all snapshot record. A client requires SQL Administrator role to invoke this service.

Request

There are no request parameters for this operation.

There's no request body for this operation.

Back to Top

Response

Supported Media Types

• application/json

201 Response

Pdb snapshot in the database.

Body ()

Root Schema : DatabasePluggableSnapshotItem

Type: object

This object describes Pluggable Database Snapshots associated with the current instance.

Show Source

• con_id: integer
  The ID of the container to which the data pertains.
• con_name: string
  Name of the PDB.
• con_uid: integer
  Unique identifier associated with the PDB.
• full_snapshot_path: string
  Full path for the snapshot.
• links: array links
• previous_snapshot_scn: integer
  SCN at which the previous snapshot for the PDB was taken
• previous_snapshot_time: integer
  Timestamp of the previous snapshot for this PDB.
• snapshot_name: string
  Snapshot name of the PDB.
• snapshot_scn: integer
  SCN at which the snapshot was taken.
• snapshot_time: integer
  Timestamp at which the snapshot was taken.

{
    "type":"object",
    "description":"This object describes Pluggable Database Snapshots associated with the current instance.",
    "properties":{
        "con_id":{
            "type":"integer",
            "description":"The ID of the container to which the data pertains."
        },
        "con_uid":{
            "type":"integer",
            "description":"Unique identifier associated with the PDB."
        },
        "con_name":{
            "type":"string",
            "description":"Name of the PDB."
        },
        "snapshot_name":{
            "type":"string",
            "description":"Snapshot name of the PDB."
        },
        "snapshot_scn":{
            "type":"integer",
            "description":"SCN at which the snapshot was taken."
        },
        "previous_snapshot_scn":{
            "type":"integer",
            "description":"SCN at which the previous snapshot for the PDB was taken"
        },
        "snapshot_time":{
            "type":"integer",
            "description":"Timestamp at which the snapshot was taken."
        },
        "previous_snapshot_time":{
            "type":"integer",
            "description":"Timestamp of the previous snapshot for this PDB."
        },
        "full_snapshot_path":{
            "type":"string",
            "description":"Full path for the snapshot."
        },
        "links":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/LinkRelation"
            }
        }
    }
}

Nested Schema : links

Type: array

Show Source

• Array of: object LinkRelation

{
    "type":"array",
    "items":{
        "$ref":"#/components/schemas/LinkRelation"
    }
}

Nested Schema : LinkRelation

Type: object

Show Source

• href(required): string
• rel(required): string

{
    "type":"object",
    "properties":{
        "rel":{
            "type":"string"
        },
        "href":{
            "type":"string"
        }
    },
    "required":[
        "rel",
        "href"
    ]
}

Back to Top