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...") |
(Nessuna differenza)
|
Versione delle 12:00, 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