Scripting a People Soft clone with RMAN

I’ve done this with E-Biz so I thought I’d do it with People Soft.  Now before you go off trying this script, TEST IT FIRST!  If it blows up your database, you don’t know me!  Also, this will not work unless you’re using a catalog/repository for RMAN

This script is really made up of 3 parts:

1.the addition of some code in your RMAN backup script (assuming you already have one that is) that builds an RMAN run module for the clone build, cleans up the previous days SCP and then SCP’s your rman backups and run modules to the clone box

http://wp.me/p2OgNa-2E

2.the main cloning script.  the script assumes you’re using ASM and you may need to fiddle with the script to fit your ASM structure, or if not using ASM, just comment it out, and

http://wp.me/P2OgNa-4K

3.the ASM cleanup script (if you need it).

http://wp.me/P2OgNa-4V

Now I’m sure there are a million ways to get this done and this may not be the most efficient…. but it works.  As you can see from the main cloning script, we don’t do a lot of post-clone stuff with the people soft clones as we normally leave that up to the app developers.

If you see any glaring errors, please let me know.

Advertisements

One thought on “Scripting a People Soft clone with RMAN

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