04-28-2023 09:04 AM
Hi,
on windows client, we backup an Oracle DB with catalog. It's backup about 1,6Tb and last week i found two of four jobs still writing but hanging. I've stopped the backup, and on ..\user_ops\dbext\logs there are 4 .lock files like this:
vxbsa.01651564654.23215.5151.files.1.lock
If i remember, when backup finish these lock files are canceled. I requested at dba admin to check rman session hangings and then i retried the backup. Now i have 8 lock files.
How i can resolve this issue?
I think that the lock still there, backup will fail.
Any suggest is accepted.
Thanks in advance, and Regards.
Solved! Go to Solution.
05-08-2023 04:21 AM
Try using the suggestions made in this thread at SuperUser to identify what process are locking the files.
https://superuser.com/questions/117902/find-out-which-process-is-locking-a-file-or-folder-in-windows
05-01-2023 12:21 AM
My suggestions:
I don't recall leftover lock files will prevent new backups.
05-02-2023 01:22 AM
Hi Nicolai,
i've executed your steps but if i try to delete lock files, it's not permitted and i receive this message: "The action can't be completed because the file is open in OracleService"
Thanks & Regards,
05-03-2023 12:21 AM
That's new to me. Is Rman process still running ?
05-03-2023 04:53 AM
Hi Nicolai,
dba admin told me that he has deleted old process appended, but lock's files deletion, still not permitted.
Thanks & Regards,
05-08-2023 04:21 AM
Try using the suggestions made in this thread at SuperUser to identify what process are locking the files.
https://superuser.com/questions/117902/find-out-which-process-is-locking-a-file-or-folder-in-windows