Re: [Veritas-bu] Oracle Backups

[Steven L. Sesar]

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:[EMAIL PROTECTED]] Sent: Wednesday, November 15, 2006 12:08 PM To: Dave Brown Cc: veritas-bu@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@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@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: [EMAIL PROTECTED] ===================================

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