[Veritas-bu] Oracle Backups
2006-11-15 14:07:16
Subject: |
[Veritas-bu] Oracle Backups |
From: |
ssesar at mitre.org (Steven L. Sesar) |
Date: |
Wed, 15 Nov 2006 14:07:16 -0500 |
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: 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
>
> _______________________________________________
> 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/2ca0cec2/attachment-0001.html
|
|
|