http://www.lazydba.com/xcomment.pl?dbascripts:8

이곳과

http://www.tafora.fr/wp/ora01207.html

 

그리고 metalink에서 찾은 문서로 확인하세요

 

Problem Description

-------------------

Using an Oracle Standby database configuration in v8.0.x - v8.1.x,

if the primary controlfile is copied to a standby database for a graceful switch over

to the standby, the following errors may occur:

ORA-1110 database file %s failed verification check

ORA-1122 data file %s: '%s'

ORA-1207 file is more recent than control file - old control file

 

Solution Description

--------------------

The recommended work around is to create a new controlfile with the

'NORESETLOGS' option to make a new primary controlfile.

A graceful switchover from the primary to secondary can be performed

with no redo loss and no resetlogs.

A CREATE CONTROLFILE NORESETLOGS command may be used at the standby

to allow online logs copied from the primary to be applied to the standby,

and to open the standby without RESESTLOGS.

 

An alternative work around is to recreate a standby controlfile from the primary

database. Use the new controlfile for recovery at the standby, just before

copying the backups to the primary, or attempting the switch over to the standby.

 

Explanation

-----------

The error ORA-1207 may be signalled when reading the datafile headers in a

standby database setup. This is recorded in [BUG:1034927] and is fixed in v8.0.

This happens when the standby does more controlfile transactions than the primary.

The controlfile transaction count is recorded in the datafile header

on every write.

If the counter is greater than the counter in the controlfile, then the presumption

is that the controlfile must be a backup.

However,

if the last write to the datafile header was done at the standby, this check may fail

because the standby controlfile counter is higher than the primary's.

 

References

----------

[BUG:1034927] DATAFILES FROM STANDBY CAN MAKE PRIMARY CONTROLFILE LOOK LIKE A BACKUP Platform generic.

Fixed In Ver: 8.0.

 

Additional Search Words

-----------------------

control file

database를 nomount로 startup 하시고 create controlfile로 controlfile을 새로 create하시면 됩니다.