Oracle 11g控制文件丢失后的恢复方法

   REUSE DATABASE cams

   LOGFILE GROUP 1 ('/u01/app/oracle/oradata/cams/redo01.log'),

           GROUP 2 ('/u01/app/oracle/oradata/cams/redo02.log'),

           GROUP 3 ('/u01/app/oracle/oradata/cams/redo03.log')

   NORESETLOGS

   DATAFILE '/u01/app/oracle/oradata/cams/example01.dbf',

            '/u01/app/oracle/oradata/cams/finchina01.dbf',

            '/u01/app/oracle/oradata/cams/finchina02.dbf',

            '/u01/app/oracle/oradata/cams/finchina03.dbf',

            '/u01/app/oracle/oradata/cams/finchina101.dbf',

            '/u01/app/oracle/oradata/cams/finchina1.dbf',

            '/u01/app/oracle/oradata/cams/finchina.dbf',

            '/u01/app/oracle/oradata/cams/sysaux01.dbf',

            '/u01/app/oracle/oradata/cams/system01.dbf',

            '/u01/app/oracle/oradata/cams/temp01.dbf',

            '/u01/app/oracle/oradata/cams/undotbs01.dbf',

            '/u01/app/oracle/oradata/cams/users01.dbf'

   MAXLOGFILES 50

   MAXLOGMEMBERS 3

   MAXLOGHISTORY 400

   MAXDATAFILES 200

   MAXINSTANCES 6

   NOARCHIVELOG