DataGuard ORA-01207

standby库在startup时报如下错误：
ORA-01207: file is more recent than control file - old control
重建控制文件即可，详细步骤如下：
[code]
SQL> alter database backup controlfile to trace as '/oracle/controfile.bak';

SQL> shutdown

SQL> exit


[oracle@localhost ~]$ cat /oracle/controfile.bak
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "PSZX_DB" NORESETLOGS FORCE LOGGING ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/oracle/oradata/pszx_by/redo01.log' SIZE 50M,
GROUP 2 '/oracle/oradata/pszx_by/redo02.log' SIZE 50M,
GROUP 3 '/oracle/oradata/pszx_by/redo03.log' SIZE 50M
DATAFILE
'/oracle/oradata/pszx_by/system01.dbf',
'/oracle/oradata/pszx_by/undotbs01.dbf',
'/oracle/oradata/pszx_by/sysaux01.dbf',
'/oracle/oradata/pszx_by/users01.dbf'
CHARACTER SET ZHS16GBK
;

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 28 15:07:53 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> @/oracle/controfile.bak
ORA-01081: cannot start already-running ORACLE - shut it down first

Control file created.

SQL> recover database;
Media recovery complete.
SQL> ALTER DATABASE OPEN resetlogs;
ALTER DATABASE OPEN resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery


SQL> ALTER DATABASE OPEN;

Database altered.

SQL> select instance_name,status from v$instance;

INSTANCE_NAME STATUS
---------------- ------------
pszx_by OPEN[/code]