Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

copy raw oracle vols from prod to non-prod environment....

Denver Osborn
Honored Contributor

copy raw oracle vols from prod to non-prod environment....

I'm looking to setup "performence test" type of env using db from prod env. The oracle data is located on one emc symm and the perf test env will be located on another symm... I'll be having a bcv of the prod data presented to my perf host where I'll import the vg and temporarily activate it.

What I'm looking to find are good methods to copy the "bcv" prod data to a new volume group's lvols. For the few filesystem I'll use fbackup piped to frecover... but that stills leaves me w/ needing to copy the raw volumes over.

Any suggestions on how I could copy the raw oracle data from one volume group's lvol to another? I'm not planning on dd'ing it...

If anyone's done something like this before, please post your experiences. I'd appreciate any feedback or ideas. (maybe using oracle native backup utils and named pipes?)

Thanks!
-denver
3 REPLIES
Chan 007
Honored Contributor

Re: copy raw oracle vols from prod to non-prod environment....

Denver,

I did it once using omniback (Raw - Object Copying). But in fact my DB was just 300GB. So if you have a backups taken for your production system, just use that to clone a new DB. But you need similar or more size for each LV.

It took about 9 Hrs for backup and 7.25 Hrs for restore. I worked well.

Note: It was adviced that the DB should be shutdown for a good copy.

Also: Why don't you use srdf between arrays? If it is available?

Chan



Chan 007
Honored Contributor

Re: copy raw oracle vols from prod to non-prod environment....

Denver,

I did it once using omniback (Raw - Object Copying). But in fact my DB was just 300GB. So if you have a backups taken for your production system, just use that to clone a new DB. But you need similar or more size for each LV.

It took about 9 Hrs for backup and 7.25 Hrs for restore. It worked well.

Note: It was adviced that the DB should be shutdown for a good copy.

Also: Why don't you use srdf between arrays? If it is available?

Chan



Denver Osborn
Honored Contributor

Re: copy raw oracle vols from prod to non-prod environment....

thanks for the response...

turns out my storage folks redesigned their plan and will add another bcv, sync/split and present to my host for a vgimport. (saves me a lot of work by not having to backup/restore)

-denver