Datasheet

Using RMAN with ASM

You can use RMAN in conjunction with ASM. In the following sections, we will cover the

following RMAN-related operations:

Copying database datafiles to an ASM disk with RMAN



Creating RMAN backups on ASM



Copying Database Datafiles to an ASM Disk with RMAN

If you want to move your entire database to ASM, you can easily do this with RMAN.

First you make an image copy of the database, copying it to an ASM disk group. Then use

the RMAN

switch database to copy command to switch the database from using the

old dataﬁles to using the new dataﬁles that were copied onto the ASM drives. Here is an

example of moving the database dataﬁles using the following commands:

RMAN>shutdown

RMAN>startup mount

RMAN>backup as copy database format ’+COOKED_DGROUP1’;

RMAN>switch database to copy;

RMAN>alter database open;

Creating RMAN Backups on ASM

RMAN backup sets can be made to ASM disks. This means that the database, archived redo

logs, control-ﬁle backups, and spﬁles can all be backed up to ASM disks. There are two dif-

ferent ways of using ASM for backups. You can send individual backups directly to an ASM

disk group, or you can deﬁne the ﬂash recovery area to be a disk group and cause backups to

be sent to the ﬂash recovery area. Let’s look at these two options in a bit more detail.

Backing Up from RMAN to ASM Directly

Backing up to an ASM disk group with RMAN is quite easy. Use the RMAN backup com-

mand and add the

format parameter indicating the disk group to which you want to back

up the database. Here is an example:

RMAN>backup as compressed backupset database format ’+COOKED_DGROUP1’;

You can also back up archived redo logs and database control ﬁles using RMAN via the

same method.

95134c01.indd 43 1/28/09 9:43:46 AM