If you must move the OS file of an RMAN backup, moving it at the OS level is perfectly fine and will not in any way alter your ability to restore it, but RMAN must know where to find it.  So how do you tell RMAN about that file's new location?  Enter CATALOG BACKUPPIECE.  This command simply registers into the RMAN catalog (that is, the database's CONTROL FILES and possibly an RMAN Catalog database)

 

And there is no risk to register a backuppiece from another database, as RMAN warns you that this backuppiece does not belong to this one and gives you the SID of the database it comes from:

 

RMAN> CATALOG BACKUPPIECE 'V:\backup\fra\0TS0SMQB_1_1' ;

ORA-19870: erreur lors de la restauration de l'ÚlÚment de sauvegarde V:\BACKUP\FRA\0TS0SMQB_1_1

ORA-19691: V:\BACKUP\FRA\0TS0SMQB_1_1 provient d'une autre base de donnÚes : id=3682310869, nom=OTHERDB

 

Just in passing, you can also catalog an RMAN datafile copy: RMAN> CATALOG DATAFILECOPY 'D:\oradata\users01.dbf'; and ARCHIVE LOGs: RMAN> CATALOG ARCHIVELOG 'D:\archives\MYDB\ARC0000027304_0837506108.arc', 'D:\archives\MYDB\ARC0000027308_0837506108.arc';

 

But what if you have many backuppieces to register with RMAN?   Enter CATALOG RECOVERY AREA and CATALOG START WITH.

 

First, if you want to move many RMAN files into your Flash Recovery Area (FRA), do it at the OS level:

then run CATALOG RECOVERY AREA

 

RMAN will list the files it found the ask for your manual confirmation to catalog all of them:

The result can be of 3 kinds:

1. it will list the files that rightly belong to the current database and have been cataloged:

Voulez-vous vraiment cataloguer les fichiers ci-dessus (YES ou NO) ? yes

catalogage des fichiers...

catalogage terminÚ

 

Liste des fichiers cataloguÚs

=======================

Nom de fichier : V:\BACKUP\FRA\MYDB\B8S1KIFP_1_1

Nom de fichier : V:\BACKUP\FRA\MYDB\C-3960881722-20170405-00

Nom de fichier : V:\BACKUP\FRA\MYDB\C-3960881722-20170405-01

Nom de fichier : V:\BACKUP\FRA\WSVPHX\C-3960881722-20170406-00

 

2. It will list the files that are RMAN files but belong to other databases:

Liste des fichiers qui n'Útaient pas cataloguÚs

=======================================

Nom de fichier : V:\BACKUP\FRA\MYDB\0US0SMQI_1_1

  RMAN-07518: Cause : fichier de base de donnÚes ÚtrangÞre, DBID : 3682310869, nom de base de donnÚes : OTHERDB1

Nom de fichier : V:\BACKUP\FRA\MYDB\11S0TJ5K_1_1

  RMAN-07518: Cause : fichier de base de donnÚes ÚtrangÞre, DBID : 3682310869, nom de base de donnÚes : OTHERDB2

Nom de fichier : V:\BACKUP\FRA\MYDB\17S0TTN4_1_1

  RMAN-07518: Cause : fichier de base de donnÚes ÚtrangÞre, DBID : 3682310869, nom de base de donnÚes : OTHERDB1

 

3. it will list the files that cannot be cataloged:

La liste des fichiers dans la zone de rÚcupÚration n'est pas gÚrÚe par la base de donnÚes

==========================================================

Nom de fichier : V:\BACKUP\FRA\MYDB\B6S1KI7L_1_1

  RMAN-07526: Cause : ce fichier n'est pas un fichier Oracle Managed Files

Nom de fichier : V:\BACKUP\FRA\MYDB\F4S0SQRN_1_1

  RMAN-07526: Cause : ce fichier n'est pas un fichier Oracle Managed Files

le nombre de fichiers non gÚrÚs par la zone de rÚcupÚration est 2, totalisant 1.95GB

 

