Re: [Veritas-bu] Oracle Backups

[Steven L. Sesar]

RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of backup command at 11/14/2006 22:36:29 RMAN-06059: expected archived log not found, lost of archived log compromises recoverability ORA-19625: error identifying file /s03/archivelogs/prod/DEST1/archPROD0000124130.arc.0001 ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 This indicates that you (or someone) did manually delete archive logs. RMAN is expecting /s03/archivelogs/prod/DEST1/archPROD0000124130.arc.0001 to exist, because according to the catalog, it has backed it up at least once. It's trying a subsequent time, but it's been manually removed - hence, the job is failing. Martin, Jonathan (Contractor) wrote: 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Dave Brown Sent: Wednesday, November 15, 2006 1:20 PM To: Peter DrakeUnderkoffler Cc: veritas-bu@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:[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 _______________________________________________ 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