Upgrade database from 12.1.0.2 to 12.2.0.1    

Find Invalid Objects in Your Databases

calcul de l’are https://droit-finances.commentcamarche.com/faq/3561-allocation-chomage-2019-calcul-de-l-indemnite-are-2019 calcul du salaire journalier de référence https://droit-finances.commentcamarche.com/contents/1532-chomage-calcul-du-salaire-journalier-de-reference   Vous avez créé une entreprise et bénéficiez de l’Allocation de Retour à l’Emploi (ARE)   (ARE) et création […]

— ———————————————————————————– — File Name : https://oracle-base.com/dba/monitoring/identify_trace_file.sql — Author : Tim Hall — Description : Displays the name of the trace file associated with the current session. — Requirements : […]

Avant la 10G :   Activer la trace : SQL> EXEC DBMS_SYSTEM.set_sql_trace_in_session(sid=>123, serial#=>1234, sql_trace=>TRUE);Désactiver la trace : SQL> EXEC DBMS_SYSTEM.set_sql_trace_in_session(sid=>123, serial#=>1234, sql_trace=>FALSE);Après la 10G : Activer la trace : SQL> […]

merci :   http://www.lami-dba.com/2018/03/desactiver-active-dataguard.html

RMAN> shutdown immediateRMAN> startup mountRMAN> run2> {3> set until restore point <nomdupointderestaure>;4> restore database;5> recover database;6> } RMAN> alter database open resetlogs;database openedRMAN>

  Steps to Refresh a Physical Standby Database with Changes Made to the Primary Database   source : https://docs.oracle.com/en/database/oracle/oracle-database/18/spmss/refresh-a-physical-standby-db.html#GUID-828A4953-3F7E-4975-ADA4-5469D6794BB0  le site inclus les prérequis que l’on oublie souvent:   Oracle […]

Source : https://www.orafaq.com/forum/t/122395/   to start a standby database :   #!/bin/bash ORA_HOME= »/opt/oracle/920″ ORA_OWNER= »oracle » SQLCMD= »sqlplus ‘/as sysdba' » LOGFILE= »strt.log » cat startup.sql | su – $ORA_OWNER -c « $SQLCMD » > $LOGFILE   to […]

Source : https://valehagayev.wordpress.com/2016/07/09/dataguard-commands-and-sql-scripts/ start redo apply in foreground stop redo apply process on the Standby database (to stop MRP) start real-time redo apply start redo apply in background check redo […]