on 09-01-2012 10:16 AM
Hi All,
BRBACKUP failing with return 3 and the following are the errors in the log file.
ORA-00206: error in writing (block 6144, # blocks 64) of control file
ORA-00202: control file: '/oracle/PRD/sapbackup/cntrlPRD.dbf'
ORA-27072: File I/O error
Plese suggest how to resolve the issue.
Thankyou
Regards
--Chandu
File IO error when writing to /oracle/PRD/sapbackup/cntrlPRD.dbf suggests:
- Harddisk defective
- Filesystem defective
- Filesystem full
- No write permission to directory
- No write permission to file (if already existing)
Volker
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Volker,
Thanks for the reply actually backup is taken by another team,they will backup to tapes we need to monitor the backups if any issue occurs we have to resolve,please suggest how can we check the error occurred due to tape or file system and it will comes under basis task or backup team?
Regards
Chandu
Well, a hardware error or a filesystem defect should be logged in the operating system syslog, which might be, depending on your unix-flavor be located in
/var/adm/messages
/var/adm/syslog
/var/log/messages
/var/log/syslog
:
:
or these messages might be listable with commands like "dmesg" or "errpt", ...
You can try to manually backup the controlfile to a different location than sapbackup in sqlplus:
alter database backup controlfile to '/filesystem/for_sure_intact/with_all_required_permissions/cntrl_copy_prd.dbf';
If this works, /oracle/PRD/sapbackup has a problem for sure.
You could ask the unix guys to run a filesystem check (fsck) for the underlying filesystem. This might require the filesystem to be unmounted, so this might require a downtime, depending on UNIX and filesystemtype.
The permissions should be checkable with "ls -l" 😉
Volker
Hi Chandrashekar,
It looks like the controlfile has been corrupted. Copy one of the correct controlfile into the "/oracle/PRD/sapbackup". To do so, follow the procedure, below;
1) Identify the othe control files at the OS level;
SQL> show parameter control_files;
2) Shutdown the database
SQL> shutdown immediate
3) Rename original corrupted controlfile "cntrlPRD.dbf" to "cntrlPRD.dbf.orig". Then, copy one of the correct control files into the "/oracle/PRD/sapbackup", identified at the step 1.
> mv cntrlPRD.dbf cntrlPRD.dbf.orig
> cp <controlfile path>/cntrlPRD.dbf /oracle/PRD/sapbackup/cntrlPRD.dbf
4) Start the database
SQL> startup
Then, try to take a backup.
Best regards,
Orkun Gedik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.