Toad World® Forums

Duplicate Database

Hello,

i have a Oracle 12c DB on Windows Server 2012 in Single mode (not CDB or PDB) with archivelog mode and i must create a TestDB from the active DB on the same server.

How can i make this ?

Greetings

Karsten

If it’s 12.1.0.2, then you can set up a CDB somewhere and create a pluggable from your existing “normal” database. I wrote a blog about this last year. www.toadworld.com/…/how-to-clone-a-database-across-servers-without-copying-files

Hello,

sory, but we have a Oracle 12.1.0.1-Server .

What is the reason for this situation.

Karsten

Create a second instance of Oracle on the box. Either do a cold database restore of the primary datafiles or do simple Export imports. There are quite a few ways to do what you want.

It is possible, to make this work with toad ? Toad is a very good tool, but a database cloning can i not make ?!