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 Aragon, Gabriel (GE Commercial Finance)
Reply:     1     2     3     4     5     6     7     8     9     10     >>  

I dont have the equals sign neither.=20
I made two test:

1. Duplicate DB in the same host with different dir stucture and also =
same oracle version.
Result =3D Success

2. Duplicate DB to another host with different dir structure and =
different oracle version.
Result =3D Failure.

Yes I have an error, sorry in the first email I didn 't copy it, but I =
think it 's for the long time that the process hangs, this is the final =
part of 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 <-- here it hangs looong time..

RMAN-00571: =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
RMAN-00569: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D ERROR MESSAGE =
STACK FOLLOWS =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RMAN-00571: =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
RMAN-03002: failure of Duplicate Db command at 07/15/2004 16:15:32
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-01013 (See ORA-01013.ora-code.com): user =
requested cancel of current operation

Recovery Manager complete.
-- ---- ---- ---- ---- ---- -----

Something else, I don 't use a catalog for the backups.

Any ideas?
Tks
Gabriel


-- --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 09:55 a.m.
To: oracle-l@(protected)
Subject: RE: RMAN duplicate hangs


I was trying to say that I don 't have the 'equals ' sign before the log
file size - and maybe you don 't either.
Are you using the same rman script on host A and B? So, on host A
(where target is located) the script works, but on host B it does =
not?=3D20
Do all of your directories exist?
Do you get a specific error message when the crash occurs?

Jay

-- --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 9:48 AM
To: oracle-l@(protected)
Subject: RE: RMAN duplicate hangs

Yes the '3D ' is gargabage in the mail.=3D3D20

Oracle version for original DB is 9.2.0.3 in host A, and 9.2.0.4 in host
=3D3D B, (both under windoze) is that a possible problem when using
duplicate =3D3D command? I already thought about using backup =
controlfile
and then =3D3D resetlogs, but seems to be inneccesary since there 's a
duplicate =3D3D command, when I try to duplicate db at the same host, =
the
process =3D3D completes successfully.

Also, I would like to know if the query to monitor the process is the =
=3D3D
right one, and what is the trash generated in the last two lines. Maybe
=3D3D a problem with different oracle versions?=3D3D20

Thanks
Gabriel
=3D3D20

-- --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 '=3D3D3D3D ' when specifying the size of the redo logs. .e.g =
=3D3D
"SIZE 50M " not "SIZE =3D3D3D3D 50m ". However, if this isn 't the correct
syntax, I would expect an error instead of just 'hanging '.

Jay






**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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --