- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- HELP - database in limbo
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-12-2006 03:33 AM
тАО01-12-2006 03:33 AM
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-12-2006 03:46 AM
тАО01-12-2006 03:46 AM
Re: HELP - database in limbo
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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-12-2006 04:02 AM
тАО01-12-2006 04:02 AM
Re: HELP - database in limbo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-12-2006 04:18 AM
тАО01-12-2006 04:18 AM
Re: HELP - database in limbo
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-12-2006 04:24 AM
тАО01-12-2006 04:24 AM
Re: HELP - database in limbo
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-12-2006 04:57 AM
тАО01-12-2006 04:57 AM
Re: HELP - database in limbo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-12-2006 08:14 AM
тАО01-12-2006 08:14 AM
SolutionDid 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-12-2006 09:24 AM
тАО01-12-2006 09:24 AM
Re: HELP - database in limbo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-12-2006 03:49 PM
тАО01-12-2006 03:49 PM
Re: HELP - database in limbo
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-10-2006 08:12 PM
тАО04-10-2006 08:12 PM
Re: HELP - database in limbo
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.