Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Veritas file locking
there are several ways to fix this. (in decreasing order of draconianess)
nothing quite says "client site database issue" like a misconfigured backup job that decides that its going to lock a controlfile during a backup. puke.
those fuzzy backups of an open database not in hot backup mode or not created by rman are likely worthless. have you ever had them restore a controlfile that was open and active from a backup set?
oh right, this is just backups, not backup/restore/recovery.
telling them that the restore/recovery part will fail may get their attention.
Paul
On Thu, 24 Feb 2005 15:19:30 -0700, Bryan Wells <bunjibry_at_gmail.com> wrote:
> Hello again... newbie here.
>
> 9205 DataWarehouse on W2K Advanced Server. Has anyone ever had any
> issues with Veritas running weekend fulls on everything, including
> data files and oracle binaries? would veritas take precedence by
> locking these files for backup, not allowing the db to access them?
>
> We seem to be having this issue. i can see the error in the alert
> log, and correspond it to a rough time that veritas had the specific
> data file locked for backup. im making assumtions, but we believe
> that it is this that brings the DB down. could this hard down cause
> corruption in our MV indexes, especially since they are not being
> rebuilt when the MV is being rebuilt. or does dropping the MV
> recreate the index?
>
> told you I was a newbie. Thanks in advance for your help and of
> course the help youve given me already!
>
> --
> Bryan S Wells - DBA Newbie
> bunjibry_at_gmail.com
> --
> http://www.freelists.org/webpage/oracle-l
>
-- #/etc/init.d/init.cssd stop # f=ma, divide by 1, convert to moles. -- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 24 2005 - 18:07:11 CST