Catégorie : Système

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 […]

It’s now easier for people to find your Page in search. People can also visit your Page at fb.me/oracledbajoly and send messages to your Page at m.me/oracledbajoly.

Test Result 92851040.pdf

https://lamp-dev.com/elance-ansi-sql-code-test-with-answers/109 1. Consider a table named “salary” having the following columns: “id” (type: INT)“salary” (type: INT)“incentive” (type: INT)“tax” (type: INT) Write a standard SQL query which will update the tax […]

Se faire rembourser ses notes de frais dans le cadre d’un CDI, c’est possible, en voici la preuve ici.   https://www.juritravail.com/chiffres-et-indices/frais-professionnels-allocations-forfaitaires-limites-exoneration.html