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@(protected)
I said it "looked " clear - Riddick
-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of Aragon, Gabriel (GE
Commercial Finance)
Sent: Friday, July 16, 2004 8:48 AM
To: oracle-l@(protected)
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@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of Hostetter, Jay M
Sent: Viernes, 16 de Julio de 2004 06:54 a.m.
To: oracle-l@(protected)
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@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Aragon, Gabriel (GE
Commercial Finance)
Sent: Thursday, July 15, 2004 4:18 PM
To: oracle-l@(protected)
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
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@(protected)
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@(protected)
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
