WikiSysop il 12:02, 23 apr 2018

2018-04-23T12:02:23Z

← Versione meno recente		Versione delle 12:02, 23 apr 2018
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]]

WikiSysop: Creata pagina con "

 #!/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..."

2018-04-23T12:00:58Z

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..."

Nuova pagina

<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
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

</pre>

[[Categoria:Database]]
[[Categoria:Oracle]]

Oracle conversione piattaforma - Cronologia

WikiSysop il 12:02, 23 apr 2018

WikiSysop: Creata pagina con "
#!/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..."