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

 Interesting. I was searching for sbtpcstart in Metalink and found that you had solved it by mentioning nofilenamecheck.

Govindan
On Tue, 6 Feb 2007 11:27:45 -0500, "Bobak, Mark" <Mark.Bobak_at_il.proquest.com> said:

  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

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