Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"switch datafile" returns "RMAN-06015"

ozoracleJul 18 2011 — edited Jul 19 2011

Hi,

I'm facing a strange error.

I'm trying to restore a database from a cold backupsets created by RMAN into a new machine.

My restore commands returns "RMAN-06015" when it tries to execute "switch datafile" command.

RMAN> run{
2> set newname for datafile
3> 'E:\ORACLE\PRODUCT\10.1.0\ORADATA\DAWA\UNDOTBS201' TO
4> 'D:\oracle\oradata\dawa\UNDOTBS201';
5> switch datafile all;
6> }

executing command: SET NEWNAME

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of switch command at 07/19/2011 11:36:55
RMAN-20230: datafile copy not found in the recovery catalog
RMAN-06015: error while looking up datafilecopy name: D:\ORACLE\ORADATA\DAWA\UNDOTBS201

The file D:\ORACLE\ORADATA\DAWA\UNDOTBS201 doesn't exist in the production.
It doesn't exist in the controlfile either. I made a bakup of the control file into the trace folder and checked the generated file. That file doesn't exist overthere.

It isn't part of the backupset either.

RMAN> list backup of tablespace undotbs2 ;

List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
780     Full    1M         DISK        00:26:37     06-JUL-11
        BP Key: 780   Status: EXPIRED  Compressed: NO  Tag: FULLDB
        Piece Name: \\PRODSERVER\DBBACKUPS\PLMGPUNM_1_1
  List of Datafiles in backup set 780
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  117     Full 24338668495 06-JUL-11 E:\ORACLE\PRODUCT\10.1.0\ORADATA\DAWA\UNDOTBS201
  119     Full 24338668495 06-JUL-11 E:\ORACLE\PRODUCT\10.1.0\ORADATA\DAWA\UNDOTBS203
  121     Full 24338668495 06-JUL-11 E:\ORACLE\PRODUCT\10.1.0\ORADATA\DAWA\UNDOTBS205

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
781     Full    128K       DISK        00:27:54     07-JUL-11
        BP Key: 781   Status: EXPIRED  Compressed: NO  Tag: FULLDB
        Piece Name: \\PRODSERVER\DBBACKUPS\PMMGQ09T_1_1
  List of Datafiles in backup set 781
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  118     Full 24338668495 06-JUL-11 E:\ORACLE\PRODUCT\10.1.0\ORADATA\DAWA\UNDOTBS202
  120     Full 24338668495 06-JUL-11 E:\ORACLE\PRODUCT\10.1.0\ORADATA\DAWA\UNDOTBS204

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
783     Full    22G        DISK        00:33:07     09-JUL-11
        BP Key: 783   Status: EXPIRED  Compressed: NO  Tag: FULLDB09072011
        Piece Name: \\PRODSERVER\DBBACKUPS\PQMH1JNA_1_1
  List of Datafiles in backup set 783
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 24380946158 09-JUL-11 E:\ORACLE\PRODUCT\10.1.0\ORADATA\DAWA\UNDOTBS206
  53      Full 24380946158 09-JUL-11 E:\ORACLE\PRODUCT\10.1.0\ORADATA\DAWA\UNDOTBS207
  118     Full 24380946158 09-JUL-11 E:\ORACLE\PRODUCT\10.1.0\ORADATA\DAWA\UNDOTBS202
  119     Full 24380946158 09-JUL-11 E:\ORACLE\PRODUCT\10.1.0\ORADATA\DAWA\UNDOTBS203
  120     Full 24380946158 09-JUL-11 E:\ORACLE\PRODUCT\10.1.0\ORADATA\DAWA\UNDOTBS204

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
784     Full    13G        DISK        00:28:33     09-JUL-11
        BP Key: 784   Status: EXPIRED  Compressed: NO  Tag: FULLDB09072011
        Piece Name: \\PRODSERVER\DBBACKUPS\PRMH1LLN_1_1
  List of Datafiles in backup set 784
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  54      Full 24380946158 09-JUL-11 E:\ORACLE\PRODUCT\10.1.0\ORADATA\DAWA\UNDOTBS208
  117     Full 24380946158 09-JUL-11 E:\ORACLE\PRODUCT\10.1.0\ORADATA\DAWA\UNDOTBS201
  121     Full 24380946158 09-JUL-11 E:\ORACLE\PRODUCT\10.1.0\ORADATA\DAWA\UNDOTBS205

BS Key  Type LV Size
------- ---- -- ----------
786     Full    28G
  List of Datafiles in backup set 786
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 24470026732 16-JUL-11 E:\ORACLE\PRODUCT\10.1.0\ORADATA\DAWA\UNDOTBS206
  53      Full 24470026732 16-JUL-11 E:\ORACLE\PRODUCT\10.1.0\ORADATA\DAWA\UNDOTBS207
  118     Full 24470026732 16-JUL-11 E:\ORACLE\PRODUCT\10.1.0\ORADATA\DAWA\UNDOTBS202
  119     Full 24470026732 16-JUL-11 E:\ORACLE\PRODUCT\10.1.0\ORADATA\DAWA\UNDOTBS203
  121     Full 24470026732 16-JUL-11 E:\ORACLE\PRODUCT\10.1.0\ORADATA\DAWA\UNDOTBS205

  Backup Set Copy #1 of backup set 786
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:31:39     16-JUL-11       NO         TAG20110716T135920

    List of Backup Pieces for backup set 786 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    786     1   UNAVAILABLE \\PRODSERVER\DBBACKUPS\PTMHJ91Q_1_1

  Backup Set Copy #2 of backup set 786
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:31:39     19-JUL-11       NO         TAG20110716T135920

    List of Backup Pieces for backup set 786 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    789     1   AVAILABLE   X:\TEMP\PTMHJ91Q_1_1

BS Key  Type LV Size
------- ---- -- ----------
787     Full    17G
  List of Datafiles in backup set 787
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  54      Full 24470026732 16-JUL-11 E:\ORACLE\PRODUCT\10.1.0\ORADATA\DAWA\UNDOTBS208
  117     Full 24470026732 16-JUL-11 E:\ORACLE\PRODUCT\10.1.0\ORADATA\DAWA\UNDOTBS201
  120     Full 24470026732 16-JUL-11 E:\ORACLE\PRODUCT\10.1.0\ORADATA\DAWA\UNDOTBS204

  Backup Set Copy #1 of backup set 787
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:29:36     16-JUL-11       NO         TAG20110716T135920

    List of Backup Pieces for backup set 787 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    787     1   UNAVAILABLE \\PRODSERVER\DBBACKUPS\PUMHJATD_1_1

  Backup Set Copy #2 of backup set 787
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:29:36     19-JUL-11       NO         TAG20110716T135920

    List of Backup Pieces for backup set 787 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    788     1   AVAILABLE   X:\TEMP\PUMHJATD_1_1

In OS level, logged on user has access privileges:

D:\>copy d:\temp\test.log D:\ORACLE\ORADATA\DAWA\UNDOTBS201.txt
        1 file(s) copied.

What should I do to get rid of that error?

Oracle 10g R1 on Windows 2003 32-bit

This post has been answered by 585179 on Jul 18 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 15 2011

Added on Jul 18 2011

#general-database-discussions

2 comments

3,304 views