Refreshing Development database
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.
Refreshing the Development Database
In relation to the question I have another question. If the standby database and development servers are in different UNIX boxes will the following solution work?
1. Shutdown the standby database.
2. Shutdown the Development database.
3. Copy the control files, datafiles, redolog files, parameter files from the standby database to the development database, with the same directory structure.
Open the development database pointing to the parameter file of the new copied parameter file.
Will this replicate the development database with that of my standby database? I think it should exactly replicate right?
Would appreciate if any one can clear this doubt. With the theoretical knowledge of Architecture and Administration of Oracle database I got to this solution.