Home| Progetto| Web| Faq| Acronimi | ||||
Argomenti Documenti pubblicabili:1120
Scripts:1282 Documenti non pubblicabili:162 Categorie tematiche:68 .Net |_C# |_Visual basic.net |_Asp.net Active Server Pages C++ Cascade Style Sheet JavaScript Mysql Php Xml Java |_Java 2 Micro Edition |_Java server pages |_Java Servlet Oracle |_PLSQL PostgreSQL Unix
Unix...
Info:
Variabili nelle shell unix/linux
Oracle...
Script:
Query per visualizzare percentuale di storage disponibile e ripartizione storage per datafile
Unix...
Tip:
How remove a file named -r
PLSQL...
Script:
TYPE TABLE
Unix...
Tip:
Eseguire più comandi in una sola linea
Shell scripting...
Script:
Array
Un servizio Web XML è un'unità logica di applicazioni che fornisce dati e servizi ad altre applicazioni.
Le applicazioni accedono ai servizi Web XML tramite protocolli Web universali e formati di dati quali HTTP, XML e SOAP.
Php Funzione mail()
La J2EE (Java 2 Enterprise Edition) è dedicata a tutti coloro che desiderano aggiungere il supporto della versione Enterprise di Java (ad esempio a Tomcat) e quindi le funzionalità avanzate come Enterprise JavaBeans etc.
Un servizio Web XML è un'unità logica di applicazioni che fornisce dati e servizi ad altre applicazioni.
Le applicazioni accedono ai servizi Web XML tramite protocolli Web universali e formati di dati quali HTTP, XML e SOAP.
|
Unix
Home >Unix > Export and compress dump on the fly
Those scripts are tested on HP-UX and SunOS machines, it work with all oracle versions (I use scripts like these from 8i to 11g) When storage it is a issue, it's a frequent dba tecnique exporting or importing databases using pipe to compress the dump on the fly and not after. Unfortunally the same trick does not yet work with datapump (10G) export / import tools. Script to export and compress on the fly a local Oracle database
#!/bin/ksh
# file= exp_pipe_local.ksh data=`date '+%Y%m%d_%H%M'` export ORACLE_SID=CUST01 # set eventually NLS_LANG variable..., is good practice to set it always in the script , even in local enviroment. #export NLS_LANG=AMERICAN_AMERICA.UTF8 ORACLE_PIPE=ora_pipe_${ORACLE_SID}_${data} mkfifo ${ORACLE_PIPE} expfile=${ORACLE_SID}_FULL_${data}.dmp logfile=${ORACLE_SID}_FULL_${data}.log compress -c < ${ORACLE_PIPE} > ${expfile}.Z & # some export parameters exp system/password file=${ORACLE_PIPE} log=${logfile} direct=Y feedback=100000 compress=N FULL=Y # sometimes it may help wait few seconds before removing pipe file, to avoid that it is still busy sleep 15 rm ${ORACLE_PIPE} Script to export and compress on the fly a remote Oracle database
#!/bin/ksh
# file= exp_pipe_remote.ksh data=`date '+%Y%m%d_%H%M'` remoteDB=CATALOG01 # set eventually NLS_LANG variable, in paricular if enviroments are differents check that is properly set. export NLS_LANG=AMERICAN_AMERICA.UTF8 ORACLE_PIPE=ora_pipe_${remoteDB}_${data} mkfifo ${ORACLE_PIPE} expfile=${remoteDB}_${data}.dmp logfile=${remoteDB}_${data}.log compress -c < ${ORACLE_PIPE} > ${expfile}.Z & # some export parameters exp system/password@${remoteDB} file=${ORACLE_PIPE} log=${logfile} direct=Y feedback=100000 compress=N FULL=Y sleep 15 # sometimes it may help wait few seconds before removing pipe file, to avoid that it is still busy rm ${ORACLE_PIPE} Finally, To import a compressed exp dump without decompressing:
#!/bin/ksh
# file= imp_pipe_remote.ksh data=`date '+%Y%m%d_%H%M'` remoteDB=CUST01 export NLS_LANG=AMERICAN_AMERICA.UTF8 compressdump=CUST01_20090120_1715.dmp.Z filelog=imp_to_${remoteDB}.log orapipe=ora_pipe_${compressdump}_${remoteDB}_${data} mkfifo ${orapipe} nohup uncompress -c < ${compressdump} > ${orapipe} & # some import parameters imp system/password@${remoteDB} file=${orapipe} log=${filelog} ignore=Y tables=mytable feedback=10000 buffer=30000000 sleep 15 rm ${orapipe} Dott. Marco Magnani DBA Oracle Kenan FX Arbor Warning: include(ads/text468x15.html): failed to open stream: No such file or directory in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131 Warning: include(): Failed opening 'ads/text468x15.html' for inclusion (include_path='.;C:\php\pear') in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131 Tutorial ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Script ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Comandi ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Cerca
Unix...
Info:
ps
Well-formedness is a new concept introduced by [XML]. Essentially this means that all elements must either have closing tags or be written in a special form (as described below), and that all the elements must nest properly.
Well-formedness is a new concept introduced by [XML]. Essentially this means that all elements must either have closing tags or be written in a special form (as described below), and that all the elements must nest properly.
Unix...
Info:
ps
Oracle...
Definizioni:
Area PGA
Shell scripting...
Script:
Compact if construct
fishScript.Com is accessible by Mobile access technology
as mobile phones, Palm and Pocket PC .
Nicoleta e Marco Magnani tutorial, examples, courses, esempi, corsi, esercizi, appunti vari Dottoressa Nicoleta Dragu Formatrice Docente Insegnante Mediatrice Culturale Dott. Marco Magnani Universita La Sapienza Roma Master Computer Science Hunter College New York , Data Base Administrator DBA oracle System architect |