This content has been marked as final. Show 12 replies
I'm going to move and upgrade my 32 bit Oracle database server 10g to another 64 bit windows 2008 server.
New database server will be 64 bit Oracle database server 11g.
Somebody told me export import doesn't carry archieve logs therefore is there any way to move and upgrade the database without any lost?Yes, in export/import, you will create a new database and import. The question is why you want to prefer export/import?
is it source database 32bit is in different OS platform? If not directly after installation you can upgrade the database. using DBUA
Please check below notes, you can find good doc in it:
Minimizing Downtime During Production Upgrade [ID 478308.1]
Master Note For Oracle Database Upgrades and Migrations [ID 1152016.1]
Different Upgrade Methods For Upgrading Your Database [ID 419550.1]
My source database is on 32 bit Windows 2003 Server and we don't want to lost any log file (archieve log etc.) during the movement and upgrade.
My source database is on 32 bit Windows 2003 Server and we don't want to lost any log file (archieve log etc.) during the movement and upgrade.If you want to upgrade, you should have DOWN TIME, Then there is no concept of loosing data.
If in case of RAC, appying interim patch, there you have option of roll upgrade patch. here you should have downtime mush and should.
First of all I want to work on test environment.
Therefore I want to move my database on another test server (64 bit windows server 2008 enterprise) and work on it to upgrade Oracle database server 11g.
If I manage to upgrade test environment then there will be a "down time" for upgrading original database.
Which steps I have to follow for doing this.
1 Read documentation
2 Read documentation
3 Read documentation
4 ... Did I say 'Read documentation'?
Please do not ask people to paraphrase or abstract the documents you can and should read yourself.
Senior Oracle DBA
No, it's not priggish, especially since the documentation tells you exactly how to upgrade from 10g to 11g.
Your question comes across like this:
"I'm too busy or too lazy to read the manuals, so could someone just tell me how to upgrade my database"
That may not be your intention, but that's how it comes across. If you had read the docs (which are actually pretty good) and didn't understand some steps or had some specific questions, then sure, by all means, ask away.
Sometimes the answer really is "RTFM," which is what it is.
Best of luck,
1.Create DB link between the two databases
2.create insert scripts by using DB link
3.run the scripts on newly configured 64 bit Oracle Database 11g on Windows 2008
@venkat What about indexes, stored procedures, users, Queues, object types, views, and any other of the many types of objects that would also be in the database?
No, I cannot recommend this approach.
Upgrading the DB is the right approach, and it's [url http://docs.oracle.com]documented quite nicely.
I have a questions:
1. Can we apply "10g (on Linux 32bit) archive logs" to "11g (on Linux 64bit)"?
So you've used your very first forum post to hijack another user's thread that is over a year old?
Please don't do that.
I have a questions:
Then you should create a new thread and ask your question.