HIDDEN CONTENT A- Quelques notions : channel = connection between rman and instance rman can backup : database tablespace datafile archivelog controlfile B- Installation rman : voir article [RMAN] Installation C- Première connexion rman : D- Faire connaissance...
In progress MAJDA Console at Monday May 17, 2010 10:37:49 ================================================= SQL: TEXTE ACCESSED_OBJ LOCKED_OBJ EVENT WAIT_S INST Duree SID USERNAME SPID TEMP_USED_M UNDO_USED_M bfhbb9pp59uap:select s.username, decode(s.status,:"SYS_B_00",:"SYS_B_01",:"...
My own very pratice database console Better than OEM, I swear ! HIDDEN CONTENT
HIDDENT CONTENT #--rman backup 00 20 * * 0-5 /home/ora102/TOOLS/DBA/rman_backup.sh archivelog 00 20 * * 6 /home/ora102/TOOLS/DBA/rman_backup.sh full #--backup voting disk 00 14 * * 7 /home/ora102/TOOLS/DBA/votingbak.sh #-- Calcul statistics 00 20 * *...
HIDDEN CONTENT dba_tab_modifications v$bh dbms_stats.GATHER_SYSTEM_STATS dba_segments #-- Majda monitoring 00 * * * * /home/ora102/majda/mod.ksh #00,30 * * * * /home/ora102/majda/mon.ksh 0 * * * * /home/ora102/majda/system_stat_history.sh #mod.sh log=/home/ora102/majda/mod.log...
HIDDEN CONTENT 1) clean target schema if FULL import.(check recycle_bin=off) drop user XXXX cascade; 2) clean NOT RUNNING datapump jobs set verify off define job= SYS_EXPORT_SCHEMA_04 exec DBMS_DATAPUMP.STOP_JOB (DBMS_DATAPUMP.ATTACH('SYS_EXPORT_SCHEMA_04','SYS'),1,0);...
HIDDENT CONTENT 1) Que faire import.sh : Importe le dumpfile dans la base locale en FULL. Si la taille du dump dépasse 20G, le script recrée les indexes et les constraintes en dehors du impdp Dans tous les cas, le CODE est crée après, pour éviter le message...
0/3 : sql.bsq usefull information /* please check this on sql.bsq file -------------------------------- 1 = table check, 2 = primary key, 3 = unique, 4 = referential, 5 = view with CHECK OPTION, 6 = view READ ONLY check 7 - table check constraint associated...
HIDDEN CONTENT 1/3 Should create a table which contains the complete necessary information by row drop table t_ind; create table t_ind ( index_owner varchar2(30), index_name varchar2(30), index_type VARCHAR2(27), table_owner varchar2(30), table_name varchar2(30),...
HIDDEN CONTENT --> Compare tables --> Compare column_name ( could be extented simply by adding column_id, data_type, DATA_LENGTH) No matter about position, type, lenght of the columns prompt comparaison TABLES select '&util','Miss', table_name from dba_tables...
