| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN duplicate hangs (FEEDBACK)
Hi All, after upgrading the target server from 9203 to 9204 (last funday =
sunday), and having both windows servers running the same oracle =
versions, the rman duplication process was successfully completed.
I also removed the line:
SET UNTIL TIME 'SYSDATE-1'; as an example for a correct sintaxis for RMAN could be:
SET UNTIL TIME "TO_DATE('22-jul-2004 10:00:00', 'dd-mon-YYYY = hh24:mi:ss')";
Thank you all for your help!
Gabriel
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of DENNIS WILLIAMS
Sent: Martes, 20 de Julio de 2004 10:26 a.m.
To: 'oracle-l_at_freelists.org'
Subject: RE: RMAN duplicate hangs
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=20
-----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=20
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.=3D20
Oracle version for original DB is 9.2.0.3 in host A, and 9.2.0.4 in host =
=3D
B, (both under windoze) is that a possible problem when using duplicate =
=3D
command? I already thought about using backup controlfile and then =3D
resetlogs, but seems to be inneccesary since there's a duplicate =3D =
command,
when I try to duplicate db at the same host, the process =3D completes
successfully.
Also, I would like to know if the query to monitor the process is the =
=3D
right one, and what is the trash generated in the last two lines. Maybe =
=3D a
problem with different oracle versions?=3D20
Thanks
Gabriel
=3D20
-----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 '=3D3D3D' when specifying the size of the redo logs. .e.g =3D =
"SIZE
50M" not "SIZE =3D3D3D 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,=3D3D3D20
I'm trying to duplicate a DB from host A to host B using RMAN, after =3D =
=3D3D3D
dealing with the directories stuff (having the backup files in the same
=3D3D3D path as the original) I tried once again to run the process, =
from =3D
host =3D3D3D B, but after creating the DB and restoring the datafiles in =
host
=3D B, =3D3D3D after finishing media recovery it hangs up.. and then =
crashes
without =3D =3D3D3D 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
-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 =
16 14826 0 100 040715 14:50:58 10 Hash Join 18 10860 44 100 040715 14:50:58 288197021 =3D!/=3D3D3DFF=3D3D3DF9'??=3D3D3DB1'=3D3D
I don't know what are the last two rows. After a couple of hours the =3D =
=3D3D3D
process stops.
This is my script:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE AUXNAME FOR DATAFILE 1 TO =3D3D3D
'F:\ORACLE\oradata\TESTING\datafiles\SYSTEM01.DBF';
CONFIGURE AUXNAME FOR DATAFILE 2 TO =3D3D3D
'F:\ORACLE\oradata\TESTING\datafiles\UNDOTBS01.DBF';
=3D3D2E
=3D3D2E
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
=3D3D3D 50M,
GROUP 2 ('D:\ORACLE\ORADATA\TESTING\REDO02.LOG',
'F:\ORACLE\ORADATA\TESTING\MAINFILES\BCK_REDO02.LOG') SIZE
=3D3D3D 50M,
GROUP 3 ('D:\ORACLE\ORADATA\TESTING\REDO03.LOG',
'F:\ORACLE\ORADATA\TESTING\MAINFILES\BCK_REDO03.LOG') SIZE
=3D3D3D 50M; }
CONFIGURE AUXNAME FOR DATAFILE 1 CLEAR;=3D3D3D20 CONFIGURE AUXNAME FOR DATAFILE 2 CLEAR;=3D3D3D20 . =3D3D2E Am I missing something or doing something wrong? Any ideas?
TIA
Gabriel
-- 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 Mon Jul 26 2004 - 17:24:20 CDT
 |
 |