Partial Database Clonning
569820May 12 2009 — edited May 19 2009Hi 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.