I'm going to toss a wild idea in here in case it helps. Toss it back if it doesn't apply. Are you using NFS? Dennis Williams DBA Lifetouch, Inc. dwilliams@xxxxxxxxxxxxx I said it "looked" clear - Riddick -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Aragon, Gabriel (GE Commercial Finance) Sent: Friday, July 16, 2004 8:48 AM To: oracle-l@xxxxxxxxxxxxx Subject: RE: RMAN duplicate hangs Yes the '3D' is gargabage in the mail.=20 Oracle version for original DB is 9.2.0.3 in host A, and 9.2.0.4 in host = B, (both under windoze) is that a possible problem when using duplicate = command? I already thought about using backup controlfile and then = resetlogs, but seems to be inneccesary since there's a duplicate = command, when I try to duplicate db at the same host, the process = completes successfully. Also, I would like to know if the query to monitor the process is the = right one, and what is the trash generated in the last two lines. Maybe = a problem with different oracle versions?=20 Thanks Gabriel =20 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Hostetter, Jay M Sent: Viernes, 16 de Julio de 2004 06:54 a.m. To: oracle-l@xxxxxxxxxxxxx Subject: RE: RMAN duplicate hangs What database version are you using? Is that your entire script? This may not be the problem, but in my rman scripts for cloning, I do not have an '=3D3D' when specifying the size of the redo logs. .e.g = "SIZE 50M" not "SIZE =3D3D 50m". However, if this isn't the correct syntax, I would expect an error instead of just 'hanging'. Jay -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Aragon, Gabriel (GE Commercial Finance) Sent: Thursday, July 15, 2004 4:18 PM To: oracle-l@xxxxxxxxxxxxx Subject: RMAN duplicate hangs Hello list,=3D3D20 I'm trying to duplicate a DB from host A to host B using RMAN, after = =3D3D dealing with the directories stuff (having the backup files in the same =3D3D path as the original) I tried once again to run the process, from = host =3D3D B, but after creating the DB and restoring the datafiles in host = B, =3D3D after finishing media recovery it hangs up.. and then crashes without = =3D3D creating the redo logs. -this is the last entry to the log file --> media recovery complete Finished recover at 15-JUL-04 printing stored script: Memory Script { shutdown clone; startup clone nomount ; } executing script: Memory Script -I'm monitoring the process with this query: select sid, serial#, context, round(sofar/totalwork*100,2) "% Complete", substr(to_char(sysdate,'yymmdd hh24:mi:ss'),1,15) "Time Now", elapsed_seconds, opname from v$session_longops; -and when the process hangs, the query displays this: 31 6288 0 100 040715 14:50:58 43 Hash Join 12 9025 13 100 040715 14:50:58 0 RMAN: aggregate = =3D3D output 16 14826 0 100 040715 14:50:58 10 Hash Join 18 10860 44 100 040715 14:50:58 288197021 = !/=3D3DFF=3D3DF9'??=3D3DB1'=3D ?? 29 4292 44 100 040715 14:50:58 288202572 = !/=3D3DFF=3D3DF9'?=3D3DA3t'=3D ?? I don't know what are the last two rows. After a couple of hours the = =3D3D process stops. This is my script: CONFIGURE DEFAULT DEVICE TYPE TO DISK; CONFIGURE AUXNAME FOR DATAFILE 1 TO =3D3D 'F:\ORACLE\oradata\TESTING\datafiles\SYSTEM01.DBF'; CONFIGURE AUXNAME FOR DATAFILE 2 TO =3D3D 'F:\ORACLE\oradata\TESTING\datafiles\UNDOTBS01.DBF'; =3D2E =3D2E RUN { ALLOCATE AUXILIARY CHANNEL aux1 DEVICE TYPE DISK; ALLOCATE AUXILIARY CHANNEL aux2 DEVICE TYPE DISK; SET UNTIL TIME 'SYSDATE-1'; DUPLICATE TARGET DATABASE TO 'testing' LOGFILE GROUP 1 ('D:\ORACLE\ORADATA\TESTING\REDO01.LOG', 'F:\ORACLE\ORADATA\TESTING\MAINFILES\BCK_REDO01.LOG') SIZE =3D3D 50M, GROUP 2 ('D:\ORACLE\ORADATA\TESTING\REDO02.LOG', 'F:\ORACLE\ORADATA\TESTING\MAINFILES\BCK_REDO02.LOG') SIZE =3D3D 50M, GROUP 3 ('D:\ORACLE\ORADATA\TESTING\REDO03.LOG', 'F:\ORACLE\ORADATA\TESTING\MAINFILES\BCK_REDO03.LOG') SIZE =3D3D 50M; } CONFIGURE AUXNAME FOR DATAFILE 1 CLEAR;=3D3D20 CONFIGURE AUXNAME FOR DATAFILE 2 CLEAR;=3D3D20 . =3D2E Am I missing something or doing something wrong? Any ideas? TIA Gabriel **DISCLAIMER This e-mail message and any files transmitted with it are intended for = the =3D use of the individual or entity to which they are addressed and may = contain=3D information that is privileged, proprietary and confidential. If you = are n=3D ot the intended recipient, you may not use, copy or disclose to anyone = the =3D message or any information contained in the message. If you have = received t=3D his communication in error, please notify the sender and delete this = e-mail=3D message. The contents do not represent the opinion of D&E except to the = ex=3D tent that it relates to their official business. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------