Networker

Re: [Networker] Nsrnmo scripts with arguments

2004-06-27 15:07:56
Subject: Re: [Networker] Nsrnmo scripts with arguments
From: Anuj Mediratta <anuj AT ACE-DATA DOT NET>
To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
Date: Sun, 27 Jun 2004 19:07:51 -0000
Sorry for the delay Arun - I was away,

For multiple instances, you need multiple nsrnmo scripts with different
ORACLE_HOME. In this case you configure more than one client resource for
the Client with different backup commands which could be nsrnmo & nsrnmo1
depending on the name of the script given by you.

I have not tried any incr/diff level backups but for db backups, backup
application would backup whatever is provided by the RMAN script, therefore
you need to set the backup level in the script only. Skip level works from
Networker as it simply writes the bootstrap after checking the level and
does not invoke the RMAN script. The only important Legato component in
backup script is Pool name that links it with the other resources. Backup
levels at Legato level are meaningless. Please find below some
documentation I got from Legato for understanding the incr backups. I
discourage incr. backups in db as while restoring, you need to first
restore the full backup and then the increments. This is time consuming but
a db restore is mission critical and should hve the minimum possible
restore window.

****************************************************************************
        INCREMENTAL BACKUPS (WHAT ARE THEY AND WHEN TO USE THEM)
It is essential that a level 0 backup be performed first as this is used as
the reference for all incremental backups. A full backup does not relate to
any incremental backups.
Incremental backups are not the same as having archive logs. Archive logs
hold the changes to all blocks in the Oracle database. If the same block
changes one thousand times in a day then that will be one thousand entries
in the redo logs but only one entry in the incremental backup, whilst if
all blocks change once then the amount of incremental data will be roughly
the same as the amount of archive logs.
Incremental backups, above level 0, will normally store significantly less
data than an incremental 0 or full backup. The backups may not be
significantly faster as it is necessary for Oracle to read each block
before determining whether or not it needs to be backed up, at the selected
backup level. This means that whilst less data is transferred to tape,
possibly across the network, roughly the same amount of data is still read
from the disk subsystem.
This means that incremental backups may be appropriate where it is
necessary to reduce the amount of data stored each night or where backups
are being conducted across a slow network link. Where the backup window is
to be reduced there may be more appropriate methods.
Before restoring an incremental backup it is necessary to restore the
appropriate level 0 backup. This can mean that the recovery window will
increase as the period from the level 0 backup increases. This needs to be
considered in the light of Service Level Agreements (SLAs) and business
requirements.
E.g. if a level 0 is performed on Sunday this may take four hours to
restore. If each day of the week then does a incremental backup then the
restore time may increase each day so that by Saturday the restore time has
changed to five hours.

Incremental Backups
Incremental levels 0-4 are supported by RMAN.  A level 0 of a file or
tablespace must be performed prior to any other incremental backup level.
A non-level 0 backup of a file or tablespace that does not have a previous
level 0 backup will fail.
Differential Incremental Backups
A differential incremental backup contains only blocks that have been
changed since the most recent backup at the same level or lower.

run {
allocate channel dev1 type 'sbt_tape';
backup incremental level 0    # all blocks
database;
}

run {
allocate channel dev1 type 'sbt_tape';
backup incremental level 1      # blocks changed since the last
                              # level 1 or 0
database;
}

run {
allocate channel T1 type 'sbt_tape';
backup incremental level 2      # blocks changed since the last
                              # level 2, 1 or 0
database;
}


Cumulative Incremental Backups
A cumulative incremental backup at level n contains only blocks that have
been changed since the most recent backup at level n-1 or lower.  Compare
the following example with the previous one.

run {
allocate channel T1 type 'sbt_tape';
backup incremental level 2 cumulative  # blocks changed since last
                                       # level 1 or 0
database;
}

****************************************************************************
Please check the exact inc syntax from any RMAN documentation.

Regards,
Anuj Mediratta
LCNA


On Fri, 25 Jun 2004 15:03:59 -0500, Arun Sondhi <asondhi AT RA.ROCKWELL DOT COM>
wrote :

> Hi Anuj,
> Thanks for reply, There are multiple db instances on same server. I would
> be able to one script nsrnmo and pass it SID for each as the client runs.
> Since you are running RMAN I am curious to know how do you schedule level
> backups using RMAN and Legato, as Legato schedules are meaningless (Full
> and skip are the only ones that are meaningful), so how does level get
> passed to RMAN scripts?
>
> Sincerely,
>
> Arun Sondhi
> CCNP,CCDP
>
> Ph  : +1 414.382.0206
> Pg  : +1 414.341.8650
> Mo : +1 414.213.1540
> Extn: 20206
>
>
>
>
> "Anuj Mediratta" <anuj AT ace-data DOT net>
> 06/25/2004 12:47 PM
>
>
>         To:     NETWORKER AT LISTMAIL.TEMPLE DOT EDU, asondhi AT ra.rockwell 
> DOT com
>         cc:
>         Subject:        Re: [Networker] Nsrnmo scripts with arguments
>
>
> Hi Arun,
>
> I don't think you can use nsrnmo.sh with arguments like this. The databse
> ID & the backup type need to be set under the RMAN script only. Infact as
> per my experience, you need to set dbid only if you have multiple dtabases
>
> with same names else bckup would be perfect simply by using connect target
>
> username/password@servicename command.
>
> What is your purpose of using the arguments with the script name?
>
> Regards,
> Anuj Mediratta
> LCNA
> On Thu, 24 Jun 2004 11:32:43 -0500, Arun Sondhi <asondhi AT RA.ROCKWELL DOT 
> COM>
> wrote :
>
> > Hi RMAN users,
> >
> > In Legato can the backup command nsrnmo be passed with arguments like
> > nsrnmo.sh -d <dbid> -t <type>
> >
> > or through Application information?
> >
> >
> >
> > Sincerely,
> >
> > Arun Sondhi
> > CCNP,CCDP
> >
> > Ph  : +1 414.382.0206
> > Pg  : +1 414.341.8650
> > Mo : +1 414.213.1540
> > Extn: 20206
> >
> > --
> > Note: To sign off this list, send a "signoff networker" command via
> email
> > to listserv AT listmail.temple DOT edu or visit the list's Web site at
> > http://listmail.temple.edu/archives/networker.html where you can
> > also view and post messages to the list.
> > =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
> >
> >
> >
>
>
>
> --
> Note: To sign off this list, send a "signoff networker" command via email
> to listserv AT listmail.temple DOT edu or visit the list's Web site at
> http://listmail.temple.edu/archives/networker.html where you can
> also view and post messages to the list.
> =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
>
>
>

--
Note: To sign off this list, send a "signoff networker" command via email
to listserv AT listmail.temple DOT edu or visit the list's Web site at
http://listmail.temple.edu/archives/networker.html where you can
also view and post messages to the list.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

<Prev in Thread] Current Thread [Next in Thread>