such as files that simply are not Oracle files:

Nom de fichier : V:\BACKUP\FRA\MYDB\JohnDoe.txt

  RMAN-07517: Cause : l'en-tÛte de fichier est endommagÚ

 

You can also use the same command with NOPROMPT:

and you will not be prompted to confirm you want the found files to be cataloged.

 

That was for CATALOG RECOVERY AREA, which is synonymous with CATALOG DB_RECOVERY_FILE_DEST (both commands behave exactly the same, with or without NOPROMPT).  But if you are moving your RMAN file to locations that are not your FRA, use CATALOG START WITH.

 

CATALOG START WITH will catalog all the files located in the specified directory and its subdirectories.  It will work as CATALOG RECOVERY AREA: first list the found files, then ask for your manual confirmation to catalog all these files, then give the same 3 kinds of results: cataloged, other DB, not Oracle.

On Windows with Oracle 11gR1, I have tested that these all behave the same:

catalog start with 'V:\backup\fra' ;      catalog start with 'V:\backup\fra\\' ;      catalog start with 'V:\backup\fra/' ;     catalog start with 'V:\backup\fra\' ;      catalog start with "V:\backup\fra/" ;      catalog start with "V:\backup\fra\" ;      catalog start with "V:\backup\fra" ;

 

The result is something like:

Voulez-vous vraiment cataloguer les fichiers ci-dessus (YES ou NO) ? yes

catalogage des fichiers...

catalogage terminÚ

 

Liste des fichiers cataloguÚs

=======================

Nom de fichier : V:\BACKUP\fra\F6S0SR4E_1_1

Nom de fichier : V:\BACKUP\fra\ICS0VFGC_1_1

Nom de fichier : V:\BACKUP\fra\MYDB\AUTOBACKUP\2017_04_18\O1_MF_S_941592559_DHBMYJ73_.BKP

Nom de fichier : V:\BACKUP\fra\MYDB\AUTOBACKUP\2017_04_18\O1_MF_S_941592586_DHBMZBW7_.BKP

...

Liste des fichiers qui n'Útaient pas cataloguÚs

=======================================

Nom de fichier : V:\BACKUP\fra\0TS0SMQB_1_1

  RMAN-07518: Cause : fichier de base de donnÚes ÚtrangÞre, DBID : 3682310869, nom de base de donnÚes : OTHERDB2

Nom de fichier : V:\BACKUP\fra\13S0TMM3_1_1

  RMAN-07518: Cause : fichier de base de donnÚes ÚtrangÞre, DBID : 3682310869, nom de base de donnÚes : OTHERDB1

...

Nom de fichier : V:\BACKUP\fra\WSVPHX\JohnDoe.txt

  RMAN-07517: Cause : l'en-tÛte de fichier est endommagÚ

 

Now, something important. With CATALOG BACKUPPIECE/ARCHIVELOG/CONTROLFILECOPY/DATAFILECOPY, CATALOG RECOVERY AREA and CATALOG START WITH, we have told RMAN that there are RMAN files in those new locations (typically, after moving those files there ourselves).  But RMAN has NOT been told that those files are NO LONGER in their ORIGINAL locations.  Indeed, RMAN will think there are 2 copies of each of those files we have moved then cataloged. Demontration with one RMAN backuppiece file.

 

With LIST BACKUP, I discover that a backuppiece is located where it should not be:

 

BS Key  Type LV Size       Device Type Elapsed Time Completion Time 

------- ---- -- ---------- ----------- ------------ -----------------

19635   Full    1016.32M   DISK        00:04:15     17-04-14 01:29:24

        BP Key: 19635   Status: AVAILABLE  Compressed: YES  Tag: SVG COMPLETE

        Piece Name: C:\ORACLE\ORA112\DATABASE\B6S1KI7L_1_1

  Liste des fichiers de données dans l'ensemble de sauvegarde 19635

  File LV Type Ckp SCN    Ckp Time          Name

  ---- -- ---- ---------- ----------------- ----

  1       Full 622954959  17-04-14 01:25:10 C:\ORACLE\ORADATA\MYDB\SYSTEM01.DBF

  2       Full 622954959  17-04-14 01:25:10 C:\ORACLE\ORADATA\MYDB\SYSAUX01.DBF

 

