3 Replies Latest reply: Dec 7, 2012 8:08 AM by user10437625 RSS

    RMAN Backup - List Copy command

    user10437625
      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