Coskan’s Approach to Oracle

February 6, 2012

Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backups (on Exadata!!)

Filed under: Basics — coskan @ 7:47 am

Just a quick note to point a MOS note which I found out yesterday . I already tweeted about it and it has been retweeted many time by my follower, but for wider audience I decided to write a blog post as well.

As you may already know, to migrate databases between different endian formats, using RMAN Transportable Tablespaces is an option but for this option to work, you need to have a downtime since tablespaces needs to be read only, and this downtime can be very long duration depending on the data size.

 

To sort this problem for migrations to Exadata platform (method only supported on Exadata) Oracle now brought incremental backup availability for TTS, till Oracle puts this as a public document (or somebody post about the steps) you need a MOS access to  see the method.

For more information.

Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backups [ID 1389592.1]

 

In my humble opinion, Oracle better decide to support this on other platforms since method should not have anything to do with Exadata spesific other than being supported (don’t know any rman method which needs Exadata spesific features)

About these ads

2 Comments »

  1. Hi Coskan-

    hope you are doing fine, I was working on some oracle script for kind of SQL*Plus dashboard for RAC env. it is similar to Tanel/Andrian database top script.. but I have added a lot more details to it.. including exadata cell smart scan/cpu/.sql monitor .. and lot more info. Still i am working on and its not fully complete. Do you think you will have some time to review it and share your comments for further improvement… I know you are the one of the person i know who love oracle [ i am also on same boat ]…

    just thought to check with you, I can share details with you *if you are ok*.. my email address is jagjeet.malhi@gmail.com and if you send me an test email I can give you all the info.. code … to test out.

    I know, this may look rude to contact you directly like this, I really apologies in case you do not like the way I am approaching you.

    my comment is not related to the blog post here, so you may want to remove this.

    Thanks
    Jagjeet Singh

    Comment by Jagjeet Singh — March 12, 2012 @ 9:27 am

  2. My brother recommended I might like this website.

    He used to be entirely right. This post actually made
    my day. You cann’t believe just how much time I had spent for this information!
    Thanks!

    Comment by http://www.sciebem.com.mx/ — August 29, 2013 @ 5:54 pm


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Silver is the New Black Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 203 other followers

%d bloggers like this: