alter databasebackup controfile to trace as
alter databasebackup controfile to trace as '/bk/col.sql';
一致性停库破坏日志文件和控制文件
启动数据库
sql> startup
oracle instancestarted.
total systemglobal area  314572800 bytes
fixed size                  1219136 bytes
variablesize             113247680 bytes
databasebuffers          192937984 bytes
redobuffers                7168000 bytes
ora-00205: errorin identifying control file, check alert log for more info
因为没有控制文件所以会出205错误
我们根据备份的控制文件信息重新创建控制文件
createcontrolfile reuse database orcl2 resetlogs  archivelog
    maxlogfiles 16
    maxlogmembers 3
    maxdatafiles 100
    maxinstances 8
    maxloghistory 292
logfile
  group 1'/u01/tiger/oradata/orcl2/redo01.log' size 50m,
  group 2'/u01/tiger/oradata/orcl2/redo02.log' size 50m,
  group 3'/u01/tiger/oradata/orcl2/redo03.log' size 50m
datafile
  '/u01/tiger/oradata/orcl2/system01.dbf',
  '/u01/tiger/oradata/orcl2/tiger.dbf',
  '/u01/tiger/oradata/orcl2/sysaux01.dbf',
  '/u01/tiger/oradata/orcl2/users01.dbf',
  '/u01/tiger/oradata/orcl2/undotbs02.dbf',
  '/u01/tiger/oradata/orcl2/undotbs01',
  '/u01/tiger/oradata/orcl2/tiger01.dbf'
character setzhs16gbk
;
因为之前也没有了redo日志文件所以重启数据库的时候用resetlogs参数
alter databaseopen resetlogs
，