05-06-2015 05:51 AM
It's been couple of months since we are noticing that the database backups are getting hung. Its intruppting the archive log backup as well. This issue is intermittent and doen't look to be from backup side. We are trying to understand about the failure along with other options like to have ZFS snapshot backups instead of the oracle agent.
Unfortunately i don't have the logs of hung DB/Archive backups. The DB backups is scheduled to run on every saturday and i will get the logs once it runs.
Just want to know if there are any thoughts and/or recommendations?
Configuration Details:
Oracle agent is installed on .........
SunOS 5.9 UNIX Client.
SunOS 5.10 UNIX Media Server
SunOS 5.9 UNIX Master Server
Solved! Go to Solution.
05-08-2015 01:29 AM
3 Choices:
I cannot see any other options.
You will need to troubleshoot hung backups.
I guess you no longer have support with Oracle or Symantec since Solaris 9 ran out of support with both vendors long time ago....
If you want to go the ZFS snapshot route - you will have to ask Oracle if that is supported with Oracle db.
05-06-2015 11:34 PM
RMAM backup/archives to disk, you then bacup the dump file via file system backup. Does not scale very well and you may need a lot of disk.
05-07-2015 11:17 AM
Thanks for reverting back.
Yes. We do have that plan but its at the bottom. You rightly said that we need to provide lot of space to dump the RMAN DB/archive files and thats what we can't offer at the moment.
05-08-2015 01:29 AM
3 Choices:
I cannot see any other options.
You will need to troubleshoot hung backups.
I guess you no longer have support with Oracle or Symantec since Solaris 9 ran out of support with both vendors long time ago....
If you want to go the ZFS snapshot route - you will have to ask Oracle if that is supported with Oracle db.
05-08-2015 05:57 AM
Thanks Marriane for having your thoughts!
You're right that we don't have Symantec support. We have 6.5.6 environment. We are upgrading it to 7.6 in September this year.
Reg troubleshooting, i have created dbclient log directory to capture the logs when the schedule DB backup runs Sat 9AM ET.
I'm not sure whether the backups will success or hung but i will post the logs tomorrow.
05-08-2015 06:11 AM
Please remember to change permission on dbclient folder to 777.
Best to start a new discussion for hanging Oracle backups. I believe your query about alternative backup methods in this discussion has been answered.
05-08-2015 07:02 AM
zfs snapshot works, I can tell you. If you want to be sure sure, you could stop the db so theres nothing in flight, snap the filesystems and theres your cold db backup.Start up, wont be down for more than a few minutes, or you can do it hot live with a bit of thinking.Jim
05-08-2015 07:13 AM
Yes. My query is answered.
I'm openig a new discussion right away for the hung oracle backup. I just got information that yesterday my colleague ran Oracle DB Incremental backups as a test and it's hung. I'll copy the logs in other discussion.
Possible to let me know what part of logs you need ?
Thanks Nicolai & Marianne for your thoughts!
-Arshad