Control File-Urgent
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 20

Thread: Control File-Urgent

  1. #1
    Join Date
    Nov 2000
    Posts
    157
    Hi All

    My controlfile is corrupted.So i created a control file and trying to execute this at svrmgr.But it is giving me the error message :

    svrmgr>startup nomount
    svrmgr>@control.sql

    'D:\ORANT\DATABASE\TGGG\AHTG.DAT'
    *

    ORA-01967: INVALID OPTION FOR CREATE CONTROLFILE
    ORA-01507:DATABASE NOT MOUNTED
    ALTER DATABASE OPEN RESETLOGS
    *
    ORA-01507:DATABASE NOT MOUNTED

    ----------------------------------------------------------------------------------------------------------------
    The Control File is:

    CREATE CONTROLFILE REUSE DATABASE "TGGG" RESETLOGS NOARCHIVELOG
    MAXLOGFILES 32
    MAXLOGMEMBERS 2
    MAXDATAFILES 50
    MAXINSTANCES 16
    MAXLOGHISTORY 1600
    LOGFILE
    GROUP 1 (
    'D:\ORANT\DATABASE\TGGG\LOG1TGGG.ORA',
    'D:\ORANT\DATABASE\TGGG\LOG1ATGGG.ORA'
    ) SIZE 1M,
    GROUP 2 (
    'D:\ORANT\DATABASE\TGGG\LOG2TGGG.ORA',
    'D:\ORANT\DATABASE\TGGG\LOG2ATGGG.ORA'
    ) SIZE 1M,
    GROUP 3 (
    'D:\ORANT\DATABASE\TGGG\LOG3TGGG.ORA',
    'D:\ORANT\DATABASE\TGGG\LOG3ATGGG.ORA'
    ) SIZE 1M,
    GROUP 4 (
    'D:\ORANT\DATABASE\TGGG\LOG4TGGG.ORA',
    'D:\ORANT\DATABASE\TGGG\LOG4ATGGG.ORA'
    ) SIZE 1M,
    GROUP 5 (
    'D:\ORANT\DATABASE\TGGG\LOG5TGGG.ORA',
    'D:\ORANT\DATABASE\TGGG\LOG5ATGGG.ORA'
    ) SIZE 2M
    DATAFILE
    'D:\ORANT\DATABASE\TGGG\SYS1TGGG.ORA'
    'D:\ORANT\DATABASE\TGGG\AHTG.DAT'
    'D:\ORANT\DATABASE\TGGG\gggrollback'
    'D:\ORANT\DATABASE\TGGG\gggtemp'
    'D:\ORANT\DATABASE\TGGG\AHTGT'
    'D:\ORANT\DATABASE\TGGG\CQCC.DAT'
    'D:\ORANT\DATABASE\TGGG\TGACTION.DAT'
    'D:\ORANT\DATABASE\TGGG\TGSAMPLE'
    'D:\ORANT\DATABASE\TGGG\TGSCHEMANEW.DAT'
    'D:\ORANT\DATABASE\TGGG\TGTST.DAT'
    'D:\ORANT\DATABASE\TGGG\TGINT.DAT'
    'D:\ORANT\DATABASE\TGGG\ONEX.DAT'
    'D:\ORANT\DATABASE\TGGG\TONEX.DAT'
    'D:\ORANT\DATABASE\TGGG\POCT.DAT'
    'D:\ORANT\DATABASE\TGGG\TPOCT.DAT'
    'D:\ORANT\DATABASE\TGGG\SCMAR.DAT'
    'D:\ORANT\DATABASE\TGGG\TCMAR.DAT'
    'D:\ORANT\DATABASE\TGGG\ONEX1.DAT'
    'D:\ORANT\DATABASE\repository'

    ;

    # Recovery is required if any of the datafiles are restored backups,
    # or if the last shutdown was not normal or immediate.
    RECOVER DATABASE

    # Database can now be opened normally.
    ALTER DATABASE OPEN RESETLOGS;

    ----------------------------------------------------------------------------------------------------------------

    Please come back to me with some solution.

    Thanks
    Ravi
    ravi

  2. #2
    You must separate each datafile with a comma ,
    Also I guess you have at least 2 controlfiles, so copy the good and replace the bad.
    Ramon Caballero, DBA, rcaballe@yahoo.com

  3. #3
    Join Date
    Nov 2000
    Posts
    157

    urgent

    Hi

    Still it is giving the Errors:
    ORA-01503:CRETAE CONTROLFILE FAILED
    ORA-01991:INVALID PASSWORD FILE 'D:\ORANT\DATABASE\PWDTGGG.ORA'
    ORA-00283:RECOVERY SESSION CANCELLED DUE TO ERRORS
    ORA-01610:RECOVERY USING THE BACKUP CONTROLFILE OPTION MUST BE DONE
    ALTER DATABASE OPEN RESETLOGS
    *
    ORA-01194:FILE 1 NEEDS MORE RECOVERY TO BE CONSISTENT
    0RA-01110:DATAFILE 1: 'D:\ORANT\DATABASE\TGGG\SYS1TGGG.ORA'

    WHAT CAN I DO NOW?

    MY DATABASE IS ORACLE 734 ON WINDOWS NT4.0

    I DON'T HAVE THE BACKUP CONTROLFILE.sO I CREATED A CONTROLFILE LIKE ABOVE.

    ANY HELP PLEASE.

    THANKS
    RAVI

    ravi

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    What do you mean ? Ur control files got corrupted or control file got corrupted. If one of the mirrored control file gets corrupted you can copy the good one to the location of corrupted one and bring the databse up.

    Thats what rcaballe talking about.
    Reddy,Sam

  5. #5
    Join Date
    Nov 2000
    Posts
    157
    hI RC

    i AM WAITING FOR UR ADVICE AND SUGGESTIONS TO RESOLVE THIS PROBLEM

    tHANKS
    rAVI
    ravi

  6. #6
    Join Date
    Nov 2000
    Posts
    157
    Hi

    Ok controlfiles created.

    but it is giving the error message when i am trying to startup the database.
    svrmgr>startup

    **Invalid password file 'd:\orant\database\pwdtggg.ora'

    any advice plz!!

    Thanks
    Ravi
    ravi

  7. #7
    Join Date
    Nov 2000
    Posts
    157
    ANY SOLUTION????
    ravi

  8. #8
    Join Date
    Nov 2000
    Posts
    157
    HI All

    I recreated the password file too.Now i am getting some other problem:

    svrmgr>startup

    ora-01589:must use RESETLOGS OR NORESETLOGS option for database open
    alter database open resetlogs
    *
    ora-01113:file 1 needs media recovery
    ora-01110: data file 1: 'd:\orant\database\tggg\sys1tggg.ora'

    Its a test database.Noarchive mode.Don't have any backup.

    Any solution to bring the database up?

    Thanks in advance
    Ravi
    ravi

  9. #9
    You could apply your old online redo logs, but I don't believe you backed up.
    So I guess you don't have other option than cancelling the recover.
    Ramon Caballero, DBA, rcaballe@yahoo.com

  10. #10
    Join Date
    Nov 2000
    Posts
    157
    HI RAMON

    wHAT COMMANDS I HAVE TO USE NOW TO START THE DATABASE.

    tHANKS
    Ravi
    ravi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width