Why not take a supported way? Simply build a recover database at new server, apply the logs from primary and then apply the last log, shutdown the primary, copy over the logfiles, and then activate it. and then run your upgrade scripts, can be done within 1 hour no matter how big your database is!
On 9/27/05, Michael McMullen <ganstadba@(protected)> wrote: > > How come the production server isn't available during the export or it > isn't > safe? > It seems going the script way would require a whole lot more monitoring > then > an exp/imp. Think of all the hours spent writing/debugging/monitoring the > code. Are your servers the same OS? > -- -- Original Message -- -- > From: <jost@(protected)> > To: <ORACLE-L@(protected)> > Sent: Tuesday, September 27, 2005 10:10 AM > Subject: A special way of migration > > > > > > > > > > > > > > Hi list, > > > > i have an unusal question i think, but i am curios about your meaning > about > > this. > > > > I am often in the situation to get a production database from an old > > db-server > > to a new one. In some cases i am also instructed to lift up the Oracle > > Version. Naturally i use export/import to get all the data of our > > application > > into the new database. > > > > Sometimes the databases are quite big (about 20 to 200 Gig), so the > Import > > and > > some other stuff lasts long. The consequence is, of course, to do it at > > weekends or after buisness hours. > > > > So far so good. There is no problem so far, but i was thinking about > > another > > solution for this task.(maybe i am just lazy? ;-) > > > > Here is my idea. > > > > Write a package to get the application data via a database link into the > > new > > database. The easiest way is "create table ... as select * from > > ...@(protected)" > > > > This is very fast, as my first tests have shown. > > > > After that, i get all Indexes via some dynamic SQL, the same with all > sorts > > of > > constraints. At last i get all defaults for the table columns also via > > dynamic SQL > > > > The advantage for me is, i can start one procedure, enjoy my weekend and > > just > > have to look for problems after everything is done. It seems to be safe > for > > the old production database, so, in worst case, we just have to cancel > the > > installation of the new db-server, but the production database is still > > available. > > > > What did i miss? Where are the pitfalls? > > > > I started to write the package. It is working inside a test - scenario > with > > a > > small database. > > > > Some things are still missing. Views are not implemented now, also > Triggers > > are not ready yet. Packages of the application are no problem, because > they > > are part of the installation of the application so i can install it > after > > the > > process is done. if they are compiling without errors, it is also a good > > sign > > for the whole "migration" of the data because of the dependencies. > > Sequences are also not totally ready now. > > > > So, what is your opinion? > > > > Thx in advance > > > > Joerg > > > > -- > > http://www.freelists.org/webpage/oracle-l > > > -- > http://www.freelists.org/webpage/oracle-l >
<div>Why not take a supported way?</div> <div> </div> <div>Simply build a recover database at new server, apply the logs from primary and then apply the last log, shutdown the primary, copy over the logfiles, and then activate it.</div> <div>and then run your upgrade scripts, can be done within 1 hour no matter how big your database is!</div> <div> </div> <div><br><br> </div> <div><span class="gmail_quote">On 9/27/05, <b class="gmail_sendername">Michael McMullen</b> <<a href="mailto:ganstadba@(protected)">ganstadba@(protected)< /a>> wrote:</span> <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0 .8ex; BORDER-LEFT: #ccc 1px solid">How come the production server isn't available during the export or it isn't<br>safe?<br>It seems going the script way would require a whole lot more monitoring then <br>an exp/imp. Think of all the hours spent writing/debugging/monitoring the <br>code. Are your servers the same OS?<br>-- -- Original Message -- --<br>From: <<a href="mailto:jost@(protected)">jost@(protected)</a>> <br>To: <<a href="mailto:ORACLE-L@(protected)">ORACLE-L@(protected)</a> ><br>Sent: Tuesday, September 27, 2005 10:10 AM<br>Subject: A special way of migration<br><br><br>><br>><br>><br>><br>><br>> Hi list, <br>><br>> i have an unusal question i think, but i am curios about your meaning<br>about<br>> this.<br>><br>> I am often in the situation to get a production database from an old<br>> db-server<br>> to a new one. In some cases i am also instructed to lift up the Oracle <br>> Version. Naturally i use export/import to get all the data of our<br> > application<br>> into the new database.<br>><br>> Sometimes the databases are quite big (about 20 to 200 Gig), so the Import<br>> and <br>> some other stuff lasts long. The consequence is, of course, to do it at<br>> weekends or after buisness hours.<br>><br>> So far so good. There is no problem so far, but i was thinking about<br>> another <br>> solution for this task.(maybe i am just lazy? ;-)<br>><br>> Here is my idea.<br>><br>> Write a package to get the application data via a database link into the<br>> new<br>> database. The easiest way is " ;create table ... as select * from <br>> ...@(protected)"<br>><br>> This is very fast, as my first tests have shown.<br>><br>> After that, i get all Indexes via some dynamic SQL, the same with all<br>sorts<br>> of<br>> constraints. At last i get all defaults for the table columns also via <br>> dynamic SQL<br>><br>> The advantage for me is, i can start one procedure, enjoy my weekend and<br>> just<br>> have to look for problems after everything is done. It seems to be safe<br>for<br>> the old production database, so, in worst case, we just have to cancel the <br>> installation of the new db-server, but the production database is still<br>> available.<br>><br>> What did i miss? Where are the pitfalls?<br>><br>> I started to write the package. It is working inside a test - scenario <br>with<br>> a<br>> small database.<br>><br>> Some things are still missing. Views are not implemented now, also<br>Triggers<br>> are not ready yet. Packages of the application are no problem, because<br>they <br>> are part of the installation of the application so i can install it after<br>> the<br>> process is done. if they are compiling without errors , it is also a good<br>> sign<br>> for the whole "migration" of the data because of the dependencies. <br>> Sequences are also not totally ready now.<br>><br>> So, what is your opinion?<br>><br>> Thx in advance<br>><br>> Joerg <br>><br>> --<br>> <a href="http://www.freelists.org/webpage/oracle-l"> http://www.freelists.org/webpage/oracle-l</a><br>><br>--<br><a href="http:/ /www.freelists.org/webpage/oracle-l">http://www.freelists.org/webpage/oracle-l< /a><br></blockquote></div><br><br clear="all"><br>-- <br>Regards <br>Zhu Chao<br><a href="http://www.cnoug.org">www.cnoug.org</a><br>
