Oracle conversione piattaforma

#!/bin/sh

ORACLE_SID=$1
ORAENV_ASK=NO
export ORACLE_SID ORAENV_ASK
. oraenv
unset ORAENV_ASK

mkdir -p /transito/es40/${ORACLE_SID}/


sqlplus '/ as sysdba' << EOF
shutdown immediate;
startup
alter system checkpoint;
shutdown immediate;
startup mount;
alter database open read only;
-- select * from V\$TRANSPORTABLE_PLATFORM;
set serveroutput on
declare
    db_ready boolean;
  begin
    /* db_ready is ignored, but with SERVEROUTPUT set to ON any 
     * conditions preventing transport will be output to console */
    db_ready := dbms_tdb.check_db('Linux x86 64-bit', dbms_tdb.skip_none);
  end;
/
EOF

rman target / nocatalog << EOF
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONVERT DATABASE NEW DATABASE '${ORACLE_SID}'
        transport script '/transito/es40/${ORACLE_SID}/${ORACLE_SID}.sql'
        to platform 'Linux x86 64-bit'
	format '/transito/es40/${ORACLE_SID}/%U';
EOF