Home » Server Options » Data Guard » Database cloning. (ORACLE 10.2.0.4.0, Windows)
Database cloning. [message #415232] Sun, 26 July 2009 10:27 Go to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member

Hi Gurus,

We have a production database and one development database. Our developers want the development database to be updated with the production database with every two days once. Actually i was doing export in production and then import in test database.

Actually only some rows will be modified in all the tables.

Is that any other way to refresh the test database like cloning the database or creating the standby database.

Please share your comments.

Thanks in Advance,
Seenu.

Re: Database cloning. [message #415341 is a reply to message #415232] Mon, 27 July 2009 05:37 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

>>Our developers want the development database to be updated with the production database with every two days once

What's your prodcution database size?

>>Is that any other way to refresh the test database like cloning the database or creating the standby databas

Yes Physical Standby database

Use Advanced Replicaiton (It's Materialized View based replication (only use read only materialized views))

[Updated on: Mon, 27 July 2009 07:23]

Report message to a moderator

Previous Topic: Resolving Archivelog Gap on Physical Standby Database
Next Topic: ORA-00314 on standby
Goto Forum:
  


Current Time: Thu Mar 28 04:29:44 CDT 2024