I'm looking for a solution that would extract the last months data from a production database onto a test server. I thought about finding the SCN number from a month ago and using the export utility for this but not sure if this would work. Any ideas on this?
10-19-2005, 04:26 AM
If database is in archive log mode u can apply archive logs to test server till required SCN. I hope test server and production server have same OS and production server is in archive log mode
10-19-2005, 04:41 AM
If you want the database to restored as past to a point-in-time do a point-in-time recovery until the desired timestamp on test server. As Amit said the OS should be same.
OR if you just want last's moth's data on the new database then create DB link and pull the data using SQL queries.