SQL> alter system set db_recovery_file_dest_size = 20g;
System altered.
SQL> alter system set db_recovery_file_dest = '+FRA';
System altered.
SQL> alter database open;
Database altered.
oracle@rac01{MYDBA1}/apps/oracle> rman target /
RMAN> backup database plus archivelog delete input;
Starting backup at 30-MAY-11
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=28 instance=MYDBA1 device type=DISK
…
piece handle=+FRA/mydba/backupset/2011_05_30/annnf0_tag20110530t221427_0.320.752537669 tag=TAG20110530T221427 comment=NONE
…
piece handle=+FRA/mydba/backupset/2011_05_30/nnndf0_tag20110530t221430_0.318.752537671 tag=TAG20110530T221430 comment=NONE
…
piece handle=+FRA/mydba/backupset/2011_05_30/ncsnf0_tag20110530t221430_0.319.752537717 tag=TAG20110530T221430 comment=NONE
…
piece handle=+FRA/mydba/backupset/2011_05_30/annnf0_tag20110530t221520_0.322.752537721 tag=TAG20110530T221520 comment=NONE
Finished backup at 30-MAY-11
RMAN> list backup;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1 51.25M DISK 00:00:01 30-MAY-11
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20110530T221427
Piece Name: +FRA/mydba/backupset/2011_05_30/annnf0_tag20110530t221427_0.320.752537669
List of Archived Logs in backup set 1
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 370 21024735 30-MAY-11 21065551 30-MAY-11
2 348 21058468 30-MAY-11 21064126 30-MAY-11
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 1.52G DISK 00:00:44 30-MAY-11
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20110530T221430
Piece Name: +FRA/mydba/backupset/2011_05_30/nnndf0_tag20110530t221430_0.318.752537671
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 21065563 30-MAY-11 +DATA/mydba/datafile/system.256.724854319
2 Full 21065563 30-MAY-11 +DATA/mydba/datafile/sysaux.257.724854321
3 Full 21065563 30-MAY-11 +DATA/mydba/datafile/undotbs1.258.724854323
4 Full 21065563 30-MAY-11 +DATA/mydba/datafile/users.259.724854323
5 Full 21065563 30-MAY-11 +DATA/mydba/datafile/undotbs2.264.724854533
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 17.70M DISK 00:00:01 30-MAY-11
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20110530T221430
Piece Name: +FRA/mydba/backupset/2011_05_30/ncsnf0_tag20110530t221430_0.319.752537717
SPFILE Included: Modification time: 30-MAY-11
SPFILE db_unique_name: MYDBA
Control File Included: Ckp SCN: 21065725 Ckp time: 30-MAY-11
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
4 8.00K DISK 00:00:01 30-MAY-11
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20110530T221520
Piece Name: +FRA/mydba/backupset/2011_05_30/annnf0_tag20110530t221520_0.322.752537721
List of Archived Logs in backup set 4
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 371 21065551 30-MAY-11 21065731 30-MAY-11
RMAN> backup backupset 1,2,3,4 format '/oracle/backup/testrman/%U';
è this command is to backup the backupsets from ASM ‘+FRA’ to file system /data/backup/testrman
…
+FRA/mydba/backupset/2011_05_30/annnf0_tag20110530t221427_0.320.752537669
piece handle=/oracle/backup/testrman/01mdlk23_1_2 comment=NONE
…
+FRA/mydba/backupset/2011_05_30/nnndf0_tag20110530t221430_0.318.752537671
piece handle=/oracle/backup/testrman/02mdlk26_1_2 comment=NONE
…
+FRA/mydba/backupset/2011_05_30/ncsnf0_tag20110530t221430_0.319.752537717
piece handle=/oracle/backup/testrman/03mdlk3k_1_2 comment=NONE
channel ORA_DISK_1: finished piece 1 at 30-MAY-11
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:01
…
+FRA/mydba/backupset/2011_05_30/annnf0_tag20110530t221520_0.322.752537721
piece handle=/oracle/backup/testrman/04mdlk3o_1_2 comment=NONE
channel ORA_DISK_1: finished piece 1 at 30-MAY-11
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:01
Finished backup at 30-MAY-11
RMAN> backup spfile include current controlfile format '/oracle/backup/testrman/source_ctl';
…
piece handle=/oracle/backup/testrman/source_ctl tag=TAG20110530T222524 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 30-MAY-11
Then you can copy these backup pieces to a new server and restore the database on file system. You will need to restore spfile from the source backup and create spfile from pfile. You need to modify the pfile for these parameters (control_files, db_create_file_dest, db_file_name_convert, log_file_name_convert, undo_tablespace) . After that, you can restore control file, restore database, recover database until cancel using backup controlfile, and open database resetlogs.
