RE: Need help with RMAN duplicate database, hangs on sbtpcstart event.....
- From: "Kerber, Andrew" <Andrew.Kerber@xxxxxxx>
- To: Mark.Bobak@xxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 6 Feb 2007 10:41:14 -0600
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bobak, Mark
Sent: Tuesday, February 06, 2007 10:28 AM
To: oracle-l@xxxxxxxxxxxxx
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@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.
==============================================================================
Other related posts:
