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: Kalle <kminerva_at_jippii.fi>
Date: Tue, 24 Jun 2003 07:03:16 GMT
Message-ID: <3EF7F656.C87A24EA@jippii.fi>


excellent,

thank you

Kalle

"konsultant_1 - konsultancIT.pl" wrote:

> 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
>
> ------------------------------------------------------------------------
> Name: backupFull.sh
> backupFull.sh Type: Bourne Shell Program (application/x-sh)
> Encoding: 7bit
>
> ------------------------------------------------------------------------
> 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);
> }
Received on Tue Jun 24 2003 - 02:03:16 CDT

Original text of this message

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