I need to refresh our development database (8.1.7.4) with production data. The database is about 500 Gb in size. So I don't want to do export, import, etc. RMAN is not yet in use. So no refresh from RMAN backup.

I have a standby of the prodcution database on the same server as the development database.

Here is what I am planning to do.

1. Shutdown the standby database.
2. Delete the datafiles on the development database.
3. Copy the .dbf files from the standby database to development database.
4. Copy the $APPL_TOP from standby to development.

There has got to be more than this. Am I missing anything here? Thanks.