So I want to move that B6S1KI7L_1_1 file to my FRA and notify RMAN of that change:

First move the file at the OS level, then, in RMAN:

RMAN> CATALOG START WITh 'V:\BACKUP\FRA' ;

recherche de tous les fichiers correspondant au modèle V:\backup\fra\

Liste des fichiers inconnus de la base de données

=====================================

Nom de fichier : V:\BACKUP\FRA\B6S1KI7L_1_1

Voulez-vous vraiment cataloguer les fichiers ci-dessus (YES ou NO) ? catalogage des fichiers...

catalogage terminé

Liste des fichiers catalogués

=======================

Nom de fichier : V:\BACKUP\FRA\B6S1KI7L_1_1

 

Now let's look at the details of that backuppiece:

RMAN> LIST BACKUPPIECE 19635 ;

Liste des ensembles de sauvegarde

===================

BS Key  Type LV Size

------- ---- -- ----------

19635  Full    1016.32M

  Liste des fichiers de données dans l'ensemble de sauvegarde 19635

  File LV Type Ckp SCN    Ckp Time          Name

  ---- -- ---- ---------- ----------------- ----

1       Full 622954959  17-04-14 01:25:10 C:\ORACLE\ORADATA\MYDB\SYSTEM01.DBF

  2       Full 622954959  17-04-14 01:25:10 C:\ORACLE\ORADATA\MYDB\SYSAUX01.DBF

  3       Full 622954959  17-04-14 01:25:10 C:\ORACLE\ORADATA\MYDB\UNDOTBS01.DBF

  4       Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\USERS01.DBF

  5       Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\DATA01.DBF

  6       Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\DATA02.DBF

  7       Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\DATA03.DBF

  8       Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\INDX01.DBF

  9       Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\INDX02.DBF

  10      Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\INDX03.DBF

  11      Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\LOB_S_01.DBF

  12      Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\LOB_B_01.DBF

  13      Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\TOOLS_01.DBF

  Backup Set Copy #1 of backup set 19635

  Device Type Elapsed Time Completion Time   Compressed Tag

  ----------- ------------ ----------------- ---------- ---

  DISK        00:04:15     17-04-14 01:29:24 YES        SVG COMPLETE

    Liste des éléments de sauvegarde pour l'ensemble de sauvegarde 19635, Copie #1

    BP Key  Pc# Status      Piece Name

    ------- --- ----------- ----------

    19635   1   AVAILABLE  C:\ORACLE\ORA112\DATABASE\B6S1KI7L_1_1

 

  Backup Set Copy #2 of backup set 19635

  Device Type Elapsed Time Completion Time   Compressed Tag

  ----------- ------------ ----------------- ---------- ---

  DISK        00:04:15     17-04-20 20:10:23 YES        SVG COMPLETE

    Liste des éléments de sauvegarde pour l'ensemble de sauvegarde 19635, Copie #2

    BP Key  Pc# Status      Piece Name

    ------- --- ----------- ----------

    19773   1   AVAILABLE  V:\BACKUP\FRA\B6S1KI7L_1_1

 

AARGH! RMAN thinks there are 2 copies of backupiece 19635 (one at the old location, one at the new location), and both are listed as available (when only the one in the new location is available).  So let's tell RMAN to harmonize what is at at the OS level and in its catalog. To do so we can use CROSSCHECK BACKUP or CROSSCHECK BACKUPPIECE (other options are CROSSCHECK COPY, CROSSCHECK BACKUPSET, CROSSCHECK CONTROLFILECOPY, CROSSCHECK DATAFILECOPY, CROSSCHECK ARCHIVELOG.  You can apply filters such as CROSSCHECK BACKUP OF DATABASE COMPLETED AFTER 'SYSDATE-4/24'; ). CROSSCHECK will go throught the files that match the given criteria and check whether they are found at the OS level where RMAN thinks they are. Those that are found at the location known by RMAN will be marked as available, those that are not found there will be marked as EXPIRED.

 

