Rman-duplicate target database

Bonjour,
J'essaye de dupliquer ma base de données Oracle 9i R2 sous win XP sur la même machine.
Je suis scrupuleusement la doc tout se déroule à merveille jusqu' arriver à :

Code:

---

1 2 3 4 5 6 7 8 9

media recovery complete Finished recover at 10-DEC-07   printing stored script: Memory Script { shutdown clone; startup clone nomount ; } executing script: Memory Script.

---

Il reste là innactif, sans message d'erreur ni rien.

les fichiers sont bien ecrit à l'emplacement indiqué,
Si j'ai bien compris, d'après la doc, l'étape d'après c'est un switch log file, alors, j'ai l'impression que mon serveur attends ce switch et est bloqué. Cependant, mes deux instances sont bien en archive log et archivage automatique spécifié à true dans les deux initxx.ora correspondants !
J'ai aussi pensé à un pbm d'espace, mais il en ai rien.
Aviez vous déjà rencontré ce problème ?

Merci

après avori attendu une bonne demi heure, j'ai enfin eu un message d'erreur :

Code:

---

1 2 3 4 5 6 7 8

RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 12/10/2007 13:19:39 RMAN-03015: error occurred in stored script Memory Script RMAN-06136: ORACLE error from auxiliary database: ORA-01013: user requested canc el of current operation

---

voilà, si ça peut aider

il me semble avoir déjà vu ce message sur ce forum, mais qui ne corresponds pas tout a fait à mon problème.

Ne voyant pas de réponse, je vais essayer de detailler plus.

voici le script utilisé pour la duplication avec Rman et juste après le résultat d'RMAN :

Code:

---

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257

