cancel
Showing results for 
Search instead for 
Did you mean: 

BRBACKUP FAILED WITH RETURNCODE 3

0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

volker_borowski2
Active Contributor
0 Kudos

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

0 Kudos

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

volker_borowski2
Active Contributor
0 Kudos

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

0 Kudos

Hi Volker,

Thanks for the reply,

Linux guys checked there is no problem with OS and FS .

Please suggest for the resolution .

Regards,

chandu

Former Member
0 Kudos

In addition to oracle error ORA-27072: File I/O error should be more info about error. Check errno code returned

Regards

Roman

Answers (1)

Answers (1)

Former Member
0 Kudos

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