programatically cloning a database via shellscript

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

did that around 4 years ago

Quote:

---

Originally Posted by jlakhani

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

---

Sure, lots of times.

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

thanks

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

Code:

---

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

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.