Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN duplicate hangs

RE: RMAN duplicate hangs

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Tue, 20 Jul 2004 10:26:24 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B00A4D@EXCHMN3>


Brian - See if this is the discussion thread you are recalling.

http://www.orafaq.net/maillist/oracle-l/2003/12/08/0561.htm

Dennis Williams
DBA
Lifetouch, Inc.

Does believing you're the last sane man on the planet make you crazy?

       Del Spooner in I Robot, played by Will Smith

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Spears, Brian Sent: Tuesday, July 20, 2004 10:24 AM
To: oracle-l_at_freelists.org
Subject: RE: RMAN duplicate hangs

Dennis, Remember I asked this same question about a year ago. I had the same problem. You told me to look at NFS at that time too. I eventually found it was not NFS but some thing was wrong in the script. I have been away from that for the last year..but is there a way to find my response to the RMAN duplicate hanging issue. I am confident it will resolve this issue. All I can remember it that it had to do with the way I was trying to do it.

Brian

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of DENNIS WILLIAMS
Sent: Friday, July 16, 2004 2:11 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: RMAN duplicate hangs

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_at_lifetouch.com
I said it "looked" clear - Riddick

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Aragon, Gabriel (GE Commercial Finance) Sent: Friday, July 16, 2004 8:48 AM
To: oracle-l_at_freelists.org
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Hostetter, Jay M
Sent: Viernes, 16 de Julio de 2004 06:54 a.m. To: oracle-l_at_freelists.org
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Aragon, Gabriel (GE Commercial Finance) Sent: Thursday, July 15, 2004 4:18 PM
To: oracle-l_at_freelists.org
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_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org put
'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org put
'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Jul 20 2004 - 10:28:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US