5 Replies Latest reply: Feb 28, 2013 2:01 AM by zycoz100 RSS

    db restore non archive mode lost redo log file..restore from controlfile tr

    zycoz100
      i have a db 11g I had taken non archive backup but failed to take redo log files backup...
      so while i restored the db ... after formatting the machine ..the oracle instance wont start.


      I create a controlfile trace but when i run it i get errors.
      since i dont have the older log files.. how do i get around with this issue
      Thanks
      Following is the sample of control file trace ..Note i cannot create the redo log file
      since db wont be mounted at most it shall be in nonmount mode
      and below is my created controlfile ....
      CREATE CONTROLFILE REUSE DATABASE "XE" NORESETLOGS NOARCHIVELOG
      MAXLOGFILES 16
      MAXLOGMEMBERS 3
      MAXDATAFILES 100
      MAXINSTANCES 8
      MAXLOGHISTORY 292
      LOGFILE
      GROUP 1
      'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_80L7C259_.LOG'
      SIZE 50M BLOCKSIZE 512,
      GROUP 2
      'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_80L7C375_.LOG'
      SIZE 50M BLOCKSIZE 512
      -- STANDBY LOGFILE
      DATAFILE
      'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF',
      'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.DBF',
      'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF',
      'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF'
      CHARACTER SET AL32UTF8
      ;

      I dont have these 2 files ..what do i do to get around this situation
      'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_80L7C259_.LOG'
      SIZE 50M BLOCKSIZE 512,
      GROUP 2
      'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_80L7C375_.LOG'
      SIZE 50M BLOCKSIZE 512
      -- STANDBY LOGFILE
      DATAFILE

      Edited by: zycoz100 on Feb 27, 2013 10:57 PM