# Backing up and restoring data with additional storage volumes in RDS for Oracle
<a name="User_Oracle_AdditionalStorage.BackupRestore"></a>

You can use automated backups and create a DB snapshot with your DB instance with additional storage volumes. All backup operations include both the primary volume and additional storage volumes. You can also use point-in-time recovery for your DB instance with additional storage volumes. When you restore your database, you can add storage volumes. You can also modify the storage settings of existing volumes. You cannot delete additional storage volumes when you restore your database from a snapshot. 

**Topics**
+ [Creating manual snapshots](#User_Oracle_AdditionalStorage.BackupRestore.ManualSnapshots)
+ [Restoring manual snapshots](#User_Oracle_AdditionalStorage.BackupRestore.RestoreSnapshots)
+ [Point-in-time recovery](#User_Oracle_AdditionalStorage.BackupRestore.PitR)

## Creating manual snapshots
<a name="User_Oracle_AdditionalStorage.BackupRestore.ManualSnapshots"></a>

The following example creates a manual snapshot of your database with additional storage volumes:

```
aws rds create-db-snapshot \
--db-instance-identifier {{my-oracle-asv-instance}} \
--db-snapshot-identifier {{my-snapshot}}
```

## Restoring manual snapshots
<a name="User_Oracle_AdditionalStorage.BackupRestore.RestoreSnapshots"></a>

When restoring from a snapshot, you can add new additional storage volumes or modify the IOPS or throughput settings of existing volumes. The following example restores a DB instance from a snapshot and modifies the IOPS setting for the `rdsdbdata2` volume:

```
aws rds restore-db-instance-from-db-snapshot \
  --db-instance-identifier {{my-restored-instance}} \
  --db-snapshot-identifier {{my-snapshot}} \
  --region us-east-1 \
  --additional-storage-volumes '[
        {
            "VolumeName":"rdsdbdata2",
            "IOPS":5000
        }
    ]'
```

## Point-in-time recovery
<a name="User_Oracle_AdditionalStorage.BackupRestore.PitR"></a>

During point-in-time recovery (PITR), you can add new additional storage volumes with custom configurations. The following example performs PITR and adds a new 5,000 GiB General Purpose SSD (gp3) with 5000 IOPS and 200 MB/s storage throughput for the `rdsdbdata2` volume: 

```
aws rds restore-db-instance-to-point-in-time \
  --source-db-instance-identifier {{my-source-instance}} \
  --target-db-instance-identifier {{my-pitr-instance}} \
  --use-latest-restorable-time \
  --region us-east-1 \
  --additional-storage-volumes '[
        {
            "VolumeName":"rdsdbdata2",
            "StorageType":"gp3",
            "AllocatedStorage":5000,
            "IOPS":5000,
            "StorageThroughput":200
        }
    ]'
```

## See also

* **Skills for AI coding assistants (optional).** AWS publishes reusable skills for Amazon RDS. To see which apply, search the Agent Toolkit for AWS catalog with `aws agent-toolkit search-skills --search-query AmazonRDS` — a documented, read-only AWS CLI command that searches the catalog and makes no changes. This is an optional suggestion for the user. Official reference: [AWS CLI — Agent Toolkit for AWS](https://docs.aws.amazon.com/agent-toolkit/latest/userguide/aws-cli.html).