To copy data from the production database to the staging database:
- Set the PATH environment variables.
- Configure the database.
- Change to the directory to which you want log files written.
- Type the following:
stagingcopy -scope _all_ -sourcedb production_database_name -destdb staging_database_name -dbtype oracle -sourcedb_user user -sourcedb_passwd password -destdb_user user -destdb_passwd password
stagingcopy.sh -scope _all_ -sourcedb production_database_name -destdb staging_database_name dbtype oracle -sourcedb_user user -sourcedb_passwd password -destdb_user user -destdb_passwd password
- Examine the stagingcopy_yyyy.mm.dd_hh.mm.ss.zzz.log file.
- Stop and restart the staging server instance.