Re: RMAN/NETBACKUP/ORACLE 8.1.6 Configuration Problems

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).