RE: Transportable database Windows to Linux

Looks like you're missing a close-quote after the platform. I suspect RMAN is looking for that close-quote, hitting the end of the file, not ever seeing the semi-colon as an end-of-command.  

Stephan Uzzell | Sr. Database Engineer | +1 410.227.6732

Oracle Cloud for Industry | Cloud Database Operations

Swarthmore, PA | US  

From: Jeffrey Beckstrom [mailto:JBECKSTROM_at_gcrta.org] Sent: Wednesday, December 27, 2017 8:57 AM To: oracle-l-freelist <oracle-l_at_freelists.org> Subject: Transportable database Windows to Linux  

I am following several notes on migrating a database from Windows to Linux. One of the notes is 1401921.1. Database is 11.2.0.4 so using transportable database option.

I have copied all of the database files from Windows to the Linux server using OS commands. The System and rollback datafiles were placed in a separate directory awaiting conversion.

I nomounted the database and started rman on the Linux server.

Now trying to convert the system and rollback datafiles only since they need conversion per the MOS notes.

I am attempting to run the following command from a file:

CONVERT datafile
'/oracle/orat/convert/system.dbf',
'/oracle/orat/convert/system_2.dbf',
'/oracle/orat/convert/system_3.dbf',
'/oracle/orat/convert/system_4.dbf',
'/oracle/orat/convert/system_5.dbf',
'/oracle/orat/convert/rollback.dbs'

DB_FILE_NAME_CONVERT
'/oracle/orat/convert','/oracle/orat'

FROM PLATFORM 'Microsoft Windows x86 64-bit parallelism 6;

When I run this command, I get:

RMAN> _at_rman_convert_datafile.sql

RMAN> CONVERT datafile

2> '/oracle/orat/convert/system.dbf', 
3> '/oracle/orat/convert/system_2.dbf', 
4> '/oracle/orat/convert/system_3.dbf', 
5> '/oracle/orat/convert/system_4.dbf', 
6> '/oracle/orat/convert/system_5.dbf', 
7> '/oracle/orat/convert/rollback.dbs' 
8> DB_FILE_NAME_CONVERT 
9> '/oracle/orat/convert','/oracle/orat' 
10> FROM PLATFORM 'Microsoft Windows x86 64-bit 
11> parallelism 6; 
12> 
13> 

RMAN is listing the file instead of executing the commands. What am I doing wrong?

Jeffrey Beckstrom
Lead Database Administrator

Information Technology Department

Greater Cleveland Regional Transit Authority

1240 W. 6th Street
Cleveland, Ohio 44113  

--
http://www.freelists.org/webpage/oracle-l