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博客 ” ,链接:http://blog.itpub.net/26179376/viewspace-1981704/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26179376/viewspace-1981704/