Oracle 11g back and restore

**suityou01** · 6 April 2013, 13:32

Originally posted by RasputinDude View Post

Folks, the Client where I am at the moment needs to create a test Oracle 11g DB based on live data from the end customer.

I'm going to do this using Amazon RDS and I need to provide detailed instructions on what I need to get from the end customer.

My thinking is that I need a datapump backup; do I need to specify with or without log files, and are there any further format issues that I need to specify - such as exporting the table names, sprocs etc? To clarify, I am trying to create a new database based on an already existing one. I am starting with nothing, so I don't have users, schema details, tables etc.

I've done this in MySQL but never Oracle. Can any of the learned CUK people provide a bit of a steer?

Ok first question, does this backup need to be used for development purposes? If so I would create a full backup of the schema and restore it onto your dev box.

If not then a more lightweight image could be created. Takes much less time and is only an image, fully functional but does not exist on the file system as a full backup would, only in an image file.

Take a look at using RMAN, linky

**RasputinDude** · 8 April 2013, 08:29

Thanks Suity, that's a helpful link.

The backup does need to be used for development purposes.

--

"You must spread some reputation around before giving it to suityou01 again"