alter database backup controlfile to trace as '/tmp/1.sql' 或者查看警告日志

提取1.sql中的文件信息做控制文件使用

vi /tmp/control_create.sql

####################################

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE "DBORA" NORESETLOGS ARCHIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

MAXLOGHISTORY 292

LOGFILE

GROUP 1 '/u01/app/oradata/dbora/redo01.log' SIZE 50M,

GROUP 2 '/u01/app/oradata/dbora/redo02.log' SIZE 50M,

GROUP 3 '/u01/app/oradata/dbora/redo03.log' SIZE 50M

DATAFILE

'/u01/app/oradata/dbora/system01.dbf',

'/u01/app/oradata/dbora/undotbs01.dbf',

'/u01/app/oradata/dbora/sysaux01.dbf',

'/u01/app/oradata/dbora/users01.dbf',

'/u01/app/oradata/dbora/example01.dbf'

CHARACTER SET AL32UTF8

;

#######################################

执行脚本

@/tmp/control_create.sql

alter database open;

ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oradata/dbora/temp01.dbf' reuse;

##########################################

关闭一致性

*._allow_resetlogs_corruption=true

*._allow_error_simulation=true

ITPub博客

非归档重建控制文件