- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Error while Restoring a Oracle 9i image on Ora...
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
тАО06-20-2007 02:58 AM
тАО06-20-2007 02:58 AM
Error while Restoring a Oracle 9i image on Oracle 10g
We have migrated from Oracle 9i to Oracle 10g.
Hence we noe have to restore Oracle 9i image on the Oracle 10g. But I am getting some errors. I am listing the errors below:
=============================================
ORA-19870: error reading backup piece /tmp/
ORA-07202: sltln: invalid parameter to sltln.
============================================
Could you please help us resolve the issue?
Thanks and regards,
Kaustubh Kane.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-13-2007 10:38 PM
тАО07-13-2007 10:38 PM
Re: Error while Restoring a Oracle 9i image on Oracle 10g
You cannot restore oracle 9i database to oracle 10g.
Avinash
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-14-2007 01:16 AM
тАО07-14-2007 01:16 AM
Re: Error while Restoring a Oracle 9i image on Oracle 10g
Are you saying that you are copying datafiles used by 9i environment onto a 10g environment and using the 10g Oracle binaries/installation to use this ?
Then, what does the statement "We have migrated from Oracle 9i to Oracle 10g" mean ? Migration essentially is database migration and needs to be carried out by the DBAs.
Please try to give some more details of your problem,what all you have done and what you are exactly trying to achieve, so that it can be understood appropriately.
Regards,
Ninad
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-15-2007 03:24 AM
тАО07-15-2007 03:24 AM
Re: Error while Restoring a Oracle 9i image on Oracle 10g
Are you using RMAN?
If this is something critical, i would prefer that you contact Oracle support.
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-15-2007 04:59 AM
тАО07-15-2007 04:59 AM
Re: Error while Restoring a Oracle 9i image on Oracle 10g
Are you saying you are trying to actually complete the upgrade in this fashion? It's simply not how you do Oracle upgrades and I can't beleive anyone would attempt this sort of thing without actually looking at the manuals (which describes the supported methods):
http://download.oracle.com/docs/cd/B19306_01/server.102/b14238.pdf
Or are you saying that you now have to restore to a point before the upgrade? If so I'm afraid you will have to restore all your 9i binaries before attempting a restore of 9i RMAN backups.
HTH
Duncan
I am an HPE Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-15-2007 05:07 PM
тАО07-15-2007 05:07 PM
Re: Error while Restoring a Oracle 9i image on Oracle 10g
Also don't forget that when upgrading the database, you also need to upgrade the RMAN catalog.
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-15-2007 07:50 PM
тАО07-15-2007 07:50 PM
Re: Error while Restoring a Oracle 9i image on Oracle 10g
To summarize:
When you install 10G on a system, if there is data in place, there are utilties and procedures that need to be followed to migrate the data.
To migrate 9i data, you will need to first restore the database using 9i software or migrate the database from a cold backup.
Procedures for either eventuality exist on http://metalink.oracle.com but you need support to access that site.
10G is quite capable of accessing 9i data, after its converted/migrated.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com