Hey guys,
I am migrating oracle 11g R2 database from Windows 7 to Red hat 5 (64 bit) Linux by using RMAN through transport.sql file. I have installed Oracle 11g R2 on both system.
But the problem is my data files are scattered on different locations (I mean all are not in same directory) and I have no enough space to copy all of them in same directory. Can anybody tell me how I am supposed to write multiple locations as value of DB FILE NAME CONVERT parameter while creating transport script by using RMAN as I know command for one directory only.
RMAN> Convert database new database linuxdb
transport script to 'C:\test\transport.sql'
db_file_name_convert 'C:\oracle\oradata\orcl\' 'C:\test'
to platform 'Linux IA <32-bit>';
This command will convert all database files that resides in orcl directory and put them in test directory. But in my case, all files are not in orcl directory
and I can't copy other files in it because I have no enough space on entire system.
I can not create transport script multiple times as it is incorrect.
I appreciate your suggestions and thoughts.