So I hear but I am not sure this is what he did.  I have sent and asked
this question of him but have not received answer back as of yet.  I did
tell him that backups will not complete until this is resolved

-----Original Message-----
From: Martin, Jonathan (Contractor) [mailto:JMARTI05 at intersil.com] 
Sent: Wednesday, November 15, 2006 12:39 PM
To: Dave Brown; Peter DrakeUnderkoffler
Cc: veritas-bu at mailman.eng.auburn.edu
Subject: RE: [Veritas-bu] Oracle Backups



You can't just delete archive logs, you have to use RMAN to remove them.

Per one of my oracle DBAs.

Go into RMAN, Connect to Catalog
Run "change archivelog all validate;" then "resynch catalog;"
Run full backup.

I'm not an Oracle DBA but I know if you've manually deleted Oracle
Archive logs that's not a good thing.

-Jonathan

-----Original Message-----
From: veritas-bu-bounces at mailman.eng.auburn.edu
[mailto:veritas-bu-bounces at mailman.eng.auburn.edu] On Behalf Of Dave
Brown
Sent: Wednesday, November 15, 2006 1:20 PM
To: Peter DrakeUnderkoffler
Cc: veritas-bu at mailman.eng.auburn.edu
Subject: Re: [Veritas-bu] Oracle Backups

I just got off the phone with my NetBackup support.

Excuse me for my lack of knowledge here.  Not an Oracle/Linux guy at
all.

That being said, here is scenario of what happened nearest I can tell.

Oracle backups have been failing.

What ever function tells Oracle that it is ok to clean up transaction
logs has not been saying it is ok.

Log disk filled up

Oracle/dba guy deleted files to make room

Job fails with new error stating the log file it is supposed to backup
does not exist.

My NBSupport says he deleted the logs from the file system and not from
Oracle so when agent queries Oracle,  it says backup this file but when
it goes to do it,  file does not exist.

Make any sense at all ?

Dave

-----Original Message-----
From: Peter DrakeUnderkoffler [mailto:pcd at xinupro.com]
Sent: Wednesday, November 15, 2006 12:08 PM
To: Dave Brown
Cc: veritas-bu at mailman.eng.auburn.edu
Subject: Re: [Veritas-bu] Oracle Backups

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

The oracle client does nothing like that, all the management of archive
and redo logs is always handled within Oracle.  The agent simply
understands both RMAN and Oracle API and executes a RMAN script.  Keep
in mind that at times some house cleaning is needed between the RMAN
catalogs and the NetBackup catalogs in reference to expired images to
RMAN backup id names.

Thanks
Peter

Peter DrakeUnderkoffler
Xinupro, LLC
617-834-2352



Dave Brown wrote:
> Ok,  need some help from Oracle/Linux people here.
> 
>  
> 
> I am running an oracle backup using NB client 5.1 and Oracle client. 
> Our dba has created RMAN scripts to do hot backups of the databases.
> 
>  
> 
> I am wondering if the oracle client works like other database clients 
> (exchange, sql)  in such that it will clear transaction logs after a 
> good backup.
> 
>  
>  
> This message (including any attachments) is intended for the sole use
of
> the individual to whom it is addressed and may contain confidential 
> information. You are hereby notified that any dissemination, 
> distribution, or duplication of this message by someone other than the

> intended addressee or their designated agent is strictly prohibited.
> Information included in this message that does not relate to the 
> specified business of Worknet shall be understood as neither given by 
> nor endorsed by Worknet or its employees.  Any cost estimates or 
> estimated quotes included in this message are considered non-binding 
> estimates only and must not be considered final costs unless contained

> within an official proposal document.
> 
> 
>
------------------------------------------------------------------------
> 
> _______________________________________________
> Veritas-bu maillist  -  Veritas-bu at mailman.eng.auburn.edu 
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (FreeBSD)

iD8DBQFFW1djl+lekZRM55oRAqvnAKCJ4wsuefwxNPdhgND5PLG23iIj3gCgjCzV
EqAYw/YTNQ3sSCsmdbw97rM=
=zaI+
-----END PGP SIGNATURE----- 
 
 
This message (including any attachments) is intended for the sole use of
the individual to whom it is addressed and may contain confidential
information. You are hereby notified that any dissemination,
distribution, or duplication of this message by someone other than the
intended addressee or their designated agent is strictly prohibited.
Information included in this message that does not relate to the
specified business of Worknet shall be understood as neither given by
nor endorsed by Worknet or its employees.  Any cost estimates or
estimated quotes included in this message are considered non-binding
estimates only and must not be considered final costs unless contained
within an official proposal document.

_______________________________________________
Veritas-bu maillist  -  Veritas-bu at mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu