- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- database migration failure
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
тАО03-17-2003 07:40 AM
тАО03-17-2003 07:40 AM
database migration failure
I was attempting to migrate my production database from 7.3.4 to 8i. I have performed this several times on two other servers, on instances cloned from the production system. The only difference in the instances - is that the production server has log archiving enabled. For the migration, the initORA file had been changed - setting LOG_ARCHIVE_START = FALSE before starting the procedure.
The migprep program was hung at one point and the alert log indicated that log files needed archiving - I had to enable logging with a svrmgrl session to get it past that point. The migprep program aborted at the last line - (could do an alter database close) due to the svrmgrl session still connected - though the conv.dbf file WAS created in the dbs directory. On issuing the "alter database convert" command, this error was returned:
ORA-27072 skgfdisp: I/O error
additional information: 43
On consulting the errno.h file for this error - it reads that "the error numbers between 37 and 44 are not produced by HPUX".
Has anyone else ever seen this problem? Also - why did the logs need archiving when the archving was set to FALSE in in the initORA file?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2003 07:49 AM
тАО03-17-2003 07:49 AM
Re: database migration failure
The logs needed archiving because setting LOG_ARCHIVE_START = FALSE simply tells the database not to automatically start the ARCH process which does the archiving. This means that you'd have to archive manually (which you did).
What you probably meant to do was put the database in NOARCHIVELOG mode to prevent redo logs having to be archived at all. That's done with svrmgrl (or sqlplus internal) with the database closed...
startup mount;
alter database noarchivelog;
alter dtabase open
exit
Regards,
John
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2003 10:26 AM
тАО03-17-2003 10:26 AM
Re: database migration failure
Other poster John had given you enough information as to why logs needs archiving though you had l_a_s = false.
Regarding "ORA-27072 skgfdisp: I/O error" -- did you check alert
Stan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2003 10:53 AM
тАО03-17-2003 10:53 AM
Re: database migration failure
Unfortunately, the alertPROD.ora file gives no details - just :ORA 27072 signalled during: alter database convert
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2003 01:25 PM
тАО03-17-2003 01:25 PM
Re: database migration failure
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2003 07:26 PM
тАО03-17-2003 07:26 PM
Re: database migration failure
metalink reports your error with regards to the 2 Gig file limit.
It is possible that your database will get bigger when you migrate it. Are the filesystems its sitting on largefiles enabled?
I'd restore, check into that issue and try again when the issue is addressed.
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
тАО03-17-2003 09:03 PM
тАО03-17-2003 09:03 PM
Re: database migration failure
When you are migrating an Oracle 7.3.4 DB to 8i and if the database is runing in ARCHIVELOG mode then ensure that the archiver is started automatically otherwise the migrate may stall waiting to archive the online logs. Set LOG_ARCHIVE_START to TRUE and ensure the archive destination has plenty of free space. This is one of the preparation steps for migration procedure oracle mentions in the check-list for migration (Note:76460.1- Metalink).
Now to fix your database problem, depends on howfar have you gone with the migration. If the migration path is before the "ALTER DATABASE CONVERT" then there are chances at this point you could still open your database using Oracle7 code.
to continue. If you do open the database using Oracle7 then note that:
a)You will need to re-run the Oracle7 catalog and catproc if you want to use the database under Oracle7.
But remember even a simple startup / shutdown will mean you have to re-run the above migration steps again otherwise the "convert" file will then contain invalid checkpoint information.
If your migration path is beyond the ALTER DATABASE CONVERT statement then it requires you to revert to a backup, restore the DB and then follow the migration procedure again.
If you have a good backup I would prefer to restore from backup, and then follow the migration procedure again. Make sure the automatic archive = TRUE if your DB is runing on archivelog mode, and have plenty of space in the archivelogs file system.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2003 09:48 PM
тАО03-17-2003 09:48 PM
Re: database migration failure
Please check your archive destination.
It may not goto the right place ?
permission ? file system full ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-21-2003 02:11 PM
тАО03-21-2003 02:11 PM
Re: database migration failure
Thanks