This discussion is archived
3 Replies Latest reply: Dec 7, 2012 8:08 AM by 751522 RSS

RMAN Backup - List Copy command

751522 Newbie
Currently Being Moderated
OS - Windows 2008 R2
Oracle Version 11.2.0.3

Hi,
I am migating my test database from 10g to 11g. I am testing the RMAN (nocatalog) backup. I run a backup and do a 'List Copy' command and I get the following result :
specification does not match any control file copy in the repository List of Datafile Copies =======================

Key File S Completion Time Ckp SCN Ckp Time
------- ---- - ------------------- ---------- -------------------
45 1 A 2012-12-06 15:25:42 3985863946 2012-12-06 15:25:27
Name: P:\RMAN_T2KP_BACKUP_FILES\DATA_D-T2KP_I-3612607046_TS-SYSTEM_FNO-1_1UNS6JV7
Tag: TAG20121206T152146

46 2 A 2012-12-06 15:25:43 3985863944 2012-12-06 15:25:27
Name: P:\RMAN_T2KP_BACKUP_FILES\DATA_D-T2KP_I-3612607046_TS-SYSAUX_FNO-2_1SNS6JV7
Tag: TAG20121206T152146

27 3 A 2012-12-06 15:23:25 3985863725 2012-12-06 15:21:47
Name: P:\RMAN_T2KP_BACKUP_FILES\DATA_D-T2KP_I-3612607046_TS-UNDOTBS1_FNO-3_1HNS6JOB
Tag: TAG20121206T152146

47 4 A 2012-12-06 15:25:43 3985864013 2012-12-06 15:25:43
Name: P:\RMAN_T2KP_BACKUP_FILES\DATA_D-T2KP_I-3612607046_TS-USERS_FNO-4_25NS6JVN
Tag: TAG20121206T152146

37 5 A 2012-12-06 15:25:21 3985863889 2012-12-06 15:24:46
Name: P:\RMAN_T2KP_BACKUP_FILES\DATA_D-T2KP_I-3612607046_TS-T2_ESTACTTRANSDET_DATA_FNO-5_1NNS6JTU
Tag: TAG20121206T152146

31 6 A 2012-12-06 15:24:37 3985863820 2012-12-06 15:23:33
Name: P:\RMAN_T2KP_BACKUP_FILES\DATA_D-T2KP_I-3612607046_TS-T2_ESTREVDET_DATA_FNO-6_1JNS6JRL
Tag: TAG20121206T152146

38 7 A 2012-12-06 15:25:21 3985863897 2012-12-06 15:24:56
Name: P:\RMAN_T2KP_BACKUP_FILES\DATA_D-T2KP_I-3612607046_TS-T2_LARGE_DATA_FNO-7_1PNS6JU8
Tag: TAG20121206T152146

34 8 A 2012-12-06 15:24:54 3985863819 2012-12-06 15:23:32
Name: P:\RMAN_T2KP_BACKUP_FILES\DATA_D-T2KP_I-3612607046_TS-T2_LARGE_INDEX_FNO-8_1INS6JRK
Tag: TAG20121206T152146

28 9 A 2012-12-06 15:23:30 3985863724 2012-12-06 15:21:47
Name: P:\RMAN_T2KP_BACKUP_FILES\DATA_D-T2KP_I-3612607046_TS-T2_MED_DATA_FNO-9_1GNS6JOB
Tag: TAG20121206T152146

29 10 A 2012-12-06 15:23:54 3985863722 2012-12-06 15:21:47
Name: P:\RMAN_T2KP_BACKUP_FILES\DATA_D-T2KP_I-3612607046_TS-T2_MED_INDEX_FNO-10_1ENS6JOB
Tag: TAG20121206T152146

48 11 A 2012-12-06 15:25:44 3985864009 2012-12-06 15:25:42
Name: P:\RMAN_T2KP_BACKUP_FILES\DATA_D-T2KP_I-3612607046_TS-T2_MICRO_DATA_FNO-11_22NS6JVM
Tag: TAG20121206T152146

49 12 A 2012-12-06 15:25:44 3985864010 2012-12-06 15:25:43
Name: P:\RMAN_T2KP_BACKUP_FILES\DATA_D-T2KP_I-3612607046_TS-T2_MICRO_INDEX_FNO-12_23NS6JVN
Tag: TAG20121206T152146

42 13 A 2012-12-06 15:25:40 3985863947 2012-12-06 15:25:28
Name: P:\RMAN_T2KP_BACKUP_FILES\DATA_D-T2KP_I-3612607046_TS-T2_PETITE_DATA_FNO-13_1VNS6JV8
Tag: TAG20121206T152146

43 14 A 2012-12-06 15:25:41 3985863945 2012-12-06 15:25:27
Name: P:\RMAN_T2KP_BACKUP_FILES\DATA_D-T2KP_I-3612607046_TS-T2_PETITE_INDEX_FNO-14_1TNS6JV7
Tag: TAG20121206T152146

40 15 A 2012-12-06 15:25:23 3985863877 2012-12-06 15:24:38
Name: P:\RMAN_T2KP_BACKUP_FILES\DATA_D-T2KP_I-3612607046_TS-T2_SMALL_DATA_FNO-15_1MNS6JTM
Tag: TAG20121206T152146

