Hi Jdoyle,


Re: PROD
Is this database working?
Have you done the alterations to the controlfile trace dump, and is your specified parameter file path correct and pointing to an existing file?


Yes my prod instance is on and working fine.
I altered the controlfile trace dump as suggested. My parameter file path correct and pointing to an existing file.


Re: TEST; several questions:
Is this DB on the same machine as PROD?
Is it running in ARCHIVELOG mode?
What is your environment, OS, etc.
What exactly are you trying to do with test? We cannot deal with recovery issues just yet, and perhpas may not need to. You probably won't need to restore from tape.

Yes the test db is on the same machine as PROD.
It is not running in ARCHIVELOG mode.
my OS is unix. Oracle version is 7.1.4
Since i have a exceed maxdatafile number, I am trying to modify the maxdatafile number on the test instance 1st and if it works i'll do it on the PROD one.

I'd like to tell you this:

I checked audit files and trace files of the test instance: i note that : the test instance is off @ 9am this morning when i ran the recreate_controlfile_script first time.
Everytime i try to connect to the test db i got an error:
ora-01033: oracle initialization or shutdown in progress.
Everytime i try to bounce test db (after setenv oracle_sid test)
server always shutdown and startup the PROD db not the TEST. Its seem to me that the TEST instance is hanging now.

I hope you get the pictrue of my problem.

Thanks,
Jn1971