Solved

RMAN-06024 during clone database

Posted on 2011-09-11
4
1,910 Views
Last Modified: 2012-05-12
Apologies in advance for the long post, trying to get all the information here at the start.

I am currently working with a pre production system configuring backups.  The database was created by someone else and backups were handed to me to setup.

Backups all appear to be working correctly, but I'm having no end of trouble restoring from them.  A backup that you can't restore is worthless.

So, here's my story.

OS: Windows Server 2008 R2 Enterprise 64 Bit
DB: oracle 11.2.0.2

Trying to test the backup of the database we'll call PROD to a clone database I'll call TEMP, to be restored to the same server.  
(I know TEMP is a reserved word, but it wasn't the actual name used so we can rule out any conflicts there)

Logs are what came out of the processes, with just database and identifiable information altered.

I first put the PROD DB into Archive Log Mode (it's running NOARCHIVELOG usually during pre-prod).
Autobackup of Controlfile is on.

alter system switch logfile executed at 8:15 PM

I ran the following backup through RMAN:

Backup Log:
==========
Recovery Manager: Release 11.2.0.2.0 - Production on Sun Sep 11 20:16:22 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PROD (DBID=747725684)

RMAN> backup check logical database plus archivelog not backed up;
2> backup current controlfile;
3> delete noprompt obsolete;
4> sql "alter database backup controlfile to trace as ''e:\oracle\backups\prod\ctl\controlPROD.txt'' reuse";
5> sql "create pfile=''e:\oracle\backups\prod\ctl\initPROD.txt'' from spfile";
6> backup validate database archivelog all;
7> restore database validate;
8> crosscheck backup;
9> delete noprompt expired backup;
10> 

Starting backup at 11-SEP-11
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=134 device type=DISK
skipping archived log file E:\ORACLE\FAST_RECOVERY_AREA\PROD\ARCHIVELOG\2011_09_11\O1_MF_1_42_76TMR507_.ARC; already backed on 11-SEP-11
skipping archived log file D:\ORACLE\FAST_RECOVERY_AREA\PROD\ARCHIVELOG\ARC0000000042_0761362122.0001; already backed on 11-SEP-11
skipping archived log file E:\ORACLE\FAST_RECOVERY_AREA\PROD\ARCHIVELOG\2011_09_11\O1_MF_1_43_76TMRR55_.ARC; already backed on 11-SEP-11
skipping archived log file D:\ORACLE\FAST_RECOVERY_AREA\PROD\ARCHIVELOG\ARC0000000043_0761362122.0001; already backed on 11-SEP-11
skipping archived log file E:\ORACLE\FAST_RECOVERY_AREA\PROD\ARCHIVELOG\2011_09_11\O1_MF_1_44_76TNK57J_.ARC; already backed on 11-SEP-11
skipping archived log file D:\ORACLE\FAST_RECOVERY_AREA\PROD\ARCHIVELOG\ARC0000000044_0761362122.0001; already backed on 11-SEP-11
skipping archived log file E:\ORACLE\FAST_RECOVERY_AREA\PROD\ARCHIVELOG\2011_09_11\O1_MF_1_45_76TOJ8QP_.ARC; already backed on 11-SEP-11
skipping archived log file D:\ORACLE\FAST_RECOVERY_AREA\PROD\ARCHIVELOG\ARC0000000045_0761362122.0001; already backed on 11-SEP-11
skipping archived log file E:\ORACLE\FAST_RECOVERY_AREA\PROD\ARCHIVELOG\2011_09_11\O1_MF_1_46_76TOM50G_.ARC; already backed on 11-SEP-11
skipping archived log file D:\ORACLE\FAST_RECOVERY_AREA\PROD\ARCHIVELOG\ARC0000000046_0761362122.0001; already backed on 11-SEP-11
skipping archived log file E:\ORACLE\FAST_RECOVERY_AREA\PROD\ARCHIVELOG\2011_09_11\O1_MF_1_47_76TON3PT_.ARC; already backed on 11-SEP-11
skipping archived log file D:\ORACLE\FAST_RECOVERY_AREA\PROD\ARCHIVELOG\ARC0000000047_0761362122.0001; already backed on 11-SEP-11
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=48 RECID=33 STAMP=761602031
input archived log thread=1 sequence=49 RECID=35 STAMP=761602543
input archived log thread=1 sequence=50 RECID=37 STAMP=761602583
channel ORA_DISK_1: starting piece 1 at 11-SEP-11
channel ORA_DISK_1: finished piece 1 at 11-SEP-11
piece handle=E:\ORACLE\FAST_RECOVERY_AREA\PROD\RMAN\1BMMA8GO_1_1 tag=TAG20110911T201624 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 11-SEP-11

Starting backup at 11-SEP-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=D:\ORACLE\ORADATA\PROD\UNDOTBS01.DBF
input datafile file number=00005 name=D:\ORACLE\ORADATA\PROD\TABLES\PRD_TABMSF_01.DBF
input datafile file number=00006 name=D:\ORACLE\ORADATA\PROD\TABLES\PRD_TABMSF_02.DBF
input datafile file number=00007 name=D:\ORACLE\ORADATA\PROD\TABLES\PRD_TABMSF_03.DBF
input datafile file number=00008 name=D:\ORACLE\ORADATA\PROD\TABLES\PRD_TABMSF_04.DBF
input datafile file number=00009 name=D:\ORACLE\ORADATA\PROD\TABLES\PRD_TABMSF_05.DBF
input datafile file number=00010 name=D:\ORACLE\ORADATA\PROD\TABLES\PRD_TABMSF_06.DBF
input datafile file number=00011 name=D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMSF_01.DBF
input datafile file number=00012 name=D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMSF_02.DBF
input datafile file number=00013 name=D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMSF_03.DBF
input datafile file number=00014 name=D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMSF_04.DBF
input datafile file number=00015 name=D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMSF_05.DBF
input datafile file number=00016 name=D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMSF_06.DBF
input datafile file number=00017 name=D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMSF_07.DBF
input datafile file number=00018 name=D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMSF_08.DBF
input datafile file number=00019 name=D:\ORACLE\ORADATA\PROD\LOB\PRD_LOBMSF.DBF
input datafile file number=00001 name=D:\ORACLE\ORADATA\PROD\SYSTEM01.DBF
input datafile file number=00002 name=D:\ORACLE\ORADATA\PROD\SYSAUX01.DBF
input datafile file number=00020 name=D:\ORACLE\ORADATA\PROD\TABLES\PRD_TABMER_01.DBF
input datafile file number=00023 name=D:\ORACLE\ORADATA\PROD\TF90.DBF
input datafile file number=00021 name=D:\ORACLE\ORADATA\PROD\TABLES\PRD_TABMRF_01.DBF
input datafile file number=00022 name=D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMRF_01.DBF
input datafile file number=00004 name=D:\ORACLE\ORADATA\PROD\USERS01.DBF
channel ORA_DISK_1: starting piece 1 at 11-SEP-11
channel ORA_DISK_1: finished piece 1 at 11-SEP-11
piece handle=E:\ORACLE\FAST_RECOVERY_AREA\PROD\RMAN\1CMMA8GP_1_1 tag=TAG20110911T201625 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:12:57
Finished backup at 11-SEP-11

Starting backup at 11-SEP-11
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=51 RECID=39 STAMP=761603362
channel ORA_DISK_1: starting piece 1 at 11-SEP-11
channel ORA_DISK_1: finished piece 1 at 11-SEP-11
piece handle=E:\ORACLE\FAST_RECOVERY_AREA\PROD\RMAN\1DMMA992_1_1 tag=TAG20110911T202922 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 11-SEP-11

Starting Control File and SPFILE Autobackup at 11-SEP-11
piece handle=E:\ORACLE\FAST_RECOVERY_AREA\PROD\AUTOBACKUP\2011_09_11\O1_MF_S_761603363_76TR3N0D_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 11-SEP-11

Starting backup at 11-SEP-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 11-SEP-11
channel ORA_DISK_1: finished piece 1 at 11-SEP-11
piece handle=E:\ORACLE\FAST_RECOVERY_AREA\PROD\RMAN\1FMMA995_1_1 tag=TAG20110911T202925 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 11-SEP-11

Starting Control File and SPFILE Autobackup at 11-SEP-11
piece handle=E:\ORACLE\FAST_RECOVERY_AREA\PROD\AUTOBACKUP\2011_09_11\O1_MF_S_761603367_76TR3QHC_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 11-SEP-11

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 14 days
using channel ORA_DISK_1
no obsolete backups found

sql statement: alter database backup controlfile to trace as ''e:\oracle\backups\prod\ctl\controlPROD.txt'' reuse

sql statement: create pfile=''e:\oracle\backups\prod\ctl\initPROD.txt'' from spfile

Starting backup at 11-SEP-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=D:\ORACLE\ORADATA\PROD\UNDOTBS01.DBF
input datafile file number=00005 name=D:\ORACLE\ORADATA\PROD\TABLES\PRD_TABMSF_01.DBF
input datafile file number=00006 name=D:\ORACLE\ORADATA\PROD\TABLES\PRD_TABMSF_02.DBF
input datafile file number=00007 name=D:\ORACLE\ORADATA\PROD\TABLES\PRD_TABMSF_03.DBF
input datafile file number=00008 name=D:\ORACLE\ORADATA\PROD\TABLES\PRD_TABMSF_04.DBF
input datafile file number=00009 name=D:\ORACLE\ORADATA\PROD\TABLES\PRD_TABMSF_05.DBF
input datafile file number=00010 name=D:\ORACLE\ORADATA\PROD\TABLES\PRD_TABMSF_06.DBF
input datafile file number=00011 name=D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMSF_01.DBF
input datafile file number=00012 name=D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMSF_02.DBF
input datafile file number=00013 name=D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMSF_03.DBF
input datafile file number=00014 name=D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMSF_04.DBF
input datafile file number=00015 name=D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMSF_05.DBF
input datafile file number=00016 name=D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMSF_06.DBF
input datafile file number=00017 name=D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMSF_07.DBF
input datafile file number=00018 name=D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMSF_08.DBF
input datafile file number=00019 name=D:\ORACLE\ORADATA\PROD\LOB\PRD_LOBMSF.DBF
input datafile file number=00001 name=D:\ORACLE\ORADATA\PROD\SYSTEM01.DBF
input datafile file number=00002 name=D:\ORACLE\ORADATA\PROD\SYSAUX01.DBF
input datafile file number=00020 name=D:\ORACLE\ORADATA\PROD\TABLES\PRD_TABMER_01.DBF
input datafile file number=00023 name=D:\ORACLE\ORADATA\PROD\TF90.DBF
input datafile file number=00021 name=D:\ORACLE\ORADATA\PROD\TABLES\PRD_TABMRF_01.DBF
input datafile file number=00022 name=D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMRF_01.DBF
input datafile file number=00004 name=D:\ORACLE\ORADATA\PROD\USERS01.DBF
channel ORA_DISK_1: backup set complete, elapsed time: 00:04:05

Open in new window

List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
1    OK     0              57387        153600          77972022  
  File Name: D:\ORACLE\ORADATA\PROD\SYSTEM01.DBF
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              75803           
  Index      0              17617           
  Other      0              2793            

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
2    OK     0              53623        153605          77972116  
  File Name: D:\ORACLE\ORADATA\PROD\SYSAUX01.DBF
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              36317           
  Index      0              33296           
  Other      0              30364           

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
3    OK     0              197505       1048576         77972116  
  File Name: D:\ORACLE\ORADATA\PROD\UNDOTBS01.DBF
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0               
  Index      0              0               
  Other      0              851071          

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
4    OK     0              34           641             71720528  
  File Name: D:\ORACLE\ORADATA\PROD\USERS01.DBF
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              15              
  Index      0              2               
  Other      0              589             

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
5    OK     0              77898        262144          77645810  
  File Name: D:\ORACLE\ORADATA\PROD\TABLES\PRD_TABMSF_01.DBF
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              181304          
  Index      0              13              
  Other      0              2929            

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
6    OK     0              78784        262144          77607708  
  File Name: D:\ORACLE\ORADATA\PROD\TABLES\PRD_TABMSF_02.DBF
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              182101          
  Index      0              13              
  Other      0              1246            

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
7    OK     0              78910        262144          77607871  
  File Name: D:\ORACLE\ORADATA\PROD\TABLES\PRD_TABMSF_03.DBF
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              180391          
  Index      0              0               
  Other      0              2843            

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
8    OK     0              79629        262144          77613691  
  File Name: D:\ORACLE\ORADATA\PROD\TABLES\PRD_TABMSF_04.DBF
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              181189          
  Index      0              0               
  Other      0              1326            

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
9    OK     0              78100        262144          77605096  
  File Name: D:\ORACLE\ORADATA\PROD\TABLES\PRD_TABMSF_05.DBF
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              180939          
  Index      0              0               
  Other      0              3105            

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
10   OK     0              75934        262144          77607710  
  File Name: D:\ORACLE\ORADATA\PROD\TABLES\PRD_TABMSF_06.DBF
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              184195          
  Index      0              13              
  Other      0              2002            

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
11   OK     0              131869       262144          77605096  
  File Name: D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMSF_01.DBF
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0               
  Index      0              127030          
  Other      0              3245            

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
12   OK     0              128845       262144          77647376  
  File Name: D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMSF_02.DBF
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0               
  Index      0              131503          
  Other      0              1796            

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
13   OK     0              131005       262144          77648786  
  File Name: D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMSF_03.DBF
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0               
  Index      0              128738          
  Other      0              2401            

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
14   OK     0              131957       262144          77647369  
  File Name: D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMSF_04.DBF
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0               
  Index      0              128532          
  Other      0              1655            

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
15   OK     0              130093       262144          77580635  
  File Name: D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMSF_05.DBF
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0               
  Index      0              128969          
  Other      0              3082            

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
16   OK     0              131873       262144          77601752  
  File Name: D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMSF_06.DBF
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0               
  Index      0              129306          
  Other      0              965             

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
17   OK     0              132613       262144          77601752  
  File Name: D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMSF_07.DBF
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0               
  Index      0              127759          
  Other      0              1772            

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
18   OK     0              130801       262144          77647368  
  File Name: D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMSF_08.DBF
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0               
  Index      0              129236          
  Other      0              2107            

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
19   OK     0              262017       262144          1039694   
  File Name: D:\ORACLE\ORADATA\PROD\LOB\PRD_LOBMSF.DBF
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0               
  Index      0              0               
  Other      0              127             

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
20   OK     0              24218        25600           77958879  
  File Name: D:\ORACLE\ORADATA\PROD\TABLES\PRD_TABMER_01.DBF
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              424             
  Index      0              517             
  Other      0              441             

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
21   OK     0              12673        12800           1221883   
  File Name: D:\ORACLE\ORADATA\PROD\TABLES\PRD_TABMRF_01.DBF
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0               
  Index      0              0               
  Other      0              127             

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
22   OK     0              12673        12800           1222156   
  File Name: D:\ORACLE\ORADATA\PROD\INDEXES\PRD_IDXMRF_01.DBF
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0               
  Index      0              0               
  Other      0              127             

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
23   OK     0              16377        25600           77455254  
  File Name: D:\ORACLE\ORADATA\PROD\TF90.DBF
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              4247            
  Index      0              4258            
  Other      0              718             

Open in new window

channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=42 RECID=21 STAMP=761598901
input archived log thread=1 sequence=43 RECID=23 STAMP=761598920
input archived log thread=1 sequence=44 RECID=25 STAMP=761599701
input archived log thread=1 sequence=45 RECID=27 STAMP=761600698
input archived log thread=1 sequence=46 RECID=29 STAMP=761600789
input archived log thread=1 sequence=47 RECID=31 STAMP=761600819
input archived log thread=1 sequence=48 RECID=33 STAMP=761602031
input archived log thread=1 sequence=49 RECID=35 STAMP=761602543
input archived log thread=1 sequence=50 RECID=37 STAMP=761602583
input archived log thread=1 sequence=51 RECID=39 STAMP=761603362
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
List of Archived Logs
=====================
Thrd Seq     Status Blocks Failing Blocks Examined Name
---- ------- ------ -------------- --------------- ---------------
1    42      OK     0              1997            E:\ORACLE\FAST_RECOVERY_AREA\PROD\ARCHIVELOG\2011_09_11\O1_MF_1_42_76TMR507_.ARC
1    43      OK     0              515             E:\ORACLE\FAST_RECOVERY_AREA\PROD\ARCHIVELOG\2011_09_11\O1_MF_1_43_76TMRR55_.ARC
1    44      OK     0              1596            E:\ORACLE\FAST_RECOVERY_AREA\PROD\ARCHIVELOG\2011_09_11\O1_MF_1_44_76TNK57J_.ARC
1    45      OK     0              86043           E:\ORACLE\FAST_RECOVERY_AREA\PROD\ARCHIVELOG\2011_09_11\O1_MF_1_45_76TOJ8QP_.ARC
1    46      OK     0              28612           E:\ORACLE\FAST_RECOVERY_AREA\PROD\ARCHIVELOG\2011_09_11\O1_MF_1_46_76TOM50G_.ARC
1    47      OK     0              298             E:\ORACLE\FAST_RECOVERY_AREA\PROD\ARCHIVELOG\2011_09_11\O1_MF_1_47_76TON3PT_.ARC
1    48      OK     0              10318           E:\ORACLE\FAST_RECOVERY_AREA\PROD\ARCHIVELOG\2011_09_11\O1_MF_1_48_76TPSZOV_.ARC
1    49      OK     0              1291            E:\ORACLE\FAST_RECOVERY_AREA\PROD\ARCHIVELOG\2011_09_11\O1_MF_1_49_76TQ9Z2F_.ARC
1    50      OK     0              55              E:\ORACLE\FAST_RECOVERY_AREA\PROD\ARCHIVELOG\2011_09_11\O1_MF_1_50_76TQC7NF_.ARC
1    51      OK     0              1665            E:\ORACLE\FAST_RECOVERY_AREA\PROD\ARCHIVELOG\2011_09_11\O1_MF_1_51_76TR3LCP_.ARC
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
List of Control File and SPFILE
===============================
File Type    Status Blocks Failing Blocks Examined
------------ ------ -------------- ---------------
SPFILE       OK     0              2               
Control File OK     0              788             
Finished backup at 11-SEP-11

Starting restore at 11-SEP-11
using channel ORA_DISK_1

channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece E:\ORACLE\FAST_RECOVERY_AREA\PROD\RMAN\1CMMA8GP_1_1
channel ORA_DISK_1: piece handle=E:\ORACLE\FAST_RECOVERY_AREA\PROD\RMAN\1CMMA8GP_1_1 tag=TAG20110911T201625
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:09:25
Finished restore at 11-SEP-11

using channel ORA_DISK_1
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=E:\ORACLE\FAST_RECOVERY_AREA\PROD\RMAN\10MMA4PJ_1_1 RECID=25 STAMP=761598772
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=E:\ORACLE\FAST_RECOVERY_AREA\PROD\RMAN\11MMA4U8_1_1 RECID=26 STAMP=761598920
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=E:\ORACLE\FAST_RECOVERY_AREA\PROD\RMAN\12MMA4UA_1_1 RECID=27 STAMP=761598922
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=E:\ORACLE\FAST_RECOVERY_AREA\PROD\RMAN\13MMA5MI_1_1 RECID=28 STAMP=761599700
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=E:\ORACLE\FAST_RECOVERY_AREA\PROD\RMAN\14MMA5ML_1_1 RECID=29 STAMP=761599701
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=E:\ORACLE\FAST_RECOVERY_AREA\PROD\RMAN\15MMA5MN_1_1 RECID=30 STAMP=761599704
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=E:\ORACLE\FAST_RECOVERY_AREA\PROD\RMAN\19MMA6PK_1_1 RECID=31 STAMP=761600820
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=E:\ORACLE\FAST_RECOVERY_AREA\PROD\RMAN\1AMMA7BE_1_1 RECID=32 STAMP=761601391
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=E:\ORACLE\FAST_RECOVERY_AREA\PROD\RMAN\1BMMA8GO_1_1 RECID=33 STAMP=761602584
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=E:\ORACLE\FAST_RECOVERY_AREA\PROD\RMAN\1CMMA8GP_1_1 RECID=34 STAMP=761602586
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=E:\ORACLE\FAST_RECOVERY_AREA\PROD\RMAN\1DMMA992_1_1 RECID=35 STAMP=761603362
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=E:\ORACLE\FAST_RECOVERY_AREA\PROD\AUTOBACKUP\2011_09_11\O1_MF_S_761603363_76TR3N0D_.BKP RECID=36 STAMP=761603363
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=E:\ORACLE\FAST_RECOVERY_AREA\PROD\RMAN\1FMMA995_1_1 RECID=37 STAMP=761603366
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=E:\ORACLE\FAST_RECOVERY_AREA\PROD\AUTOBACKUP\2011_09_11\O1_MF_S_761603367_76TR3QHC_.BKP RECID=38 STAMP=761603367
Crosschecked 14 objects


using channel ORA_DISK_1
specification does not match any backup in the repository

Recovery Manager complete.
==========

Initiated that backup @ 8:16 PM
Backup finsihed @ 8:43 PM

Alter system switch logfile executed @ 8:52 PM

Run the following archive log backup script @ 8:59 PM

Initiated log backup @ 8:59
Finished @ 8:59

backup archivelog all not backed up;
crosscheck archivelog all;
delete noprompt obsolete;

Open in new window


Used the saved PFILE from the PROD database and edited it to the following:
PFILE:

temp.__db_cache_size=3388997632
temp.__java_pool_size=100663296
temp.__large_pool_size=33554432
temp.__oracle_base='C:\Oracle'#ORACLE_BASE set from environment
temp.__pga_aggregate_target=3590324224
temp.__sga_target=6744440832
temp.__shared_io_pool_size=0
temp.__shared_pool_size=3120562176
temp.__streams_pool_size=33554432
*.audit_file_dest='C:\Oracle\admin\temp\adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_file_record_keep_time=14
*.control_files='D:\Oracle\Oradata\temp\control01.ctl','E:\Oracle\fast_recovery_area\temp\control02.ctl'
*.db_block_size=8192
*.db_cache_size=2147483648
*.db_domain=''
*.db_name='temp'
*.instance_name='temp'
*.db_recovery_file_dest='e:\oracle\fast_recovery_area'
*.db_recovery_file_dest_size=268435456000
*.diagnostic_dest='C:\Oracle'
*.dispatchers=''
*.java_pool_size=209715200
*.job_queue_processes=1000
*.log_archive_dest_1='location=use_db_recovery_file_dest'
*.log_archive_dest_2='location=D:\Oracle\fast_recovery_area\temp\ARCHIVELOG'
*.memory_target=0
*.open_cursors=1000
*.pga_aggregate_target=1073741824
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=0
*.shared_pool_size=1610612736
*.shared_servers=0
*.undo_tablespace='UNDOTBS1'
*.workarea_size_policy='AUTO'
*.db_file_name_convert='D:\Oracle\Oradata\prod\Indexes\PRD_','D:\Oracle\Oradata\temp\Indexes\TEMP_','D:\Oracle\Oradata\prod\Tables\PRD_','D:\Oracle\Oradata\temp\Tables\TEMP_','D:\Oracle\Oradata\prod\LOB\PRD_','D:\Oracle\Oradata\temp\LOB\TEMP_','D:\Oracle\Oradata\prod','D:\Oracle\Oradata\temp'
*.log_file_name_convert='D:\Oracle\Oradata\prod','D:\Oracle\Oradata\temp','E:\Oracle\Oradata\prod','E:\Oracle\Oradata\temp'

Open in new window


Next started the duplicate process:
Shutdown clone DB.
Startup Nomount with the above pfile

Output from the duplicate attempt:

Executed the following:

set ORACLE_HOME=c:\oracle\product\11.2.0\dbhome_1
set ORACLE_SID=temp
d:
cd \oracle\oradba
%ORACLE_HOME%\bin\rman target /@prod auxiliary / @temp_dup.scr > d:\oracle\oradba\temp_dup.log

==========

Recovery Manager: Release 11.2.0.2.0 - Production on Sun Sep 11 21:57:28 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PROD (DBID=747725684)
connected to auxiliary database: TEMP (not mounted)

RMAN> run
2> {
3> allocate auxiliary channel aux1 device type disk;
4> set until time "to_date('2011-09-11:20:55:00','YYYY-MM-DD:HH24:MI:SS')";
5> duplicate target database to temp;
6> }
7> 
using target database control file instead of recovery catalog
allocated channel: aux1
channel aux1: SID=66 device type=DISK

executing command: SET until clause

Starting Duplicate Db at 11-SEP-11

contents of Memory Script:
{
   sql clone "create spfile from memory";
}
executing Memory Script

sql statement: create spfile from memory

contents of Memory Script:
{
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area    3991994368 bytes

Fixed Size                     2259264 bytes
Variable Size               1828718272 bytes
Database Buffers            2147483648 bytes
Redo Buffers                  13533184 bytes
allocated channel: aux1
channel aux1: SID=66 device type=DISK

contents of Memory Script:
{
   set until scn  77790792;
   sql clone "alter system set  db_name = 
 ''PROD'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   sql clone "alter system set  db_unique_name = 
 ''TEMP'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   shutdown clone immediate;
   startup clone force nomount
   restore clone primary controlfile;
   alter clone database mount;
}
executing Memory Script
executing command: SET until clause

sql statement: alter system set  db_name =  ''PROD'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set  db_unique_name =  ''TEMP'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area    3991994368 bytes

Fixed Size                     2259264 bytes
Variable Size               1828718272 bytes
Database Buffers            2147483648 bytes
Redo Buffers                  13533184 bytes
allocated channel: aux1
channel aux1: SID=66 device type=DISK

Starting restore at 11-SEP-11

released channel: aux1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 09/11/2011 21:57:55
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore

Recovery Manager complete.
==========

Also tried this, with the same result:

RMAN> duplicate target database to temp
2> until time "to_date('2011-09-11:20:55:00','YYYY-MM-DD:HH24:MI:SS')"
3> backup location 'e:\oracle\fast_recovery_area\prod\rman';

Open in new window


This is the first time I've tried to clone a DB using Oracle 11g - I've used this process lots of times in Oracle 10g and I can't for the life of me work out what I'm doing wrong.  I've searched this site, google and MOS for this error message and the only articles I've found have been specifically related to duplicating a database for standby and the solution in the associated MOS document says to switch logfiles after the backup which I have done and doesn't seem to have fixed it.

Anyone have any insight into what I'm missing ?

0
Comment
Question by:AddOnsInc
  • 2
  • 2
4 Comments
 
LVL 12

Expert Comment

by:praveencpk
ID: 36521041
the control file is missing from the specified location to rewrite.
i.e >>*.control_files='D:\Oracle\Oradata\temp\control01.ctl','E:\Oracle\fast_recovery_area\temp\control02.ctl' <<

so first try restoring the controlfile in this location.


0
 
LVL 12

Accepted Solution

by:
praveencpk earned 500 total points
ID: 36521125
you have to issue
alter system archive log current;
not the >>Alter system switch logfile<<
then try duplicate command in rman.
0
 

Author Comment

by:AddOnsInc
ID: 36522815
Praveencpk:

Did "Alter system archive log current" - same results.

As to your first response, isn't recovery of controlfile the first step of a recovery of the target DB and not as a part of cloning a database ?
0
 

Author Comment

by:AddOnsInc
ID: 36527509
I believe I have worked it out.  After taking the backup, need to switch logfiles, alter system archive log current, backup the controlfile again and then it seems to work.

My problem?  Not trying to restore to a point *after* I had done those steps.  Thanks!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now