Backup Base Database

Automatic Backup

Oracle recommends to use Oracle-managed automatic backup for your databases.

Oracle Database@Google Cloud provides the following two (2) choices as the Backup destination for Oracle Base Database Service in the OCI console.

1. Object Storage
2. Autonomous Recovery Service (Not supported at GA)

To use the automatic backup option, you need to select one of the choices described above after creating Based Database from OCI.

Object Storage

1. Select Object Storage from the Backup destination list.
2. Enter your Backup retention period between 7 and 60 days. You can modify the retention period after the database has been provisioned.
3. From the Scheduled time for daily backup (UTC) drop-down, select the time window when the daily backup starts.
4. From the Scheduled time for incremental backup (UTC) drop-down, select the time window when the incremental backups start.
5. If you want to take your first backup immediately after your Oracle Base Database is created, select the Take the first backup immediately button.

Automatic Backup from the OCI Console

1. From the OCI console, select Oracle Base Database Service and then select the DB System that you are using, and then select the Databases tab. Optionally, select the compartment from applied filters.
   
   
   
   
2. From theDatabases tab, select the database that you are using.
   
   
   
   
3. From the Backup section of the Database Information tab, you can view the details of your automatic backup settings, such as Incremental backup schedule, Backup destination and Backup retention period.
   
   
   
   
4. From the More actions drop-down on Database Information tab, you can select Configure automatic backups option and turn on toggle for Enable automatic backups.
   
   
   
   
5. Adjust the configuration of automatic backups, then select the Save button to confirm.
   
   
   
   
6. From the Backups tab, you can view details of your backup such as State, Type, Backup destination, Encryption Key, Database version, Started and Ended.
   
   
   
   
7. You can also modify the automatic backups configuration by selecting the Actions button, then Configure automatic backups.
   
   
   
   
8. Adjust the configuration of automatic backups, then select the Save button to confirm.
   
   
   
   

Manual Backup (Standalone backup)

Standalone backups are Oracle Database backups stored in the same backup destination as the automatic backup destination selected during the configure automatic backups step. Standalone backups are not subject to automatic backup retention policies if backup destination is object storage. They are kept in the selected backup destination until you decide to delete them. Standalone backups are subject to automatic retention policies if backup destination is Autonomous Recovery Service

1. From the OCI console, select Oracle Base Database Service and then select the DB System that you are using, and then select the Databases tab. Optionally, select the compartment from applied filters.
   
   
   
   
2. From theDatabases tab, select the database that you are using.
   
   
   
   
3. Select the Backups tab, and then select the Create Backup button.
   
   
   
   
4. From the Create Backup page, complete the following substeps.
   1. Enter a Name for your backup.
   2. Select Backup retention Period between Retain backup per backup retention policy or Specify long-term backup retention period
   3. Select the Create button to complete the creation step.
      
      
      
      
   4. Return to the Backups tab within your Database system details to view the State of your backup. Once your backup is created, the state will change from Creating to Active.