ORA-19625 ORA-27037 Errors Using Incrementally Updating Backups

Today I have been reported with next error when a full backup is executed;

 
Starting backup at 04-OCT-16
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=557 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: NMO v4.2.0.0
sent command to channel: ORA_SBT_TAPE_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 10/04/2016 07:08:56
ORA-19625: error identifying file /OCETA/prod/archives/OCETA/datafile/o1_mf_sysaux_bpxdw00t_.dbf
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

The problem is the datafile indicate before is missing, I don’t sure how it did, but this db file no exits. The problem is for Oracle it exist yet. Please, look below, the next sequence of commands to solve the problem. The solution is force the expired of this file, in the next backup Oracle to create a new copy of the file, in this case associated to sysaux tbs.

 
RMAN>

RMAN> list datafilecopy '/OCETA/prod/archives/OCETA/datafile/o1_mf_sysaux_bpxdw00t_.dbf';

List of Datafile Copies
=======================

Key     File S Completion Time Ckp SCN    Ckp Time
------- ---- - --------------- ---------- ---------------
7895715 3    A 04-OCT-16       259771489071 03-OCT-16
        Name: /OCETA/prod/archives/OCETA/datafile/o1_mf_sysaux_bpxdw00t_.dbf
        Tag: COPY_ONLINE_DISK

RMAN> crosscheck copy of datafile 3;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=461 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=434 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=554 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=45 device type=DISK
validation failed for datafile copy
datafile copy file name=/OCETA/prod/archives/OCETA/datafile/o1_mf_sysaux_bpxdw00t_.dbf RECID=24070 STAMP=924328947
Crosschecked 1 objects

RMAN>
RMAN> list datafilecopy '/OCETA/prod/archives/OCETA/datafile/o1_mf_sysaux_bpxdw00t_.dbf';

List of Datafile Copies
=======================

Key     File S Completion Time Ckp SCN    Ckp Time
------- ---- - --------------- ---------- ---------------
7895715 3    X 04-OCT-16       259771489071 03-OCT-16
        Name: /OCETA/prod/archives/OCETA/datafile/o1_mf_sysaux_bpxdw00t_.dbf
        Tag: COPY_ONLINE_DISK

RMAN>

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s