Home » RDBMS Server » Backup & Recovery » Duplicating a database AND maintaining it
Duplicating a database AND maintaining it [message #270292] Wed, 26 September 2007 07:24 Go to next message
Messages: 5
Registered: September 2007
Junior Member
Sounds like replicating, right? Wink

But the case is this.

We now have a single production database machine having 4 different SID's (instances) on it. Let's say the machine is called DB.

My task is to create a new setup, which has machines DB1 and DB2, where DB1 is a clone of DB, and DB2 is a physical standby replica of DB1.

Data Guard and making the replica between DB1 and DB2 is clear to me, I have built and documented the process.

Now I would like to create a copy of DB data to DB1 and DB2, and maintain the data flow somehow from DB to DB1, which then sends it to DB2.

I can create the initial copy from a cold backup. But how to maintain the replica of DB in DB1, WITHOUT ANY CHANGES to DB's setup? DB generates Archive log all right, I could use it. But how?

All the systems are 10g ( running on Windows 2003 Server with identical hardware and hard disk structure.

All the databases have same db_name across all machines, although unique_dbname will differ.

Can I read in Archive logs from DB to DB1, and if yes, how?

This arrangement between DB and DB1 is of course meant to be temporary. When the customer accepts the system, the DB is dropped off and DB1 will be the production server.

Any pointers?

[Updated on: Wed, 26 September 2007 07:28]

Report message to a moderator

Re: Duplicating a database AND maintaining it [message #270444 is a reply to message #270292] Wed, 26 September 2007 22:12 Go to previous message
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Search for "Duplicate Database" either in this forum or look at Oracle documentation.
Previous Topic: Help, oracle9i
Next Topic: fast copy/duplicate of database (NetApp/time finder-SRDF/BCV)
Goto Forum:

Current Time: Fri Oct 28 13:47:46 CDT 2016

Total time taken to generate the page: 0.07424 seconds