| Create a database with the backup (but not a standby) [message #61210] |
Mon, 05 April 2004 15:23  |
gulshan
Messages: 19
Registered: January 2004
|
Junior Member |
|
|
Hi...All
I had a Oracle database on windows NT. I was using the version 8i. But due to some cause my system crashes and then i have copied my all the files (datafiles and redo log files) to another harddisk. I have control file and parameter file also. Now i have installed windows 2000 professional and Oracle 9i. Can i create the database with the same name from the backup that i already have. can i create a new database with the same name that i prior had by creating the new control file. Please give me suggestion.
Thanks
|
|
|
|
|
|
| Re: Create a database with the backup (but not a standby) [message #61234 is a reply to message #61210] |
Tue, 06 April 2004 10:28  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Nope,you cannot use the 8i database datafiles with 9i ORACLE_HOME directly. As Anatol mentioned,install 8i and first make sure its operational under 8i environment. Then you can either migrate to 9i using the migration utility or precreate a fresh database in 9i and export/import from the 8i database. Export/import gives you the option of reorganising the database cleanly(improves performance) and also customize the tablespaces etc.
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
