Control File-Urgent

[cravi]

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

[rcaballe]

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.

[cravi]

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

[sreddy]

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.

[cravi]

hI RC

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

tHANKS
rAVI

[cravi]

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

[cravi]

ANY SOLUTION????

[cravi]

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

[rcaballe]

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.

[cravi]

HI RAMON

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

tHANKS
Ravi