Control File-Urgent

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

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.

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

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.

hI RC

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

tHANKS
rAVI

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

ANY SOLUTION????

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

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.

HI RAMON

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

tHANKS
Ravi

well unfortunately I think your databse's gone for good

:D
Try a RECOVER DATABASE
and then put CANCEL
Cross your fingers and open it, if you can't, sorry, It's asistolic (dead).
I guess that's why you must put a timeout in log switch.

HI

WHEN I AM USING THE RECOVER DATABASE UNTIL CANCEL THE ERROR MESSAGE IS:

ORA-00283:RECOVERY SESSION CANCELLED DUE TO ERRORS.
ORA-01610:RECOVERY USING THE BACKUP CONTROLFILE OPTION MUST BE DONE.

ANY IDEA TO RESOLVE THIS

THANKS
RAVI

SQL> recover database using backup controlfile until cancel;

er I didnt know you can use until cancel option in noarchive mode databases :0

Hi

when i am using recover database using backup controlfile until cancel.The error message is:

ora-00279: change 32498 generated at 03/09/01 needed for thread 1
ora-00289: suggestion: d:\orant\rdbms73\%oracle_sid%00599.001
ora-00280: change 32498 for thread 1 is in sequence #599
specify log:<=suggested|filename\auto|cancel

I TYPED AUTO

ora-00308:cannot open archivedlog 'D:\orant\rdbms73\%oracle_sid%00599.001'
ora-09202:sfisi:error identifying file
osd-04002:unable to open file
0/s-error: the system cannot find the file specified;

Any solution plz.

Thanks for all your help
Ravi

Put cancel.
If you had backed up the online redo logs before the CREATE CONTROLFILE...RESETLOGS, you could apply it like archived redo logs.
So put cancel.
If it says the DB is inconsistent, it doesn't matter as long as you can export the data.
Put cancel and then ALTER DATABASE OPEN RESETLOGS;
Sorry about my english I don't know how to say in the time (ficticious, wishfull time)

well before do anything to this half dead database... back it up

then do the recovery, when it asks you for the log it must be one of online redo logs, you have to guess which you should apply and type manually the file name NOT auto

Hey ramon/pando & All

Please First of all accept my Thanks.

I did it.

I deleted the previous control file which i created now and the i recreated a control file with NORESETLOGS.

SO IT MAKES THE NEW CONTROLFILE CURRENT.

Then i issued alter database open resetlogs.That's it.All done.

Thank you very much
Ravi

what are the side effects of Recover until Cancel ??

Thanks
Anurag


[Edited by anuragmin on 03-12-2001 at 06:04 PM]