RMAN>  CROSSCHECK BACKUP ;

canal affecté : ORA_DISK_1

canal ORA_DISK_1 : SID=245 type d'unité=DISK

élément de sauvegarde vérifié : repéré comme étant 'EXPIRED'

descripteur d'élément de sauvegarde=C:\ORACLE\ORA112\DATABASE\B6S1KI7L_1_1 RECID=19635 STAMP=941246710

élément de sauvegarde vérifié : repéré comme étant 'AVAILABLE'

descripteur d'élément de sauvegarde=V:\BACKUP\FRA\B6S1KI7L_1_1 RECID=19773 STAMP=941812809

élément de sauvegarde vérifié : repéré comme étant 'AVAILABLE'

descripteur d'élément de sauvegarde=C:\ORACLE\ORA112\DATABASE\C-3960881722-20170414-00 RECID=19636 STAMP=941246966

élément de sauvegarde vérifié : repéré comme étant 'AVAILABLE'

descripteur d'élément de sauvegarde=C:\ORACLE\ORA112\DATABASE\B8S1KIFP_1_1 RECID=19637 STAMP=941246969

élément de sauvegarde vérifié : repéré comme étant 'AVAILABLE'

descripteur d'élément de sauvegarde=C:\ORACLE\ORA112\DATABASE\C-3960881722-20170414-01 RECID=19638 STAMP=941246981

...

 

I could also have just run CROSSCHECK BACKUPPIECE 19635   ;

 

So now, RMAN knows that one of my 2 copies is EXPIRED:

 

RMAN> LIST BACKUPPIECE 19635 ;

Liste des ensembles de sauvegarde

===================

BS Key  Type LV Size

------- ---- -- ----------

19635   Full    1016.32M

  Liste des fichiers de données dans l'ensemble de sauvegarde 19635

  File LV Type Ckp SCN    Ckp Time          Name

  ---- -- ---- ---------- ----------------- ----

  1       Full 622954959  17-04-14 01:25:10 C:\ORACLE\ORADATA\MYDB\SYSTEM01.DBF

  2       Full 622954959  17-04-14 01:25:10 C:\ORACLE\ORADATA\MYDB\SYSAUX01.DBF

  3       Full 622954959  17-04-14 01:25:10 C:\ORACLE\ORADATA\MYDB\UNDOTBS01.DBF

  4       Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\USERS01.DBF

  5       Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\DATA01.DBF

  6       Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\DATA02.DBF

  7       Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\DATA03.DBF

  8       Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\INDX01.DBF

  9       Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\INDX02.DBF

  10      Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\INDX03.DBF

  11      Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\LOB_S_01.DBF

  12      Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\LOB_B_01.DBF

  13      Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\TOOLS_01.DBF

  Backup Set Copy #1 of backup set 19635

  Device Type Elapsed Time Completion Time   Compressed Tag

  ----------- ------------ ----------------- ---------- ---

  DISK        00:04:15     17-04-14 01:29:24 YES        SVG COMPLETE

    Liste des éléments de sauvegarde pour l'ensemble de sauvegarde 19635, Copie #1

    BP Key  Pc# Status      Piece Name

    ------- --- ----------- ----------

    19635   1   EXPIRED    C:\ORACLE\ORA112\B6S1KI7L_1_1

  Backup Set Copy #2 of backup set 19635

  Device Type Elapsed Time Completion Time   Compressed Tag

  ----------- ------------ ----------------- ---------- ---

  DISK        00:04:15     17-04-20 20:10:23 YES        SVG COMPLETE

    Liste des éléments de sauvegarde pour l'ensemble de sauvegarde 19635, Copie #2

    BP Key  Pc# Status      Piece Name

    ------- --- ----------- ----------

    19773   1   AVAILABLE   V:\BACKUP\FRA\B6S1KI7L_1_1

 

