Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
RMAN duplicate hangs

RMAN duplicate hangs

2004-07-16       - By Hostetter, Jay M

Reply:     1     2     3     4     5     6     7     8     9     10     >>  

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@(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,=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
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 =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.
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --