programatically cloning a database via shellscript

[jlakhani]

Hey folks:

I know this question has been asked over and over again and I searched the knowlegebase & metalink prior to posting but I have to ask this question. Rman and standby is not an option for me

On a regular basis I do full db refreshes of 300gb for siebel group from PristineDB to db1, db2, db3, db4, db5, where I copy the pristinedb files to differnt mountpoint and rename them to db1 or db2 or db3 or db4..

What I have been asked to do is to automate this process.. has anyone done this in schell scriptint environment?

thanks
Jigar

[pando]

did that around 4 years ago

[marist89]

What I have been asked to do is to automate this process.. has anyone done this in schell scriptint environment?

Sure, lots of times.

[jlakhani]

Can you folks give me the shell script so I can customize it for my usage?

thanks

[tamilselvan]

You can write shell scripts, otherwise you will never know "what a shell script is".
The logic is simple:

Loop
   mo more tablespace then exit
   put one tablespace in begin backup mode.
   ftp the data files for the tablespace on to a different server
   put the tablespace in end backup mode.
End loop
ftp the archive log files to other server
Go to other server
Recover the database. 
exit

Tamil

[jlakhani]

Tamilselvan:

I am not worried about the logic nor am I worried about how to achieve writing this script.. the Shellscript has refresh any of the 7 databases sitting on the server from a pristine copy automatically. The shellscript needs to accept the name of the instance which needs to be refreshed...

i am trying to figure out how to tell the shellscript which mountpoints belong to which instances...so i was hoping I didnt have to re-invent the wheel.