automating database refreshes
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: automating database refreshes

  1. #1
    Join Date
    Mar 2001
    Posts
    149

    automating database refreshes

    Hi all, I've been given a task to write a script automatically take an full export file from a production server and put in a test server. From there do an import to the database. I've never done this before, does anyone have any ideas or suggestions? Thanks

  2. #2
    Join Date
    Sep 2002
    Posts
    411
    create a test database and create all tablespace that were existed on Production database and run a full import

  3. #3
    Join Date
    Mar 2001
    Posts
    149
    thanks mike, actually I tried to write a unix shell script would do all of these, basically automate the whole process. you have any ideas?

  4. #4
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    write a shell script:

    1. set sid
    2. to take an exp with logs
    3.change the oracle_sid
    4. imp with logs
    5.send email that imp was done to dba.
    done
    "High Salaries = Happiness = Project Success."

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