| Backup @ Oracle 8i Restore @ Oracle 9i How ? [message #173353] |
Mon, 22 May 2006 01:21  |
dicxz80
Messages: 3
Registered: May 2006
Location: Indonesia
|
Junior Member |
|
|
my OS was crashed, i used win2k and Oracle 8i, i've already backup all data files and control file @ oracle\oradata and oracle\admin
then i reinstall my OS using win2k and Oracle 9i i want to restore my database using files above.
how to do that ? i know that is possible but i dont know how to do. could you masters explain to me step be step ?
right now i already have a system with win2k OS and Oracle9i is already installed in it without prestarter database.
thx a lot
|
|
|
|
|
|
| Re: Backup @ Oracle 8i Restore @ Oracle 9i How ? [message #173501 is a reply to message #173353] |
Mon, 22 May 2006 14:11  |
itman73
Messages: 6
Registered: May 2006
Location: Dallas, Texas, USA
|
Junior Member |
|
|
If I'm understanding the situation correctly ...
If you performed a cold backup, that means your database was shutdown cleanly before the backup, correct?
If it was a clean shutdown, recovery should not be needed.
You should be able to migrate the database to 9i, but you should contact Oracle Support or get the procedure off Metalink. Practice the migration using a copy of production database on a development server until you address all issues and users can verify all is well.
IMO, from a production standpoint, it's a very dangerous practice to not have your current Oracle version installed on the server. What if something goes wrong during the migration process and you run out of time for your migration window? You should have a contingency plan where you restore the database files from backup again, open your database up for use with the original version, reschedule the migration for another time.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
but thx for the information to have backup plan before migrating. right now i only able to move the database instance to another system but with the same version of oracle