Database Administration (MOSC)

MOSC Banner

Migrate database from windows to AIX 6.

edited Jan 22, 2012 8:49PM in Database Administration (MOSC) 2 comments
Hi
        You have lots of options in your hand to do this .


1 Export and import database But it will take huge amount of time if your database size is huge.


2 We can migrate through rman utility.  You can use this utility if you have same ENDIAN_FORMAT (select * from  v$TRANSPORTABLE_PLATFORM;). There are two values in  ENDIAN_FORMAT (Little and big) . This value should be same little = Littile  and big=big.


3  You can do this with transportable tablespace .  But your database version should be higher 10.2.0.1. and you can take only table and indexes export backup but function and views you have to use export / Import utility.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center