Oracle ORA-01221エラ解析

プロのOracle Databaseの復旧サービスを提供
携帯番号： +86 13764045638 メール：service@parnassusdata.com

ORA-01221エラは8iによく現れるが、10gの後にめったり現れない。

Error: ORA 1221
Text: datafile <name> is not the same file to a background process
——————————————————————————-
Cause: When the database writer opens the datafile, it is accessing a
different physical file than the foreground doing the recovery.
The time-stamp set in the file header by the foreground was not found
by the background.
It may be that the background process could not read the file at all.
Action: Look in the DBWR trace file for the error it received when attempting
to read the file header.
Reconfigure the operating system as needed to have the filename
successfully access the same file when opened by a background process.
Hdr: 4395739 10.1.0.3 RDBMS 10.1.0.3 RECOVERY PRODID-5 PORTID-219 ORA-1221
Abstract: AFTER RESIZING A DATAFILE, OTHER DATAFILE IS CORRUPT ORA-1237 ORA-1221

If datafile is resized beyond space available, error occurs, database crashes
and a different datafile shows ORA-1221 corruption

Hdr: 706775 8.0.3.2.0 RDBMS 8.0.3.2.0 PRODID-5 PORTID-89 ORA-1221
Abstract: ORA-470, ORA-449 AND ORA-1221 ON STARTUP
Symptom(s)
~~~~~~~~~~

When recreating a controlfile, you receive the following errors:

ORA-01503: CREATE CONTROLFILE failed
ORA-01227: log is inconsistent with other logs

When trying to open the database after a failed controlfile creation you may receive:

ORA-01221: data file 1 is not the same file to a background process
Change(s)
~~~~~~~~~~

You issued exec sys.dbms_backup_restore.zerodbid(fno => 0) while the database was open.
Cause
~~~~~~~
Database Corruption Will Occur During the Cloning Process when the Above Command
is Performed with the Database Mounted.

The function dbms_backup_recovery.zeroDbid must never be invoked while the database is open
as this could damage it (impossible to mount and dismount the database).

(Internal Note)

Fix
~~~~

Recreate the controlfile with the SET DATABASE option:

CREATE CONTROLFILE REUSE SET DATABASE “RPT1” RESETLOGS ARCHIVELOG