Emigar - Ultime modifiche [it]

Query Varie

2026-05-22T13:24:18Z

Per 10.2

@@ Riga 40: / Riga 40: @@
  col owner for a20
  select job_name, owner, enabled from dba_scheduler_jobs;
 <pre>
@@ Riga 414: / Riga 423: @@
  order by 1,2,3;
 </pre>
@@ Riga 499: / Riga 527: @@
 -->
 ==Autoextend datafiles==

Oracle startup script

2026-05-20T16:07:06Z

/etc/init.d/oracle

@@ Riga 1: / Riga 1: @@
 ==Upstart==
@@ Riga 36: / Riga 71: @@
 </pre>
 [[Categoria:Database]]

Oracle upstart

2026-05-20T15:58:01Z

WikiSysop ha spostato la pagina Oracle upstart a Oracle startup script

Nuova pagina

==Upstart==

<pre>
# description "start and stop oracle instance"

start on runlevel [3]
stop on runlevel [!3]

console log
chdir /home/oracle
setuid oracle
setgid oinstall
expect fork

env ORACLE_BASE=/u01/app/oracle
env ORACLE_SID=ORCL
env ORAENV_ASK=NO

script
. oraenv
echo startup | sqlplus '/ as sysdba'
lsnrctl start LISTENER
echo 'ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;' | sqlplus '/ as sysdba'

end script

pre-stop script
. oraenv
echo 'ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;' | sqlplus '/ as sysdba'
echo 'shutdown immediate' | sqlplus '/ as sysdba'
lsnrctl stop LISTENER

end script

</pre>

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

Oracle Blocchi Corrotti

2026-05-20T15:48:31Z

← Versione meno recente		Versione delle 15:48, 20 mag 2026
(Una versione intermedia di uno stesso utente non è mostrata)
Riga 1:		Riga 1:

			==Lista degli oggetti con blocchi corrotti==
⚫	~~SELECT~~ ~~DISTINCT~~ ~~owner, segment_name, partition_name, segment_type, tablespace_name from v$database_block_corruption dbc~~ JOIN dba_extents e ON dbc.file# = e.file_id AND dbc.block# BETWEEN e.block_id and e.block_id+e.blocks-1 ~~order by 1,2;~~
			SELECT DISTINCT owner, segment_name, partition_name, segment_type, tablespace_name, e.bytes/(1024*1024) mb
			from v$database_block_corruption dbc
		⚫	JOIN dba_extents e ON dbc.file# = e.file_id AND dbc.block# BETWEEN e.block_id and e.block_id+e.blocks-1
			order by 1,2;

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

Oracle Blocchi Corrotti

2026-05-20T11:53:07Z

Creata pagina con " SELECT DISTINCT owner, segment_name, partition_name, segment_type, tablespace_name from v$database_block_corruption dbc JOIN dba_extents e ON dbc.file# = e.file_id AND dbc.block# BETWEEN e.block_id and e.block_id+e.blocks-1 order by 1,2; Categoria:Database Categoria:Oracle"

Nuova pagina

SELECT DISTINCT owner, segment_name, partition_name, segment_type, tablespace_name from v$database_block_corruption dbc JOIN dba_extents e ON dbc.file# = e.file_id AND dbc.block# BETWEEN e.block_id and e.block_id+e.blocks-1 order by 1,2;

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

Oracle Rman

2026-05-19T12:35:46Z

WikiSysop ha cancellato la pagina Oracle Rman il contenuto era: '=Rman script windows= ==Template per multi retention== <pre> @echo off for /f "skip=2" %%x in ('wmic Path Win32_LocalTime get Day^,DayOfWeek /Format:List') do set %%x >NUL rem echo %Day% %DayOfWeek% rem Sovrascrivi per prove rem set Day=1 rem set DayOfWeek=1 rem echo %Day% %DayOfWeek% set BCK=ORD if %DayOfWeek% EQU 0 set BCK=LT180 if %DayOfWeek% EQU 0 if %Day% GTR...', e l'unico contributore era "WikiSysop" (msg)

Oracle RMAN

2026-05-19T12:35:06Z

Mostra modifiche

Rman

2026-05-19T12:34:03Z

WikiSysop ha spostato la pagina Rman a Oracle Rman

Nuova pagina

Oracle Duplicate Database

2026-05-19T12:05:09Z

Duplicate via rman

← Versione meno recente		Versione delle 12:05, 19 mag 2026
(Una versione intermedia di uno stesso utente non è mostrata)
Riga 2:		Riga 2:

	=Duplicate via rman=		=Duplicate via rman=
			Si può partire con un spfile creato opportunamente. O si può restorare l'spfile del db originale e modificarlo tramite duplicate (dalla 11 in poi) (preferibile se si duplica su un server diverso)

			===10gR2===
			Creato spfile dell'istanza AUXILIARY, e creato passwordfile, modificata entry nel <code>listener.ora</code> e <code>tnsnames.ora</code>
			per consentire connessione via listener alla AUXILIARY.
			ORACLE_SID=TEMP
			export ORACLE_SID
			rm -f ${ORACLE_HOME}/dbs/orapwTEMP
			orapwd file=${ORACLE_HOME}/dbs/orapwTEMP password=temppassword
			sqlplus '/ as sysdba' << EOF
			shutdown abort;
			create spfile from pfile='/home/oracle/pfileTEMP.ora';
			startup nomount;
			EOF

			impostato con <code>. oraenv</code> la connessione al target (database da duplicare). Il database duplicato verrà generato nell'istanza AUXILIARY.

			ORACLE_SID=DBNAME
			export ORACLE_SID
			rman target / auxiliary sys/temppassword@TEMP nocatalog trace duplicate.log << EOF
			run
			{
			allocate auxiliary channel dd0 type sbt;
			allocate auxiliary channel dd1 type sbt;
			DUPLICATE TARGET DATABASE TO TEMP
			DB_FILE_NAME_CONVERT ('/oradata/DBNAME/','/oradata2/TEMP/')
			UNTIL LOGSEQ 1011237 THREAD 1
			LOGFILE
			'/oradata2/TEMP/onlinelog/log01.dbf' size 512M,
			'/oradata2/TEMP/onlinelog/log02.dbf' size 512M,
			'/oradata2/TEMP/onlinelog/log03.dbf' size 512M
			;
			}
			EOF

	=Duplicate PDB=		=Duplicate PDB=

Oracle RMAN

2026-05-19T12:03:16Z

Duplicate Database

← Versione meno recente		Versione delle 12:03, 19 mag 2026
(16 versioni intermedie di uno stesso utente non sono mostrate)
Riga 1:		Riga 1:
	==Duplicate Database==		==Duplicate Database==

			[[Oracle_Duplicate_Database\|Duplicate Database]]

	==Restore Point in time==		==Restore Point in time==
Riga 47:		Riga 48:

	==backup archive==		==backup archive==
			per salvare gli ultimi archive generati, ma evitare salvataggi doppi e cancellazione degli archive dopo 1 giorno dalle generazione:
	non ancora salvati
	non cancellare subito ma tieni in linea per un certo tempo


⚫	~~backup~~ archivelog all ~~not~~ backed up 1 times to device type sbt;
			Sintassi testata su rman 10.2

			backup archivelog all not backed up 1 times to destination "sbt_tape";
			backup as backupset device type sbt archivelog all not backed up 1 times;
		⚫	delete noprompt archivelog all backed up 1 times to device type sbt;
			delete noprompt archivelog all completed before 'sysdate-1' backed up 1 times to device type sbt;