Oracle conversione piattaforma: differenze tra le versioni
Jump to navigation
Jump to search
(Creata pagina con " <pre> #!/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 shu...") |
Nessun oggetto della modifica |
||
Riga 41: | Riga 41: | ||
</pre> |
</pre> |
||
<pre> |
|||
#!/bin/sh |
|||
ORACLE_SID=$1 |
|||
ORAENV_ASK=NO |
|||
export ORACLE_SID ORAENV_ASK |
|||
. oraenv |
|||
unset ORAENV_ASK |
|||
umask 000 |
|||
mkdir -p /transito/${ORACLE_SID}/datafiles/ |
|||
sqlplus '/ as sysdba' << EOF |
|||
shutdown immediate; |
|||
startup mount; |
|||
alter database open read only; |
|||
EOF |
|||
rman target / nocatalog << EOF |
|||
CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET; |
|||
CONVERT DATABASE |
|||
NEW DATABASE '${ORACLE_SID}' |
|||
TRANSPORT SCRIPT '/transito/${ORACLE_SID}/transportscript.sql' |
|||
TO PLATFORM 'Linux x86 64-bit' |
|||
DB_FILE_NAME_CONVERT |
|||
'/disk1/${ORACLE_SID}_DB/' '/transito/${ORACLE_SID}/' |
|||
'/disk2/${ORACLE_SID}_DB/' '/transito/${ORACLE_SID}/' |
|||
; |
|||
EOF |
|||
</pre> |
|||
[[Categoria:Database]] |
[[Categoria:Database]] |
Versione attuale delle 14:02, 23 apr 2018
#!/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
#!/bin/sh ORACLE_SID=$1 ORAENV_ASK=NO export ORACLE_SID ORAENV_ASK . oraenv unset ORAENV_ASK umask 000 mkdir -p /transito/${ORACLE_SID}/datafiles/ sqlplus '/ as sysdba' << EOF shutdown immediate; startup mount; alter database open read only; EOF rman target / nocatalog << EOF CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET; CONVERT DATABASE NEW DATABASE '${ORACLE_SID}' TRANSPORT SCRIPT '/transito/${ORACLE_SID}/transportscript.sql' TO PLATFORM 'Linux x86 64-bit' DB_FILE_NAME_CONVERT '/disk1/${ORACLE_SID}_DB/' '/transito/${ORACLE_SID}/' '/disk2/${ORACLE_SID}_DB/' '/transito/${ORACLE_SID}/' ; EOF