Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Migrate hundreds of Oracle databases to RHEL/Windows using DP/TTS/Shareplex

AbhijitDeyJun 28 2012 — edited Jul 6 2012
Am working on devising a migration strategy for several Oracle databases from one physical data-center location to another data-center location through dedicated WAN links. Overall snapshot:

Total 365 Dbs (28 to Oracle RAC 11gR2 and approx. 300 to DataGuard and Standalone). Source Databases versions are Oracle 9.2.0.4/9.2.0.7/10.2/10.2.0.4/11.2/11.2.0.4.
Source Databases are currently on different versions of Linux/HPUX/AIX/Windows OS. Target Database OS platform(most of them): RHEL 5.8/RHEL 6(atleast for Unix) and Windows. Plan is to migrate same versions and not upgrade(due to applications dependency). am thinking of using

-Oracle Datapump
-Transportable Tablespaces+RMAN scripting(for target datafiles)
-Shareplex for Databases in TB (this tool allows ZDT, zero-downtime migration/from Quest software)

Also my Storage/SAN colleague is using Swing gear (AUTO-LUN+BC) to migrate virtualizing the storage arrays from Source to Target location. Is it possible to "piggyback" on this SAN-level migration of the "physical" datafiles and then use Shareplex to migrate the archivelogs and apply them over to Target databases?

Need your inputs please. Thanks in advance..

Abhijit

Comments

Rahul Kumar
hi anuradha,
you can use substitution variable in the grid and then display that in text via GetHeading function.

Hope this helps.

Regards,
Rahul
661221
Rahul,

I tried it but itz not displayed...

the sub var is not visible in any dim member selection tabs ..... so i cant getit in data col/row.......if i type & refer with getheading..itz not workin.....


how can we display it????????/


Thanks
Rahul Kumar
hi,

if substitution varible is defined correctly on the cube then it should definately be displayed on the some dimension member selection.

Please check that.
Once it is visible, just use it as a member in any hidden row/column. Then use GetHeading function to display it in a text box.

Regards,
Rahul
661221
Hi,

I have cross checked all dim's in FR...but could not find 'em in any dim's.......other sub variables which r related to dim's r visible under respective dim's(Ex:Year=$curyr)......

i could see it defined in the outline for this cube.

i fell that the data load sub var is not visible under any dim as itz not related to any of them.....

Is there a way to display it in FR.

Thnx
Rahul Kumar
hi,
yes to display a substitution variable, it has to be associated with one of the dimensions.
and then only you will be able to display it.

May be one other option might be to use LINKED OBJECT in FR. so that just updating the information in one text box of one report will do it in all reports.


You can also use substitution variable in that liked object.
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 3 2012
Added on Jun 28 2012
1 comment
374 views