RE: Need help with RMAN duplicate database, hangs on sbtpcstart event.....

Just a guess, it might not have sufficient memory available to startup.  

Andrew W. Kerber
Oracle DBA
UMB   "If at first you dont succeed, dont take up skydiving"

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bobak, Mark Sent: Tuesday, February 06, 2007 10:28 AM To: oracle-l_at_freelists.org
Subject: Need help with RMAN duplicate database, hangs on sbtpcstart event.....  

Hi,

I'm running 9.2.0.6 on Sparc Solaris 9, and I'm trying to duplicate a database via RMAN.

Here's what I'm doing.

First, to connect, I do:

rman target / catalog rman/rman_at_rmancat auxiliary "sys/******@pep1"

Then I run:
run {
allocate auxiliary channel t1 type sbt_tape; set until time "to_date('Feb 02 2007 08:00:00','Mon DD YYYY HH24:MI:SS')";
DUPLICATE TARGET DATABASE to pep1 nofilenamecheck LOGFILE
GROUP 1
('/dev/vx/rdsk/redodg/pep1-redo01a','/dev/vx/rdsk/redodg/pep1-redo01b')
size 199M reuse,
GROUP 2
('/dev/vx/rdsk/redodg/pep1-redo02a','/dev/vx/rdsk/redodg/pep1-redo02b')
size 199M reuse,
GROUP 3
('/dev/vx/rdsk/redodg/pep1-redo03a','/dev/vx/rdsk/redodg/pep1-redo03b')
size 199M reuse,
GROUP 4
('/dev/vx/rdsk/redodg/pep1-redo04a','/dev/vx/rdsk/redodg/pep1-redo04b')
size 199M reuse,
GROUP 5
('/dev/vx/rdsk/redodg/pep1-redo05a','/dev/vx/rdsk/redodg/pep1-redo05b')
size 199M reuse,
GROUP 6
('/dev/vx/rdsk/redodg/pep1-redo06a','/dev/vx/rdsk/redodg/pep1-redo06b')
size 199M reuse,
GROUP 7
('/dev/vx/rdsk/redodg/pep1-redo07a','/dev/vx/rdsk/redodg/pep1-redo07b')
size 199M reuse,
GROUP 8
('/dev/vx/rdsk/redodg/pep1-redo08a','/dev/vx/rdsk/redodg/pep1-redo08b')
size 199M reuse;
}  

In terms of output, I get:
allocated channel: t1
channel t1: sid=20 devtype=SBT_TAPE
channel t1: VERITAS NetBackup for Oracle - Release 5.1 (2006040521)

executing command: SET NEWNAME

Starting Duplicate Db at 06-FEB-07

Then I get all the auto-generated NEWNAME commands from specifying nofilename.

Finally, I get:
Starting restore at 06-FEB-07

channel t1: starting proxy datafile restore channel t1: specifying datafile(s) for proxy restore restoring datafile 00001 to /oracle/tmpdata/system_test proxy file handle=bk_5945_41_613681223_ppi98227_41_1 restoring datafile 00002 to /dev/vx/rdsk/prd1dg/vtools01 proxy file handle=bk_5945_30_613681223_ppi98227_30_1 restoring datafile 00003 to /dev/vx/rdsk/prd1dg/vtools02 proxy file handle=bk_5945_42_613681223_ppi98227_42_1 restoring datafile 00004 to /dev/vx/rdsk/prd1dg/vpqdsidx01 proxy file handle=bk_5945_43_613681223_ppi98227_43_1 restoring datafile 00005 to /dev/vx/rdsk/prd1dg/vpqdsidx02 proxy file handle=bk_5945_44_613681223_ppi98227_44_1 restoring datafile 00006 to /dev/vx/rdsk/prd1dg/vpqdmidx01 proxy file handle=bk_5945_3_613681223_ppi98227_3_1 restoring datafile 00007 to /dev/vx/rdsk/prd1dg/vpqdmidx02 proxy file handle=bk_5945_45_613681223_ppi98227_45_1 restoring datafile 00008 to /dev/vx/rdsk/prd1dg/vpqdmidx03 proxy file handle=bk_5945_46_613681223_ppi98227_46_1 restoring datafile 00009 to /dev/vx/rdsk/prd1dg/vpqdmidx04 proxy file handle=bk_5945_47_613681223_ppi98227_47_1 restoring datafile 00010 to /dev/vx/rdsk/prd1dg/vascxlidx41 proxy file handle=bk_5945_31_613681223_ppi98227_31_1 restoring datafile 00011 to /dev/vx/rdsk/prd1dg/vascxlidx42 proxy file handle=bk_5945_32_613681223_ppi98227_32_1 restoring datafile 00012 to /dev/vx/rdsk/prd1dg/vdocxlidx41 proxy file handle=bk_5945_335_613681223_ppi98227_335_1 ...

And that continues for all the datafiles, and then it hangs......

If I look at V$SESSION_WAIT on the auxiliary server, I see it's waiting on sbtpcstart wait event. I left it running over night. It waited on that event for over 20 hours.

Does anyone have any idea what's going on here??

Thanks!

-Mark  

-- 
Mark J. Bobak 
Senior Oracle Architect 
ProQuest Information & Learning 

There is nothing so useless as doing efficiently that which shouldn't be
done at all.  -Peter F. Drucker, 1909-2005 

 


------------------------------------------------------------------------------
NOTICE:  This electronic mail message and any attached files are confidential.  The information is exclusively for the use of the individual or entity intended as the recipient.  If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited.  If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.

==============================================================================


--
http://www.freelists.org/webpage/oracle-l