dotmaik1

SET linesize 160 pagesize 200
col RECORD_ID FOR 9999999 head ID
col ORIGINATING_TIMESTAMP FOR a20 head DATE
col MESSAGE_TEXT FOR a120 head Message

SELECT
    record_id,
    to_char(originating_timestamp,'DD.MM.YYYY HH24:MI:SS'),
    message_text
FROM

dotmaik1

--Para obtener una lista con los objetos bloqueados ejecucutados:
set lines 200
select substr(a.os_user_name,1,8) "OS User"
, substr(b.object_name,1,30) "Object Name"
, substr(b.object_type,1,8) "Type"
, e.process "PROCESS"
, e.sid
, e.serial#
, e.username
, e.osuser

dotmaik1

select sum(BYTES)/1024/1024/1204 GB 
from DBA_EXTENTS;


select sum(BYTES)/1024/1024 MB 
from DBA_EXTENTS;

dotmaik1

SET LINESIZE 200
SET PAGES 500
COLUMN file_name FORMAT A70

SELECT file_id,
       file_name,
       ROUND(bytes/1024/1024) AS size_mb,
       ROUND(maxbytes/1024/1024) AS max_size_mb,
       autoextensible,
       increment_by,

dotmaik1

#********************************************************************************
#                            DATA PUMP EXPORTS
#********************************************************************************
#********************************************************************************
#  DAILY BACKUP
#********************************************************************************
00 21 * * 1-6 /usr/bin/ksh /oracle/u06/exports/MRORM1/scripts/backup_daily_full.ksh MRORM1
#********************************************************************************
#  DELETE BACKUP
#********************************************************************************

dotmaik1

nohup impdp USERID=\'/ as sysdba\' TABLES = AMOSSERVER_TRAINING2.MENU_USER, AMOSSERVER_TRAINING2.NG_USER_ACCESS, AMOSSERVER_TRAINING2.SIGN, AMOSSERVER_TRAINING2.STAFF_ACCESS_RIGHT, AMOSSERVER_TRAINING2.USER_ACCESS, AMOSSERVER_TRAINING2.USER_GROUP remap_schema=AMOSSERVER_TRAINING2:AMOSSERVER_TRAINING6, AMOSUSER_TRAINING2:AMOSUSER_TRAINING6 REMAP_TABLESPACE=TRAINING2:TRAINING6 DIRECTORY=BACKUP dumpfile=export_TRAINING2_18072016.dmp LOGFILE=import_only_tables_TRAINING2_18072016.log CONTENT=DATA_ONLY &

dotmaik1

1.-TOMAMOS UN BACKUP 
nohup expdp USERID=\'/ as sysdba\' schemas=AMOSUSER_MIGRATION5, AMOSSERVER_MIGRATION5 directory=DATA_PUMP_DIR dumpfile=BACKUP_TRAINING5_20072016.dmp logfile=BACKUP_TRAINING5_20072016.log EXCLUDE=statistics  &


export_MIGRATION5_18072016.dmp

2.-DROPEAMOS LOS USUARIOS:

dotmaik1

--The following script can be used to see open DB link sessions (on both databases).
-- who is querying via dblink?
-- Courtesy of Tom Kyte, via Mark Bobak
-- this script can be used at both ends of the database link
-- to match up which session on the remote database started
-- the local transaction
-- the GTXID will match for those sessions
-- just run the script on both databases

dotmaik1

set lines 200
SELECT TABLE_OWNER, 
TABLE_NAME, 
INSERTS, 
UPDATES, 
DELETES, 
TO_CHAR(TIMESTAMP,'DD-MON-YY HH24:MI:SS') TIMESTAMP, 
TRUNCATED, 
DROP_SEGMENTS 
FROM ALL_TAB_MODIFICATIONS 

dotmaik1

set verify off
set trimspool on
set lines 132
set pages 10000
set markup html on;
set linesize 300
col INSTANCE_NAME format a10
col HOST_NAME format a30
col JOB format 9999999999
col SCHEMA_USER format a30