C:\Documents and Settings\admin>rman target /@orcl auxiliary /@orcldup   Recovery Manager: Release 9.2.0.1.0 - Production   Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.   connected to target database: ORCL (DBID=1164093681) connected to auxiliary database: ORCLDUP (not mounted)   RMAN> report schema 2> ;   using target database controlfile instead of recovery catalog Report of database schema File K-bytes Tablespace RB segs Datafile Name ---- ---------- -------------------- ------- ------------------- 1 337920 SYSTEM *** C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF   2 204800 UNDOTBS1 *** C:\ORACLE\ORADATA\ORCL\UNDOTBS01.DB F 3 20480 DRSYS *** C:\ORACLE\ORADATA\ORCL\DRSYS01.DBF 4 149120 EXAMPLE *** C:\ORACLE\ORADATA\ORCL\EXAMPLE01.DB F 5 25600 INDX *** C:\ORACLE\ORADATA\ORCL\INDX01.DBF 6 20480 ODM *** C:\ORACLE\ORADATA\ORCL\ODM01.DBF 7 10240 TOOLS *** C:\ORACLE\ORADATA\ORCL\TOOLS01.DBF 8 25600 USERS *** C:\ORACLE\ORADATA\ORCL\USERS01.DBF 9 39040 XDB *** C:\ORACLE\ORADATA\ORCL\XDB01.DBF 10 51204 OEM_REPOSITORY *** C:\ORACLE\ORADATA\ORCL\OEM_REPOSITO RY.DBF   RMAN> set auxname for datafile 1 to 'c:\oracle\oradata\orcldup\system01.dbf';   executing command: SET AUXNAME auxiliary name for datafile 1 set to: c:\oracle\oradata\orcldup\system01.dbf new RMAN configuration parameters are successfully stored   RMAN> set auxname for datafile 2 to 'c:\oracle\oradata\orcldup\undotbs01.dbf';   executing command: SET AUXNAME auxiliary name for datafile 2 set to: c:\oracle\oradata\orcldup\undotbs01.dbf new RMAN configuration parameters are successfully stored   RMAN> set auxname for datafile 3 to 'c:\oracle\oradata\orcldup\drsys01.dbf';   executing command: SET AUXNAME auxiliary name for datafile 3 set to: c:\oracle\oradata\orcldup\drsys01.dbf new RMAN configuration parameters are successfully stored   RMAN> set auxname for datafile 4 to 'c:\oracle\oradata\orcldup\example01.dbf';   executing command: SET AUXNAME auxiliary name for datafile 4 set to: c:\oracle\oradata\orcldup\example01.dbf new RMAN configuration parameters are successfully stored   RMAN> set auxname for datafile 5 to 'c:\oracle\oradata\orcldup\indx01.dbf';   executing command: SET AUXNAME auxiliary name for datafile 5 set to: c:\oracle\oradata\orcldup\indx01.dbf new RMAN configuration parameters are successfully stored   RMAN> set auxname for datafile 6 to 'c:\oracle\oradata\orcldup\odm01.dbf';   executing command: SET AUXNAME auxiliary name for datafile 6 set to: c:\oracle\oradata\orcldup\odm01.dbf new RMAN configuration parameters are successfully stored   RMAN> set auxname for datafile 8 to 'c:\oracle\oradata\orcldup\users01.dbf';   executing command: SET AUXNAME auxiliary name for datafile 8 set to: c:\oracle\oradata\orcldup\users01.dbf new RMAN configuration parameters are successfully stored   RMAN> set auxname for datafile 9 to 'c:\oracle\oradata\orcldup\xdb01.dbf';   executing command: SET AUXNAME auxiliary name for datafile 9 set to: c:\oracle\oradata\orcldup\xdb01.dbf new RMAN configuration parameters are successfully stored   RMAN> set auxname for datafile 10 to 'c:\oracle\oradata\orcldup\oem_repository.d bf';   executing command: SET AUXNAME auxiliary name for datafile 10 set to: c:\oracle\oradata\orcldup\oem_repository. dbf new RMAN configuration parameters are successfully stored   RMAN> run { 2> allocate auxiliary channel c1 type disk; 3> duplicate target database to orcldup 4> skip tablespace tools 5> logfile group 1 ('c:\oracle\oradata\orcldup\log01.rdo') size 5m reuse, 6> group 2 ('c:\oracle\oradata\orcldup\log02.rdo') size 5m reuse; 7> }   allocated channel: c1 channel c1: sid=14 devtype=DISK   Starting Duplicate Db at 15-DEC-07 Datafile 7 skipped by request   printing stored script: Memory Script { set until scn 1937493; set newname for datafile 1 to "C:\ORACLE\ORADATA\ORCLDUP\SYSTEM01.DBF"; set newname for datafile 2 to "C:\ORACLE\ORADATA\ORCLDUP\UNDOTBS01.DBF"; set newname for datafile 3 to "C:\ORACLE\ORADATA\ORCLDUP\DRSYS01.DBF"; set newname for datafile 4 to "C:\ORACLE\ORADATA\ORCLDUP\EXAMPLE01.DBF"; set newname for datafile 5 to "C:\ORACLE\ORADATA\ORCLDUP\INDX01.DBF"; set newname for datafile 6 to "C:\ORACLE\ORADATA\ORCLDUP\ODM01.DBF"; set newname for datafile 8 to "C:\ORACLE\ORADATA\ORCLDUP\USERS01.DBF"; set newname for datafile 9 to "C:\ORACLE\ORADATA\ORCLDUP\XDB01.DBF"; set newname for datafile 10 to "C:\ORACLE\ORADATA\ORCLDUP\OEM_REPOSITORY.DBF"; restore check readonly clone database skip tablespace TOOLS ; } executing script: Memory Script   executing command: SET until clause   executing command: SET NEWNAME   executing command: SET NEWNAME   executing command: SET NEWNAME   executing command: SET NEWNAME   executing command: SET NEWNAME   executing command: SET NEWNAME   executing command: SET NEWNAME   executing command: SET NEWNAME   executing command: SET NEWNAME   Starting restore at 15-DEC-07   channel c1: starting datafile backupset restore channel c1: specifying datafile(s) to restore from backup set restoring datafile 00001 to C:\ORACLE\ORADATA\ORCLDUP\SYSTEM01.DBF restoring datafile 00002 to C:\ORACLE\ORADATA\ORCLDUP\UNDOTBS01.DBF restoring datafile 00003 to C:\ORACLE\ORADATA\ORCLDUP\DRSYS01.DBF restoring datafile 00004 to C:\ORACLE\ORADATA\ORCLDUP\EXAMPLE01.DBF restoring datafile 00005 to C:\ORACLE\ORADATA\ORCLDUP\INDX01.DBF restoring datafile 00006 to C:\ORACLE\ORADATA\ORCLDUP\ODM01.DBF restoring datafile 00008 to C:\ORACLE\ORADATA\ORCLDUP\USERS01.DBF restoring datafile 00009 to C:\ORACLE\ORADATA\ORCLDUP\XDB01.DBF restoring datafile 00010 to C:\ORACLE\ORADATA\ORCLDUP\OEM_REPOSITORY.DBF channel c1: restored backup piece 1 piece handle=C:\ORACLE\ORA92\DATABASE\14J36UG4_1_1 tag=TAG20071209T215619 params =NULL channel c1: restore complete Finished restore at 15-DEC-07 sql statement: CREATE CONTROLFILE REUSE SET DATABASE "orcldup" RESETLOGS ARCHIVE LOG MAXLOGFILES 50 MAXLOGMEMBERS 5 MAXDATAFILES 100 MAXINSTANCES 1 MAXLOGHISTORY 113 LOGFILE GROUP 1 ( 'c:\oracle\oradata\orcldup\log01.rdo' ) SIZE 5242880 REUSE, GROUP 2 ( 'c:\oracle\oradata\orcldup\log02.rdo' ) SIZE 5242880 REUSE DATAFILE 'C:\ORACLE\ORADATA\ORCLDUP\SYSTEM01.DBF' CHARACTER SET WE8MSWIN1252     printing stored script: Memory Script { switch clone datafile all; } executing script: Memory Script   datafile 2 switched to datafile copy input datafilecopy recid=1 stamp=641400755 filename=C:\ORACLE\ORADATA\ORCLDUP\UN DOTBS01.DBF datafile 3 switched to datafile copy input datafilecopy recid=2 stamp=641400755 filename=C:\ORACLE\ORADATA\ORCLDUP\DR SYS01.DBF datafile 4 switched to datafile copy input datafilecopy recid=3 stamp=641400756 filename=C:\ORACLE\ORADATA\ORCLDUP\EX AMPLE01.DBF datafile 5 switched to datafile copy input datafilecopy recid=4 stamp=641400756 filename=C:\ORACLE\ORADATA\ORCLDUP\IN DX01.DBF datafile 6 switched to datafile copy input datafilecopy recid=5 stamp=641400756 filename=C:\ORACLE\ORADATA\ORCLDUP\OD M01.DBF datafile 8 switched to datafile copy input datafilecopy recid=6 stamp=641400756 filename=C:\ORACLE\ORADATA\ORCLDUP\US ERS01.DBF datafile 9 switched to datafile copy input datafilecopy recid=7 stamp=641400756 filename=C:\ORACLE\ORADATA\ORCLDUP\XD B01.DBF datafile 10 switched to datafile copy input datafilecopy recid=8 stamp=641400756 filename=C:\ORACLE\ORADATA\ORCLDUP\OE M_REPOSITORY.DBF   printing stored script: Memory Script { set until scn 1937493; recover clone database delete archivelog ; } executing script: Memory Script   executing command: SET until clause   Starting recover at 15-DEC-07 datafile 7 not processed because file is offline   starting media recovery   archive log thread 1 sequence 26 is already on disk as file C:\ORACLE\ORA92\RDBM S\ARC00026.001 archive log thread 1 sequence 27 is already on disk as file C:\ORACLE\ORA92\RDBM S\ARC00027.001 archive log thread 1 sequence 28 is already on disk as file C:\ORACLE\ORA92\RDBM S\ARC00028.001 archive log thread 1 sequence 29 is already on disk as file C:\ORACLE\ORA92\RDBM S\ARC00029.001 archive log thread 1 sequence 30 is already on disk as file C:\ORACLE\ORA92\RDBM S\ARC00030.001 archive log thread 1 sequence 31 is already on disk as file C:\ORACLE\ORA92\RDBM S\ARC00031.001 archive log filename=C:\ORACLE\ORA92\RDBMS\ARC00026.001 thread=1 sequence=26 archive log filename=C:\ORACLE\ORA92\RDBMS\ARC00027.001 thread=1 sequence=27 archive log filename=C:\ORACLE\ORA92\RDBMS\ARC00028.001 thread=1 sequence=28 archive log filename=C:\ORACLE\ORA92\RDBMS\ARC00029.001 thread=1 sequence=29 archive log filename=C:\ORACLE\ORA92\RDBMS\ARC00030.001 thread=1 sequence=30 archive log filename=C:\ORACLE\ORA92\RDBMS\ARC00031.001 thread=1 sequence=31 media recovery complete Finished recover at 15-DEC-07   printing stored script: Memory Script { shutdown clone; startup clone nomount ; } executing script: Memory Script

