ORA-27069: attempt to do I/O beyond the range of the file

After reviewing this error in the alert log, I found that this was pertaining to one particular datafile.  What I did to resolve this issue was the following:

1. Go to the primary database and backup the datafile in question.  In this case, it was datafile #56.

Recovery Manager: Release - Production on Tue Dec 20 21:52:01 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to target database: POC2 (DBID=1234567890)

RMAN> backup as compressed backupset datafile 56;

Starting backup at 20-DEC-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1492 instance=poc22 device type=DISK
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00056 name=+DATA/poc2/datafile/tg_ods.256.767919427
channel ORA_DISK_1: starting piece 1 at 20-DEC-11
channel ORA_DISK_1: finished piece 1 at 20-DEC-11
piece handle=/mnt/operational_dba/rman/poc2/5smuncca_1_1 tag=TAG20111220T215210 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 20-DEC-11

2. Copy over the backup piece from primary database server to standby database server (if required).

3.  Catalog the backuppiece on the standby controlfile.

RMAN> catalog backuppiece '/mnt/operational_dba/rman/poc2/5smuncca_1_1';

cataloged backup piece
backup piece handle=/mnt/operational_dba/rman/poc2/5smuncca_1_1 RECID=768 STAMP=770421285

4. Restore and recover the datafile.

RMAN> restore datafile 56;

Starting restore at 20-DEC-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1887 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00056 to /opt/data/poc2adg/datafile/tg_ods.256.767919427
channel ORA_DISK_1: reading from backup piece /mnt/operational_dba/rman/poc2/5smuncca_1_1
channel ORA_DISK_1: piece handle=/mnt/operational_dba/rman/poc2/5smuncca_1_1 tag=TAG20111220T215210
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
Finished restore at 20-DEC-11

RMAN> recover database noredo;

Starting recover at 20-DEC-11
using channel ORA_DISK_1

Finished recover at 20-DEC-11

RMAN> exit

5. Re-enable auto recovery on standby.



Popular posts from this blog

RMAN-06091: no channel allocated for maintenance

ORA-00338: log {n} of thread {n} is more recent than control file

RMAN-10038: database session for channel prm3 terminated unexpectedly