So next time I run DELETE EXPIRED, that EXPIRED copy will no longer appear in RMAN

 

RMAN> DELETE EXPIRED BACKUP ;

utilisation du canal ORA_DISK_1

Liste des ÚlÚments de sauvegarde

BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name

------- ------- --- --- ----------- ----------- ----------

19635   19635   1   1   EXPIRED     DISK        C:\ORACLE\ORA112\DATABASE\B6S1KI7L_1_1

Voulez-vous vraiment supprimer les objets ci-dessus (YES ou NO) ? yes

ÚlÚment de sauvegarde supprimÚ

descripteur d'ÚlÚment de sauvegarde=C:\ORACLE\ORA112\DATABASE\B6S1KI7L_1_1 RECID=19635 STAMP=941246710

1 objets EXPIRED supprimÚs

 

So now let's list BACKUPSET 19635:

 

RMAN> LIST BACKUPset 19635 ;

Liste des ensembles de sauvegarde

===================

BS Key  Type LV Size

------- ---- -- ----------

19635   Full    1016.32M

  Liste des fichiers de donnÚes dans l'ensemble de sauvegarde 19635

  File LV Type Ckp SCN    Ckp Time          Name

  ---- -- ---- ---------- ----------------- ----

1       Full 622954959  17-04-14 01:25:10 C:\ORACLE\ORADATA\MYDB\SYSTEM01.DBF

  2       Full 622954959  17-04-14 01:25:10 C:\ORACLE\ORADATA\MYDB\SYSAUX01.DBF

  3       Full 622954959  17-04-14 01:25:10 C:\ORACLE\ORADATA\MYDB\UNDOTBS01.DBF

  4       Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\USERS01.DBF

  5       Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\DATA01.DBF

  6       Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\DATA02.DBF

  7       Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\DATA03.DBF

  8       Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\INDX01.DBF

  9       Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\INDX02.DBF

  10      Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\INDX03.DBF

  11      Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\LOB_S_01.DBF

  12      Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\LOB_B_01.DBF

  13      Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\TOOLS_01.DBF

  Backup Set Copy #3 of backup set 19635

  Device Type Elapsed Time Completion Time   Compressed Tag

  ----------- ------------ ----------------- ---------- ---

  DISK        00:04:15     17-04-20 22:28:00 YES        SVG COMPLETE

    Liste des ÚlÚments de sauvegarde pour l'ensemble de sauvegarde 19635, Copie #3

    BP Key  Pc# Status      Piece Name

    ------- --- ----------- ----------

    19784   1   AVAILABLE   V:\BACKUP\FRA\B6S1KI7L_1_1

  Backup Set Copy #4 of backup set 19635

  Device Type Elapsed Time Completion Time   Compressed Tag

  ----------- ------------ ----------------- ---------- ---

  DISK        00:04:15     17-04-20 22:52:54 YES        SVG COMPLETE

    Liste des ÚlÚments de sauvegarde pour l'ensemble de sauvegarde 19635, Copie #4

    BP Key  Pc# Status      Piece Name

    ------- --- ----------- ----------

    19821   1   AVAILABLE   V:\BACKUP\FRA\B6S1KI7L_1_1

  Backup Set Copy #2 of backup set 19635

  Device Type Elapsed Time Completion Time   Compressed Tag

  ----------- ------------ ----------------- ---------- ---

  DISK        00:04:15     17-04-20 20:10:23 YES        SVG COMPLETE

    Liste des ÚlÚments de sauvegarde pour l'ensemble de sauvegarde 19635, Copie #2

    BP Key  Pc# Status      Piece Name

    ------- --- ----------- ----------

    19773   1   AVAILABLE   V:\BACKUP\FRA\B6S1KI7L_1_1

 

