DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Data extraction

  1. #1
    Join Date
    Nov 2000
    Location
    London
    Posts
    94

    Data extraction

    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?
    Thanks

  2. #2
    Join Date
    Oct 2005
    Posts
    4

    Arrow

    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

    With Regards

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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.

    HTH.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width