My Oracle Support Banner

ORA-01110 ORA-1122 ORA-01251 When Restoring With a Backup from a Standby DB (Doc ID 743101.1)

Last updated on MARCH 14, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.


Symptoms

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the
Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual
environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:

Primary Database: TESTDR
Standby Database: TSTD_STBY
Database Name: TSTD_TAG

**********

A newly added datafile 283 was added to the primary database and upon trying to restore the database  from a backup taken at the standby database, receiving these errors:

ORA-00283: recovery session canceled due to errors
ORA-01110: data file 283: '/<path>/df_0048_015'
ORA-01122: database file 283 failed verification check
ORA-01110: data file 283: '/<path>/df_0048_015'
ORA-01251: Unknown File Header Version read for file number 283

Changes

1. Added new df: file#=283 to primary db, testdr
2. Noticed file# 283 added to standby db tstd_stby
3. Ran backup against standby db tstd_stby using tag for standby db.
4. Get standby control file from primary db testdr.
5. Using control file from step 4 and mount a new db called tstd_tag on standby site
6. Ran restore from bkup of step 3 using tag for standby db to tstd_tag
7. step 6 restore success
8. run 'recover standby db' against tstd_tag, and get error:


SQL> recover standby database;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 283: '/<path>/df_0048_015'
ORA-01122: database file 283 failed verification check
ORA-01110: data file 283: '/<path>/df_0048_015'
ORA-01251: Unknown File Header Version read for file number 283
which indicate file# 283 has not been restored from standby db backup. How to resolve this problem?

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.