[Veritas-bu] rman cmd files w/nb
2002-07-05 12:53:39
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. 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 ?</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> full</FONT>
<BR><FONT SIZE=3D2> tag cold_db_bk_full</FONT>
<BR><FONT SIZE=3D2> filesperset 5</FONT>
<BR><FONT SIZE=3D2> format 'bk_%U_%t'</FONT>
<BR><FONT SIZE=3D2> (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 <=
|
|
|