| 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 (character garbage in messages)
I presume the =#LETTER# garbage is just the usual email garbling we see from
various source and tranmission combinations.
mwf
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Hostetter, Jay M
Sent: Friday, July 16, 2004 7:54 AM
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 '=3D' when specifying the size of the redo logs. .e.g "SIZE
50M" not "SIZE =3D 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,=3D20
I'm trying to duplicate a DB from host A to host B using RMAN, after =3D
dealing with the directories stuff (having the backup files in the same
=3D path as the original) I tried once again to run the process, from host
=3D B, but after creating the DB and restoring the datafiles in host B, =3D
after finishing media recovery it hangs up.. and then crashes without =3D
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 =3D output 16 14826 0 100 040715 14:50:58 10 Hash Join 18 10860 44 100 040715 14:50:58 288197021 !/=3DFF=3DF9'??=3DB1'= ?? 29 4292 44 100 040715 14:50:58 288202572 !/=3DFF=3DF9'?=3DA3t'=??
I don't know what are the last two rows. After a couple of hours the =3D process stops.
This is my script:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE AUXNAME FOR DATAFILE 1 TO =3D
'F:\ORACLE\oradata\TESTING\datafiles\SYSTEM01.DBF';
CONFIGURE AUXNAME FOR DATAFILE 2 TO =3D
'F:\ORACLE\oradata\TESTING\datafiles\UNDOTBS01.DBF';
=2E
=2E
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
=3D 50M,
GROUP 2 ('D:\ORACLE\ORADATA\TESTING\REDO02.LOG',
'F:\ORACLE\ORADATA\TESTING\MAINFILES\BCK_REDO02.LOG') SIZE
=3D 50M,
GROUP 3 ('D:\ORACLE\ORADATA\TESTING\REDO03.LOG',
'F:\ORACLE\ORADATA\TESTING\MAINFILES\BCK_REDO03.LOG') SIZE
=3D 50M; }
CONFIGURE AUXNAME FOR DATAFILE 1 CLEAR;=3D20 CONFIGURE AUXNAME FOR
DATAFILE 2 CLEAR;=3D20 .
=2E
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 = use of the individual or entity to which they are addressed and may contain= information that is privileged, proprietary and confidential. If you are n= ot the intended recipient, you may not use, copy or disclose to anyone the = message or any information contained in the message. If you have received t= his communication in error, please notify the sender and delete this e-mail= message. The contents do not represent the opinion of D&E except to the ex=tent that it relates to their official business.
-- 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 Fri Jul 16 2004 - 07:15:12 CDT
 |
 |