39 16 A 2012-12-06 15:25:23 3985863861 2012-12-06 15:24:23
Name: P:\RMAN_T2KP_BACKUP_FILES\DATA_D-T2KP_I-3612607046_TS-T2_SMALL_INDEX_FNO-16_1LNS6JT7
Tag: TAG20121206T152146

33 17 A 2012-12-06 15:24:51 3985863835 2012-12-06 15:23:58
Name: P:\RMAN_T2KP_BACKUP_FILES\DATA_D-T2KP_I-3612607046_TS-T2_UPA_DATA_FNO-17_1KNS6JSE
Tag: TAG20121206T152146

30 18 A 2012-12-06 15:24:18 3985863723 2012-12-06 15:21:47
Name: P:\RMAN_T2KP_BACKUP_FILES\DATA_D-T2KP_I-3612607046_TS-T2_XLARGE_DATA_FNO-18_1FNS6JOB
Tag: TAG20121206T152146

32 19 A 2012-12-06 15:24:45 3985863721 2012-12-06 15:21:47
Name: P:\RMAN_T2KP_BACKUP_FILES\DATA_D-T2KP_I-3612607046_TS-T2_XLARGE_INDEX_FNO-19_1DNS6JOA
Tag: TAG20121206T152146

36 20 A 2012-12-06 15:25:19 3985863924 2012-12-06 15:25:11
Name: P:\RMAN_T2KP_BACKUP_FILES\DATA_D-T2KP_I-3612607046_TS-TALEAST_DATA_FNO-20_1QNS6JUN
Tag: TAG20121206T152146

44 21 A 2012-12-06 15:25:42 3985864005 2012-12-06 15:25:35
Name: P:\RMAN_T2KP_BACKUP_FILES\DATA_D-T2KP_I-3612607046_TS-TALEAST_INDEX_FNO-21_20NS6JVF
Tag: TAG20121206T152146

41 22 A 2012-12-06 15:25:34 3985863943 2012-12-06 15:25:27
Name: P:\RMAN_T2KP_BACKUP_FILES\DATA_D-T2KP_I-3612607046_TS-TALWEB_DATA_FNO-22_1RNS6JV7
Tag: TAG20121206T152146

51 23 A 2012-12-06 15:25:46 3985864008 2012-12-06 15:25:42
Name: P:\RMAN_T2KP_BACKUP_FILES\DATA_D-T2KP_I-3612607046_TS-TALWEB_INDEX_FNO-23_21NS6JVM
Tag: TAG20121206T152146

35 24 A 2012-12-06 15:25:04 3985863895 2012-12-06 15:24:53
Name: P:\RMAN_T2KP_BACKUP_FILES\DATA_D-T2KP_I-3612607046_TS-USER_DATA_FNO-24_1ONS6JU5
Tag: TAG20121206T152146

50 25 A 2012-12-06 15:25:44 3985864011 2012-12-06 15:25:43
Name: P:\RMAN_T2KP_BACKUP_FILES\DATA_D-T2KP_I-3612607046_TS-USER_INDEX_FNO-25_24NS6JVN
Tag: TAG20121206T152146

I would like to know the meaning of*
_'specification does not match any control file copy in the repository List of Datafile Copies'_
The backup seems to have run fine.
These are the commands:
RMAN> sql 'alter database backup controlfile to trace';
2> show all;
3> backup as copy database plus archivelog;
4> report obsolete;
5> host 'copy H:\oradata\arch\* H:\oradata\arch\BACKUP_ARCH\*';
6> delete obsolete;
7> list copy;
8>
sql statement: alter database backup controlfile to trace

RMAN configuration parameters for database with db_unique_name T2KP are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'p:\RMAN_T2KP_BACKUP_FILES\%F'; CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY PARALLELISM 5; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'p:\RMAN_T2KP_BACKUP_FILES\%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'P:\RMAN_T2KP_BACKUP_FILES\SNCFT2KP.ORA';

Thanks,
Vasudevan Kidambi
  • 1. Re: RMAN Backup - List Copy command
    Pavel Explorer
    Currently Being Moderated
    Hello

    try
    list backup ;
    regards,
    Pavel
  • 2. Re: RMAN Backup - List Copy command
    751522 Newbie
    Currently Being Moderated
    Thanks. I tried list backup;
    List of Backup Sets
    ===================


    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    2 Full 9.39M DISK 00:00:00 06-DEC-12
    BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20121206T152548
    Piece Name: P:\RMAN_T2KP_BACKUP_FILES\C-3612607046-20121206-01
    SPFILE Included: Modification time: 06-DEC-12
    SPFILE db_unique_name: T2KP
    Control File Included: Ckp SCN: 3985864028 Ckp time: 06-DEC-12

    I guess the message 'specification does not match any control file copy in the repository' means that the 'control file' copy is not included in the 'list copy;' command
    I was a little confused as the 10g does not give that message.
    Regards,
    Vasudevan Kidambi
  • 3. Re: RMAN Backup - List Copy command
    751522 Newbie
    Currently Being Moderated
    Thanks for answering the question.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points