Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Partial Database Clonning

569820May 12 2009 — edited May 19 2009
Hi All Gurus,

I have a question. I have to create a clone database consisting of only a subset of an existing database. That is, I have a database named "devdb", I want to create another database on same server which should contain only "system", "undo", and "users" tablespaces of "devdb" database. I have done the following steps;

1. Took a hot backup of all the data files belonging to "system", "undo", and "users" tablespaces.
2. Restored these data files into a new location on the server.
3. Generated a "create controlfile ..." script from "devdb" database.
4. Edited the script to rename the database to "newdb" and to specify new locations and names of datafiles/redo log files.
5. In a bash environment, set ORACLE_SID to "newdb", then ran the "create controlfile ..." script (generated and modified in steps 3,4), this created the controlfile.

Now I have a problem, since datafiles are restored backups (from a hot backup), we need to RECOVER DATABASE, but there are no archived log files for the "newdb" database!!!! all the archive llog files I have on the server belong to "devdb"..... so how can I do a RECOVER DATABASE from those archive log file???

Can anyone please help me? I would really appreciate an early help.
Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 16 2009
Added on May 12 2009
9 comments
2,933 views