- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle control file corrupted when the backup were...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Forums
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-19-2010 04:48 AM
тАО01-19-2010 04:48 AM
Oracle control file corrupted when the backup were running
So I'd like to verify with all of you guys, if anybody has heard anything about DP affecting the oracle environment. Any comment or suggestions will be apreciated.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-19-2010 05:01 AM
тАО01-19-2010 05:01 AM
Re: Oracle control file corrupted when the backup were running
Did this happen once or it happens everytime you run backups? Or did it happen as soon as you started backing up with DP?
You also mentioned archive logs, normally you don't backup the control files (or the redo logs or the data files)? What exactly did your backup job do?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-19-2010 05:04 AM
тАО01-19-2010 05:04 AM
Re: Oracle control file corrupted when the backup were running
Maybe you could share with us what kind of backup are you performing? Do you use RMAN ? Do you use some custom scripting to perform backup?
You say that you are DP admin. Is this a typo? If not, can you please explain to me what does it mean?
I suppose your ORACLE DB have 2 or 3 control
files, right? All of those files were corrupted? Do you have a full backup or not?
It is a good idea to actually keep in handy (and to make it on regular basis) a full backup.
Best regards,
Horia.
Horia.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-19-2010 05:50 AM
тАО01-19-2010 05:50 AM
Re: Oracle control file corrupted when the backup were running
The backup job is using the RAM, from oracle side without any different scripts.
From oracle stand point I can comment to you that we have 3 control files. When the problem happens just one got corrupted.
Our backup schedule is distributed as indicated below, and it is executed in a daily basis:
0:00 Full Backup of Oracle
06:00am / 01:00pm /09:00pm Incremental backups with focus on archive files removal.
I faced this problem last weekend and it has happened exactly 30 day before. I mean happened 2nd weekend of december/2009 and now of january/2010.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-19-2010 06:29 AM
тАО01-19-2010 06:29 AM
Re: Oracle control file corrupted when the backup were running
Is there a UNIX admin? Did he/she look at this issue?
> The backup job is using the RAM, from oracle side without any different scripts.
???
> 0:00 Full Backup of Oracle
> 06:00am / 01:00pm /09:00pm Incremental backups with focus on archive files removal.
Which files are in the datalist of the DP backup jobs? If RMAN is running, then RMAN is backing up the oracle databases and usually RMAN is set up by the DBAs. Then you (the backup admin) only need to backup the RMAN areas and NOT the database files. So the DP most likely is not touching the control files unless your datalist is including them. You need to provide more details here.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-19-2010 07:19 AM
тАО01-19-2010 07:19 AM
Re: Oracle control file corrupted when the backup were running
If the file is corrupted on the disk - then Data Protector will back up a corrupted file.
One thing...you noticed a pattern that started last month. You might want to check and see if the DBA's are running a once a month process that would affect Oracle not running RMAN.
If your not the HPUX Admin, then ask them to check cron for Oracle. Or check with DBA's and maybe they can confirm. Even if they don't and you mention this - they might go back and change when they are running this and then if the problem 'quietly' goes away - you'll know!
Rgrds,
Rita
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-19-2010 09:46 AM
тАО01-19-2010 09:46 AM
Re: Oracle control file corrupted when the backup were running
I├в d like to clarify again that I├в m backing up the Oracle using the RAM. So for those Cell Manager which has Oracle integration, you can setup backup jobs for oracle without using ├в externals├в RMAN backup scripts.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-19-2010 10:39 PM
тАО01-19-2010 10:39 PM
Re: Oracle control file corrupted when the backup were running
I believe Oracle recommend that each control file to be on different physical disks. If this is the case, maybe the HP-UX admin should check for hardware problems on the physical disk which holds the corrupted file.
Another thing: I am not very good at acronysms, can you please explain what it is RAM?
I understand that your daily backup procedure is
> 0:00 Full Backup of Oracle
> 06:00am / 01:00pm /09:00pm Incremental >backups with focus on archive files removal.
All three incremental backups experience the same corrupted control file? Your full backup is all right, no corruption?
Best regards,
Horia.
Horia.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-20-2010 03:30 AM
тАО01-20-2010 03:30 AM
Re: Oracle control file corrupted when the backup were running
First of all, DP has nothing to do with this controlfile corruption since all DP does is an interface with RMAN (not RAM). So, the issue is with RMAN (DBA's job) or filesystems (HP-UX adm job's).
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-20-2010 06:27 AM
тАО01-20-2010 06:27 AM
Re: Oracle control file corrupted when the backup were running
RMAN stores backup information in the controlfile and will increase the size of the controlfile, make sure it has room to grow. You can use the Oracle parameter CONTROL_FILE_RECORD_KEEP_TIME to control the number of days to retain the information. Mine is set for 90, but should reflect your tape retention period.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-20-2010 07:26 AM
тАО01-20-2010 07:26 AM
Re: Oracle control file corrupted when the backup were running
Anyway, you comment was a good one, I will be forwarding this indication to our DBAs.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-20-2010 10:14 AM
тАО01-20-2010 10:14 AM
Re: Oracle control file corrupted when the backup were running
That's the problem right there. When the filesystem is full, any data writes to a file will fail and leave the file corrupt. Your UNIX admin should have caught this and give this as the reason for the corrupt control files.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-20-2010 10:23 AM
тАО01-20-2010 10:23 AM
Re: Oracle control file corrupted when the backup were running
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-22-2010 06:05 AM
тАО02-22-2010 06:05 AM
Re: Oracle control file corrupted when the backup were running
As long as you have enough disk space.