Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1410
  • Last Modified:

Backup & Restore of Informatica with Oracle DAC

Hi,

We have a problem with an Oracle DAC schema .We need to refresh the installation from  Production. In the past we had problem with configuring Informatica server back to the test repository . Would You please post step by step instructions how to backup/restore Dac connection so that we can complete the process in least amount of time?
0
oleggold
Asked:
oleggold
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
Never used Informatica or DAC but strictly from a database standpoint: a FULL RMAN backup of 'baseline'.  When you are done testing, just restore from backup.

You might be ableto get away with export/import but this can take longer and would likely require some prep work to make sure everything was as-was.

Hopefully some Informatica Experts will be along later.
0
 
slightwv (䄆 Netminder) Commented:
Thought of this as soon as I clicked submit (still from a database only aspect).

Possibly flashback database:
http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9011.htm
0
 
oleggoldAuthor Commented:
it isn't a good solution but thanks for thinking
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now