"Arcangelo" <arcangelo-c_at_yahoo.com> wrote in message
news:3ef853fa$0$30820$afc38c87_at_news.optusnet.com.au...
>
> "konsultant_1 - konsultancIT.pl" <konsultant_1_at_konsultancIT.pl> wrote in
> message news:3EF7EF86.1040605_at_konsultancIT.pl...
> > Kalle wrote:
> > > Hi,
> > >
> > > I have couple of instances running on Linux (9iRel2), now I would like
> > > to do an online backup with RMAN to a disk and schedule it to happen
> > > every night.
> > >
> > > I wonder if you have a sample shell script to do this and could you
post
> > > it here.
> > >
> > > TIA
> > > Kalle
> > >
> > HI
> >
> >
> > This is CATALOG version...
> >
> >
> > Best regards
> > --
> >
> > www.konsultancIT.pl
> > Oracle&MS-SQL consulting
> >
>
>
> --------------------------------------------------------------------------
--
> ----
>
>
> > run {
> > sql "alter system archive log current";
> > allocate channel ch1 type disk;
> > backup full
> > format '/oracle/backup_rman/bckF_%s_%p_%d_%u'
> > (database include current controlfile);
> > sql "alter system archive log current";
> > backup
> > format '/oracle/backup_rman/bckA_%s_%p_%d_%u'
> > (archivelog all delete input);
> > }
> >
>
>
> It's also a very out of date version.
>
> You don't need either of the 'alter system archive log current' lines,
> because 9i RMAN throws one in for you automatically before beginning the
> backup of archivelogs.
>
> You also don't need the 'include current controlfile' line, because in 9i
> RMAN, any time you backup something that includes the SYSTEM datafile,
RMAN
> throws the controlfile into the backup set automatically.
>
> And, since this is 9i RMAN, Oracle is recommending running without a
catalog
> database these days, and hence the elaborate script you have is a bit
> redundant.
>
> To the original poster: all you need, given that you have 9i Release 2,
is:
>
> backup database;
>
> For scheduling, try cron, dbms_job or Enterprise Manager.
>
> ;-o
>
>
This is absolute nonsense.
George Barbour.
Received on Tue Jun 24 2003 - 10:03:54 CDT
