I have a query regarding clonning DB from 11g o 10g.
Machine A is on linux with DB Version 11g and machine B is on windows with DB Version 10g. Is it possible to clone DB 11g which is on Linux machine to DB 10g which is on Windows machine.
Kindly advice over the same
I don't think it's possible to do a direct clone because the DB would still remain as 11g. Other options I can think of:
Export from 11g import to 10g
Clone and then downgrade
It would depend on how large your database is, or if you could take a cut down part of it to use instead of the whole DB.
By definition a clone is an exact copy, so if you clone your 11g DB you will have another 11g DB. The only way to make it 10g is to change it in some way. Downgrade, for example.
Have you already read through the Oracle docs?
I very much doubt RMAN will allow you to downgrade the DB while duplicating it.