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 11.2.0.1.0 - 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.


SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

Comments

Popular posts from this blog

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

Upgrade from 11gR2 RAC to 12cR1 RAC using cloning methodology

RMAN-06091: no channel allocated for maintenance