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-15       - By Aragon, Gabriel (GE Commercial Finance)

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

Hello list,=20

I 'm trying to duplicate a DB from host A to host B using RMAN, after =
dealing with the directories stuff (having the backup files in the same =
path as the original) I tried once again to run the process, from host =
B, but after creating the DB and restoring the datafiles in host B, =
after finishing media recovery it hangs up.. and then crashes without =
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 =
output
16 14826 0 100 040715 14:50:58 10 Hash Join
18 10860 44 100 040715 14:50:58 288197021 !/=FF=F9 '??=B1 '??
29 4292 44 100 040715 14:50:58 288202572 !/=FF=F9 '?=A3t '??

I don 't know what are the last two rows. After a couple of hours the =
process stops.

This is my script:

CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE AUXNAME FOR DATAFILE 1 TO =
'F:\ORACLE\oradata\TESTING\datafiles\SYSTEM01.DBF ';
CONFIGURE AUXNAME FOR DATAFILE 2 TO =
'F:\ORACLE\oradata\TESTING\datafiles\UNDOTBS01.DBF ';
.
.

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 =
50M,
GROUP 2 ( 'D:\ORACLE\ORADATA\TESTING\REDO02.LOG ',
'F:\ORACLE\ORADATA\TESTING\MAINFILES\BCK_REDO02.LOG ') SIZE =
50M,
GROUP 3 ( 'D:\ORACLE\ORADATA\TESTING\REDO03.LOG ',
'F:\ORACLE\ORADATA\TESTING\MAINFILES\BCK_REDO03.LOG ') SIZE =
50M;
}

CONFIGURE AUXNAME FOR DATAFILE 1 CLEAR;=20
CONFIGURE AUXNAME FOR DATAFILE 2 CLEAR;=20
.
.

Am I missing something or doing something wrong? Any ideas?

TIA
Gabriel
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --