Veritas-bu

[Veritas-bu] Oracle Backups

2006-11-15 13:30:45
Subject: [Veritas-bu] Oracle Backups
From: ssesar at mitre.org (Steven L. Sesar)
Date: Wed, 15 Nov 2006 13:30:45 -0500
Need more information. A-logs will not be deleted by "default" - that 
needs to be explicitly defined. So does backing up a-logs. I suppose 
that it is possible that your script is asking RMAN to truncate the 
logs, but your script doesn't back them up with the backup set. I'm not 
sure that truncating logs will work, if you're not backing them up. Just 
a thought......

Let's see your script and maybe we can help troubleshoot your problem. 
Let's also see the exact RMAN/Oracle error strings from your RMAN log.

--Steve

Dave Brown wrote:
> 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
>   


-- 
===================================

   Steven L. Sesar
   Lead Operating Systems Programmer/Analyst
   UNIX Application Services R101
   The MITRE Corporation
   202 Burlington Road - MS K101
   Bedford, MA 01730
   tel: (781) 271-7702
   fax: (781) 271-2600
   mobile: (617) 519-8933
   email: ssesar at mitre.org

=================================== 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: 
http://mailman.eng.auburn.edu/pipermail/veritas-bu/attachments/20061115/6443a3d2/attachment.html

<Prev in Thread] Current Thread [Next in Thread>