Delete backup directories using RMAN

Query this table in order for you to see the platforms to which rman can convert your

SYS@EMR> select * from V$DB_TRANSPORTABLE_PLATFORM;

PLATFORM_ID PLATFORM_NAME                                                                                         ENDIAN_FORMAT
----------- ----------------------------------------------------------------------------------------------------- --------------
          7 Microsoft Windows IA (32-bit)                                                                         Little
         10 Linux IA (32-bit)                                                                                     Little
          5 HP Tru64 UNIX                                                                                         Little
         11 Linux IA (64-bit)                                                                                     Little
         15 HP Open VMS                                                                                           Little
          8 Microsoft Windows IA (64-bit)                                                                         Little
         13 Linux x86 64-bit                                                                                      Little
         12 Microsoft Windows x86 64-bit                                                                          Little
         17 Solaris Operating System (x86)                                                                        Little
         19 HP IA Open VMS                                                                                        Little
         20 Solaris Operating System (x86-64)                                                                     Little
         21 Apple Mac OS (x86-64)                                                                                 Little

Step by Step restore

• Connect to the target database using rman and backup the database - Source Node/ System

• copy following files to the Destination node ( backup pieces , control file backup and parameter file)

• Perform the modificaiton on destionation node to parameter file - PFILE

• Once the pfile is ready, set the environment parameter and connect to rman

• connect to target - start up the db no mount mode

• now restore the controlfile from the backup on destination node (which copied from source db )

Example :

restore controlfile from '/backup/file name'; 

once the restore is complete - mount the db.

• now main step is backup prices which you copied from the source db to destination db catalog themcatalog the backup pieces.

• Now, you need to recover the db - find he sequence number

  list backup of archivelog all;

• Rename the Redologfiles

  alter database rename file

• Now final step is you need to recover the db to the last sequence number

  Execute this series of statements:
  set until sequence 123456; -- sequence which you go previous. set newname for datafile 1 to '/node2/database/db1/system01.dbf'; -- data file paths modified

  restore database; 
  switch datafile all; 
  recover database; 
  alter database open resetlogs;
  

2 As a second approach this can be done using the Oracle Transportable Database - follow the link for great article form IBM guys !

Use crosscheck copy before deleting:

RMAN>crosscheck copy
RMAN>delete noprompt obsolete;

Crosscheck on it's own (without copy) doesn't do anything. You could also have done:

crosscheck backuppiece papcfat0_1_1