Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN sample script for Linux

Re: RMAN sample script for Linux

From: Arcangelo <arcangelo-c_at_yahoo.com>
Date: Tue, 24 Jun 2003 23:36:52 +1000
Message-ID: <3ef853fa$0$30820$afc38c87@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 Received on Tue Jun 24 2003 - 08:36:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US