dump controlfile trace ,恢复控制文件

startup nomout

 CREATE CONTROLFILE REUSE DATABASE "YANSHIBI" RESETLOGS  NOARCHIVELOG
    MAXLOGFILES 16
  2    3      MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 (
  4    5    6    7    8    9      '/u01/app/oracle/oradata/YANSHIBIN/onlinelog/o1_mf_1_8y60m32j_.log',
 10      '/u01/app/oracle/flash_recovery_area/YANSHIBIN/onlinelog/o1_mf_1_8y60m428_.log'
 11    ) SIZE 50M,
  GROUP 2 (
 12   13      '/u01/app/oracle/oradata/YANSHIBIN/onlinelog/o1_mf_2_8y60m5xm_.log',
 14      '/u01/app/oracle/flash_recovery_area/YANSHIBIN/onlinelog/o1_mf_2_8y60m6kj_.log'
 15    ) SIZE 50M,
 16    GROUP 3 (
    '/u01/app/oracle/oradata/YANSHIBIN/onlinelog/o1_mf_3_8y60m8jw_.log',
    '/u01/app/oracle/flash_recovery_area/YANSHIBIN/onlinelog/o1_mf_3_8y60m9fs_.log'
  ) SIZE 50M
-- STANDBY LOGFILE
DATAFILE
  '/u01/app/oracle/oradata/YANSHIBIN/datafile/o1_mf_system_8y60k6v3_.dbf',
 17   18   19   20   21   22   23    '/u01/app/oracle/oradata/YANSHIBIN/datafile/o1_mf_undotbs1_8y60k71m_.dbf',
  '/u01/app/oracle/oradata/YANSHIBIN/datafile/o1_mf_sysaux_8y60k6vg_.dbf',
  '/u01/app/oracle/oradata/YANSHIBIN/datafile/o1_mf_users_8y60k72g_.dbf',
  '/u01/app/oracle/oradata/YANSHIBIN/datafile/o1_mf_example_8y60n70d_.dbf'
CHARACTER SET UTF8 24   25   26   27
 28  ;

starup 会报错。

执行。alter  database open resetlogs;