用户名:   自动登录 找回密码
密   码:    * 注册




发表新帖 回复这个主题  [ 1 篇帖子 ] 
作者 内容
 文章标题 : ORA-01207: file is more recent than control file - old contr
帖子发表于 : 2012-09-05 22:38 
离线
头像

注册: 2011-05-01 9:15
帖子: 120
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


页首
 用户资料  
 
显示帖子 :  排序  
发表新帖 回复这个主题  [ 1 篇帖子 ] 


在线用户

注册用户: 没有注册用户


查找:
前往 :  
cron
Powered by OraSql © 2011, 2012, oracle_awen