Re: RMAN/NETBACKUP/ORACLE 8.1.6 Configuration Problems

Also the command to validate fo rmissing arch logs is:

at the ramn prompt run

change archivelog all crosscheck; --to check...

to validate...

change archivelog all validate;

(please read up the difference froim the manual; pl excuse the typos.. I am a two finger typiust...)

Anjan

Anjan Thakuria wrote:

> We have the following configuration and it has been working all right for more
> than a year and half.
>
> The config as follows...
>
> Solaris 2.6
> Netbackup 3.2
> Oracle 8.1.6 and 8.1.7.1
>
> We always do the following take a full level 0 backup... ( have riun into
> problems where it asks for very old arch so we do a resync catalog as well..
>
> Here is a sample script...
>
> run{
> resync catalog;
> allocate channel t1 type 'sbt_tape';
> allocate channel t2 type 'sbt_tape';
> backup
> incremental level 0
> format 'df_%d_%t_%s_%p'
> filesperset 5
> (database);
> # Archive the current online redo log
> sql 'alter system archive log current' ;
> sql 'alter system archive log current' ;
> # Backup the archivelogs and delete
> backup
> filesperset 10
> format 'al_t%t_s%s_p%p'
> (archivelog all delete input) ;
> release channel t1;
> release channel t2;
>
> Off course we have this as a stored script which is called form a shell script
> and is executable by root.
>
> All the backups are scheduled using the netbackup console and is only available
> top the SA.
>
> Pl let me know if there is anything more that I can help you with on this .( I
> alos have sized the large pool for this .. )
>
> Anjan
>
> Ruth Gramolini wrote:
>
> > Do you backup your archivelogs before you delete them? If you do you
> > shouldn't get the rman-20242 error. We always backup the archivelogs when
> > we do backup and store the archivelog backup with the database backup.
> >
> > We don't backup to tape so I can't help you there and we don't use
> > Netbackup.
> >
> > Regards,
> > Ruth
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Tuesday, September 04, 2001 4:25 AM
> >
> > > We have SUN engineers configure and setup Netbackup and RMAN: since then
> > we
> > > get repeated errors on all our databases: including the following:
> > > ORA-196506 failed to create sequential file returned error
> > > and
> > >
> > > rman-20242: specification does not match any archivelog in the recovery
> > > catalog
> > > (this we solve and it keeps repeating after the archivelogs have been
> > > deleted).
> > >
> > > Some instances just hang when it needs the tape.
> > >
> > > Does anyone have any advise/comments. Should we rip it all out and install
> > > from fresh ? I also feel that there were some patches added and the
> > > relinking of netbackup and oracle was not done.
> > >
> > > Thanks for any advise
> > > Sam
> > >
> > >
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author:
> > > INET: RABBIT_at_emirates.net.ae
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ruth Gramolini
> > INET: rgramolini_at_tax.state.vt.us
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Anjan Thakuria
> INET: anjan.thakuria_at_eds.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anjan Thakuria
  INET: anjan.thakuria_at_eds.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).