BackupPIECE 19635 is no longer listed.  However, I can see 3 copies of backupSET 19635, with different backupPIECE keys. These 3 copies are the results of my various CATALOG commands (CATALOG BACKUPPIECE, CATALOG START WITH etc.).  Each time a CATALOG command found an RMAN file belong to the current database, it registed a new copy of it. I can easily delete those extra copies with the DELETE BACKUPPIECE command:

RMAN> DELETE BACKUPPIECE 19773 ;

utilisation du canal ORA_DISK_1

Liste des ÚlÚments de sauvegarde

BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name

------- ------- --- --- ----------- ----------- ----------

19773   19635   1   2   AVAILABLE   DISK        V:\BACKUP\FRA\B6S1KI7L_1_1

Voulez-vous vraiment supprimer les objets ci-dessus (YES ou NO) ? yes

ÚlÚment de sauvegarde supprimÚ

descripteur d'ÚlÚment de sauvegarde=V:\BACKUP\FRA\B6S1KI7L_1_1 RECID=19773 STAMP=941812809

1 objets supprimÚs

 

And now, I have 2 copies left only:

RMAN> LIST BACKUPset 19635 ;

Liste des ensembles de sauvegarde

===================

BS Key  Type LV Size

------- ---- -- ----------

19635   Full    1016.32M

  Liste des fichiers de donnÚes dans l'ensemble de sauvegarde 19635

  File LV Type Ckp SCN    Ckp Time          Name

  ---- -- ---- ---------- ----------------- ----

1       Full 622954959  17-04-14 01:25:10 C:\ORACLE\ORADATA\MYDB\SYSTEM01.DBF

  2       Full 622954959  17-04-14 01:25:10 C:\ORACLE\ORADATA\MYDB\SYSAUX01.DBF

  3       Full 622954959  17-04-14 01:25:10 C:\ORACLE\ORADATA\MYDB\UNDOTBS01.DBF

  4       Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\USERS01.DBF

  5       Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\DATA01.DBF

  6       Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\DATA02.DBF

  7       Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\DATA03.DBF

  8       Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\INDX01.DBF

  9       Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\INDX02.DBF

  10      Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\INDX03.DBF

  11      Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\LOB_S_01.DBF

  12      Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\LOB_B_01.DBF

  13      Full 622954959  17-04-14 01:25:10 D:\ORACLE\ORA112\ORADATA\MYDB\TOOLS_01.DBF

  Backup Set Copy #4 of backup set 19635

  Device Type Elapsed Time Completion Time   Compressed Tag

  ----------- ------------ ----------------- ---------- ---

  DISK        00:04:15     17-04-20 22:52:54 YES        SVG COMPLETE

    Liste des ÚlÚments de sauvegarde pour l'ensemble de sauvegarde 19635, Copie #4

    BP Key  Pc# Status      Piece Name

    ------- --- ----------- ----------

    19821   1   AVAILABLE   V:\BACKUP\FRA\WSVPHX\B6S1KI7L_1_1

  Backup Set Copy #3 of backup set 19635

  Device Type Elapsed Time Completion Time   Compressed Tag

  ----------- ------------ ----------------- ---------- ---

  DISK        00:04:15     17-04-20 22:28:00 YES        SVG COMPLETE

    Liste des ÚlÚments de sauvegarde pour l'ensemble de sauvegarde 19635, Copie #3

    BP Key  Pc# Status      Piece Name

    ------- --- ----------- ----------

    19784   1   AVAILABLE   V:\BACKUP\FRA\WSVPHX\B6S1KI7L_1_1

 

To sum up:

  1. first move your RMAN files at the OS level. Don't be afraid to move files that do not pertain to your DB: RMAN will detect them.
  2. Run CATALOG START WITH 'newlocation' or CATALOG DB_RECOVERY_FILE_DEST to tell RMAN about the new location
  3. run CROSSCHECK for RMAN to list any file not found at the OS level as EXPIRED
  4. run DELETE EXPIRED to remove any mention of the old location from the RMAN catalog.