---

Et ça reste comme ça un bon moment , 45 min ...

et ensuite ça m'affiche le message :

Code:

---

1 2 3 4 5 6 7

RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 12/10/2007 13:19:39 RMAN-03015: error occurred IN stored script Memory Script RMAN-06136: ORACLE error FROM auxiliary DATABASE: ORA-01013: user requested canc el of current operation

---

Qulequ'un aurait une idée ??

Merci

que dit l'alert du clone ?
votre connexion n'est pas bonne : il manque le nocatalog ou les infos de connexion au catalog, ce que je vous déconseille vu les soucis d'encodage que vous aviez.

avez-vous essayer, comme je vous le conseillais, de préciser un set until qui ne nécessite aucun redo ?

et pourquoi ouvrir un second topic pour le même problème ?

Pour commencer, je m'excuse d'avoir créer un nouveau post pour un sujet qui existe dejà. Il m'avais semblé que le sujet posté par big1 concernait un problème de character set different entre le catalog et la target database.

Je pensais que par defaut Rman se connect en NOCATALOG, lorsqu'on ne specifi rien. Pourquoi y'a t il lieu de preciser NOCATALOG ici ?

Grace à vos recommendations, j'ai trouvé l'origine de mon problème. J'ai consulté et reconsulté l'Alert de la base dupliquée et là :oops: je constate qu'il y'a blocage à cause d'un shutdown (normal) et qui était bloqué par une autre session :oops:.

Je sais, c'est ridicule, j'en suis desolé.

Merci à tous.

Ps: je pense qu'il vaudrait mieux delester ce poste. Qui ferait cette betise ?!

milles pardons, j'ai confondu les 2 problèmes;... :oops:

l'essentiel, c'est que vous ayez résolu le votre ! :)

Vous n'avez pas à vous excuser.
Merci beaucoup pour votre aide et votre disponibilité :).