cancel
Showing results for 
Search instead for 
Did you mean: 

HELP - database in limbo

SOLVED
Go to solution
Dave Chamberlin
Trusted Contributor

HELP - database in limbo

Hello,
I am doing a migration of Oracle from 8.1.7.4 (64bit) to 9i. When I did startup migrate, one datafile had wrong permission set. Database shutdown. I fixed the permission of that file, but cannot startup the database under the 9i HOME(ORA-1092 instance terminated..)
I cannot open the database under the 8.1.7 HOME because the redo logs are now in 9i format. What can I do?
10 REPLIES
Steven E. Protter
Exalted Contributor

Re: HELP - database in limbo

Shalom Dave,

I suggest retoring the database files to the original copies and re-doing the migration after correcting the permissions.

You also might be able to do a startup, followed by an abort and then a normal startup.

Can you do a startup attempt and post the sqlplus output? There may be commands you can do to bring this one tablespace up.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Dave Chamberlin
Trusted Contributor

Re: HELP - database in limbo

Unfortunately I cannot replace original files as my new ultrium tape drive failed last night (as I was going to take a backup). I am attaching the output of the log file (9i alert log).
Peter Godron
Honored Contributor

Re: HELP - database in limbo

Dave,
given your situation (no backups) I would raise a TAR with Oracle.
One further mistake and the whole DB may be lost.
At least perform a backup now, so if anything goes wrong, you have something to go back to.
A. Clay Stephenson
Acclaimed Contributor

Re: HELP - database in limbo

Dave,

Let me understand this. You decided to do a database migration after a failed backup? and without a working tape drive? That was truly state of the art stupid and you deserve whatever happens to you. Never underestimate God's sense of humor. If you have good backups, you don't need them; on the other hand, if you don't have good backups ...

You may be out of limbo and are now in purgatory. I hope you are on Oracle support; they may be able to help. Please tell me that you have a backup from two days ago.
If it ain't broke, I can fix that.
Dave Chamberlin
Trusted Contributor

Re: HELP - database in limbo

Thanks Clay. This is not a production database and I intended to have a backup before procedding, but felt pressured to start this upgrade test (since replacing the tape drive will take at least a couple of days. Can the database be restarted as the 8.1.7 database with a reset of the redo logs?
Patti Johnson
Respected Contributor
Solution

Re: HELP - database in limbo

Dave,

Did you see note 267118.1 in Metalink, basically it says the problem is the compatibility parameter at 9.2 while db at 8.1.7, but changing back to 8.1.7 causes another problem. Here is the solution from the note.

Solution
To resolve this problem we need to migrate the database so that the redo logs are in the correct format:

Startup migrate;
Database opened

The migration to 9.2 was completed manually.

Just a thought.

Patti
Dave Chamberlin
Trusted Contributor

Re: HELP - database in limbo

The problem as indicated from Oracle was the same as Patti indicated. The compatible parm was set to 9.2 in the init file. Edited the init file to have "EVENT=10619 trace name context forever, level 1 allowed the instance to open correctly ignoring the compatable flag, and migration proceeded normally. Thanks.
Yogeeraj_1
Honored Contributor

Re: HELP - database in limbo

hi,

Can you investigate if you can offiline drop the datafile which you were having problems and create it again and import the data?

It would also be advisable to work with Oracle Support on that!

good luck

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
VikramAdmin
Occasional Visitor

Re: HELP - database in limbo

Thats a DB question.
Did you check if there is any information in the traces/logs? Is there more error message information that can be used here?

I remember one Oracle DBA telling me that he had to comment out rollback parameters when he did the first restart.
Dave Chamberlin
Trusted Contributor

Re: HELP - database in limbo

problem was solved with compatability setting in init file. thanks.