System Copy - Refresh

[Former Member]

Hi there,

I am just about to start a system refresh from our ECC PROD system to our ECC QA.

I have been looking at the options available ( we currently use a 3rd party tool for our backups).

I have never done one of these before so please bear with me.

From what I have seen on SDN there are basically two options available to me. I'll be brief:

1) Restore the production database to the QA database from the latest offline backup

    using the brrestore command.

2) Manually copy all datafiles from PROD to QA. Create new control file with new path to QA.

    Then run recover database using backup controlfile until cancel

I suppose there is no right or wrong way. Just wondering what the pro's and con's are of each

of the above options are?

Many thanks

Andy

[Former Member]

I suppose you are talking about Oracle database ??

2) will not work in case your PROD is up and running.

1) will even work with an online backup.

regards

[Former Member]

Yep it is an Oracle 11g database

[Former Member]

In addition to my previous reply:

Restoring an online backup will require a new controlfile and a 'recover database' as well.

But this all has been explained a few million times ...