Hello Gurus
I want to migrate some of my databases to another server at one client.The client is asking for minimum downtime.
Like i have a database with 200GB.Now i have below options to migrate.
1)USE rman as downtime would be less.I need to take backup,restore to another server and then down prod,copy archives and apply to new location and make database up.
(this may not take more than 1 hour of downtime)
2)use expdp.downtime would be much but fragmentation in tablespace would be removed.If say i have a file with larger size then its actually using..could be re-organised.
(may take 10-15hrs of downtime)
So guys what are more advantages of using rman n expdp.
Whta you suggest for migration.is it necessary to remove fragmentation so performance would be good in future.
OS-AIX
oracle=10g
Regards