Veritas-bu

[Veritas-bu] rman cmd files w/nb

2002-07-05 12:53:39
Subject: [Veritas-bu] rman cmd files w/nb
From: RMarkham AT hafeleamericas DOT com (Markham, Richard)
Date: Fri, 5 Jul 2002 12:53:39 -0400
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C22444.83391ED0
Content-Type: text/plain;
        charset="iso-8859-1"

I need more information on configuration of the rman cmd files. The
following is a command file for a backup I'm trying.  The script is getting
executed successfully and I have a .out file that I can tail which it seems
to get to a point and not progress any further.  The robot is not active so
I have a hunch RMAN is waiting on media, or perhaps NB is waiting for some
info from RMAN.  Is there any supplementary documentation to the NB Oracle
System Admin. Guide ?

###cmd file###
connect target 'sys/****@prod'
connect catalog 'rman/****@admin'

run {
allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type 'SBT_TAPE';
backup
  full
  tag cold_db_bk_full
  filesperset 5
  format 'bk_%U_%t'
    (database);
}
###end cmd file###

###.out file###
connected to target database: PROD (DBID=2586436430)

connected to recovery catalog database

allocated channel: t1
channel t1: sid=20 devtype=SBT_TAPE
channel t1: MMS Version 2.2.0.1

allocated channel: t2
channel t2: sid=21 devtype=SBT_TAPE
channel t2: MMS Version 2.2.0.1

Starting backup at 05-JUL-02
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u21/oracle/proddata/system01.dbf
input datafile fno=00009 name=/u11/oracle/proddata/applsysx01.dbf
channel t1: starting piece 1 at 05-JUL-02
channel t2: starting full datafile backupset
channel t2: specifying datafile(s) in backupset
input datafile fno=00002 name=/u21/oracle/proddata/system02.dbf
input datafile fno=00289 name=/u11/oracle/proddata/applsysx02.dbf
channel t2: starting piece 1 at 05-JUL-02
###end .out file###

------_=_NextPart_001_01C22444.83391ED0
Content-Type: text/html;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>rman cmd files w/nb</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>I need more information on configuration of the rman =
cmd files. The following is a command file for a backup I'm =
trying.&nbsp; The script is getting executed successfully and I have a =
.out file that I can tail which it seems to get to a point and not =
progress any further.&nbsp; The robot is not active so I have a hunch =
RMAN is waiting on media, or perhaps NB is waiting for some info from =
RMAN.&nbsp; Is there any supplementary documentation to the NB Oracle =
System Admin. Guide ?</FONT></P>

<P><FONT SIZE=3D2>###cmd file###</FONT>
<BR><FONT SIZE=3D2>connect target 'sys/****@prod'</FONT>
<BR><FONT SIZE=3D2>connect catalog 'rman/****@admin'</FONT>
</P>

<P><FONT SIZE=3D2>run {</FONT>
<BR><FONT SIZE=3D2>allocate channel t1 type 'SBT_TAPE';</FONT>
<BR><FONT SIZE=3D2>allocate channel t2 type 'SBT_TAPE';</FONT>
<BR><FONT SIZE=3D2>backup</FONT>
<BR><FONT SIZE=3D2>&nbsp; full</FONT>
<BR><FONT SIZE=3D2>&nbsp; tag cold_db_bk_full</FONT>
<BR><FONT SIZE=3D2>&nbsp; filesperset 5</FONT>
<BR><FONT SIZE=3D2>&nbsp; format 'bk_%U_%t'</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp; (database);</FONT>
<BR><FONT SIZE=3D2>}</FONT>
<BR><FONT SIZE=3D2>###end cmd file###</FONT>
</P>

<P><FONT SIZE=3D2>###.out file###</FONT>
<BR><FONT SIZE=3D2>connected to target database: PROD =
(DBID=3D2586436430)</FONT>
</P>

<P><FONT SIZE=3D2>connected to recovery catalog database</FONT>
</P>

<P><FONT SIZE=3D2>allocated channel: t1</FONT>
<BR><FONT SIZE=3D2>channel t1: sid=3D20 devtype=3DSBT_TAPE</FONT>
<BR><FONT SIZE=3D2>channel t1: MMS Version 2.2.0.1</FONT>
</P>

<P><FONT SIZE=3D2>allocated channel: t2</FONT>
<BR><FONT SIZE=3D2>channel t2: sid=3D21 devtype=3DSBT_TAPE</FONT>
<BR><FONT SIZE=3D2>channel t2: MMS Version 2.2.0.1</FONT>
</P>

<P><FONT SIZE=3D2>Starting backup at 05-JUL-02</FONT>
<BR><FONT SIZE=3D2>channel t1: starting full datafile backupset</FONT>
<BR><FONT SIZE=3D2>channel t1: specifying datafile(s) in =
backupset</FONT>
<BR><FONT SIZE=3D2>input datafile fno=3D00001 =
name=3D/u21/oracle/proddata/system01.dbf</FONT>
<BR><FONT SIZE=3D2>input datafile fno=3D00009 =
name=3D/u11/oracle/proddata/applsysx01.dbf</FONT>
<BR><FONT SIZE=3D2>channel t1: starting piece 1 at 05-JUL-02</FONT>
<BR><FONT SIZE=3D2>channel t2: starting full datafile backupset</FONT>
<BR><FONT SIZE=3D2>channel t2: specifying datafile(s) in =
backupset</FONT>
<BR><FONT SIZE=3D2>input datafile fno=3D00002 =
name=3D/u21/oracle/proddata/system02.dbf</FONT>
<BR><FONT SIZE=3D2>input datafile fno=3D00289 =
name=3D/u11/oracle/proddata/applsysx02.dbf</FONT>
<BR><FONT SIZE=3D2>channel t2: starting piece 1 at 05-JUL-02</FONT>
<BR><FONT SIZE=3D2>###end .out file###</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C22444.83391ED0--

<Prev in Thread] Current Thread [Next in Thread>
  • [Veritas-bu] rman cmd files w/nb, Markham, Richard <=