7 Replies Latest reply: Sep 12, 2012 4:33 AM by Santosh Pradhan RSS

    cannot create controlfile in asm

    Santosh Pradhan
      Hi all ,

      My requirement is to create controlfile from trace .
      I have ASM configured .
      i did

      SQL> select status from v$instance;

      STATUS
      ------------
      STARTED


      and my trace file is = /backup/cntrl_trace.sql

      SQL> @/backup/cntrl_trace.sql

      CREATE CONTROLFILE REUSE DATABASE "TESTNEW" NORESETLOGS FORCE LOGGING ARCHIVELOG
      *
      ERROR at line 1:
      ORA-01503: CREATE CONTROLFILE failed
      ORA-01565: error in identifying file '+DISK_DATA/testnew/datafile/rmdata44.dbf'
      ORA-17501: logical block size 0 is invalid


      M new to asm still i got following info from asm end

      ASMCMD> lsdg
      State Type Rebal Unbal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name
      MOUNTED EXTERN N N 512 4096 1048576 3072000 160445 0 160445 0 DISK_DATA/
      DISMOUNTED N N 512 4096 1048576 0 0 0 0 0 DISK_DATA1/
      DISMOUNTED N N 512 4096 1048576 0 0 0 0 0 DISK_DATA_MIG/
      MOUNTED EXTERN N N 512 4096 1048576 20480 18812 0 18812 0 REDO_CTL/



      ASMCMD> ls
      CONTROL/
      DATAFILE/
      ONLINELOG/
      REDO/
      STDBY_REDO/
      TEMPFILE/

      ASMCMD> cd DATAFILE/
      ASMCMD> pwd
      +disk_data/testnew/DATAFILE

      plz help meee