our man in the sky

rman in the cloud.

We have started experimenting with the cloud backup module of rman (Oracle Recovery Manager). This module adds media management support for aws (Amazons Web Service), specifically the s3 storage service.

For all our databases (clients’ and our own) that run Oracle on 10g or higher we use recoverable image copies instead of backup sets (rman: backupset). We typically have one image copy set in +ASM that trails the database by n days, where n is the recovery window. In addition we have one image copy set on a filesystem (local or remote) that trails the database by less than a day (rman: until time “trunc(sysdate)”).

Our plan is to create backup sets on aws of the image copies once a week. Since the aws driver is a sbt (rman: tape) driver, there are certain restrictions. The most important is that we can only backup sets, not image copies.

According to the documentation (10gR2), the following are legal variations of the “backup … copy of …” command:

backup as copy copy of  database;
backup as backupset copy of tablespace tablespace_name;
backup as backupset copy of datafile datafile;

Based on the syntax diagrams, I am hoping I will be allowed to do:

backup as backupset copy of database;

Will let you know how it plays out.

Advertisement

Leave a Reply

Please log in using one of these methods to post your comment:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.